I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.

3 Answers  

---

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,

---

what is the command for user data type?

2 Answers  

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---

How do I view a table in sql?

0 Answers  

---

Explain the significance of the & and && operators in pl sql.

0 Answers  

---

How to test for null values?

0 Answers  

---

Why commit is not used in triggers?

0 Answers  

---

how to create a new view in mysql? : Sql dba

0 Answers  

---

what is the different between unique+not null & primary key,

4 Answers  

---

What is the maximum number of columns in sql table?

0 Answers  

---

Where the sql database files are stored?

0 Answers  

---