Can we use views in stored procedure?

0 Answers  

---

In packages the source code is compiled into p code ? how do we describe the p code

3 Answers  

---

What is cost in sql execution plan?

0 Answers  

---

What is the order of sql select?

0 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,

---

---

How One can easily select all even, odd, or Nth rows from a table using SQL queries?

4 Answers  

---

explain about mysql and its features. : Sql dba

0 Answers  

---

What is the difference between a primary key and a clustered index?

0 Answers  

---

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

7 Answers   Cognizant,

---

How can you load multi line records? : aql loader

0 Answers  

---

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance

13 Answers   IBM,

---

what is the difference between the query and corelated query

8 Answers   HSBC, IBM, TCS, Xenosoft,

---