John Piwowar
  • Male
  • Vancouver, BC
  • Canada
Share on Facebook
Share

John Piwowar's Friends

  • Tony D'Amico
  • Surachart Opun

Gifts Received

Gift

John Piwowar has not received any gifts yet

Give a Gift

 

Hi there!

Latest Activity

John Piwowar commented on jay's blog post What product components are covered by Standard Edition 10g
"Hi, You can find the list of licensed components for Standard and Enterprise Edition in the Oracle 10g documentation. Here's a link, to spare you the search. :-) Regards, John P."
Jun 5, 2009
abhishek singh left a comment for John Piwowar
"hey john , welcome to the community i am starter in oracle working for last 6-7 month.it was nice to read your blog . but i'm really looking forward to asm technology . would be great if you can comment on that once again welcome to the…"
May 1, 2009
John Piwowar posted a blog post

How old is that E-Business Suite clone, really?

In this post, I explore some methods to determine when the data in an E-Business Suite database was copied from its source.
Apr 30, 2009
John Piwowar commented on Zeeshan Ali's blog post function query
"Hi Ali, Two thoughts: First, I think you need to reverse the position of name1 and name2 in your query, for example: SQL> create table tcase (name1 varchar2(20), name2 varchar2(20)); Table created. SQL> insert into tcase values…"
Apr 23, 2009
John Piwowar posted a blog post

Oracle 10gR2 RDBMS for Mac OS X (Intel) has arrived!

Oracle has, at long last, released a version of the RDBMS for Mac OS X Intel. Not all features are supported, but on the other hand, it will run natively even on a non-Server version of Leopard. Woohoo!A quick note: I don't have any installation instructions in the post linked above, but here are some good resources:…See More
Apr 11, 2009
John Piwowar posted a blog post

Via Twitter, an interesting regexp_replace puzzle

Prolific and knowledgeable Oracle Ace LewisC asked a regular expression (more specifically, regexp_replace) question on Twitter, and I found myself thinking, "hey, I bet I could actually answer that!" So I did. Then I thought about my answer a bit more, and decided to write a blog post to expand upon my original 140-character response.
Apr 3, 2009
John Piwowar posted a blog post

Two new(ish) blog posts: EBS log files and still more EBS and Grid Control

Whose log file is it, anyway?I wrote a quick and dirty script to query FND_PROFILE tables to get information about a log file I found on an E-Business Suite app tier. Not particularly revolutionary, but on the off-chance that it helps someone, I'm sharing.More fun with Grid Control and EBSAfter two months of cheerfully monitoring your…See More
Mar 23, 2009
John Piwowar posted a blog post

Retrieving Oracle patches with wget

While working from home this evening, I had to download some patches to a remote Linux system, and was struck, not for the the first time, by the inconvenience of it all. So I wrote a quick shell function that helps me grab patches using wget. And then, I decided to share with the world, or at least the really small portion of the world that visits my blog. ;-)
Feb 13, 2009

Profile Information

About Me:
I work with Oracle products. Anyone else around here into that? ;-) OCP DBA (9i, 10g) and OCP Apps DBA (11.5.10, R12)
My Blog:
http://only4left.jpiwowar.com

Other places to find me

OTN Forums
LinkedIn
Facebook
Oracle Mix
Caribou Coffee (usually with a sleeping toddler)

John Piwowar's Blog

How old is that E-Business Suite clone, really?

In this post, I explore some methods to determine when the data in an E-Business Suite database was copied from its source.

Posted on April 30, 2009 at 6:53pm

Oracle 10gR2 RDBMS for Mac OS X (Intel) has arrived!

Oracle has, at long last, released a version of the RDBMS for Mac OS X Intel. Not all features are supported, but on the other hand, it will run natively even on a non-Server version of Leopard. Woohoo!



A quick note: I don't have any installation instructions in the post linked above, but here are some good resources:…

Continue

Posted on April 11, 2009 at 5:00pm

Via Twitter, an interesting regexp_replace puzzle

Prolific and knowledgeable Oracle Ace LewisC asked a regular expression (more specifically, regexp_replace) question on Twitter, and I found myself thinking, "hey, I bet I could actually answer that!" So I did. Then I thought about my answer a bit more, and decided to write a blog post to expand upon my original 140-character response.

Posted on April 3, 2009 at 9:30am

Two new(ish) blog posts: EBS log files and still more EBS and Grid Control

Whose log file is it, anyway?

I wrote a quick and dirty script to query FND_PROFILE tables to get information about a log file I found on an E-Business Suite app tier. Not particularly revolutionary, but on the off-chance that it helps someone, I'm sharing.



More fun with Grid Control and EBS

After two months of… Continue

Posted on March 23, 2009 at 7:44am

Retrieving Oracle patches with wget

While working from home this evening, I had to download some patches to a remote Linux system, and was struck, not for the the first time, by the inconvenience of it all. So I wrote a quick shell function that helps me grab patches using wget. And then, I decided to share with the world, or at least the really small portion of the world that visits my blog. ;-)

Posted on February 13, 2009 at 9:09pm

Comment Wall (3 comments)

You need to be a member of Oracle Community to add comments!

Join Oracle Community

At 7:24am on May 1, 2009, abhishek singh said…
hey john ,
welcome to the community
i am starter in oracle working for last 6-7 month.it was nice to read your blog .
but i'm really looking forward to asm technology .
would be great if you can comment on that
once again welcome to the community
thanks
At 10:39am on October 16, 2008, Tony D'Amico said…
John, thanks! Good to hear from you. How are things at Vocollect?
At 7:24pm on September 7, 2008, Eddie Awad said…
Hi John and welcome to OracleCommunity.net. Nice Ubiquity command by the way.
 
 
 

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

College Paper Writing Service

Actually time is a limited resource, especially for college and academic students. Who have to deal with Time is a limited resource, especially for college students who have to compact with their extracurricular, studies, and assignment paper.

Although most of the students are very dedicated for their college life and college studies. But time is a valuable thing for every person especially for students. So if you have ever faced the pressure of working on multiple assignment…

Continue

Posted by david smith on December 4, 2016 at 10:23pm

Steps to Follow When Developing Interactive Children’s eBooks

Today, just getting a book published and made available in print isn’t enough. As printed books will only reach half of your audience base. Publishers can now increase their sales by developing books in a format that is preferred by your readers. Publishers are already recognizing the disruption brought about by eBooks.…

Continue

Posted by Alvaro Dee on December 3, 2016 at 12:25am

Recover a deleted folder

Specifically to solve caused by- starting up you see, our own laptop or computer publisher, Right after that using [HKEY_CLASSES_ROOT\ftp] Add a vital dubbed recovering files from sd card "ShellFolder" When it comes to cord cost point "E436EBB6-524F-11CE-9F53-0020AF0BA770, The mistake do just stop developing, With out a reactivate or other behavior applicable.…

Continue

Posted by Rachel C on December 1, 2016 at 10:09pm

4 Things to Know About the GREATEST Function in Oracle

The GREATEST function in Oracle is one that is helpful, but I haven't seen used very often. If you do use it, keep these things in mind.
What Is The GREATEST Function?
The first thing to know about the function is what it does.
GREATEST finds the greatest value in a list of provided values.
The syntax is:
GREATEST ( expr1, [ expr_n] )
You provide it with a set of expressions, and the function will find the greatest of…
Continue

Posted by Ben Brumm on November 27, 2016 at 10:00am

© 2016   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service