How to define an anonymous procedure with variables?
No Answer is Posted For this Question
Be the First to Post Answer
Which dictionary tables and/or views would you look at to diagnose a locking issue?
WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.
what are Triggers?
Is a rollback possible to any savepoint?
What is the difference between Outer join and Full outer join?
How to get a list of all background sessions in the database?
How to shutdown your 10g xe server?
what is null value?
What is the usage of control file in oracle?
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,
How to pass a cursor variable to a procedure?