How do you get the return values in pl/sql when u exec them be sides assigning the values to Bind variables
Latest Answer : First create a Trigger and with Procedure you insert records.The :new will take the new values.So use Triggers in Procedures. ...
We have on delete cascade in Oracle but we don’t have on update cascade. If you compare Oracle with SQL Server in SQL Server we have the option called on update cascade but In Oracle we don’t have this option why? Please can you just clarify my doubt?
Hi Guys,i have an interview question. can anyone help me reg this.i have a table called "phone" and filed as "phone number" and table have values like 2489078905,2345678909now i want the result as (248)9078905,(234)5678909 into another table called phone2.
If anyone asks in interviews, about "what are the types of triggers" then my ans is likerow level,statement level,before,after,insert,update,delete 3*2*2 total 12 types.and can i even mention instead of triggers,database trigger and schema triggers
Hi 1.What is difference between procedure and function?1. procedure may or may not return values whereas function must return value2. we can call the function in the sql statements whereas we can't call the procedureExcept these two, is there any difference between these two.2. What is pl/sql table and what is use of it. In which case, we can use it3. What is ref cursor, what is the use of it.4.how the function will return multiple values. Pls give me with examples
Hi all if i can assign any value to the out parameter in procedures .... like i had created this procedure ...CREATE ORE REPLACE PROCEDURE MODETEST ( PARAMETER OUT NUMBER)ISJUSTTEST NUMBER :=20;BEGINPARAMETER :=JUSTTEST ; *HERE I ASSIGN VALUE TO OUT PARAMETER *JUSTTEST := PARAMETER;dBMS_OUTPUT.PUT_LINE(JUSTTEST);END; AND THE PROCEDURE IS CREATED WITHOUT ANY ERROR BUT I THAUGHT THE OUT PARAMETERS ARE WRITE ONLY AND WE CANT ASSIGN ANY VALUE TO IT ....
What is the maximum number of data string can be returned from DBMS_OUTPUT? andHow do you call a trigger from a table?
Hi,Can somebody please answer couple of my questions ASAP?1) How do you call a trigger on a table?2) What is the maximum number of data strings that can be returned through DBMS_OUTPUT?Much thanks!!
In my table "temp" one column contain 1 to 10 range of values in between some numbers are missing. like belowTEMPcolumn112475so in this table i want search missing number from 1 to 10.so output should be 3689.how to get this o/p?