kibeha.dk
KiBeHa - a Danish Sql and Pl/Sql Developer: The upcoming year
http://www.kibeha.dk/2015/12/the-upcoming-year.html
Tuesday, December 29, 2015. Right smack in the middle of the busiest time of the year for the business (this time of year we sell fireworks for New Year) I have opportunity to reflect a bit on the upcoming year and what 2016 will bring of challenges and joys. More directly I'll have a new label in 2016 that I was told about just before Christmas. The great honor of being Oracle ACE. Oracle User Group Norway ( OUGN. Has their traditional top-notch floating spring conference. On March 10-12th 2016. I h...
kibeha.dk
KiBeHa - a Danish Sql and Pl/Sql Developer: June 2015
http://www.kibeha.dk/2015_06_01_archive.html
Friday, June 26, 2015. ODCI dynamic table function parser. Supposing youve got data as a text string with row and column delimiters and you would like to parse out those columns and rows. The external table syntax would actually be great for this, but that requires writing the text out to a file first, and then you can import it back again as columns and rows. Demonstrates the use of ODCITable* functions. Links to this post. Monday, June 22, 2015. Escope very early status. The more responses we can get, ...
kibeha.dk
KiBeHa - a Danish Sql and Pl/Sql Developer: Welcome
http://www.kibeha.dk/p/welcome.html
Welcome to my blog (or at least an attempt to blog something about Oracle SQL and PL/SQL :-). I'm Kim Berg Hansen. And I work as Senior Developer at Trivadis Danmark. Since the year 2000 I have programmed quite a lot of Oracle SQL, a good deal of Concorde XAL, some Oracle PL/SQL, and a smattering of all sorts of other programming languages as the various tasks have mandated. I am OCE (Oracle Certified Expert) on Oracle SQL, and being honored to be an Oracle ACE as well. On the PL/SQL Challenge. Anyway - ...
kibeha.dk
KiBeHa - a Danish Sql and Pl/Sql Developer: March 2016
http://www.kibeha.dk/2016_03_01_archive.html
Tuesday, March 15, 2016. OUGN Spring Conference 2016. Im back after one of the best ocean voyages ever - the OUGN Spring Conference 2016. Links to this post. Subscribe to: Posts (Atom). Senior Developer at Trivadis Denmark. OUGN Spring Conference 2017. Member of Danish Beer Enthusiasts. View my complete profile. OUGN Spring Conference 2016. Oracle Database 12c Release 2 (12.2) : Default APEX Installation Gone! Steven Feuerstein on Oracle PL/SQL. Latest UI for Oracle Dev Gym. Oracle Database PL/SQL and EBR.
saubbane.blogspot.com
Saubhik's Blog On Oracle SQL, PL/SQL and DBA: May 2011
http://saubbane.blogspot.com/2011_05_01_archive.html
Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Monday, May 16, 2011. Reading and Writing Excel file (.xls) From PL/SQL Using COM - PART III. For details see Part I. Here is another version of the package ORDExcelSB. The earlier versions has a drawback. If you modify an existing excel file, then you can't save it in the same name. That caused the application to be hanged. You always have to save the modified file with a new name ("save as"). FUNCTION FormatFont...
saubbane.blogspot.com
Saubhik's Blog On Oracle SQL, PL/SQL and DBA: February 2011
http://saubbane.blogspot.com/2011_02_01_archive.html
Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Wednesday, February 23, 2011. Sending Multiple attachment (BLOB) using UTL SMTP. This is an example of sending multiple attachment through PL/SQL using UTL SMTP. This code is posted in OTN. SQL /* My database version */. SQL SELECT * FROM v$version;. Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod. PL/SQL Release 10.2.0.3.0 - Production. CORE 10.2.0.3.0 Production. 2 src file BFILE;. SQL /* Checki...
kscope15.com
Presenters
http://kscope15.com/presenters
EPM Foundations and Data Management. Lunch and Learn at Kscope15. BI and EPM CPE Credits. Thursday Deep Dive Sessions. While you are in Hollywood. 2015 Exhibitors and Sponsors. Community Service Day 2015. Head to Hollywood and Hallandale. Women in Technology Roundtable. Kids Fun Night Out. EPM Foundations and Data Management. Lunch and Learn at Kscope15. BI and EPM CPE Credits. Thursday Deep Dive Sessions. While you are in Hollywood. 2015 Exhibitors and Sponsors. Community Service Day 2015. Angela Anders...
saubbane.blogspot.com
Saubhik's Blog On Oracle SQL, PL/SQL and DBA: September 2011
http://saubbane.blogspot.com/2011_09_01_archive.html
Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Monday, September 5, 2011. Thesee are some scripts I posted in OTN various times. I am trying to collate them together in this thread. Script I: Exporting particular schema(s). L dp handle NUMBER;. L last job state VARCHAR2(30) := 'UNDEFINED';. L job state VARCHAR2(30) := 'UNDEFINED';. L logfilename VARCHAR2(20) := to char(sysdate, 'DDMMRRRR') '.log';. L dp handle := DBMS DATAPUMP.OPEN(operation = 'EXPORT',. L exp...
saubbane.blogspot.com
Saubhik's Blog On Oracle SQL, PL/SQL and DBA: Listing Operating system disk usages with Oracle External Table PREPROCESSOR feature
http://saubbane.blogspot.com/2015/03/listing-operating-system-disk-usages_10.html
Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Tuesday, March 10, 2015. Listing Operating system disk usages with Oracle External Table PREPROCESSOR feature. This is based on one of my posting in OTN. Database version and directory setups. Now, the OS setups:. Oracle@localhost saubhik]$ # My Operating System. Oracle@localhost saubhik]$ uname -a. Oracle@localhost saubhik]$ cat free space.sh. This shell script is call by External Table's PREPROCESSOR claus.
saubbane.blogspot.com
Saubhik's Blog On Oracle SQL, PL/SQL and DBA: Some interesting Oracle Tuning videos
http://saubbane.blogspot.com/2015/04/some-interesting-oracle-tuning-videos.html
Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Sunday, April 5, 2015. Some interesting Oracle Tuning videos. Subscribe to: Post Comments ( Atom ). 1 The Tom Kyte Blog. Inside the Oracle Optimizer. Inside the Oracle Optimizer - Removing the black magic. Richard Foote's Oracle Blog. Steven Feuerstein on Oracle PL/SQL. The Arup Nanda Blog. Example of downloading a pdf from web (https) and . Some interesting Oracle Tuning videos. View my complete profile.
SOCIAL ENGAGEMENT