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 5266what is the difference between oracle reports 6i and oracle reports 10g? give atleast 10 differences? (plz give the answer vvvvvvvvvvv.urgent)
1 22942Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.
1 3233
Explain the various types of oracle report?
What is the difference between a primary key & a unique key?
How can we generate report output in excel format?
Have you created sequence? When will you use?
How would you find total size of database in os level?
What is a cursor in oracle?
What is oracle dba role?
How can we create the complete backup of data in the oracle.
What are the parameters that we can pass through a stored procedure?
What is dynamic proxy?
What is BBED in Oracle?
What is the difference between PFILE and SPFILE in Oracle?
What is the difference between raid 5 and raid 10? Which is better for oracle?
Teradata: How can we know the indexed column in a table?
Mention what are the benefits of oracle rac?