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
Please, I want to know how to create dynamic tables ,columns, and datatype for each column in oracle ?
Question
i have a table with some values in it basically i want to count how many number (2) present in this table : Col1 Col2 Col3 ----- ------- ------- 2 1 3 8 ...
Question
i want to update my table with data in another table in oracle sql for example Table 1: ID NAME DESC --------------------------- 1 ...
Question
i want to know whether partitioning enabled or not in my database
Question
i have two date columns and i want to get the number of days between those two dates
Question
please i want to read excel (.xlsx) from PLSQL ? is that possible or not ?
Question
I'd like to create pl/sql array variable to hold an ordered collection of data thanks.
Question
I want to order by a string in SQL query like Select * From employees ORDER BY names (mark, mac , jack, steve)