Answer / tulsi

SQLCODE returns the latest code of the error that has
occured.
SQLERRM returns the relevant error message of the SQLCODE.

Answer / pervez

Hi Tulsi,
Sqlerrm returns error number as well as error message of
last error occured.

how can you create an empty table from an existing table? : Sql dba

0 Answers  

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

0 Answers  

---

Can we join tables without foreign key?

0 Answers  

---

Main diff between varray and nested tablea

3 Answers   Polaris, TCS,

---

what is variable in package specification

3 Answers  

---

What is embedded sql with example?

0 Answers  

---

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

---

What view means?

0 Answers  

---

What is scope and visibility in PL/SQL?

0 Answers  

---

Define sql delete statement.

0 Answers  

---

can i use global variables in stored procedure or function

1 Answers   L&T,

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

0 Answers  

---