Scenario From Oracle Forum
This function seems like a good idea for password validation, for example one number and 4-8 characters.
However, [...]
Entries Tagged as 'SQL and PL/SQL'
Working Example of REGEXP_LIKE -2
September 23rd, 2007 · No Comments
Tags: Interesting Coding Showcase · SQL and PL/SQL
PL/SQL:: New Compound Trigger
September 21st, 2007 · 4 Comments
The new Compound Trigger make it easier to handle a situation, where we want trigger fired at different point of [...]
Tags: Oracle 11g New Features · SQL and PL/SQL
Working Example of REGEXP_LIKE
September 18th, 2007 · No Comments
Scenario From Oracle Forum
I have to select data from table which has the words both ‘help’ and ‘window’
eg: window.open(’help’) this [...]
Tags: Interesting Coding Showcase · SQL and PL/SQL
Little bit funny piece of post!
September 18th, 2007 · 2 Comments
Hi Guys,
Today I came across one little bit funny piece of post at one of the thread in Oracle Forum.
Member [...]
Tags: Interesting Coding Showcase · SQL and PL/SQL
Updating a table from another table
September 16th, 2007 · 7 Comments
Today I went through few post by Ask Tom, and stuck with this fantastic post
Lets first create following tables to [...]
Tags: Interesting Coding Showcase · SQL and PL/SQL
SQL Tip::Using OUTER JOIN with Filter
September 12th, 2007 · 4 Comments
Hi Guys!
Today I came across very simple and very interesting fact!
First Assume as follows:
Table Structure
——————————-
SQL> desc emp;
Name Null? Type
—————————————– ——– [...]
Tags: Interesting Coding Showcase · SQL and PL/SQL
SQL Tip::UNION ALL Vs. UNION
September 11th, 2007 · No Comments
The problem with UNION is that it required sorting operation to eliminate duplicate row sets which is added cost for [...]
Tags: SQL and PL/SQL
Interesting SQL
September 3rd, 2007 · 7 Comments
Today I came across another interesting solution.
Situation was as follows:
There is PROJECTS table, with columns as follows (datatype never mind):
PERSON
ID_STATE
We [...]
Tags: Interesting Coding Showcase · SQL and PL/SQL
Deleting duplicate row in certain condition using LEAD an analytic function!
September 3rd, 2007 · 1 Comment
Today, while going through Oracle Forum, I came across this really interesting solution!
Lets suppose, We have a table tab1 having [...]
Tags: SQL and PL/SQL
PL/SQL::New PL/SQL SIMPLE_INTEGER DATA TYPE
August 29th, 2007 · No Comments
Checked the New PL/SQL SIMPLE_INTEGER data type, found following facts about it:
SIMPLE_INTEGER is a predefined subtype of the PLS_INTEGER data [...]