i have marks in table,how to find total?
Answer / jayasankar addanki
SELECT sum(field_name) from tablename
Ex: SELECT sum(marks) from students
| Is This Answer Correct ? | 12 Yes | 0 No |
How to clone the database using RMAN back
how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.
How would you determine the time zone under which a database was operating?
the user should know to which database he is connected currently in oracle
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?
Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?
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
Can we modify approve purchase order?if yes what is navigation?
Explain the payment term in ar. : oracle accounts receivable
please explain about oracle
Give two examples of referential integrity constraints.
How would you force a log switch?