Oracle PL/SQL Technology blog

To know more about Oracle, PL/SQL, Ubuntu, Python, R, MySQL and more….

Home

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

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: