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


Please Help Members By Posting Answers For Below Questions

Can we modify approve purchase order?if yes what is navigation?

1551


we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

1881


Give two methods you could use to determine what DDL changes have been made.

6032


where the dff data will be stored

1808


What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

3994






What is Restricted Mode of Instance Startup in Oracle?

683


What is the disk migration? what is the steps involved in oracle disk migration?

723


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

1773


What are different types of receipt reversals ? Explain them : oracle accounts receivable

731


Explain accounting for invoice in advance and arrears. : oracle accounts receivable

627


can we use lexical perameter in oracle plsql if yes how

1828


WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

1654


I would like to study certification course in Data base adminidtrator then where would i go to study this course?

1734


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

1963


WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2392