OraFAQ Forum: Forms » problem how to write sql query in oracle 6i

Home » Developer & Programmer » Forms » problem how to write sql query in oracle 6i

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

problem how to write sql query in oracle 6i [message #334825]

Fri, 18 July 2008 04:25

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

Report message to a moderator

Re: problem how to write sql query in oracle 6i [message #334838 is a reply to message #334825]

Fri, 18 July 2008 05:40

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.

Report message to a moderator

Re: problem how to write sql query in oracle 6i [message #334866 is a reply to message #334825]

Fri, 18 July 2008 07:58

Littlefoot
Messages: 21818
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.

Report message to a moderator

Re: problem how to write sql query in oracle 6i [message #334966 is a reply to message #334866]

Fri, 18 July 2008 23:35

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

Report message to a moderator

Re: problem how to write sql query in oracle 6i [message #334978 is a reply to message #334966]

Sat, 19 July 2008 01:19

Littlefoot
Messages: 21818
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.

Report message to a moderator

Previous Topic:	JInitiator
Next Topic:	Any good document for oracle forms developing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 14:20:39 CDT 2024