how can I convert text column value to array like : i have the values " text1, text2, text3" thanks in advance.
Oraask Latest Questions
hello guys can someone explain to me what is the differences by easy way and with example if possible.
please i want to find way to convert clob datatype to varchar2 datatype i searched many times through google but with no valuable result.
hi i face this error oracle.apps.fnd.framework.OAException: Application: ICX, Message Name: Could not find the specified responsibility. when i'm trying to run welcomePG from jdeveloper i applied all jdeveloper configurations correctly but i don't know why this error is raising. this responsibility assigned to my ...
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" ...
hi all, i have a string getting from variable in my controller like this : String Vstr = pageContext.getParameter("Myfield"); now i want to use this variable in sql statement but if i pass this variable like +Vstr in my sql ...