i faced this error when trying to call pdf or any other format report from oracle forms REP-52262 Diagnostic output is disabled oracle report version : 11G oracle forms version : 11G your help will be very appreciated.
Question
Oraask Latest Questions
Question
I want to create new column say (ID) with auto generated sequence number with auto increment by 10.how can I achieve this in oracle database 11g ?
Question
I have a column with datatype CLOB and I want to get column valueI tried using select DBMS_LOB.substr(last_name) from employees for example but it's throwing error ,I need help to query a CLOB column.
Question
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
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 ?