When system tablespace is created?

0 Answers  

---

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

0 Answers   TCS,

---

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

2 Answers   Polaris,

---

Can we create more than one constraint to column ?

6 Answers  

---

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

2 Answers   HCL,

---

---

what is integrity constrains?

3 Answers  

---

What are the type of Synonyms?

1 Answers  

---

17. Display the order number and average item cost for each order.

1 Answers   Wipro,

---

SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me

6 Answers   TCS,

---

what diffrence between function and procedure?

4 Answers  

---

What are the various types of snapshots ?

0 Answers  

---

What privilege is needed for a user to connect to oracle server?

0 Answers  

---