Forums

why this query can delete duplicates ?
why this query can delete duplicates ? Anybody can give me the detailed explanation ? Thanks select salary from employees union select salary fr

Calling a Procedure with IN & OUT Parameters
Hello, I usually call my procedures using the following way declare variable error_msg varchar2(50) exec simple_msg('ABC,'ABC','ABC',:error_msg

Varible in trigger - refering to correct schema
Hello Im having some issues with my trigger. What I want to do is call opon a different schema - depending on which data the triggers picks up.

quick question about System Change Number(SCN) in FlashBack Query topic
i know tht we can get the SCN of the database using flashback concept as follows SQL> execute :myvariable:=dbms_flashback.get_system_change_numb

Request for tunning the below query
Hi, Can any one help me on the below query while improving the performance, SELECT accdet, acceprec, accinvalid, accnetanal, accphy, accvalid,

Variable uses and placement
I'm new to PL/SQL and am trying to learn about variable valid uses/placement (any pointers to any docs is appreciated...) All of the docs I've looke

Regarding accessing SQL query issued by any user in Oracle 10g
Hi all, i want to know the queries issued by various users accessing a database... But the in view DBA_AUDIT_TRAIL,I was getting empty

updating a single value to multiple non consecutive rows
I need to update the same value to multiple non consecutive rows. I need to add an experation date to about 6000 parcels. I know I can update 1 with

Regarding accessing SQL query issued by any user in Oracle 10g
Hi all, i want to know the queries issued by various users accessing a database... But the in view DBA_AUDIT_TRAIL,I was getting empty

HOW to get the bind variables list.
I've the following problem : I've some SQL queries stored in my DB as VARCHAR2 values. I need to use DBMS_SQL in order to execute them. In theese SQ

Cursor statement failed with errors
Following statement failed with the errors. cursor proj_cursor1 is (select projectID from dsqa.table1 where projectID = any(select projectID from d

SQL query not working well
Hi, I made a small table with 5 rows and want to make them an sql consult using rownum so I'm running select * from mytable where rownum = 1;

how to populate a drop down box
Hi buddies! PROCEDURE DOWNLOAD_REPORT_FORM (report_name varchar) is begin DOWNLOAD_REPORT_HEADER(report_name); htp.p('