Empowering World With Technology

 Imp Note => In table name only underscores are allowed.  CREATE TABLE "<SCHEMA_NAME>"."<TABLE_NAME>"  ( "PXCOMMITDATETIME  TIMESTAMP(6), "PXCREATEDATETIME" TIMESTAMP(6), "PXCREATEOPNAME" VARCHAR2(128 BYTE), "PXCREATEOPERATOR" VARCHAR2(128 BYTE), "PXCREATESYSTEMID" VARCHAR2(128 BYTE), "PXINDEXCOUNT" NUMBER(18,0), "PXINDEXPURPOSE" VARCHAR2(255 BYTE), "PXINSINDEXEDCLASS" VARCHAR2(255 BYTE), "PXINSINDEXEDKEY" VARCHAR2(255 BYTE), "PXINSNAME" VARCHAR2(192 BYTE), "PXOBJCLASS" VARCHAR2(96 BYTE), "PXUPDATEDATETIME" TIMESTAMP(6), "PXUPDATEOPNAME" VARCHAR2(128 BYTE), "PXUPDATEOPERATOR" VARCHAR2(128 BYTE), "PXUPDATESYSTEMID" VARCHAR2(128 BYTE), "PYLABEL" VARCHAR2(255 BYTE), "PZINSKEY" VARCHAR2(255 BYTE) NOT NULL ENABLE, "PXSAVEDATETIME" TIMESTAMP(6) ); COMMIT;

Oracle SQL Queries Change Table Name ALTER TABLE  "<TABALE_NAME>"  RENAME TO NEW_TABLE_NAME; COMMIT; Select Query For Index Table SELECT * FROM <TABLE_NAME> where pxinsindexedkey like '%C-105%'; Case Count In Index Table SELECT COUNT(*) FROM INDEX_IN_B_DATA_CONTROL; Drop Column Command ALTER TABLE  "<TABLE_NAME>"  DROP COLUMN   "<COLUMN_NAME>"; COMMIT; Add Column ALTER TABLE <TABLE_NAME>  ( "ADDRESSCOUNTRY" VARCHAR2(255 BYTE) ); COMMIT; Modify Column ALTER TABLE <TABLE_NAME> MODIFY  (LoanProvider VARCHAR2(255 BYTE)); COMMIT;