Last week I was asked by one of IT managers on how to generate reports from database. He’d like to remind his direct reports on ticket’s backlog status. His requirement is just simply to run a simple SQL statement and email the result out weekly. I quickly told him that you can just cron or …
The Oracle SQL developer is not only a great tool for SQL development, with its migration workbench, it is an excellent tool for database migration. Did I also mention it is free? To get it started, you will need to download the latest version of the tool which is version 1.5.1. Also it is recommended …
In 11g SQL*Plus, when session is terminated, somehow it displays the process ID, SID and Serial#. Not quite sure what is really for? I guess it is for debugging purpose. 10g Client user @db10w1> select * from dual; select * from dual * ERROR at line 1: ORA-01012: not logged on 11g Client user @db10w1> …
I found one of the interesting features in SQL*Plus 11g for Oracle11g database when doing “help show” from the tool. SHOW SPPARAMETERS [parameter_name] Show specific parameters – SYSTEM @db11r1> show spparameters sga SID NAME TYPE VALUE ——– —————————– ———– —————— * lock_sga boolean * pre_page_sga boolean * sga_max_size big integer * sga_target big integer Show …
The SQL*Plus COPY command can copy data between two databases via SQL*Net. Syntax: USER1 @srcdb> copy usage: COPY FROM [db] TO [db] [opt] [table] { ([cols]) } USING [sel] [db] : database string, e.g., hr/your_password@d:chicago-mktg [opt] : ONE of the keywords: APPEND, CREATE, INSERT or REPLACE [table]: name of the destination table [cols] : a …
Today I installed Oracle 11g (11.1.0.6) on my machine. I did not realize that Oracle APEX is a part of the standard database components. So after the 11g installation, I just follow simple steps (shown later below) for the post-installation. In order to access the APEX application, either the embedded PL/SQL gateway or Oracle HTTP …
