Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 0 Answers
- 1116 Views
- Oracle, I also Faced
- E-Mail Answers
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.
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
What is integrity and what is constraint??Explain with example
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
How to create a new view in oracle?
Can group functions be mixed with non-group selection fields?
What do you mean by group by clause?
How to open a cursor variable?
What is the difference between a user and a schema in oracle?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
Explain the concept of the DUAL table.
how to make an oracle object
Oracle General 
