How to pass parameters to procedures in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?
What would you do with an in-doubt distributed transaction?
What do database buffers contain?
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
What a SELECT FOR UPDATE cursor represent.?
what is the difference between UNION AND UNIONALL
How would you change old and new values in an insert, delete and update triggers?
What is a table index in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is a initialization parameter file in oracle?
What are the data types in oracle?
What is save point in oracle database?