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 |
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What are the different types of record groups in oracle? Explain each of them
How to invoke the data pump export utility?
What are various joins used while writing SUBQUERIES?
What is raw datatype?
What is SQL Tuning Advisor in Oracle?
What is an anonymous block?
What is flashback in Oracle?
Difference between open_form and call_form in oracle.
Query to get max and second max in oracle in one query ?
34 Answers CTS, Keane India Ltd, TCS, Wipro,
How to drop an index in oracle?
What is a public synonym?