Home » SQL & PL/SQL » SQL & PL/SQL » sql command
sql command [message #1091] Sun, 31 March 2002 19:59 Go to next message
Mahesh
Messages: 90
Registered: January 2001
Member
Hai, plz any one can clear my doubt , i hope so.
my doubt is
if we inserted some data in an EMP table, for example the employee nameeg. Smith, and the salary of the employee.
how we get the display as
Smith's salary is 1000.00 like that.
i mean the "apostraphe" after the employee name.
can any one gives me the command or procedure for this.

Report message to a moderator

Re: sql command [message #1092 is a reply to message #1091] Sun, 31 March 2002 22:30 Go to previous messageGo to next message
D e e p a n k a r
Messages: 9
Registered: October 2001
Junior Member
select ename || '''s' || ' salary is ' sal from emp

hope this solves the problem

regards
Deepankar

Report message to a moderator

Re: sql command [message #1099 is a reply to message #1091] Mon, 01 April 2002 07:01 Go to previous message
Mahesh
Messages: 90
Registered: January 2001
Member
Thanx for u r help

Report message to a moderator

Previous Topic: Need help on
Next Topic: How can I see the SQL used to create a View?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 09:17:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.