Give two examples of how you might determine the structure
of the table DEPT.
- 2 Answers
- 6700 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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';
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
