Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
I have two tables one ordinary table and other is log of this table test_table test_tab_log I want to insert new row in the log table for each insert statement executed for basic table even if there is rollback executed. simply every row inserted in the base table ...
hi is there any approach in pl/sql to execute more than one procedure in one time like: BEGIN Proc1('first'); Proc1('second'); Proc1('third'); END; but ...
how can I convert text column value to array like : i have the values " text1, text2, text3" thanks in advance.
hello can I use select inside if statement like : begin if (select count(*) from employees) >= 15 then do something; end if; end; note : I want to delete rows from table where above condition evaluates with true
I have a PL/SQL procedure to update a number of rows in a table. is there is there any way to know the number of rows updated by update statement executed inside my procedure?
I want to raise user defined exception but with custom exception error message something like this : DECLARE ex_custom EXCEPTION; BEGIN RAISE ex_custom; EXCEPTION WHEN ex_custom THEN DBMS_OUTPUT.PUT_LINE(SQLERRM); END; The output is "User-Defined Exception" ...
I have a table has column ID,NAME which ID is PK I want to insert a new row if only this new row doesn't exist in the table something like this : if ID doesn't exist then INSERT STATEMENT HERE ; end if;
please I want to know how can I send emails from PL/SQL I heard about there is a package called UTL_MAIL but I want some examples to do this thanks in advance
I want to create a stored procedure with one parameter which will return multiple rows based on parameter value. how can i do this ?
hello, Ii got an error when I want to use my directory created inside UTL_FILE.FOPEN invalid directory path within the procedure to open a certain file on my local machine.
