OracleBrains.Com header image 5

Entries Tagged as 'Interesting Coding Showcase'

Deleting duplicate row in certain condition using Join!

December 1st, 2007 · No Comments

Scenario From Oracle Forum
I have a transaction table consists of duplicate records I success to write a sql
which get the [...]

[Read more →]

Tags: Interesting Coding Showcase · SQL and PL/SQL

Working Example of REGEXP_LIKE -2

September 23rd, 2007 · No Comments

Scenario From Oracle Forum
This function seems like a good idea for password validation, for example one number and 4-8 characters.
However, [...]

[Read more →]

Tags: Interesting Coding Showcase · 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 [...]

[Read more →]

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 [...]

[Read more →]

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 [...]

[Read more →]

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
—————————————– ——– [...]

[Read more →]

Tags: Interesting Coding Showcase · 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 [...]

[Read more →]

Tags: Interesting Coding Showcase · SQL and PL/SQL

Time-series related query at Oracle Forum

December 13th, 2006 · 3 Comments

Today I came across one interesting question at Oracle Forum
Dear experts!
Please help me with this kind of query!
Suppose that I [...]

[Read more →]

Tags: Interesting Coding Showcase · SQL and PL/SQL

Understanding Function Based Indexes

December 10th, 2006 · 3 Comments

First have a look at following query:
SELECT e_name, age, address
FROM employees
WHERE UPPER(e_name) = ‘RAJENDER SINGH’;
Now, One of the important instruction [...]

[Read more →]

Tags: Interesting Coding Showcase · Oracle Administration · Oracle Database

deleting duplicate rows from a table

December 5th, 2006 · 5 Comments

One of the old way in which I normally do this by using GROUP BY and HAVING keywords.
Example:
DELETE FROM EMP
WHERE [...]

[Read more →]

Tags: Interesting Coding Showcase · SQL and PL/SQL