| Naga |
Posted: Jan 09, 2007 02:08:26 AM |
Total Post: 7
Joined: Jan, 2007
|
I have created the view EMP_DEPT_VU and if i want to c its structure ..
(Choose any one)
A. Use the DESCRIBE command in the EMP_DEPT VU view.
B. Use the DEFINE VIEW command on the EMP_DEPT VU view.
C. Use the DESCRIBE VIEW command on the EMP_DEPT VU view.
D. Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
E. Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
F. Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
Ans... A or D (Acording to me)
|
|
|
 SatyaN |
| Posted: Jan 09, 2007 01:55:15 PM |  |
|
Total Post: 28
Joined: Nov, 2006
|
If i am not wrong A is the correct answer . D will be wrong from any dictionary table you can see the object details like name and status . But object structure can be only possible with DESC command....
|
|
|
|
|
| shaily |
| Posted: Jan 10, 2007 08:17:27 AM | |
|
Total Post: 1
Joined: Jan, 2007
|
hi dear
try this
SELECT TEXT
FROM USER_VIEWS
WHERE VIEW_NAME = 'VIEWNAME'
if the result is not visible completely, set long from 80 to greater value may be 500 or 1000
|
|
|
|
|
| ron |
| Posted: Jan 16, 2007 05:22:25 AM | |
|
Total Post: 9
Joined: Nov, 2006
|
answer A is correct.
the command will be
describe EMP_DEPT_VU
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
