Interested to Buy Any Domain ? << Click Here >> for more details...
What is an Oracle view?
- 1 Answers
- 2611 Views
- I also Faced
- E-Mail Answers
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 |
What are temporal data types in oracle?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
How to do paging with oracle?
Where are the settings stored for each instance in oracle?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
What is a proxy class?
How to revoke create session privilege from a user in oracle?
How to assign values to data fields in record variables?
Give syntax for SQL and ORACLE joins.
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
What is ASM (Automatic Storage Management) in Oracle?
How to select all columns of all rows from a table in oracle?
Oracle General 
