what is primary key and foreign key when and where have to use
- 5 Answers
- 5894 Views
- I also Faced
- E-Mail Answers
Answer Posted / chandrika
primary key has unique value, it dostnt contain null values
and duplicate values.
foregin key is primary key of another table
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are triggers in oracle?
What is a sub query and what are the different types of subqueries?
What is the difference between PFILE and SPFILE in Oracle?
What is oracle database client?
What is oracle instant client?
Explain cascading triggers.
How can you merge two tables in oracle?
what are actual and formal parameters?
Explain what does a control file contain?
Explain self joins in oracle?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What is the difference between count (*), count (expression), count (distinct expression)?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Difference between the “verify” and “feedback” command?
how to join query for one source type is oracle another source type is sql server ?
