Answer Posted / 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

How many sql statements are used? Define them.

1019

---

what is msql? : Sql dba

969

---

What is the need of merge statement?

1011

---

What is rename command in sql?

1004

---

what are the properties and different types of sub-queries? : Sql dba

1015

---

What is auto increment?

974

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

980

---

Do we need to create index on primary key?

904

---

What steps server process has to take to execute an update statement?

963

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

934

---

What is gpt format?

929

---

What does seeding a database mean?

935

---

explain the delete statements in sql

1028

---

What does the acronym acid stand for in database management?

1021

---

Is sql a programming?

961

---