how to retrieve daily sal from emp table in oracle 10g

Answer Posted / anuradha

Select empno,ename,sal, sal/30 "Daily_Sal" From emp;

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an oracle user account?

582


Explain the use of ignore option in imp command.

577


What is Reduced List of Values?

1708


how the indexes are stored in the Oracle Database?

1742


How does one get the view definition of fixed views/tables?

606






What is a initialization parameter file in oracle?

584


What is the difference between view and materialized view in Oracle?

610


How to put more than 1000 values into an oracle in clause?

588


What is concurrency in oracle?

547


20. Using a set operator, display the client number of all clients who have never placed an order.

1801


What are the execution control statements in oracle?

605


What are the uses of Database Trigger ?

1104


How to get a create statement for an existing table?

572


What's dateware house and what's clustor with practicle example

1641


What are dml statements in oracle?

623