Explain temporal data types in oracle
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.
How to execute a stored procedure in oracle?
What is a package in oracle?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
where we have to use ON clause and where we have to use USING clause in JOINS
How to start your 10g xe server from command line?
What is a nvl function?
List the parts of a database trigger.
How does one get the view definition of fixed views/tables?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"
Difference between sub query and nested query ?
19 Answers Keane India Ltd, TCS,