Interested to Buy Any Domain ? << Click Here >> for more details...
How would you extract DDL of a table without using a GUI tool?
- 1 Answers
- 4439 Views
- I also Faced
- E-Mail Answers
Answer / shafi.oracledba
to extract the ddl statement use the alter command to extract
| Is This Answer Correct ? | 0 Yes | 1 No |
How to build data dictionary view an new database?
How to define default values for formal parameters?
How can we find out the duplicate values in an oracle table?
What is a tns service name?
How to resolve the ORA-39133 error in Oracle?
SQL> CREATE TABLE to_table 2 (col1 NUMBER); Table created. SQL> CREATE OR REPLACE TRIGGER statement_trigger 2 AFTER INSERT ON to_table 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('After Insert Statement Level'); 5 END; 6 / Trigger created. SQL> CREATE OR REPLACE TRIGGER row_trigger 2 AFTER INSERT ON to_table 3 FOR EACH ROW 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level'); 6 END; 7 / Trigger created. SQL> INSERT INTO TO_TABLE VALUES(1); After Insert Row Level After Insert Statement Level 1 row created. SQL> BEGIN 2 INSERT INTO TO_TABLE VALUES(2); 3 INSERT INTO TO_TABLE VALUES(3); 4 INSERT INTO TO_TABLE VALUES(4); 5 INSERT INTO TO_TABLE VALUES(5); 6 INSERT INTO TO_TABLE VALUES(6); 7 INSERT INTO TO_TABLE VALUES(7); 8 INSERT INTO TO_TABLE VALUES(8); 9 INSERT INTO TO_TABLE VALUES(9); 10 INSERT INTO TO_TABLE VALUES(0); 11 END; 12 / WAT LL BE THE O/P??? XPLAIN IT>>>>
what is Single Byte Overhead...?
Where is the export dump file located?
What is a initialization parameter file in oracle?
Is oracle a relational database?
Explain drop constraint oracle?
sql command 2 know current database
Oracle General 
