Variable uses and placement
I'm new to PL/SQL and am trying to learn about variable valid uses/placement (any pointers to any docs is appreciated...)
Request for tunning the below query
Hi,
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
Hello
Calling a Procedure with IN & OUT Parameters
Hello,
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';