Answer / suman

what is indexing
An index is a performance-tuning method of allowing faster retrieval of records. An index creates an entry for each value that appears in the indexed columns. By default, Oracle creates B-tree indexes.

Can you selectively load only those records that you need? : aql loader

0 Answers  

---

How do you copy a table in sql?

0 Answers  

---

Is sql scripting language?

0 Answers  

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers   Target,

---

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

7 Answers   Cognizant,

---

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.

4 Answers   3i Infotech,

---

Why select is used in sql?

0 Answers  

---

How to use sql*plus built-in timers?

0 Answers  

---

how instead of triger is helpful for mutating tables errors handlling ?

2 Answers   Oracle,

---

How do I run a script in sql developer?

0 Answers  

---

With out using count() function. How to the find total number of rows in a table?

6 Answers  

---

What is meant by cursor in sql?

0 Answers  

---