I want to create a stored procedure with one parameter which will return multiple rows based on parameter value. how can i do this ?
Question
Oraask Latest Questions
Question
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.
Question
i face this error when trying to compile this pl/sql block Error: PLS-00103: Encountered the symbol "THEN" when expecting one of the following: := . ( % ; declare CURSOR abc IS select * from all_Objects; begin for rec in abc loop ...
Question
please i want to read excel (.xlsx) from PLSQL ? is that possible or not ?
Question
I have a cursor declared inside procedure into package and I want to use this cursor into another procedure or function inside the same package is that possible or not ?
Question
I'd like to create pl/sql array variable to hold an ordered collection of data thanks.