Forums

max function question

Hi All

please help me in this update statment

hi every one

help with multi-update

Now sure how to ask this really....

Splitting Attributes

SQL> SELECT I_NAME, substr(I_NAME,1,instr(I_NAME,'O')) "First part",

Combining refCursors and Summing

Given the following DDL:

Problem with a select distinct

I have a problema with a select distinct, I have the next sql:

column name cancatenation within PL/SQL

I have a PLSQL store procedure, and the following statement is part of a subquery

Linking with Foreign Keys

I have been getting an erro when I try and link:

Selecting an "empty" date formated field

How do you select an "empty" date field? I've tried the few ways I can think.

how make 2 column in table with data tybe long row

hi every one

records between 2 dates

Hello all,

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,