1.What is inline function in oracle and its purpose?
2.What is the equivalent operator for "different from
pattern" in oracle?
3. If you define a variable in oracle, how it will be
available? [a. Until database shut down b. Until table deleted
c. until session get expired]
Answers were Sorted based on User's Feedback
How to find the duplicate rows count from employees table in oracle?
I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.
5 Answers Microsoft, Oracle, TCS,
Explain an integrity constrains?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
How to get execution path reports on query statements?
24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.
Explain implicit cursor.
What is translate in oracle?
what is the dual table in oracle?
How to create tables for odbc connection testing?
after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble
How would you go about verifying the network name that the local_listener is currently using?