Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241) Please explain the difference between outer join and inner join? With examples would be appreciable..!
IBM,
6 19407HI 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 4492how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
2043in 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
1754how can db_files > maxdatafiles since db_files is for instance and the later is for database
CTS,
2675Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
3 6704in 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 4377HI 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 5163in 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
What are dba privileges?
What do you understand from cache fusion?
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.
What are the various oracle database objects?
What is difference between truncate and delete?
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
What is a user function?
types of indexes and the rationale behind choosing a particular index for a situation.
Name the various constraints used in oracle?
Explain the wait events in statspack report 'db scattered read'?
How to specify default values in insert statement using oracle?
Please explain drop constraint oracle?
What is load plan and types of load plans in ODI?
In topology manager where the data are stored?
How to use values from other tables in update statements using oracle?