Answer / ramachandra

we are using primary key and foreign key database designer identify an entity
diffencee b/w primary key and foreign key
1.every table should have one primary key
but foreign key it doesnt any rule we keep more than one foreign key
2.primary key doesn't accept null values
3primary key is parent key
but foreign key is child key it depends only primary key table or column it doesn't allow more than primary key column attributes.
4.primary key doesn't accept duplicate values
but foreign key accepting duplicate values

How can you enable a trace for a session?

2 Answers  

---

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

0 Answers   Wipro,

---

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

0 Answers   HCL,

---

what are the advantages of Oracle over other databases..? please give me reply...

2 Answers  

---

How would you determine the time zone under which a database was operating?

1 Answers  

---

WHAT IS CARTESIAN PRODUCT?

2 Answers  

---

what are basic modules required to implement oracle application in any oraganisation?

0 Answers  

---

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

0 Answers  

---

wht r the base tables & primary key for BOM& WIP modules

1 Answers   Satyam,

---

Give the two types of tables involved in producing a star schema and the type of data they hold.

1 Answers  

---

key flexfield structure

0 Answers   Infosys,

---

which one is currently in used software cmpanies.

0 Answers  

---