ProgrammingGeek

Oracle Express Edition can be distributed and can be used to provide third party demonstration and training. (all the above information is taken from  oracle.com ) Prerequisites Software: VMware Workstation ( VMware Workstation Link ) Oracle Enterprise Linux ( Oracle Enterprise Linux Link ) Oracle Database ( Oracle Database Link ) In this guide the below software versions are used:  VMware Workstation v10.0.0 Oracle Enterprise Linux v5.7 x86-64 Oracle Database Express Edition 11g R2 for Linux x86-64 Installation of VMware Workstation and OEL is not covered in this guide because it is straightforward. Just install them, start them. ( Notice that during the installation of OEL you must check oracle-validated-1.1.* package in system tools ) To install Oracle Database Express Edition: Log in as root user and run the executable 'oracle-xe-11.2.0-1.0.x86_64.rpm' You must run '/etc/init.d/oracle-xe configure' as the root user to configure the database. ...

Oracle offers two ways  for a session to read or write operating system files. 1.Oracle directories 2. UTL_FILE package UTL_FILE package contains many PL/SQL procedures for manipulating directory objects. Operating system directories that can be accessed by UTL_FILE are only those listed in UTL_FILE_DIR instance parameter. This parameter default to NULL but can be set to any comma separated list as well as * (wildcard) which means any directory in operating system. SQL > SELECT   NAME, VALUE             FROM     V$PARAMETER             WHERE    UPPER(NAME) = 'UTL_FILE_DIR' Result --------------------------------------------------------------------------------------------------- utl_file_dir             NULL All the directories listed will be visible to all sessions. To give a value for UTL_FILE_DIR parameter file use the following command. SQL > sqlplus /...