Give two examples of how you might determine the structure
of the table DEPT.
- 2 Answers
- 5083 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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';
| Is This Answer Correct ? | 5 Yes | 0 No |
How can you gather statistics on a table?
What background process refreshes materialized views?
How would you determine what sessions are connected and what resources they are waiting for?
What is an Oracle database Full Backup?
difference of using cursor for loop and open,fetch,close.which one is better
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
deference between & and &&
hi all, i have installed oracle xe software in windows 7. iam unable to connect sqldeveloper tool. can you please tell me how to connect. provide completed procedure.
how to replace not in with not exist?
What is supporting issues GL AP and AR?
What is database schema?
Oracle General 
