Give two examples of how you might determine the structure
of the table DEPT.
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 |
what is diff between pre insert,on insert,post insert triggers?
You have just compiled a PL/SQL package but got errors, how would you view the errors?
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
why r u using etl tool.
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?
What is Virtual Memory?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
Where in the Oracle directory tree structure are audit traces placed?