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) in oracle?

Which statement shows the view definition of the view EMP_VIEW (that is created based on the table EMP) in oracle?<br/>

Change Image    Delete

Asked by Grvion, Last updated: Nov 09, 2024

+ 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.