Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Hello oracle experts, I am developing new custom form in Oracle EBS R12 and i want to store WHO columns values like : CREATION DATE, CREATED BY, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN please guide me how to do this ? thanks in advance.
some people suggest to use this query : select * from employees where rownum <= 10 order by salary; but the problem with this will return a random set of ten rows ordered by salary which is not what I need.
when trying to extend a VO actually it's extended successfully but when i trying to search for more than one time inside LOV page this exception is throwing java.sql.SQLException: Invalid column type and this full error message: oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error ...
hi i have data set that has ampersand symbol "&" and i want to insert this data but when i put this symbol into values of insert statements TOAD asking for substitution value i tried to escape this symbol but it ...
Hello,How can I load an image from the server and save it in the application on oracle forms, please?Thanks
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 ...
hello can I use select inside if statement like : begin if (select count(*) from employees) >= 15 then do something; end if; end; note : I want to delete rows from table where above condition evaluates with true
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" ...
i have a string like this String Oracle Forms 10G and i want result to be like this String OracleForms10G without spaces between words is there any oracle function to do this ...
