creating input form using oracle 9i

hello Expert,

I am using oracle 9i.

I created a table re:

CREATE TABLE JOURNAL_TRAN
(
  TRAN_AMT    NUMBER(22,2),
  JOURNAL_NO  VARCHAR2(5 BYTE),
  DESCRIPT    VARCHAR2(30 BYTE),
  TRAN_DATE   DATE, not null
  TRAN_CODE   NUMBER(3)                         NOT NULL,
  ACC_NO      VARCHAR2(16 BYTE),
  BRANCH      VARCHAR2(6 BYTE)

I would like to to create a user front end to populate

the journal_tran table


The aim is to  provide the user with an input front_end form

with the above field names.

example

acc_no          journal_no                               tran_date

tran_code                           tran_amt

branch

descript xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


The above is a sample layout of the form.

the design should flexible to allow user customization.

How can i go about creation such form using oracle 9i.

If it is not possible with oracle can you suggest any

other method to do same.

 
Start Free Trial