-
Hi,
I want the user to select the address and phone number based on social security number in the where clause, but not to find the social security number by giving phone number in the where clause.
e.g
select address, phone from test
where ssn='123456789' ;
not
select ssn from test
where phone='123-345-1234';
Any solutions ?.
Thanks in advance.
gtm
-
Can you create a view?
MH
I remember when this place was cool.
-
Hi, if I create a view without ssn, then I can not use the ssn in the predicate. Any suggestions ?
-
Hmmm. Almost sounds like you will need to create a refcursor and hide the logic behind it.
Jeff Hunter
-
Actually, this query would run from a web page.
Gtm
-
Originally posted by marist89
Hmmm. Almost sounds like you will need to create a refcursor and hide the logic behind it.
Jeff Hunter
-
Thank you Jeff, would you please provide an example to the solutions ?.
Thanks-
-
Does the table have user's login id ?
-
Create a procedure - input the SSN, and out comes the name and phone number.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|