Tags » Oracle

Installation SQLplus

For a customer I was required to extract and report data from an Oracle database
Ofcourse I want to automate this task to the full extent. 155 more words


Oracle ITSO Mindmap Update

So I have been chipping away at my mind mapping of the foundation reference architecture from Oracle (part of the IT Strategies from Oracle – ITSO… 39 more words


Daily Reading for 2/14

A robed woman tips her head to the side, takes in a deep breath then exhales; the seeds in her hand lifting off and into the wind. 295 more words


Methods of Efficient Data Access – 2

Hi everyone,

In this article, I’ll continue to talk about Methods of Efficient Data Access, which I had started writing before, from where I left off. 1,291 more words


send mail alert - Wen Oracle DB shutsdown

SQL> connect sys/password as sysdba

SQL> @$ORACLE_HOME/rdbms/admin/utlmail.sql 

Package created. 

Synonym created. 

SQL> @$ORACLE_HOME /rdbms/admin/prvtmail.plb 

Package body created. 

No errors. 
SQL> alter system set smtp_out_server = '<ip-address:port' scope=Both; 

System altered. 120 more words

Methods of Efficient Data Access – 1

Methods of Efficient Data Access– 1
Hi everyone,

In this article, I’ll discuss how we can improve the performance of methods we apply while accessing data, their differences and, how we can enhance our data accessing performance. 1,925 more words