How do I run sql?

0 Answers  

---

what is the difference between inner and outer join? Explain with example. : Sql dba

0 Answers  

---

What will you get by the cursor attribute sql%notfound?

0 Answers  

---

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

2 Answers   Maruti Suzuki,

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

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.

4 Answers   CGI, IBM,

---

How do you display "13th of November, 17 days left for month end" without hardcoding the date.

3 Answers  

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

what is sql? : Sql dba

0 Answers  

---

What is java sql connection?

0 Answers  

---

what are all different types of collation sensitivity? : Sql dba

0 Answers  

---

How to set up sql*plus output format in oracle?

0 Answers  

---