Tags » Oracle

Long Time No Post

So it’s been a while since I last wrote anything and it’s odd that the last time I wrote I had only four decks as now I have around twenty different decks. 43 more words

Tarot

☆ September 2nd 2014 AngelScope ☆

This is a wondrous time of exploration, romance and creativity

Regardless of whether you are male or female, your feminine, creative spirit is being nourished and awakened by the star of Venus. 162 more words

Spirituality

Oracle's OCI accepts 'ampersand' as legal indicators for bind variable placeholders - undocumented?

I came across a piece of Perl DBI code recently. It surprised me that it actually worked.


$dbh->{TraceLevel} = '5|DBD|SQL';

my $sql =<<'EOS';
select :v1, :v2
from dual
where &v2 = 2
EOS

my $sth = $dbh->prepare($sql);

$sth->bind_param(':v1', 10);
$sth->bind_param(':v2', 2);

$sth->execute;

my $rows = $sth->fetchall_arrayref();
print Dumper($rows);

… 298 more words
Technology

Sage 300 ERP 2016 SQL Server Only

Introduction

If you were able to attend the Sage 300 ERP roadmap sessions at Sage Summit you would have heard that the next major release of Sage 300 ERP (named 2016 but released in 2015) will be dropping support for… 1,199 more words

Sage 300 ERP

HOWTO Secure iSCSI Luns Between Oracle Enterprise Linux 7 and NetApp Storage with Mutual CHAP

This post demonstrates how to enable Bidirectional or Mutual CHAP on iSCSI luns between Oracle Enterprise Linux 7 and NetApp storage. The aggregate, lun and disk sizes are small in this HOWTO to keep it simple. 1,967 more words

Security

SLOB Patch 2014.09.01 - AWR Post-Processing Script (awr_info.sh) Fix.

The SLOB kit comes with a little script that extracts interesting information from the awr.txt file produced at the end of a SLOB test. This is just a quick blog entry to point folks to a patched version of awr_info.sh that works properly with all Oracle Database 11g releases as well as Oracle Database 12c. 353 more words

Oracle

ROSEMARY'S NEWS

Labor Day! Here in the US this signals the end of Summer. School has started for the kids, swimming pools are closing. Nights are getting cooler and days are getting noticeably shorter. 374 more words

Guidance For Conscious Living