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

0 Answers  

---

How can I speed up sql query?

0 Answers  

---

What does trigger mean in slang?

0 Answers  

---

Can we rollback delete command?

0 Answers  

---

In what condition is it good to disable a trigger?

0 Answers  

---

Which are the different character-manipulation functions in sql?

0 Answers  

---

What is prepared statement in sql?

0 Answers  

---

How to run sql statements with oracle sql developer?

0 Answers  

---

What is a data manipulation language?

0 Answers  

---

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---

Is sql the best database?

0 Answers  

---

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,

---