Home » SQL & PL/SQL » SQL & PL/SQL » is it possible to Retrieve All the rows also need some more functional columns
is it possible to Retrieve All the rows also need some more functional columns [message #323414] Wed, 28 May 2008 07:55 Go to next message
prakash2007
Messages: 14
Registered: March 2007
Junior Member
Retrieve All the rows also need some more functional columns like calculating annual salary from salary of the employee in emp table i want to use *

table structure

eno ename dept desg sal
1 dfd efs ds 2000

output

eno ename dept desg sal annual salary
1 dfd efs ds 2000 24000
Re: is it possible to Retrieve All the rows also need some more functional columns [message #323416 is a reply to message #323414] Wed, 28 May 2008 07:59 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
This is the most basic of SQL commands, probably on page 1. I think it's time to search the documentation.

http://tahiti.oracle.com
Previous Topic: Grant - Table & Trigger.
Next Topic: how to set prompt off
Goto Forum:
  


Current Time: Sat Dec 03 08:11:18 CST 2016

Total time taken to generate the page: 0.15481 seconds