Category Archives: scripts for sqlplus

sql4oracle.zip updated

Posted on 14 March 2013 by tlu

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

sql4oracle.zip updated with new and updated files

Posted on 20 October 2011 by tlu

The following scripts has been added – and lots of updates: header – show $header from database source objects ccid – show segment values for a ccid ubj – @obj on user objects cnt – count number rows in multiple … Continue reading →

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

sql4oracle.zip updated with new and updated files

Posted on 3 October 2010 by tlu

The following scripts has been added/updated: @create_user – new @activate_user – new @disable_user – new @user_password – new @enable_user – new @save_profile_user – new @del_resp – updated @password – new @dump – updated @info – updated @cre_forms_pkg – new @cre_table_pkg … Continue reading →

Posted in scripts for sqlplus | Leave a comment

The par.sql script updated

Posted on 26 June 2010 by tlu

The par.sql script updated to use v$parameter2. This will show paramteres like control_files and utl_file_dir like this:  control_files              /u000/app/oradata/XXXX/cntrl01.dbf control_files              /u000/app/oradata/XXXX/cntrl02.dbf control_files              /u000/app/oradata/XXXX/cntrl03.dbf

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

New script added: wf_oecogs.sql – to run oecogs workflow for a order line

Posted on 29 January 2010 by tlu

This script accepts ordernumber and line and will start the oecogs workflow, showing debug messages from workflow. Great script for customizing the oecogs workflow. It is included in the sql4oracle.zip file

Posted in scripts for sqlplus | Leave a comment

New scripts for ftp of out and log from applications server to PC

Posted on 28 January 2010 by tlu

The reqftp.sql will show the latest request – and you just need copy/paste the @reqft2 <request id> to download log and out files. NB: You need to edit the reqftp2.sql with your enviroment data: hostname:   def hostname = <hostname … Continue reading →

Posted in scripts for sqlplus | Leave a comment

Just added: the proc scripts, to generate prototype scripts

Posted on 20 January 2010 by tlu

The proc scripts will generate procedure calls with declare section, assign section and procedure call.

Posted in scripts for sqlplus | Leave a comment

Structure of Oracle Applications Database

Posted on 20 October 2009 by tlu

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