Partial key
I just want just like in other programminglanquages acces a table as follows,
It has foor eaxple an index on name. Alot of Sm... names are there.
I now see that in a where clause I have to ask for a full name like Smith to get all mr Smith's. When have in de where clause, where name = "S", following the index nothing is found. And I just want all the names beginning with S or Sm etc.
Any suggestions?
Subject
Views
Written By
Posted
Partial key
3564
June 11, 2005 12:03PM
1823
June 14, 2005 10:42AM
1953
June 14, 2005 02:16PM
1691
June 15, 2005 02:21AM
1692
June 15, 2005 05:16AM
1844
June 15, 2005 06:24AM
5046
June 15, 2005 12:06PM
1752
June 16, 2005 05:07AM
1720
June 16, 2005 07:57AM
1723
June 16, 2005 08:30AM
1780
June 16, 2005 08:50AM
1627
June 16, 2005 10:21AM
2731
June 16, 2005 03:00PM
1725
June 17, 2005 12:00AM
1640
June 17, 2005 01:28AM
1627
June 20, 2005 01:21AM
1819
June 20, 2005 06:41AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.