Answer / shanmugavelu

Virtual column or Pseudo Columns like
rowid,rownum,sysdate,nextval,currval,uid,user

Answer / sathish

the virtual cols are rownum, rowid . like

14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth

1 Answers   Wipro,

---

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL

1 Answers   TCS,

---

How do I manually create a database in oracle?

0 Answers  

---

What are joins, explain all types of joins?

0 Answers   Bravura Solutions,

---

What is a cursor and what are the steps need to be taken?

0 Answers  

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

0 Answers   Infosys,

---

What is the difference between postgresql and oracle?

0 Answers  

---

Explain how you would restore a database using RMAN to Point in Time?

0 Answers  

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

0 Answers   eicc,

---

How to drop an index in oracle?

0 Answers  

---

how to unbreak sequence numbers during intereptions

1 Answers   Ion Exchange,

---

What are the components of physical database structure in the Oracle database?

1 Answers  

---