Answer / ramesh

From Scott Schema

1.Desc Dept

2.Select Table_name,Column_name,Data_type,nullable from
user_tab_columns wheRE table_name = 'DEPT'

Answer / amrutharao d

1. SQL>Desc Dept

2. SQL>Select Table_name,Column_name,Data_type,nullable from
user_tab_columns wheRE table_name = 'DEPT'

3. SQL>set long 99999
SQL>select dbms_metadata.get_ddl('TABLE','DEPT') from
dual;

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---

Hot backup procedure?

2 Answers  

---

What column differentiates the V$ views to the GV$ views and how?

3 Answers  

---

What is the difference between Datapump & export/import?

2 Answers  

---

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

---

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

---

How to start SQL Server in minimal configuration mode?

1 Answers  

---

how can you connect from 10g user to 11g user??

0 Answers   HP,

---

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

---