Can we write insert statement in function in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
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.
1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
Explain the use of indexes option in imp command.
hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..
Explain parameter file in oracle.
How do I know if oracle is installed on windows?
What are dml statements in oracle?
What is clustered table in Oracle?
What is a materialised view?
How to connect to a local oracle 10g xe server?
What is SQL access advisor in Oracle?
What is a snapshot log?