OraFAQ Forum: Forms » can i perform select statement using forms

Home » Developer & Programmer » Forms » can i perform select statement using forms_ddl?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

can i perform select statement using forms_ddl? [message #80252]

Thu, 29 August 2002 18:21

sjane
Messages: 2
Registered: August 2002

Junior Member

can i perform select statement using forms_ddl? if ever, how? if not, how can i create a dynamic where condition that accepts user input condition for my select statement

Report message to a moderator

Re: can i perform select statement using forms_ddl? [message #80260 is a reply to message #80252]

Fri, 30 August 2002 13:16

Gursharn
Messages: 4
Registered: August 2002

Junior Member

Place a text box on your form, say txt_userInput.
in your code do this:

DECLARE
v_input VARCHAR2(25);
v_result VARCHAR2(25);

BEGIN
v_input := :txt_userInput;

SELECT column_name
INTO v_result
FROM table_name
WHERE column_name = v_input;

END;

--this will work if you are only returning one row from the select statement. If however, you anticipate more than one row will be returned, you will need to use a cursor.

Report message to a moderator

Re: can i perform select statement using forms_ddl? [message #80264 is a reply to message #80252]

Fri, 30 August 2002 16:05

sjane
Messages: 2
Registered: August 2002

Junior Member

sorry if my question is not that clear or complete...

i want to perform select statement wherein the user is allowed to input the condition for my select statement for example ...

Select col from table where (user's condition)

how will i perform this?

Report message to a moderator

Previous Topic:	Re: ANNOYING ALERT!
Next Topic:	forms 6i on the web

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 06:47:13 CDT 2024