- CREATE TABLE a(
- id NUMBER(5) generated BY DEFAULT AS identity PRIMARY KEY,
- name VARCHAR(20) NOT NULL
- );
- ALTER TABLE orders ADD foreign KEY (supplier_id) REFERENCES supplier(supplier_id);
- Sequences
- CREATE SEQUENCE seq_name
- minvalue 1
- maxvalue 100
- START WITH 1
- INCREMENT BY 1
- no cycle
- cache 20;
- INSERT INTO b VALUES (abc_seq.NEXTVAL, 'aaa');
- DROP SEQUENCE seq_name;
- ALTER SEQUENCE abc_seq INCREMENT BY 2;
- CASE AND WHEN expression;
- SELECT employee_id, first_name, salary,
- CASE employee_id WHEN 101 THEN 1.20 * salary
- ELSE salary
- END
- "Salary Updated"
- FROM hr.employees WHERE employee_id IN (101);
Recent Pastes