How would you extract DDL of a table without using a GUI tool?
Answer / shafi.oracledba
to extract the ddl statement use the alter command to extract
| Is This Answer Correct ? | 0 Yes | 1 No |
What is a data dictionary and how can it be created?
What is pragma autonomous transaction in oracle?
What is an Index ? How it is implemented in Oracle Database ?
What is the difference between post-database commit and post-form commit?
Difference between hot backup vs. Cold backup?
What is merge in oracle?
What is DTS and purpose of DTS ?
How can we force the database to use the user specified rollback segment?
What is flashback in Oracle?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL
Explain what are the different type of segments?
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit