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.
How to drop all partitions from all tables belonging to this schema based on date Hi, I have a script to delete the partition from a table which meet certain criteria and this the block of code to do this : DECLARE v_sql varchar2(500); v_date ...
How to repeat the same values to the next record from the previous record ?
hi, we using message('') in oracle forms to show message what is the equivalent approach to do this in oracle reports 10g?
Hello guys, i called a report (10g) from apex page and it's working fine without errors but i have found that all the schema informations like schema nam, username and password it's appear in the url which is not secure, so please ...
hello experts, what i want is : query to display 'job' & their counts & then display the no. of distinct 'dept no' under each 'job' & their counts ? consider i have these dataset : SQL> select * from dept; DEPTNO DNAME LOC ---------- -------------- ...
How to call MySQL Procedure from Oracle using HS Link ? HS link is correct and I can get the tables data just by adding '@' at the end of the table name ,but I can't call the SP same way ...
please someone explain shortly what is major differences between ADF and JSF ?
I face this error when I want to execute this block of code in an anonymous pl/sql block: DECLARE BEGIN SELECT last_name INTO v_last FROM employees; dbms_output.put_line('v_last is :' || v_last ); END; PLS-00201: identifier must be declared thanks.
it is possible to INSERT or UPDATE or even DELETE a row inside table through view ?
I have item named (ON_HAND_QTY) and i want to do a certain action whenever the value changed in this item what i need something like this :old_value and :new_value or something similar to this logic.
