Table is a logical structure in database that is using for store the data in databases. We can create table in oracle by using this syntax.
Code To Create Table:
CREATE TABLE GRN_MASTER
(
GRN_NUM NUMBER,
GRN_DATE DATE,
SUPPLIER_ID NUMBER,
GATE_PASSS_ID NUMBER,
STORE_ID NUMBER,
APPROVED_ID NUMBER,
CONSTRAINTS PK_GRN_NUM PRIMARY KEY (GRN_NUM)
);
No comments:
Post a Comment
Thank You For Comment