hello I want to know if my column value is number or character in oracle 10g something like : select (case when ( is_number(mycolumn)) then 'your column value is number' else 'your column value is not number'
Question
Oraask Latest Questions
Question
Error report: SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended" i face this error when trying to execute this update statement please can anyone tell me error cause and solution UPDATE employees set last_name = 'test' JOIN dept ...
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
Question
how can know all reserved words by oracle to avoid using it ?
Question
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
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 confused about the meaning of schema and user is there any difference between twice or not ?
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
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 ...