Answer / gourvendra singh

if you want to find a string value you can use the
following command
select length(TRIM(TRANSLATE(string,'+-.123456789',' ')))
from dual;
string=value that u entered
if the result is null then the string is numeric else its a
character

Answer / kumarvijay

var=1; --var='a'

select to_number(var) from dual;

if variable holds string it will through exception else it
will execute.

What is the purpose of cursors in pl/sql?

0 Answers  

---

How to use transactions efficiently : transact sql

0 Answers  

---

Can we enter data in a table in design view?

0 Answers  

---

What is normalization sql?

0 Answers  

---

Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 Answers  

---

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

0 Answers  

---

What is sql*loader and what is it used for? : aql loader

0 Answers  

---

Is record in pl sql?

0 Answers  

---

Differentiate pl/sql and sql?

0 Answers  

---

What is Referential Integrity?

3 Answers  

---

Can you have more than one key in a database?

0 Answers  

---