Home » SQL & PL/SQL » SQL & PL/SQL » select rows (oracle 10g)
select rows [message #363407] Sun, 07 December 2008 00:02 Go to next message
modhiyakomal
Messages: 49
Registered: November 2008
Location: US
Member
Hi all
how can i select rows from table whose empname starts with S
if i write
select * from emp
where empname='Smith';

then it will return only row with empname Smith, i want all rows which starts with S

thanks
komal
Re: select rows [message #363408 is a reply to message #363407] Sun, 07 December 2008 00:34 Go to previous messageGo to next message
joicejohn
Messages: 327
Registered: March 2008
Location: India
Senior Member
@modhiyakomal,

You can use LIKE Condition.

Hope this helps,

Regards
Jo
Re: select rows [message #363411 is a reply to message #363408] Sun, 07 December 2008 01:48 Go to previous message
modhiyakomal
Messages: 49
Registered: November 2008
Location: US
Member
thanks prob is solved
Previous Topic: Server Date format
Next Topic: Converting a string to comma seperated value
Goto Forum:
  


Current Time: Sat Dec 03 10:03:52 CST 2016

Total time taken to generate the page: 0.17143 seconds