Answer Posted / svj

PRAGMA (also called pseudo instructions) is the keyword
that signifies that the statement is a compiler directive,
which is not processed when PL/SQL block is executed.
Rather,it directs the PL/SQL compiler to interpret all
occurrences of the exception name within the block as the
associated Oracle server error number.

How to list all tables in your schema?

992

---

How to create a new view in oracle?

1015

---

Compare and contrast between sql and sql server and explain its various functions?

920

---

What is oracle server autotrace in oracle?

1091

---

Describe the types of sub query?

939

---

Explain the difference between replace() and translate() functions in oracle?

976

---

What are dml statements in oracle?

1045

---

How to convert characters to numbers in oracle?

1001

---

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

1983

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2176

---

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?

974

---

How many types of cluster table in Oracle?

987

---

What is a trace file and how is it created in oracle?

974

---

Is there an oracle sql query that aggregates multiple rows into one row?

934

---

What is oracle used for?

971

---