Answer Posted / allin

5 Different integrity constraints are given

1- Primarykey- creating the index and better performance
2- Unique - should not accept the repeated value
3- NotNull - Should enter any value
4- ForeignKey - can accept values which the values should
existed in primarykey column.Should accept
null values.
5- Check - between the two boundaries.

Thanks & Regards,
RatnaRao
9833847339

> 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?

2030

---

How to open and close an explicit cursor in oracle?

1058

---

How to assign data of the deleted row to variables?

1075

---

Explain temporal data types in oracle

1095

---

How to retrieve values from data fields in record variables?

1113

---

What is define in oracle?

1060

---

what is a Nested Loop join?

2111

---

What is raw datatype?

1136

---

What are the different pseudo commands? Explain in general?

1080

---

How to create a table interactively?

1088

---

What is a system tablespace?

1071

---

Please explain drop constraint oracle?

1104

---

What are the execution control statements in oracle?

1093

---

Can we write insert statement in function in oracle?

1089

---

How to select all columns of all rows from a table in oracle?

1052

---