If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please
1 3549what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?
3 6659how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?
3 7087function can return value ,procedure also return value through out parameter then what is the difference?
3 6518create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?
2 6498TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?
10 10854
Explain the difference in execution of triggers and stored procedures?
Is sql dba a good career? : SQL DBA
Is oracle sql free?
How do we use distinct statement? What is its use?
Why stored procedure is better than query?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
What is the current version of sql?
What is varchar example?
What is an alias command?
what are the advantages of sql ? : Sql dba
How many types of keys are there in sql?
What is dml with example?
What is the requirement of self-join?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What is sql*loader?