Forums

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,

Loop Through Date Range

Hi guys,

How to sum these output values

Hi

distinct rows

Hi

UTL File problem

Hi

Update data to upper case in parent/child tables

Hi Gurus!

Create or replace package is ending ORA-21700

Database 9.2.0., patch 8 (9.2.0.8.0).

update 2 columns by doing inner 2-column query

Hi,

Record count of entire database

Does anyone know if there is a way to obtain the number of records in each table of the database using a single select statement or must a select count be done for each individual table?

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.

How to give the privillege for triggers?

Hi,

ORA-00932: inconsistent datatypes: expected - got CLOB

SO : windows xp

utl_file open error

i have file in the unix path

comparing tables across databases sql refinement ideas required

Hi all