how to see the oracle 9i/10g table in pc? or In my pc where the table is saved and how to see?

1 Answers  

---

What is crud stand for?

0 Answers  

---

What is data control language?

0 Answers  

---

How many joins can you have in sql?

0 Answers  

---

What are the advantages of stored procedure?

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 Suneel Reddy

6 Answers   Target,

---

Can you have more than one key in a database?

0 Answers  

---

Can we call procedure in select statement?

0 Answers  

---

Give which cursor is better for better performance means type of cursors?

2 Answers  

---

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

0 Answers   BT,

---

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

---

Is not equal in sql?

0 Answers  

---