Answer / Anshuman Verma

Database scripts are a series of SQL commands used to create, modify, or manage database structures and data. They can be used for tasks like creating tables, inserting data, altering tables, and more.

difference between oracle8i and oracle9i

4 Answers   NIIT,

---

What is a Tablespace?

5 Answers  

---

Why oracle is used?

1 Answers  

---

What is Database Buffers ?

1 Answers  

---

Explain the use of record length option in exp command.

1 Answers  

---

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

1 Answers  

---

What is Index and different types of Indexes?

7 Answers  

---

How to see free space of each tablespace?

1 Answers  

---

What is the difference between Delete, Truncate and Drop in Oracle?

1 Answers   MCN Solutions,

---

how to handle exceptions in post production

1 Answers  

---

I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!

1 Answers  

---

Define 'view' advantage ?

2 Answers   AZTEC, TCS,

---