Calling a Procedure with IN & OUT Parameters
Hello,

I usually call my procedures using the following way

declare variable e

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

Tha

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

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 fro

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 th

All possible combinations of String in PL/SQL
Hi All,

Could you please explain the logic of getting all possible combinations of String

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 thro

How to sum these output values
Hi

I need sum the month totals
SELECT region_name, area_name ,SUM (CASE WHEN S

distinct rows
Hi
version 10.2.0.3

I have a query output something like the following

ID

UTL File problem
Hi
I have a file in certain path with the following permissions (The file is a dummy file witho

Update data to upper case in parent/child tables
Hi Gurus!

In production we have a product table and which is being reference by many tabl

Create or replace package is ending ORA-21700
Database 9.2.0., patch 8 (9.2.0.8.0).
I trying run
create or replace package ....etc.

update 2 columns by doing inner 2-column query
Hi,
is something like this possible?

update contract_all set col1,col2 =
(

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 usi

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 - P

Select Rows as Columns..
is there a way to select COLUMN_NAME from user_tab_columns where table_name='TABLENAME';
and ha

send message to the java application
Oracle 10g with Windows platform.

I have a java application that periodically pings the d

How to give the privillege for triggers?
Hi,

How to give the privillage for triggers to particular user?

Please let me

ORA-00932: inconsistent datatypes: expected - got CLOB
SO : windows xp
database : XE

there is a table (transito) with two fields of clob

utl_file open error
i have file in the unix path

Path /popdev01/pop/popdevb/tfi/

File name

 

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash