Forums

Loop Through Date Range

Hi guys,

HOW to get the bind variables list.

I've the following problem : I've some SQL queries stored in my DB as VARCHAR2 values.

Regarding accessing SQL query issued by any user in Oracle 10g

Hi all,

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.

Regarding accessing SQL query issued by any user in Oracle 10g

Hi all,

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...)

Request for tunning the below query

Hi,

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

Varible in trigger - refering to correct schema

Hello

Calling a Procedure with IN & OUT Parameters

Hello,

why this query can delete duplicates ?

why this query can delete duplicates ? Anybody can give me the detailed explanation ?

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

All possible combinations of Strings from table in PL/SQL

Hi,

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 0 value in the SQL. Need this to use Avg and

All possible combinations of String in PL/SQL

Hi All,

How to give the privillege for triggers?

Hi,

WS-Security PL/SQL Forms

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod

Select Rows as Columns..

is there a way to select COLUMN_NAME from user_tab_columns where table_name='TABLENAME';

send message to the java application

Oracle 10g with Windows platform.

utl_file open error

i have file in the unix path