Home » Developer & Programmer » Forms » how to update the table by forms (oracle forms)
how to update the table by forms [message #469710] Thu, 05 August 2010 10:56 Go to next message
awanish
Messages: 1
Registered: August 2010
Location: delhi
Junior Member
hi... i have a tabular form select * from emp

and i want to create table and store there data in goup
select empono,sal,com group by dept
i want to insert in another table
how i insert the data in table by forms front end and then update also when again click the button
or any change occur in form

insert into a
select empono,sal,com group by dept

please reply if u have idea by code
Re: how to update the table by forms [message #469766 is a reply to message #469710] Thu, 05 August 2010 14:13 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
What do you mean by "select empono,sal,com group by dept".
Do you mean for each dept you will create a table?

By
Vamsi
Re: how to update the table by forms [message #469975 is a reply to message #469766] Fri, 06 August 2010 11:55 Go to previous message
payalagarwal
Messages: 8
Registered: August 2010
Junior Member
hi,
your Question is not quite clear... do you want to create tables for diffrent departments or you simply want to make data entries in emp table and afterwrds update also, using forms? and please make the idea of groups clear, do you want to retrive the emp information by simply giving the department no?
Previous Topic: Migrating from oracle 8i to oracle 10g
Next Topic: Changing the Colour of Item
Goto Forum:
  


Current Time: Thu Sep 19 17:53:24 CDT 2024