What is a sql trace file?

0 Answers  

---

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

1 Answers   CGI,

---

how to get a list of columns in an existing table? : Sql dba

0 Answers  

---

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

---

What is self-join and what is the requirement of self-join?

0 Answers  

---

How packaged procedures and functions are called from the following?

2 Answers  

---

Why is sql better than hql?

0 Answers  

---

Are null values same as that of zero or a blank space?

0 Answers  

---

What is a database link?

3 Answers  

---

what is a join? : Sql dba

0 Answers  

---

Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 Answers  

---

Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 Answers  

---