After what I find yesterday (Enhancements in Oracle 11g PL/SQL), I research more about Oracle 11g. Found out few more [...]

[Read more →]

Before Oracle 10g Release 2, Life cycle of a transaction was as follows:
- Transaction Starts When User Issues the First [...]

[Read more →]

We cannot use SYSDATE as part of a CHECK Constraint defination.
See the example:
SQL> CREATE TABLE EVENT(
2 EVENT_ID NUMBER(5) CONSTRAINT PK_EVENT [...]

[Read more →]

Recycle Bin is one of the new feature introduced in Oracle 10g and works a little bit like the recycle [...]

[Read more →]

There are many ways to detect the block corruption in a database. One of them is to use “ANALYZE TABLE” [...]

[Read more →]

One of the biggest loophole that an Oracle database installation can have is Oracle Listener without a password. At the [...]

[Read more →]

Today when checking “Search Keyphrases” for my site, I found out that someone wants to know about “starting tns listener [...]

[Read more →]

Today I found out this very interesting fact about default value.
While inserting or updating we can use reserver word “DEFAULT” [...]

[Read more →]

Recently I came to know about very interesting procedure called “KSDWRT” in DBMA_SYSTEM.
It can be used to add our own [...]

[Read more →]

Comment by S. Inderjeet Singh on Understanding TNS Listener
“After this database authenticates login information, the listener process redirect the client [...]

[Read more →]