1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

What are cursor?where are they used?

 2 5472

Please explain the difference between outer join and inner join? With examples would be appreciable..!

IBM,

6 17210

What is the difference between formula column and place holder?

 3 6400

HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.

2 3432

how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

 1530

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1292

What is store procedure?and how do u take the values from database and run in scripts?

Polaris,

2 4479

how can db_files > maxdatafiles since db_files is for instance and the later is for database

CTS,

2173

What are the composite date types in oracle?

HCL,

6 15999

Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table

 3 5299

in reports 1og.if we enter a query in list of values then parameter form displays a dropdown.in that if any ething is selected then that will display in the report.supp if i am not selected any value then it should display all the values.how it is possible?can any one help me........

 1 3275

HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.

 2 4171

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

 1694

how to use sequence and what use of sequence cache

 1 3760

what is difference between where clause and having clause?

 13 32972

Un-Answered Questions { Oracle }

How do we represent comments in oracle?

627

What are the different pseudo commands? Explain in general?

540

What is data store? How to create data store?

325

What is the load plans? And how to create for the load plans?

304

What is a read only transaction in oracle?

596




What is the history of ODI?

330

What is pga_aggregate_target?

294

What skills do you need to be a database administrator?

271

How to find out what oracle odbc drivers are installed?

574

What is the usage of save points in oracle database?

533

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

2835

What are the attributes of cursor?

589

How to install oracle odbc drivers?

623

How many types of cluster table in Oracle?

575

What is oracle partial backup?

306

For More Un-Answered { Oracle } Questions Click Here