Home

Latest
Difference between RANK and DENSE_RANK
SYS_CONTEXT function and its usage
TO_DATE function explained with examples 
10 must-know Oracle Interview questions
5 different ways to load flat file into Oracle table
Install R on Ubuntu
PLJSON – JSON extension for PL/SQL
DDL Triggers Oracle
High Water Mark Oracle

Most read
5 ways to delete duplicate records in Oracle
5 ways to test Oracle RefCursor results
Difference between Trunc and Round function
Ref Cursor examples
TO_CHAR function Oracle
Oracle interview questions and answers
Notepad++ – Tips and Tricks
Difference between DECODE and CASE in Oracle
Julian Date Oracle
Nth highest salary 
TO_CHAR (number) function

Advertisements

15 thoughts on “Home”

  1. create table library(sid number not null,bid number not null,tdate varchar2(40),rdate varchar2(40),constraint fk_lib foreign key library(sid,bid)references (student.sid,book.bid))

  2. create table library(sid number not null,bid number not null,tdate varchar2(40),rdate varchar2(40),constraint fk_lib foreign key library(sid,bid)references (student.sid,book.bid))

    i got error of ORA-00906: missing left parenthesis .how can i solve it

  3. a table having duplicate records like 1,2,3,1,2,3,1,2,3,1,2,3,1,2,3….

    i want keep unique records in same table and duplicate value should be inserted into another table.

      1. hi ,
        You have given simple tool to debug the code.

        Could you pls tell me how debug package using your simple tool .
        Please provide me some example

    1. In short, when you need a return value to the caller and can be callable from sql( with some restrictions) use function. (This may not be true in all situations, but mostly)

      1. thank u sir..when will you start perfrmance tuning sessins sir..please do asap sir,its my humble request to u sir

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s