-- Criação do banco de dados
CREATE DATABASE Mercado;
-- Uso do banco de dados
USE Mercado;
-- Criação da tabela Fornecedor
CREATE TABLE Fornecedor (
id INT PRIMARY KEY AUTO_INCREMENT,
nome VARCHAR(50),
sobrenome VARCHAR(50),
sexo CHAR(1),
idade INT,
cidade VARCHAR(50),
email VARCHAR(100),
telefone VARCHAR(20),
);
-- Inserção dos registros na tabela Fornecedor
INSERT INTO Fornecedor (nome, sobrenome, sexo, idade, cidade, email, telefone) VALUES
('João', 'Medeiros', 'M', 25, 'São Paulo', '[email protected]', '11987654321'),
('Carlos', 'Medeiros', 'M', 35, 'Rio de Janeiro', '[email protected]', '21987654321'),
('Pedro', 'Medeiros', 'M', 45, 'Belo Horizonte', '[email protected]', '31987654321'),
('Lucas', 'Medeiros', 'M', 15, 'Curitiba', '[email protected]', '41987654321'),
('Marcos', 'Medeiros', 'M', 55, 'Porto Alegre', '[email protected]', '51987654321'),
('Maria', 'Silva', 'F', 22, 'São Paulo', '[email protected]', '11987654322'),
('Ana', 'Silva', 'F', 30, 'Rio de Janeiro', '[email protected]', '21987654322'),
('Clara', 'Silva', 'F', 18, 'Belo Horizonte', '[email protected]', '31987654322'),
('Fernanda', 'Silva', 'F', 40, 'Curitiba', '[email protected]', '41987654322'),
('Juliana', 'Silva', 'F', 50, 'Porto Alegre', '[email protected]', '51987654322'),
('Felipe', 'Costa', 'M', 28, 'Recife', '[email protected]', '81987654321'),
('Ricardo', 'Oliveira', 'M', 33, 'Fortaleza', '[email protected]', '85987654321'),
('Lucas', 'Lima', 'M', 19, 'Salvador', '[email protected]', '71987654321'),
('Gabriel', 'Santos', 'M', 31, 'Brasília', '[email protected]', '61987654321'),
('Paulo', 'Gomes', 'M', 27, 'Manaus', '[email protected]', '92987654321'),
('Camila', 'Pereira', 'F', 21, 'Belém', '[email protected]', '91987654321'),
('Larissa', 'Rodrigues', 'F', 29, 'Goiânia', '[email protected]', '62987654321'),
('Patrícia', 'Martins', 'F', 17, 'Florianópolis', '[email protected]', '48987654321'),
('Bruna', 'Souza', 'F', 20, 'Vitória', '[email protected]', '27987654321'),
('Renata', 'Alves', 'F', 23, 'Maceió', '[email protected]', '82987654321');
Write, Run & Share PL/SQL code online using OneCompiler's Oracle PL/SQL online editor and compiler for free. It's one of the robust, feature-rich online editor and compiler for Oracle PL/SQL running on latest version 23c (23.3.0.0). Getting started with the OneCompiler's Oracle PL/SQL editor is really simple and pretty fast. The editor shows sample boilerplate code when you choose language as 'PL/SQL' and start writing code to learn and test online without worrying about tedious process of installation.
PL/SQL is procedural extension for SQL created by Oracle. It is by default embedded into the Oracle Database. PL/SQL program units are compiled and stored inside the Oracle Database which results in optimal execution times as the PL/SQL and SQL run within the same server process.
Following is the syntax structure for the PL/SQL code blocks
DECLARE
<declarations section>
BEGIN
<executable command(s)>
EXCEPTION
<exception handling>
END;
DECLARE
message varchar2(100):= 'Hello, World!';
BEGIN
dbms_output.put_line(message);
END;
/
CREATE OR REPLACE FUNCTION
hello_user
(user_name IN VARCHAR2)
RETURN VARCHAR2
IS
BEGIN
RETURN 'Hello ' || user_name;
END hello_user;
/
BEGIN
dbms_output.put_line(hello_user('Peter'));
END;
/
BEGIN
DBMS_OUTPUT.put_line (1/0);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ('error is: ' || SQLERRM);
END;