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 oracle datasource?
1.display list of all users from ur data base.what is the query?
What is oracle database client?
Explain the difference between a procedure and a function? What do you understand by those terms?
What are the different pseudo commands? Explain in general?
Difference between the “verify” and “feedback” command?
Explain alias?
I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.
5 Answers Microsoft, Oracle, TCS,
How data locks are respected in oracle?
Explain rename?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)