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 19182HI 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 4396how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
1983in 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
1701how can db_files > maxdatafiles since db_files is for instance and the later is for database
CTS,
2629Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
3 6558in 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 4305HI 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 5067in 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
2141
Give one method for transferring a table from one schema to another?
Explain the use of dde package in d2k.
Difference between oracle's plus (+) notation and ansi join notation?
How to sort the query output in oracle?
What is the difference between a database and instance? What is the relation between them?
What is an oracle report?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
Use of an integrity constraint is better to validate data. Explain
How to return top 5 rows in oracle?
Any work done in oracle workflow builder. Did you customize or build a new workflow?
How to use group functions in the select clause using oracle?
How do I know if oracle client is installed on windows?
How to handle a single quote in oracle sql?
Explain what are the uses of rollback segment?
How to connect the oracle server as sysdba?