How do I tune a sql query?

0 Answers  

---

in a package one procedure is wrong package shows valid or not

4 Answers  

---

How do you copy a table in sql?

0 Answers  

---

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  

---

Is sqlite thread safe?

0 Answers  

---

create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers   Polaris,

---

what is the forward decleration in packages?

1 Answers  

---

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

---

How to display the records between two range in Oracle SQL Plus?

0 Answers   MCN Solutions,

---

What will be the output for the below Query Select 'High' from dual where null = null;

12 Answers   Infosys, Satyam,

---

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

---

Can we use ddl commands in pl sql?

0 Answers  

---