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 6449

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

IBM,

6 19160

What is the difference between formula column and place holder?

3 7908

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 4386

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

1978

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

1695

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

Polaris,

2 5617

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

CTS,

2623

What are the composite date types in oracle?

HCL,

6 18007

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

3 6547

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 4295

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 5058

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 4480

what is difference between where clause and having clause?

13 36469


Un-Answered Questions { Oracle }

What are the different responsibilities of a dba?

722


Can i create more than one Master Repository in ODI?

597


A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

558


Differentiate between pre-select and pre-query?

1106


Does dba need to know programming?

568


How to use regular expression in pattern match conditions in oracle?

1041


What is a table index in oracle?

1131


What are the goals of dba?

558


Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?

575


Are you familiar with user exits in reports?

1


How can I combine multiple rows into a comma-delimited list in oracle?

1062


What is translate in oracle?

1098


What degree do database administrators need?

544


Please explain oracle left join with an example?

1045


what is difference between group above and group left report

3820