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 trigger types of trigger?

0 Answers  

---

How do you declare a constant?

0 Answers  

---

how can create data base link for tow servers (scott schema) give examples plz

2 Answers  

---

Its possible to add more than one primary key for the table

4 Answers  

---

What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Metric Stream, Polaris,

---

Is sql free?

0 Answers  

---

pl/sql testing means what ...... explain process how to find pl/sql bugs

1 Answers   Zensar,

---

Why indexing is needed?

0 Answers  

---

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

0 Answers  

---

Is pl sql different from sql?

0 Answers  

---

what is the main difference between join and subqurey?

3 Answers   Oracle,

---

What is the difference between a primary key and a unique key?

0 Answers  

---