Which statement shows the view definition of the view EMP_VIEW (that - ProProfs Discuss
Advertisement

Which statement shows the view definition of the view EMP_VIEW (that is created based on the table EMP)?

Which statement shows the view definition of the view EMP_VIEW (that is created based on the table EMP)?

Change Image    Delete



A. SELECT view_text FROM TABLE emp WHERE view_name = EMP_VIEW ;
B. SELECT view_text FROM my_views WHERE view_name = EMP_VIEW ;
C. DESCRIBE VIEW emp_view
D. SELECT text FROM user_views WHERE view_name = EMP_VIEW ;

This question is part of grvmock
Asked by Grvion, Last updated: Oct 19, 2020

+ Answer
Request
Question menu
Vote up Vote down

2 Answers

l.Steven

l.Steven

l.Steven
L.Steven

Answered Jan 07, 2018

The statement which shows the view definition of the view EMP_VIEW that is created based on the table EMP is given as: SELECT text FROM user_views WHERE view_name = EMP_VIEW. Oracle Corporation is a company that creates databases for a big number of clients all over the globe.

They specialize in creating databases for companies, and provide them a framework using which they can carry out complex management operations and keep a record of information of their employees and customers. It is considered to be a go-to source for content management systems and databases all over the globe.

upvote downvote
Reply 

John Smith

John Smith

John Smith
John Smith

Answered Mar 01, 2017

SELECT text FROM user_views WHERE view_name = EMP_VIEW ;
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.