can we use a having cluase in groupby clause. if there are 500 records i will give rownumber<250 then how many records does it retrieve. wt is the result of nvl2(null,notnull,null) if there are four tables without using cartesian how many joins can be there. in the sql subqueries wt is the parent ans1)select 2)update,3) delete 4)2&3
2 6058Post New i2 Oracle Call Interface (OCI) Interview Questions
What are the disadvantages of a shell structure?
what is difference between milestone and run-levels in Solaris ?
What is the use of the function in c?
What is MVVM design pattern?
Write a Program for Insert in a sorted list
What is the difference between convert and parse in c#?
Write a program to show the change in position of a cursor using c
What are the differences between informatica and abinitio?
if company is registered in West Bangal and goods are purchased from Maharashtra for export, and export will be done from Maharastra, then who can issue the H form?
How data is processed and what are the fundamentals of this approach?
Illustrate the sandals of ancient Egyptian people.
What are the differences between Structures and Arrays?
How can a company invite public deposits through advertisements?
Explain me what could be the cause of selenium webdriver test to fail?
What are routines in datastage? Enlist various types of routines.