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.

How to create a view on a table which does not exists

4 Answers   Oracle, TCS,

---

What are the blocks in stored procedure?

6 Answers   Microsoft,

---

In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?

4 Answers   Tech Soft,

---

What is the non-clustered index in sql?

0 Answers  

---

Explain two virtual tables available at the time of database trigger execution.

1 Answers  

---

What is form and report?

0 Answers  

---

What is difference between Procedures and Functions ?

6 Answers   Hi Caliber IT,

---

what is the forward decleration in packages?

1 Answers  

---

What are the packages in pl sql?

0 Answers  

---

What is count * in sql?

0 Answers  

---

Describe types of sql statements?

0 Answers  

---

Explain the uses of database trigger.

0 Answers  

---