Answer / Karan Singh

A syntax error occurs when there is an incorrect use of language constructs in the SQL or PL/SQL code, making it impossible for the compiler to understand the code. A runtime error occurs during execution of the program, usually due to logical errors such as division by zero, null pointer, etc.

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

1 Answers   Microsoft,

---

what are the different types of joins?

4 Answers   Choice Solutions,

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

1 Answers  

---

What is sql injection vulnerability?

1 Answers  

---

how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 Answers  

---

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  

---

how to sort records in sql?

3 Answers  

---

What are the modes of parameters that can be passed to a procedure ?

3 Answers  

---

What is a dirty read sql?

1 Answers  

---

What are the sql versions?

1 Answers  

---

Write a query to display the current date in sql?

1 Answers  

---

how to connect oracle in unix prompt?

4 Answers   Polaris,

---