Skip to content

Latest commit

 

History

History
40 lines (32 loc) · 1.02 KB

sqlSamples.md

File metadata and controls

40 lines (32 loc) · 1.02 KB

Oracle SQL sample commands

-- Create --

CREATE TABLE Student(ID NUMBER(*,0), 
  FIRSTNAME NVARCHAR2(50),
  LASTNAME NVARCHAR2(50),
  ADDRESS NVARCHAR2(500),
  AGE NUMBER(3),
  SALARY NUMBER(6,4)
  GENDER NCHAR(1),
  DATE_STORED TIMESTAMP,
);
  • NUMBER(3) is same as NUMBER(3,0)
-- Insert --

INSERT INTO Student(ID, FIRSTNAME, LASTNAME, ADDRESS, AGE, GENDER) VALUES(1, 'Mahindra Singh', 'Dhoni', 'Jharkand', 33, 'M', '15-12-16 09:46:12,630000000');
INSERT INTO Student(ID, FIRSTNAME, LASTNAME, ADDRESS, AGE, GENDER) VALUES(2, 'Sachin', 'Tendulkar', 'Mumbai', 36, 'M', '15-12-16 09:46:12,630000000');
INSERT INTO Student(ID, FIRSTNAME, LASTNAME, ADDRESS, AGE, GENDER) VALUES(3, 'Juila', 'Roberts', 'California', 40, 'F', '15-12-16 09:46:12,630000000');
-- Alter Table/Column --

ALTER TABLE MY_SCHEMA.STUDENT
  ADD (INSURANCE NVARCHAR2(2),
       CLUB_PASS NUMBER(5,0));
-- Constraint --

ALTER TABLE MY_SCHEMA.STUDENT
  ADD CONSTRAINT CLUB_PASS_CONSTRAINT
    CHECK (CLUB_PASS IN ('AA', 'BB'));