Oracle

Loop Through Date Range

Hi guys,

All possible combinations of String in PL/SQL

Hi All,

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 Strings from table in PL/SQL

Hi,

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

why this query can delete duplicates ?

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

Calling a Procedure with IN & OUT Parameters

Hello,

Varible in trigger - refering to correct schema

Hello

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

Request for tunning the below query

Hi,

insert Multiple rows into the table from that table data

Hi All,

Error when call dll from oracle

Hi all, please help me!

present value of sequence?

Hi

Oracle Connectivity

Hi Every One,

Count number of records in all the tables with a querry URGENT PLEASE...

I downloaded ORACLE 9I DATA DUMP into my comp. There are number of tables. I need to find out the tables with records more than say 100 or so at on go. Can it be possible... If so kindly let me

Help on query replacing the date

Hi Pals,

Error when call dll from oracle

Hi all, please help me!

Logging and nologging bulk insert

Hi,

present value of sequence?

Hi

How to insert random unique values in 2 columns ?

I have table with 2 columns