mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com

5 Answers  

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

---

Can we use ddl commands in pl sql?

0 Answers  

---

What is an Integrity Constraint?

4 Answers  

---

What is data abstraction in sql?

0 Answers  

---

---

can we delete the trigger in a view? if yes why if not why?

5 Answers   Tech Mahindra,

---

what is sub-query? : Transact sql

0 Answers  

---

How to call the function and Procedure in trigger?

3 Answers   IBM,

---

If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?

2 Answers  

---

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

12 Answers   IBM,

---

What do you mean by “trigger” in sql?

0 Answers  

---

Are pl sql variables case sensitive?

0 Answers  

---