Oracle General (1809)
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 18917HI 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 4293how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
1933in 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
1639how can db_files > maxdatafiles since db_files is for instance and the later is for database
CTS,
2583Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
3 6393in 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 4195HI 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 4969in 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
2074
Can a View based on another View in Oracle?
How do I find the database name in oracle?
Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?
What is a canvas in oracle forms?
what is tripstop report?
What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?
Explain the wait events in statspack report 'enqueue'?
How to use regular expression in pattern match conditions in oracle?
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
what are basic modules required to implement oracle application in any oraganisation?
How can you merge two tables in oracle?
What is meant by joins?
How to call a sub procedure?
What do you mean by sga and how is it different from pga?
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g