Answer / pankajsharma

l_utlfile=utl_file_type;
l_utlfile=utl_file.fopen('filepath','filename','mode')

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

---

What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,

---

How many types of literals are available in pl sql?

0 Answers  

---

What is diff between bulk collect and forall

3 Answers   Metric Stream,

---

Can we interchange parameters in procedure while calling

1 Answers   TCS,

---

---

State the advatage and disadvantage of Cursor's?

2 Answers  

---

How to display all Friday's in a year with date?

4 Answers   Flipkart,

---

difference between anonymous blocks and sub-programs.

0 Answers  

---

Which join is default?

0 Answers  

---

How exception is different from error?

0 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 are the advantages of stored procedure?

0 Answers  

---