I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
find out the second highest salary?
55 Answers Cognizant, Nucsoft, Oracle, TCS, Wondersoft,
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.
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Can the default values be assigned to actual parameters?
What is blob datatype?
How to export data to a csv file?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
How to end the current transaction in oracle?
How to best split csv strings in oracle 9i?
How translate command is different from replace?
types of indexes and the rationale behind choosing a particular index for a situation.
What do you understand by a database object?