Home » SQL & PL/SQL » SQL & PL/SQL » how to make it by help of procedure
how to make it by help of procedure [message #608876] Wed, 26 February 2014 00:51 Go to next message
aaditya321
Messages: 225
Registered: January 2014
Location: Delhi
Senior Member
I have query please help me, I need some record as when user search id no. 2 then get only id no.2 information not others, when any user search id no.1, id no.2, id no. 5 then user got only corresponding id no.1, id no.2, id no.5 data not others. Similarly user can search different.

Report message to a moderator

Re: how to make it by help of procedure [message #608877 is a reply to message #608876] Wed, 26 February 2014 00:55 Go to previous messageGo to next message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That would be a WHERE clause, I suppose. 
where id = 2
or
where id in (1, 2, 5)

Keyword you might be looking for is "varying elements in IN list" (here's a Tom Kyte's blog, but you may search for more).

Report message to a moderator

Re: how to make it by help of procedure [message #608879 is a reply to message #608877] Wed, 26 February 2014 01:10 Go to previous messageGo to next message
aaditya321
Messages: 225
Registered: January 2014
Location: Delhi
Senior Member
user can search randomly not fixed please make procedure.

Report message to a moderator

Re: how to make it by help of procedure [message #608880 is a reply to message #608879] Wed, 26 February 2014 01:21 Go to previous message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Did you read the link Littlefoot posted?

Report message to a moderator

Previous Topic: CLOB extraction
Next Topic: Need invalid records
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 06:58:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.