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
i2,
2 5455I have table that has student names in it.If I query on the names my result set should return as 'VALUE NOT ENTERED' for null entries.
1 3894i want to know rdbms certification details and syallabus and for whom i contact for rdbms certification in bangalore i need answer very urgent please mail to aniltelkar50@gmail.com please as soon as possible
2106Post New Oracle Call Interface (OCI) Questions