Home » Developer & Programmer » Forms » can i perform select statement using forms_ddl?
can i perform select statement using forms_ddl? [message #80252] Thu, 29 August 2002 18:21 Go to next message
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
Re: can i perform select statement using forms_ddl? [message #80260 is a reply to message #80252] Fri, 30 August 2002 13:16 Go to previous messageGo to next message
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.
Re: can i perform select statement using forms_ddl? [message #80264 is a reply to message #80252] Fri, 30 August 2002 16:05 Go to previous message
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?
Previous Topic: Re: ANNOYING ALERT!
Next Topic: forms 6i on the web
Goto Forum:
  


Current Time: Sat Mar 02 11:55:39 CST 2024