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