Scribd
Upload
4 views1 page

User Management Script

The document outlines the SQL commands to create a 'MENUS' table with various columns including OID, PARENT_OID, MENU_NAME, and others. It also includes constraints for primary and foreign keys, as well as a sequence for generating unique OID values. The table is designed to manage menu items with hierarchical relationships and additional metadata.

Uploaded by

optimusprimedeveloper
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views1 page

User Management Script

The document outlines the SQL commands to create a 'MENUS' table with various columns including OID, PARENT_OID, MENU_NAME, and others. It also includes constraints for primary and foreign keys, as well as a sequence for generating unique OID values. The table is designed to manage menu items with hierarchical relationships and additional metadata.

Uploaded by

optimusprimedeveloper
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

CREATE TABLE "MENUS"

( "OID" NUMBER NOT NULL ENABLE,

"PARENT_OID" NUMBER,

"MENU_NAME" NVARCHAR2(100),

"MENU_LINK" NVARCHAR2(200),

"STATUS" NVARCHAR2(1),

"DESCRIPTION" NVARCHAR2(200),

"SORT_BY" NUMBER,

"PID_EMPLOYEE_INSERT_BY" NUMBER,

"PID_EMPLOYEE_UPDATE_BY" NUMBER,

"UPDATE_DATE" DATE,

"INSERT_DATE" DATE DEFAULT sysdate,

"ICON_IMG" VARCHAR2(250),

"MENU_NAME_BANGLA" VARCHAR2(250),

CONSTRAINT "MENUS_C01" CHECK (parent_oid <> oid) ENABLE,

CONSTRAINT "MENUS_CON_PK" PRIMARY KEY ("OID")

USING INDEX ENABLE

) ENABLE ROW MOVEMENT

ALTER TABLE "MENUS" ADD CONSTRAINT "MENUS_CON" FOREIGN KEY ("PARENT_OID")

REFERENCES "MENUS" ("OID") ENABLE

CREATE SEQUENCE "MENUS_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999


INCREMENT BY 1 START WITH 1527 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE GLOBAL

You might also like