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;

i have marks in table,how to find total?

1 Answers  

---

What is the disk migration? what is the steps involved in oracle disk migration?

0 Answers  

---

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

0 Answers  

---

can we drop dual table

7 Answers   Metric Stream,

---

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

0 Answers  

---

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

0 Answers  

---

What is the Symbol use for Inner Join

1 Answers   Oracle, TCS,

---

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

4 Answers  

---

Explain the use of table functions.

0 Answers  

---

I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?

1 Answers   Oracle,

---

How would you force a log switch?

1 Answers  

---

A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?

7 Answers   TCS,

---