Answer Posted / sujith

authorization means being capable to access some data or
application
authentication is a process of being identified by certain
condition to become authorized...... but at the same time
authentication might not be the only criterion to become
authorized......


There is a narrow gap between these two terms.....
take an example.....
to enter into your e-mail account , you
should be authenticated by user id and pwd... however it
doesn't mean that you are fully authorized to access the
whole page,

how the indexes are stored in the Oracle Database?

2330

---

What are the differences between primary key and unique key?

1057

---

Can I create users through internet explorer in oracle 10g?

1152

---

What are the attributes of cursor?

1104

---

Can we call procedure inside function in oracle?

1144

---

What is raw datatype?

1184

---

How data locks are respected in oracle?

1107

---

What are the arithmetic operations?

1146

---

What is a data dictionary and how can it be created?

1232

---

How to get a create statement for an existing table?

1010

---

What is query image?

1019

---

How to create a table interactively?

1158

---

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

2087

---

What is a snapshot in oracle database?

1070

---

Why do we use coalesce function in oracle?

1163

---