|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions The PRAGMA EXECPTION_INIT tells the complier to associate an exception with an oracle error. To get an error message of a specific oracle error. e.g. PRAGMA EXCEPTION_INIT Latest Answer : PRAGMA EXCEPTION_INIT statement associate the declared exception with the standard Oracle server error number. PRAGMA EXCEPTION_INIT tells the compiler to associate an exception name with an Oracle error number. That allows you to refer to any internal ... Why Functions are used in oracle ?Can Functions Return more than 1 values?Why Procedures are used in Why Functions are used in oracle ?Can Functions Return more than 1 values?Why Procedures are used in oracle ?What are the Disadvantages of packages?What are the Global Variables in Packages? Read Answers (17) | Asked by : sandeep kelkar How to return more than one value from a function?What are the types of triggers?What are the features of oracle 9i 1)what is the starting "oracle error number"?2)what is meant by forward declaration in functions? Read Answers (7) | Asked by : suribabu Latest Answer : No. You cannot export a higher version to the lower version. ... Read Answers (2) | Asked by : santanu koner Latest Answer : You should put your question here. This forum is not a library. Please take care. ... Read Answers (1) | Asked by : sudha periasamy Latest Answer : define is use for predefine variable its depends on user. You can use char or number ... 1.What is bulk collect?2.What is instead trigger3.What is the difference between Oracle table & PL/SQL table?4.What R built in Packages in Oracle?5.what is the difference between row migration & row changing? Sir,pls send me some more oftanily asked oracle interview questions iam an one year exprience person...i need one year oracle interview questions..... Read Answers (2) | Asked by : basavarajkolur Hi, What is nocopy parameter in oracle procedure. what is the use of it. In which situation,we can use the nocopy parameter.Thanks,Saravanan.P Latest Answer : Ussually IN paramter is pass by value and OUT/IN OUT are pass by refererence....If one wants to send the IN paramter too as pass by reference he could add NOCOPY parameter....advantage is always less memory usagedisadvantage is when there is a change ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
