Home » Developer & Programmer » Forms » problem how to write sql query in oracle 6i
problem how to write sql query in oracle 6i [message #334825] Fri, 18 July 2008 04:25 Go to next message
kvsd_12
Messages: 5
Registered: July 2008
Junior Member
hi
i have problem that SQL query
of
select * from employee
where city='new york'
employee table have id,first_name,city
are fields
how to write
that query in oracle 6i forms
Re: problem how to write sql query in oracle 6i [message #334838 is a reply to message #334825] Fri, 18 July 2008 05:40 Go to previous messageGo to next message
mfinn
Messages: 9
Registered: July 2008
Location: UK
Junior Member
You write that SQL exactly the same way in Forms as you do anywhere else.

Please explain what your problem is.
Re: problem how to write sql query in oracle 6i [message #334866 is a reply to message #334825] Fri, 18 July 2008 07:58 Go to previous messageGo to next message
Littlefoot
Messages: 21821
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You can't use such a query in Forms; if it is part of a trigger or a procedure, it should be a PL/SQL block and SELECT statement, in that case, requires INTO clause.

Or, if you'd like to use a SELECT statement as a data block source, name all columns you'd like to use in a block.
Re: problem how to write sql query in oracle 6i [message #334966 is a reply to message #334866] Fri, 18 July 2008 23:35 Go to previous messageGo to next message
kvsd_12
Messages: 5
Registered: July 2008
Junior Member
thanks for response.
can you please tell me how to write such query
with coding in pl/sql
Re: problem how to write sql query in oracle 6i [message #334978 is a reply to message #334966] Sat, 19 July 2008 01:19 Go to previous message
Littlefoot
Messages: 21821
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
The best way for you would be studying one of PL/SQL books. I'd recommend the PL/SQL User's Guide and Reference.
Previous Topic: JInitiator
Next Topic: Any good document for oracle forms developing
Goto Forum:
  


Current Time: Thu Nov 07 16:52:46 CST 2024