Home » Developer & Programmer » Forms » EXECUTE QUERY
EXECUTE QUERY [message #588714] Thu, 27 June 2013 11:18 Go to next message
jocelyne
Messages: 34
Registered: December 2012
Location: lebanon
Member
hi all,

how can i execute query using a where condition?

thank you
Re: EXECUTE QUERY [message #588715 is a reply to message #588714] Thu, 27 June 2013 11:21 Go to previous messageGo to next message
BlackSwan
Messages: 21944
Registered: January 2009
Senior Member
jocelyne wrote on Thu, 27 June 2013 09:18
hi all,

how can i execute query using a where condition?

thank you



use any SQL client utility, such as sqlplus, that can connect to Oracle DB

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

[Updated on: Thu, 27 June 2013 11:22]

Report message to a moderator

Re: EXECUTE QUERY [message #588716 is a reply to message #588715] Thu, 27 June 2013 11:23 Go to previous messageGo to next message
jocelyne
Messages: 34
Registered: December 2012
Location: lebanon
Member
well i'm using sqlplus but i need to execute query with a where condition in the form
Re: EXECUTE QUERY [message #588717 is a reply to message #588716] Thu, 27 June 2013 11:27 Go to previous messageGo to next message
cookiemonster
Messages: 10573
Registered: September 2008
Location: Rainy Manchester
Senior Member
Is this a question about oracle forms?
Re: EXECUTE QUERY [message #588718 is a reply to message #588717] Thu, 27 June 2013 11:29 Go to previous messageGo to next message
jocelyne
Messages: 34
Registered: December 2012
Location: lebanon
Member
yes it's about triggers in oracle forms
Re: EXECUTE QUERY [message #588720 is a reply to message #588718] Thu, 27 June 2013 11:40 Go to previous messageGo to next message
jocelyne
Messages: 34
Registered: December 2012
Location: lebanon
Member
i just need to execute query from the db in a tabular form but using a where condition
can you please help me?
Re: EXECUTE QUERY [message #588721 is a reply to message #588720] Thu, 27 June 2013 12:15 Go to previous messageGo to next message
jocelyne
Messages: 34
Registered: December 2012
Location: lebanon
Member
i have tried the execute immediate query but it did not work does anyone have another solution?
Re: EXECUTE QUERY [message #588723 is a reply to message #588721] Thu, 27 June 2013 13:12 Go to previous messageGo to next message
joy_division
Messages: 4454
Registered: February 2005
Location: East Coast USA
Senior Member
This is such a generic question that cannot be answered with such little information provided. and you wonder why the thread keeps going on and on and on and on.
Please ask a fully detailed question.
My answer is you do not need a where clause, you use the built-in functionality of FORMS and base the block on a table.

Also, "but it did not work" is not an Oracle error message.

[Updated on: Thu, 27 June 2013 13:13]

Report message to a moderator

Re: EXECUTE QUERY [message #588724 is a reply to message #588723] Thu, 27 June 2013 13:32 Go to previous messageGo to next message
jocelyne
Messages: 34
Registered: December 2012
Location: lebanon
Member
create table Product_detail
(
id_inv_det integer,
barcode varchar2(50),
quantity integer,
unit_price integer,
total integer,
constraint pk_iddetail_barcode primary key(id_inv_det,barcode),
constraint fk_iddetail foreign key(id_inv_det) references Invoice_detail(id_inv_det),
constraint fk_barc foreign key(barcode) references Product(barcode)
);

this is my table all i want is to get the data from the db and put it in a grid but i don't want to display all the records, i need to display only the records for the selected id_inv_det

did you get what i need?
Re: EXECUTE QUERY [message #588725 is a reply to message #588724] Thu, 27 June 2013 13:50 Go to previous message
Littlefoot
Messages: 18826
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
  • enter query mode
  • now, enter desired value into ID_INV_DET
  • execute query
  • only records that contain that value within the ID_INV_DET column are displayed
Previous Topic: iconic image with label in button
Next Topic: Global variable
Goto Forum:
  


Current Time: Fri Apr 18 19:31:27 CDT 2014

Total time taken to generate the page: 0.09139 seconds