Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



Oracle Interview Questions
Questions Answers Views Company eMail

What are cursor?where are they used?

2 6544

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

IBM,

6 19407

What is the difference between formula column and place holder?

3 8033

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 4492

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

2043

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

1754

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

Polaris,

2 5731

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

CTS,

2675

What are the composite date types in oracle?

HCL,

6 18228

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

3 6704

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 4377

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 5163

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

2197

how to use sequence and what use of sequence cache

1 4547

what is difference between where clause and having clause?

13 36932


Un-Answered Questions { Oracle }

What are dba privileges?

593


What do you understand from cache fusion?

1


We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

5380


What are the various oracle database objects?

1204


What is difference between truncate and delete?

1100


I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1260


What is a user function?

715


types of indexes and the rationale behind choosing a particular index for a situation.

2564


Name the various constraints used in oracle?

1082


Explain the wait events in statspack report 'db scattered read'?

631


How to specify default values in insert statement using oracle?

1157


Please explain drop constraint oracle?

1161


What is load plan and types of load plans in ODI?

674


In topology manager where the data are stored?

727


How to use values from other tables in update statements using oracle?

1131