How many LONG columns are allowed in a table?

6 Answers   CTS,

---

What is sql comments?

0 Answers  

---

Explain clause in sql?

0 Answers  

---

Are there any features that are decommissioned in 11g that are not present in 11g?

0 Answers  

---

can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?

1 Answers  

---

When is a declare statement required?

0 Answers  

---

What is difference between Procedures and Functions ?

6 Answers   Hi Caliber IT,

---

Explain what is dbms?

0 Answers  

---

What are the advantages of indexing?

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,

---

Which is faster truncate or drop?

0 Answers  

---

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

---