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 6448

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

IBM,

6 19158

What is the difference between formula column and place holder?

3 7907

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 4382

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

1977

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

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

Polaris,

2 5611

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

CTS,

2622

What are the composite date types in oracle?

HCL,

6 18006

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

3 6546

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 4291

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 5056

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

2135

how to use sequence and what use of sequence cache

1 4479

what is difference between where clause and having clause?

13 36464


Un-Answered Questions { Oracle }

What privilege is needed for a user to delete rows from tables in another schema?

1066


Is oracle a relational database?

916


Difference between transaction type and transaction sources. : oracle accounts receivable

1032


is there a tool to trace queries, like profiler for sql server?

1141


How to list all user accounts in oracle?

1027


How to delete multiple rows from a table in oracle?

1060


How to use null as conditions in oracle?

1083


What is the difference between internal & external schema?

757


What is merge statement used for?

1024


What is redo log?

1064


How do we represent comments in oracle?

1048


What is difference between co-related sub query and nested sub query?

567


If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

576


how to write customizations in po

1618


You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

617