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 5092what is the difference between oracle reports 6i and oracle reports 10g? give atleast 10 differences? (plz give the answer vvvvvvvvvvv.urgent)
1 22754Q1: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 3012
How to select some columns from a table in oracle?
What is a trigger and what are its types?
What is open database communication (odbc) in oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
Which data loaded are in target db?
How can you determine if an oracle instance is up from the operating system level?
What is the difference between raid 5 and raid 10? Which is better for oracle?
Write a syntax for update query in oracle?
How can you determine the space left in a file system?
How to start your 10g xe server?
What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?
How to update a table row with a record?
What is dual table oracle?
Why do we need a database?