what is the command used to fetch first 5 characters of the string? : Sql dba

0 Answers  

---

Is sql a oracle?

0 Answers  

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

0 Answers  

---

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers   Zensar,

---

Are views faster than queries?

0 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---

explain normalization concept? : Sql dba

0 Answers  

---

How will you a activate/deactivate integrity constraints?

2 Answers  

---

wtite down triggr not any entry on Sunday

2 Answers   NIT,

---

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

0 Answers  

---

What is the difference between inner join and outer join?

0 Answers  

---

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

3 Answers   HCL,

---