Answer / vaishali

First way is :

desc dept;

Second Way is:

select COLUMN_NAME,decode(NULLABLE,'N','NOT
NULL',' '),DATA_TYPE||'('||DATA_LENGTH||')' from
user_tab_columns where table_name='DEPT';

Answer / chinnikrishna

DESC Dept;

Name a tablespace automatically created when you create a database.

3 Answers   HCL,

---

what is different between inline query,subquery& corelated query?

8 Answers   Quest,

---

what is shared memory?

1 Answers   IBM,

---

Can we get the deleted Record again if the delete transaction has been committed.

4 Answers  

---

Whats the purpose of using Nextval while creating the sequence.

2 Answers   HCL,

---

how can we send a concurrent program output to the clients through mail or fax give me example.

1 Answers   Cap Gemini,

---

What is the difference between oracle media recovery and crash recovery?

0 Answers  

---

What are the mandatory setups in setting up a PO in oracle

1 Answers   Silicon,

---

What do you mean by Oracle MEDIA RECOVERY?

0 Answers  

---

What view would you use to determine free space in a tablespace?

0 Answers  

---

8. Supporting AP, AR and GL?

0 Answers   Oracle,

---

What command would you use to create a backup control file?

1 Answers  

---