Give two examples of how you might determine the structure
of the table DEPT.
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
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
what is semphore explian it?
What view would you use to determine free space in a tablespace?
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
What is db_recovery_file_dest in oracle? When do you need to set this value?
Difference between negative and positive adjustments : oracle accounts receivable
What is auto invoicing? Explain : oracle accounts receivable
What is the disk migration? what is the steps involved in oracle disk migration?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
What are different types of transactions in ar? : oracle accounts receivable
What is the difference between oracle media recovery and crash recovery?
as a technical developer in oracle applications which type errors feced in your experience sofar
what are the tools used for oracle 10g in real time.
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..