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

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

Notional Pool Setups

Hi All,

I have a requirement to setup a Notional Cash pool setups between pool leader and subaccount,

Please let me know what are the setups required to complete this.

Thanks,

Kishore

Posted by Kishore on September 14, 2014 at 11:00pm

Join cases between related tables in data computing and analytics

Related computing can be: Inner join or outer join. The outer join can be further divided into left join, right join, and full join. With esProc, such kinds ofrelated computing can be easily implemented. In the discussion below, we will introduce the join operations with some examples using the table emp and table sOrder.

Table structure:

The table emp stores the employee data table, in which the…

Continue

Posted by Jim King on August 25, 2014 at 1:35am

Oracle RAC Classes

Contact me for Oracle High Availability Training / Online Classes - Dubai shans.dba@gmail.com

Posted by Shanmugam on August 18, 2014 at 1:00am

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service