Category Archives: Using sqlplus

How to setup a sqlplus environment.

sql4oracle.zip updated

New files: x4o_objects – script to create the xls4oracle objects view. Joins lots of informations: SQL> desc x4o_objects  Name                                    ————————————-  OWNER                                   OBJECT_NAME                             OBJECT_DESCRIPTION                      LAST_UPDATE_DATE                        OBJECT_TYPE                             SOURCE                                  DOWNLOAD                                UPLOAD                                 load.sql – script to generate upload and download script. locks.sql – change … Continue reading

Posted in oracle applications, scripts for sqlplus, Using sqlplus | Leave a comment

Structure of Oracle Applications Database

Everything is executed with the apps user. All packages, procedures, functions and views are (or should be) owned by the apps user. Tables and indexes are owner by application users (like AR, GL, AP…) and access is granted to the … Continue reading

Posted in scripts for sqlplus, Using sqlplus | Leave a comment

Apps Initialize

When Oracle Applications is running, its running with the apps logon. When you develop for oracle applications, you should allways connect as the apps user. All database objects is accessible from the apps user. When you connect to the database … Continue reading

Posted in Using sqlplus | Tagged | Leave a comment

Setup sqlplus

This articel will show you how to setup to use sqlplus on a windows platform. install an oracle client retrieve and update tnsname create a sqlplus working folder – like: c:\apps\sql copy the needed (all) scripts from sql4oracle.com to the … Continue reading

Posted in Using sqlplus | Tagged , , , | Leave a comment