Forums

Loop Through Date Range
Hi guys, I have date range as parameter like 01/JAN/2009 TO 16/JAN/2009 now i want to loop through this date range and want to get date like 01/JAN

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

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

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

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,

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

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.

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

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

with clause
hi all, i have a big query that usually access the same table more than once. for example, i have something like this select

All possible combinations of Strings from table in PL/SQL
Hi, I am trying to figure out how to build a list of all possible string combinations from values stored in a single table. There are multiple "

Add weeks in a query?
I have a SQL that summarizes the quantity per week. The weeks that has no value does not exist in the table. How can I add these missing weeks with a

All possible combinations of String in PL/SQL
Hi All, Could you please explain the logic of getting all possible combinations of String in PL/SQL? For ex if "HER" is string then the output s

How to give the privillege for triggers?
Hi, How to give the privillage for triggers to particular user? Please let me know, if it is possible. Thanks

WS-Security PL/SQL Forms
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod PL/SQL Release 10.2.0.2.0 - Production Forms 32 Bit Version 10.1.2.0.2 (Productio

Select Rows as Columns..
is there a way to select COLUMN_NAME from user_tab_columns where table_name='TABLENAME'; and have the output as: COL1, COL2, COL3 instead of: COL1

send message to the java application
Oracle 10g with Windows platform. I have a java application that periodically pings the database table to see if it contains the specific row so th

utl_file open error
i have file in the unix path Path /popdev01/pop/popdevb/tfi/ File name: qua01 this path is hard coded in the table PQ10. i will be