Answer / jayasankar addanki

SELECT sum(field_name) from tablename

Ex: SELECT sum(marks) from students

How to clone the database using RMAN back

0 Answers  

---

how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

1 Answers   Alshaya,

---

How would you determine the time zone under which a database was operating?

1 Answers  

---

the user should know to which database he is connected currently in oracle

3 Answers  

---

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

0 Answers   Cap Gemini,

---

Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?

1 Answers  

---

How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views

2 Answers   Cap Gemini, Syntel,

---

Can we modify approve purchase order?if yes what is navigation?

0 Answers   L&T,

---

Explain the payment term in ar. : oracle accounts receivable

0 Answers  

---

please explain about oracle

1 Answers  

---

Give two examples of referential integrity constraints.

1 Answers  

---

How would you force a log switch?

1 Answers  

---