PLSQL Basic Excluir
- DELETE Basic
DELETE FROM TableName []
WHERE [] Condição;
PLSQL Selecione Excluir
- Selecione Excluir
DELETE
FROM (SELECT *
FROM EMPREGADOS
WHERE Dept_ID = 1,003);
PLSQL Delete com Retornando
- Excluir com retorno
DELETE
FROM TempEmployee
WHERE EMPL_ID = 1
RETURNING rowid INTO ReturnVal;
PLSQL Excluir partição
- Excluir partição
DELETE FROM [TableName]
PARTITION [PartitionName];
Ex:
DELETE FROM PAYROLL
PARTITION (TaxYear2001);
PLSQL Excluir Database
- Excluir do banco de dados
DELETE
FROM [TableName] @
Ex:
DELETE
FROM TempEmployee @ HR_db;
