SELECT EMPLOYEE_ID
, MANAGER_ID
, DEPARTMENT_ID
FROM EMPLOYEES
WHERE (MANAGER_ID, DEPARTMENT_ID) IN (SELECT MANAGER_ID
, DEPARTMENT_ID
FROM EMPLOYEES
WHERE EMPLOYEE_ID IN (199,174))
AND EMPLOYEE_ID NOT IN (199,174);
MERGE INTO table_name table_alias USING (table|view|sub_query) alias ON (join condition) WHEN MATCHED THEN UPDATE SET col1 = col_val1, col2 = col2_val WHEN NOT MATCHED THEN INSERT (column_list) VALUES (column_values);
INSERT [ALL] [conditional_insert_clause] [insert_into_clause value_clause] (subquery)# conditional_insert_clause
[ALL] [FIRST] [WHEN conditional THEN] [insert_into_clause values_clause] [ELSE] [insert_into_clause values_clause]
INSERT INTO DEPT
(DEPARTMENT_ID , DEPARTMENT_NAME,MANAGER_ID)
VALUES
(300,'DEVELOPER',DEFAULT);
UPDATE EMP13
SET JOB_ID = (SELECT JOB_ID
FROM EMPLOYEES
WHERE EMPLOYEE_ID = 205)
,
SALARY= (SELECT SALARY
FROM EMPLOYEES
WHERE EMPLOYEE_ID = 205)
WHERE EMPLOYEE_ID = 104;
INSERT INTO
(SELECT EMPLOYEE_ID
,LAST_NAME
,HIRE_DATE
,JOB_ID
,SALARY
,DEPARTMENT_ID
FROM EMP13
WHERE DEPARTMENT_ID = 50);
VALUE
(99999,'ARAFA','A.ARAFA',TO_DATE('5-NOV-1986','DD-MON-RR'),'ORA_DEV'
,':D',50);
CREATE TABLE TEST1 (
PK NUMBER PRIMARY KEY,
FK NUMBER,
COL1 NUMBER,
col2 NUMBER,
CONSTRAINT fk_constraint FOREIGN KEY (fk) REFERENCES test1,
CONSTRAINT CK1 CHECK (PK > 0 AND COL1 > 0),
CONSTRAINT ck2 CHECK (col2 > 0));
CREATE TABLE NEW_EMP
(employee_id NUMBER(6)
PRIMARY KEY USING INDEX
(CREATE INDEX emp_id_idx ON
NEW_EMP(employee_id)),
first_name VARCHAR2(20),
last_name VARCHAR2(25));
ALTER TABLE EMP
DISABLE CONSTRAINT EMP_DPT_FK;
ALTER TABLE <table_name>
ADD [CONSTRAINT <constraint_name>]
type (<column_name>);
ALTER TABLE table
ADD (column datatype [DEFAULT expr]
[, column datatype]...);
