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.
Hi , I have the below query where am using TRUNC on the column2 filed which is increasing the performance delay. so need to avoid the TRUNC on this check and need to use BETWEEN operator. Here SYSTEMDATE is the currentdateandtime. So how can ...
Hi, I need a sample for using sys_connect_by_path in sql query please regards,
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.
