Why is there a need for sqlcode and sqlerrm variables?

0 Answers  

---

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,

---

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

3 Answers   iNautix, Oracle,

---

What are the two virtual tables available at the time of database trigger execution?

0 Answers  

---

What is difference between sql and oracle?

0 Answers  

---

what tools available for managing mysql server? : Sql dba

0 Answers  

---

When is the update_statistics command used?

0 Answers  

---

Explain what is dbms?

0 Answers  

---

what is 'mysqlimport'? : Sql dba

0 Answers  

---

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

0 Answers  

---

If we have n no of columns in a table, can we add new column in that table with not null constraint?

2 Answers  

---