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 pl sql in oracle?

0 Answers  

---

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

5 Answers   HSBC,

---

What is db journal file?

0 Answers  

---

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,

---

what is column? : Sql dba

0 Answers  

---

What are the parameter modes supported by pl/sql?

0 Answers  

---

List out the acid properties and explain?

0 Answers  

---

how to drop an existing index in mysql? : Sql dba

0 Answers  

---

Tell me what a package consists of.

3 Answers  

---

What is offset in sql query?

0 Answers  

---

Explain sql data types?

0 Answers  

---

Is hadoop a nosql?

0 Answers  

---