what is difference between inner join & nested query or
subqueries


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Oracle AllOther Interview Questions

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

2 Answers   Polaris,


Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?

1 Answers  


How do you add a data file to a tablespace?

1 Answers  


What is auto invoicing? Explain : oracle accounts receivable

0 Answers  


Explain the difference between a data block, an extent and a segment.

1 Answers   Accenture, IBM,


hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

0 Answers  


My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

0 Answers   Wipro,


Explain the use of table functions.

0 Answers  


Can we modify approve purchase order?if yes what is navigation?

0 Answers   L&T,


8. Supporting AP, AR and GL?

0 Answers   Oracle,


What is $FLEX$ and $PROFILES$?

2 Answers  


Give two examples of how you might determine the structure of the table DEPT.

2 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)