Home » Other » Training & Certification » Why should we use foreign keys (and several other questions)
Why should we use foreign keys (and several other questions) [message #278372] Sat, 03 November 2007 08:47 Go to next message
aditya369
Messages: 2
Registered: September 2007
Junior Member
Hi, friends
This is the first time i am using this forum
please help me, i want some answers for these questions.

1. why procedure is faster than the sql statement?
2. what is the diff between procedure and functions?
3. why should be we use foreign key for relations in database?


Thnaking you
aditya

[MOVED, MERGED and RENAMED by LF

Please, read the OraFAQ Forum Guide to learn how to properly ask a question.

removed by MC, I think interview question is as the same as homework]

[Updated on: Sat, 03 November 2007 10:34] by Moderator

Report message to a moderator

why should be use foreign key in databases? [message #278374 is a reply to message #278372] Sat, 03 November 2007 09:24 Go to previous messageGo to next message
aditya369
Messages: 2
Registered: September 2007
Junior Member
HI friends,

I have recently attended one interview in that i have faced this question. i would like to know that answer, please help me

1. why should be use foreign key in database for relations?
and is there any way without using foreign key?


Thanking you
aditya
Re: why should be use foreign key in databases? [message #278376 is a reply to message #278374] Sat, 03 November 2007 09:50 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Read Maintaining data integrity chapter of the Application Developer's Guide.
Re: why procedure is faster than sequel statements? [message #278377 is a reply to message #278372] Sat, 03 November 2007 09:56 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
1) Is it? How do you know? As far as I can tell, SQL statement runs faster than PL/SQL procedure.

2) This is the difference. Read also how to code PL/SQL procedures.

3) You are cross-posting.
Previous Topic: Developer
Next Topic: Multiple basic questions from sunilcse1 (merged)
Goto Forum:
  


Current Time: Thu Mar 28 19:41:56 CDT 2024