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 5681

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

IBM,

6 17595

What is the difference between formula column and place holder?

 3 6723

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 3641

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

 1607

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

1375

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

Polaris,

2 4692

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

CTS,

2255

What are the composite date types in oracle?

HCL,

6 16438

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

 3 5542

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 3510

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 4356

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

 1789

how to use sequence and what use of sequence cache

 1 3922

what is difference between where clause and having clause?

 13 33678

Un-Answered Questions { Oracle }

What is tns name?

637

Can we store pictures in the database and if so, how it can be done?

682

Explain oracle insert into command?

727

How many types of database triggers exist?

651

What is oracle rownum?

599




How to write a query with a left outer join in oracle?

706

as a technical developer in oracle applications which type errors feced in your experience sofar

1882

Can you joined two sources without common column?

388

What is the relation of a user account and a schema?

708

What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?

346

What is supporting issues GL AP and AR?

2100

How to uncatalog backup?

351

What are the types of locks in database?

350

What is the difference between a database and instance?

405

How to lock and unlock a user account in oracle?

723

For More Un-Answered { Oracle } Questions Click Here