What are the PL/SQL Program limits ?
Question
Oraask Latest Questions
Question
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 ...
Question
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 ...
Question
how can I convert text column value to array like : i have the values " text1, text2, text3" thanks in advance.
Question
please i want to find way to convert clob datatype to varchar2 datatype i searched many times through google but with no valuable result.
Question
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
Question
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?
Question
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" ...
Question
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;
Question
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