Answer Posted / ajmal khan

select length('string') from dual;
or
select length(column_name) from table_name;

What is the command used to fetch first 5 characters of the string?

1395

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1343

---

What does a pl/sql package consist of?

972

---

What are the possible values for the boolean data field?

961

---

Explain dml and ddl?

986

---

Is oracle sql free?

982

---

When should I use nosql database?

1006

---

What is full form of rtm?

1003

---

What is the usage of nvl function?

1036

---

Define implicit and explicit cursors.

1143

---

What is difference between primary and secondary key?

1023

---

what is the difference between group by and order by in sql? : Sql dba

1125

---

What is the purpose of a sql?

974

---

Is grant a ddl statement?

894

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4021

---