1 / 21

Developer 2000 Forms and Reports (Oracle 9i)

Developer 2000 Forms and Reports (Oracle 9i). Vandana Janeja April 2004 For : Database Systems 22:198:603 Prof. Vijay Atluri Adapted from material by Dr.Richard Holowczak and Mahmoud Youssef Mohamed . ssh to pegasus, then ssh to penelope, password same as pegasus password.

juan
Download Presentation

Developer 2000 Forms and Reports (Oracle 9i)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Developer 2000Forms and Reports (Oracle 9i) Vandana Janeja April 2004 For : Database Systems22:198:603 Prof. Vijay Atluri Adapted from material by Dr.Richard Holowczak and Mahmoud Youssef Mohamed

  2. ssh to pegasus, then ssh to penelope, password same as pegasus password

  3. To create tables: initiate sqlplus from penelope Sqlplus username: pegasususername@oradata2 Password if logging on first time is Spring2004 Change password after logging on first time using passw command

  4. To be able to start forms initiate tunneling You should have installed PC Xware before this

  5. To start forms type: f90desm on penelope prompt

  6. Change browser preferences using menu options: Edit-> preferences-> runtime tab Web Browser location /usr/local/bin/mozilla After changing this you will have to close and start forms again for this to take effect

  7. Connecting to database

  8. Creating the data block using wizard

  9. Browsing tables of existing user, if you have not connected before you will be prompted to connect here

  10. Selecting fields

  11. Giving name to Data Block wizard

  12. Layout Wizard is initiated to create a form layout

  13. Selecting fields to be shown on the form

  14. Changing width height of form components This can be done in the layout editor also Selecting type of form

  15. Layout Editor

  16. Saving form as .fmb file

  17. For Other detailed notes please refer to: http://www.pegasus.rutgers.edu/~youssefm/oracle/forms/index.html And http://cimic.rutgers.edu/~holowcza/oracle/

More Related