I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)

5 Answers   Relq,

---

how can stop the sequence with mention the max value and with out mention the max value

1 Answers   Zensar,

---

What are the parameter modes supported by pl/sql?

0 Answers  

---

Is sql database free?

0 Answers  

---

What is difference between % ROWTYPE and TYPE RECORD ?

2 Answers  

---

What is a constraint? Tell me about its various levels.

0 Answers  

---

I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????

3 Answers   Infosys,

---

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,

---

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

2 Answers   Maruti Suzuki,

---

What is pl sql code?

0 Answers  

---

how to get a list of all tables in a database? : Sql dba

0 Answers  

---

How do u count no of rows in a table?

8 Answers   CTS,

---