Answer Posted / raj

select max(sal) from emp where sal < (select max(sal) from
emp)

Oracle

2380

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2398

---

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2267

---

What is the difference between a user and a schema in oracle?

1034

---

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

2034

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2324

---

what is the difference between substr and instr function in oracle?

1091

---

What is a snapshot in oracle database?

1026

---

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2265

---

Why should I use oracle database?

997

---

How can Oracle users be audited?

1118

---

What is an oracle data file?

1105

---

What is a cursor in oracle?

1177

---

How can I create database in oracle?

1029

---

Explain the use of rows option in exp command.

1094

---