What is an Oracle view?
Answer / nishi
A view is a virtual table. Every view has a query attached to it. (The query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)
| Is This Answer Correct ? | 1 Yes | 0 No |
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
How to Remove the 3rd highest salary person record from table?
How to get a list of all user accounts in the database?
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
What is the database name in oracle?
How to establish administrator authentication to the server?
What is connection pool in oracle?
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
What is the Tune Query
Why we use bulk collect in oracle?
What is a sub query? What are its various types?
How would you optimize a slow SQL query?