Databases

Pages

Home
MySql
Oracle
PostGRESql
MSAccess
DB2
SQL

Tuesday, 11 October 2011

New Text Document

Posted by Ravinder at 11:07

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

No comments:

Labels

Hibernate (10)
MySql (103)
PLSQL (152)
SQL Tuning (6)

Popular Posts

ROWCOUNT in cursor FOR loop Sure, for all the good it will do you

Question: How do I access the %ROWCOUNT for an implicit cursor in a cursor FOR loop, as in (select * from dept) loop? Answer: Raymond, if yo...
Global temporary tables or collections

Question: You talk a lot about using collections, but I've never seen you write anything about global temporary tables. Wouldn't the...
Difference between POST-TEXT-ITEM and WHEN-VALIDATE-ITEM?

Post-text-item will fire every time your cursor moves out of the field. It doesn't matter whether a value is newly entered or is bei...
Block Level Properties

Navigation Style property Specifies how a Next Item or Previous Item operation is processed when the input focus is in the last navigable it...
Why doesn't an UPDATE raise the NO_DATA_FOUND exception

Question: Why doesn't an UPDATE raise the NO_DATA_FOUND exception? Answer: Arun, a number of people have asked that question over the ye...
How do I pause a PLSQL program

Question: I'm using a trigger on insert in order to create a flat file on a remote machine, using the dbms_file package. In case of netw...
Is it possible to compare the OLD and NEW value in FOR-LOOP within a trigger

Question: I have to log all modifications made by the user at the field level with a timestamp and user ID. I could write a lot of hard-code...
Key-Mode & Locking Mode Properties

{\rtf1\ansi\ansicpg1252\deff0\deflang16393{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 Calibri;}} {\*\generator...
SELECT COUNT(1) vs COUNT(star)

Question: Is select count(1) from aTable faster or more resource efficient than Select count(*) from aTable? I've heard that select coun...
How do I create nested FORALL statements

Question: Every FORALL statement has to be followed by a DML statement using the index variable. I am facing a situation where a nested FORA...

Total Pageviews

Followers

Blog Archive

► 2013 (1)
- ► January (1)

► 2012 (49)
- ► December (3)
- ► October (2)
- ► September (44)

▼ 2011 (390)
- ▼ October (139)
- ► September (98)
- ► August (153)

Feedjit

Watermark theme. Powered by Blogger.

Pages

Tuesday, 11 October 2011

New Text Document

No comments:

Post a Comment