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 |
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
Will you be able to store pictures in the database?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
List out the components of logical database structure of oracle database.
what is Table ?
Explain about your project and its relation to the current job position you are applying to?
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
diff between DELETE and TRUNCATE?.
14 Answers HCL, Yalamanchili Software,
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What is pragma autonomous transaction in oracle?
What is the order of defining local variables and sub procedures/functions?
Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.