What is the order of defining local variables and sub procedures/functions?


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

Post New Answer

More Oracle General Interview Questions

is there a tool to trace queries, like profiler for sql server?

0 Answers  


How to export your connection information to a file?

0 Answers  


Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

4 Answers   JPMorgan Chase,


How do I use os authentication with weblogic jdriver for oracle and connection pools?

0 Answers  


How to select some columns from a table in oracle?

0 Answers  






Can a parameter be passed to a cursor?

0 Answers  


What are the various oracle database objects?

0 Answers  


13. Display the second to fifth characters in each client name.

2 Answers   Wipro,


cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 Answers  


Explain about your project and its relation to the current job position you are applying to?

0 Answers  


Describe an oracle table?

0 Answers  


how to get the second max val for every group in a table

6 Answers   Verizon,


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)