Difference between primary key and unique key ?
Answer Posted / vijay
Primary key's main role is to make field as unique and
relates to other sub table. Whereas unique is role only to
keep unique value in that field.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Is java required for oracle client?
What suggestions do you have to reduce the network traffic?
How to store only time; not date and time?
What is a data lock in oracle?
What types of joins are used in writing subqueries?
What is the difference between view and materialized view in Oracle?
Explain the features of oracle?
How to delete multiple rows from a table in oracle?
Is insert autocommit in oracle?
How can we view last record added to a table?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is the parameter mode that can be passed to a procedure?
Explain the difference between a procedure and a function?
What is the usage of save points in oracle database?