How to assign query results to variables?


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

Post New Answer

More Oracle General Interview Questions

What is E-R diagram ?

2 Answers   CGI, Keane India Ltd,


Difference between pre-select and pre-query

0 Answers  


If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 Answers  


What happens if the update subquery returns multiple rows?

0 Answers  


How to import one table back from a dump file?

0 Answers  






how to hide the stored procedure inside a package

1 Answers  


What is columnar storage what is the advantage?

0 Answers  


What are the varoius components of physical database structure of oracle database?

0 Answers  


what is the syntax of update command?

3 Answers   Semantic Space,


What is PL/SQL ?

0 Answers  


What is a table index?

0 Answers  


Explain view?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • 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)