Interested to Buy Any Domain ? << Click Here >> for more details...
Give two examples of how you might determine the structure
of the table DEPT.
- 2 Answers
- 6347 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
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
Why more redos are generated when the oracle database is in begin backup mode?
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
How many segment are present in Oracle Manufacturing
What is an Oracle database Partial Backup?
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
what is difference between inner join & nested query or subqueries
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.
What is the difference between recovery and restoring of the oracle database?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
what is the link between suppliers and banks in ap module in oracle apps? And also query?
Difference between transaction type and transaction sources. : oracle accounts receivable
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
what are the tools used for oracle 10g in real time.
What is the sql query to find the employee who has Nth maximum salary?
