What is the purpose of the primary key?

0 Answers  

---

i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w

4 Answers   Scope International,

---

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  

---

What is the default isolation level in sql server? : Transact sql

0 Answers  

---

What is composite data type in pl sql?

0 Answers  

---

how tsql statements can be written and submitted to the database engine? : Transact sql

0 Answers  

---

how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000

4 Answers  

---

what is meant by nl2br()? : Sql dba

0 Answers  

---

What is the difference between delete, truncate and drop command?

0 Answers  

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

0 Answers  

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

---

How to handle bulk data?

0 Answers  

---