what is the difference between primary key & foreign key?
Answer Posted / leang heng
Primary Key is a column or group of columns that determine
in each Record to make not null.
Foreign Key is Column that provide Relationship to Primary
Key between Entities or Table.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
State any two functions of oracle?
What is the difference between alert log file and tarce file ?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What is recycle bin in Oracle?
Will you be able to store pictures in the database?
What is the sql query to concatenate column values from multiple rows in oracle?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
How do we get field detail of a table?
What is ordinary table in oracle?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What is the exact use of Collections?
List the various oracle database objects?
How does oracle handle read consistency?