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 |
Explain materialized views and how they are used.
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
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 does coalescing a tablespace do?
can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )
Could you please let me know the interfaces in OM / FA??
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
What is the sql query to find the employee who has Nth maximum salary?
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.
Is it possible to drop a column in a table which contains only one column? How?
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.