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 5469

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

IBM,

6 17198

What is the difference between formula column and place holder?

 3 6384

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 3421

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

 1528

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

1287

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

Polaris,

2 4472

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 15979

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

 3 5286

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 3264

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 4167

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 3752

what is difference between where clause and having clause?

 13 32956

Un-Answered Questions { Oracle }

What are open_form,call_form,new_form?

1

What are the provisions and resources provided in the oracle’s cloud server?

1

How to rename a column in an existing table?

615

Why do you create or replace procedures rather that drop and recreate.

543

What are the five main functions of a database administrator?

296




What is autocashrule set? : oracle accounts receivable

733

As an oracle dba what are the entire unix file you should be familiar with?

281

What are the differences between char and nchar in oracle?

593

What are summary column and placeholder column in reports?

1

Explain rename?

549

What are the types of data contol?

322

What do you understand by lov?

561

How will you identify oracle database software release?

525

Explain how you would restore a database using RMAN to Point in Time?

1630

How do we represent comments in oracle?

625

For More Un-Answered { Oracle } Questions Click Here