In a package if we have 10 procedures or functions,How to
know which will execute first?
Answer / guest
1.Inner\Sub Group statements are Executed
2.Procedures\Functions having normal fetching stmt is
executed first
Is This Answer Correct ? | 1 Yes | 3 No |
Can we use threading in pl/sql?
Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.
i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w
4 Answers Scope International,
How to get employee name from employee table which is the fiveth highest salary of the table
I have done oracle 10g. I need a project knowledge. So if u please send a project how it should be done,Or you can send email link. I will be very grateful to u.
how to find the second highest salary from emp table?
211 Answers CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar,
Which join condition can be specified using on clause?
How to find 3rd highest salary of an employee from the employee table in sql?
What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?
How to start oracle sql developer?
What is a dirty read sql?
how can you see all indexes defined for a table? : Sql dba