Variable uses and placement
I'm new to PL/SQL and am trying to learn about variable valid uses/placement (any pointers to any do

Request for tunning the below query

Can any one help me on the below query while improving the performance,

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

Im having some issues with my trigger.
What I want to do is call opon a differ

Calling a Procedure with IN & OUT Parameters

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 ?


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

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

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

distinct rows

I have a query output something like the following


UTL File problem
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 (
I trying run
create or replace package ....etc.

update 2 columns by doing inner 2-column query
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 - Prod
PL/SQL Release - P

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


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