Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Mike

Pages: 1 ... 122 123 [124] 125 126 ... 128
PSOUG / NWOUG - Lunch & Learn Oracle Hyperion Overview
« on: June 15, 2009, 09:10:37 PM »
NWOUG - Lunch & Learn Oracle Hyperion Overview

Please come lunch and learn about Oracle Hyperion. Oracle Corporation and your Northwest Oracle Users Group (NWOUG) are sponsoring this FREE event -- lunch is included!

Oracle’s Hyperion Enterprise is a proven packaged application that improves departmental financial consolidation and reporting efficiency by streamlining the collection, consolidation, and reporting of financial results in a global environment. With Hyperion Enterprise, you will be able to reduce your financial close cycle, improve the quality of financial information, and enhance decision-making. Hyperion Enterprise can be distributed and installed at remote offices quickly and easily, and can be fully deployed by the finance organization with minimal information technology support.

Jeff Jacoby from Oracle will be the speaker at this event.

Jeff will be sharing with us at this event

·  Overview of Hyperion

·  Hyperion strategy/roadmap

·  Q&A session will follow after the presentation

When: Tuesday, Jul 14, 2009, 12:00 PM until 1:30 PM
Where: Oregon Health & Science University (OHSU) STE 900-901
1515 SW 5th Ave.
Portland, OR  97201

Registration is required. Click on the following link to register now, space is limited.

PSOUG / Oracle Beware - Google Tests Cloud-Based Database
« on: June 12, 2009, 03:30:21 PM »
Oracle Beware — Google Tests Cloud-Based Database

On Tuesday, the same day Google held a press event to launch its Google Apps Sync for Microsoft Outlook, the company quietly announced in its research team blog a new online database called Fusion Tables.

Under the hood of Fusion Tables is data-spaces technology, which would 'allow Google to add to the conventional two-dimensional database tables a third coordinate with elements like product reviews, blog posts, Twitter messages and the like, as well as a fourth dimension of real-time updates,' according to Stephen E. Arnold, a technology and financial analyst.

'So now we have an n-cube, a four-dimensional space, and in that space we can now do new kinds of queries which create new kinds of products and new market opportunities,' said Arnold, whose research about this topic includes a study done for IDC last August. 'If you're IBM, Microsoft and Oracle, your worst nightmare is now visible.'"

PSOUG / Oracle OpenWorld: October 11th ~ 15th
« on: June 12, 2009, 06:31:23 AM »
Oracle OpenWorld: October 11th ~ 15th

Where can you find the most relevant content for your business and technology needs, network with peers from around the world, get hands-on experience with a full breadth of Oracle technology, and preview what’s coming next from Oracle and its partners? At Oracle OpenWorld,  October 11th ~ 15th.

Oracle OpenWorld brings you more than 1,800 sessions, 400 partner exhibits, keynotes from the world’s technology leaders, hands-on labs, several special networking events, and more. In one place, with one purpose: to help you get the most business benefit from your technology, today and in the future. Learn. Plan. Profit. It all starts here.

Oracle OpenWorld Highlights
    Hotel and Travel Information
    Registration Details
    Session Streams and Tracks
    Oracle Develop
    Primavera Program

   Oracle Mix
    Oracle OpenWorld Blog
    Oracle OpenWorld Wiki
    Exhibition Experience
    Sponsor Listing

   Exhibition Hall Floor Plans
    Oracle PartnerNetwork Activities
    Win a ride with Sean Tucker
    Why Attend Oracle OpenWorld

PSOUG / Re: Add Columns to big Oracle table
« on: June 02, 2009, 08:32:46 PM »
That's a lot of rows to add columns to. Frankly I'd be surprised if it didn't take a while.   :)

Maybe someone here can suggest some tips to speed it up, but I think what you're seeing may be normal.

Hi All,
   I am adding 6 null columns to big oracle table with about 60 million records and it is taking forever to complete.  Any suggestions?  Thanks…Sam 

PSOUG / By Request: How to send email from Oracle
« on: June 02, 2009, 08:51:49 AM »
We've had numerous requests asking how to send email from's one way:

Code: [Select]
create or replace procedure E_MAIL(

p_to in varchar2,
p_from in varchar2,
p_subject in varchar2,
p_text in varchar2 default null,
p_html in varchar2 default null,
p_smtp_hostname in varchar2,
p_smtp_portnum in varchar2)
l_boundary varchar2(255) default ‘a1b2c3d4e3f2g1′;
l_connection utl_smtp.connection;
l_body_html clob := empty_clob; –This LOB will be the email message
l_offset number;
l_ammount number;
l_temp varchar2(32767) default null;
l_connection := utl_smtp.open_connection( p_smtp_hostname, p_smtp_portnum );
utl_smtp.helo( l_connection, p_smtp_hostname );
utl_smtp.mail( l_connection, p_from );
utl_smtp.rcpt( l_connection, p_to );

l_temp := l_temp || ‘MIME-Version: 1.0′ || chr(13) || chr(10);
l_temp := l_temp || ‘To: ‘ || p_to || chr(13) || chr(10);
l_temp := l_temp || ‘From: ‘ || p_from || chr(13) || chr(10);
l_temp := l_temp || ‘Subject: ‘ || p_subject || chr(13) || chr(10);
l_temp := l_temp || ‘Reply-To: ‘ || p_from || chr(13) || chr(10);
l_temp := l_temp || ‘Content-Type: multipart/alternative; boundary=’ ||
chr(34) || l_boundary || chr(34) || chr(13) ||

– Write the headers
dbms_lob.createtemporary( l_body_html, false, 10 );

– Write the text boundary
l_offset := dbms_lob.getlength(l_body_html) + 1;
l_temp := ‘–’ || l_boundary || chr(13)||chr(10);
l_temp := l_temp || ‘content-type: text/plain; charset=us-ascii’ ||
chr(13) || chr(10) || chr(13) || chr(10);

– Write the plain text portion of the email
l_offset := dbms_lob.getlength(l_body_html) + 1;

– Write the HTML boundary
l_temp := chr(13)||chr(10)||chr(13)||chr(10)||’–’ || l_boundary ||
chr(13) || chr(10);
l_temp := l_temp || ‘content-type: text/html;’ ||
chr(13) || chr(10) || chr(13) || chr(10);
l_offset := dbms_lob.getlength(l_body_html) + 1;

– Write the HTML portion of the message
l_offset := dbms_lob.getlength(l_body_html) + 1;

– Write the final html boundary
l_temp := chr(13) || chr(10) || ‘–’ || l_boundary || ‘–’ || chr(13);
l_offset := dbms_lob.getlength(l_body_html) + 1;

– Send the email in 1900 byte chunks to UTL_SMTP
l_offset := 1;
l_ammount := 1900;
while l_offset < dbms_lob.getlength(l_body_html) loop
l_offset := l_offset + l_ammount ;
l_ammount := least(1900,dbms_lob.getlength(l_body_html) – l_ammount);
end loop;
utl_smtp.quit( l_connection );

After creating this procedure, just call it from any form or trigger.

PSOUG / A neat trick from Denes Kubicek's ApEx BLOG....
« on: June 02, 2009, 08:28:19 AM »
A neat trick from Denes Kubicek's ApEx BLOG....

In Apex you can create links out of your columns in a report. What you currently can't do is to put a condition behind this link and generate it upon that condition - if there is a link then it is there for all the rows. The only workarround for this is to create the link in your SQL. In that case your SQL may look quite clumsy and hard to read. Something like this:

Code: [Select]
          WHEN deptno = 10
             THEN    '<a href="java-script:popUp2('''
                  || 'f?p=&APP_ID.:500:&SESSION.::&DEBUG.::'
                  || 'P500_DEPTNO:'
                  || deptno
                  || ''', 700, 700);">'
                  || '<img src="#IMAGE_PREFIX#gobut.gif">'
                  || '</a>'
          WHEN deptno = 20
             THEN    '<a href="java-script:popUp2('''
                  || 'f?p=&APP_ID.:501:&SESSION.::&DEBUG.::'
                  || 'P501_DEPTNO:'
                  || deptno
                  || ''', 700, 700);">'
                  || '<img src="#IMAGE_PREFIX#go_search.gif">'
                  || '</a>'
          ELSE    '<a href="java-script:popUp2('''
               || 'f?p=&APP_ID.:502:&SESSION.::&DEBUG.::'
               || 'P502_DEPTNO:'
               || deptno
               || ''', 700, 700);">'
               || '<img src='
               || '"#WORKSPACE_IMAGES#go_button.gif">'
               || '</a>'
       END LINK,
       ename, job, hiredate
  FROM emp

The solution for this problem you can find here. Back in 2006 I created a function for generating links. This function can do the following for you:

  • create a link based on a target page you provide, without having to code a full apex link,
  • replace the link with an image if desired,
  • sort the links based on any columns in your source,
  • open the target page in the same window or in a popup window,
  • add a request to your link,
  • reset pagination if required,
  • add a checksum to your link.

At the end, your query looks much better if you use that function:

Code: [Select]
          WHEN deptno = 10
             THEN return_link_fn (p_page         => 500,
                                  p_item         => 'P500_DEPTNO',
                                  p_value        => deptno,
                                  p_image_n      => 'gobut.gif'
          WHEN deptno = 20
             THEN return_link_fn (p_page         => 501,
                                  p_item         => 'P501_DEPTNO',
                                  p_value        => deptno,
                                  p_image_n      => 'go_search.gif'
             ELSE return_link_fn (p_page         => 502,
                                  p_item         => 'P502_DEPTNO',
                                  p_value        => deptno,
                                  p_image_n      => 'go_button.gif'
       END LINK,
       ename, job, hiredate
  FROM emp

PSOUG / Oracle Lawsuit Against SAP Delayed Until 2010
« on: June 02, 2009, 08:21:58 AM »

FRANKFURT -(Dow Jones)- The trial in Oracle Corp.'s (ORCL) lawsuit against German software company SAP AG (SAP) over SAP's former subsidiary TomorrowNow has again been postponed to Nov. 1, 2010, according to a court document posted on a Web site run by SAP.

The trial was originally scheduled to be heard by a U.S. district court in San Francisco in February 2010, but in May the two companies asked to have the start of litigation postponed until June 2010.

U.S. software firm Oracle brought a lawsuit against SAP in March 2007, alleging that TomorrowNow Inc., which SAP bought in 2005, illegally obtained and reused Oracle software-support documentation.

SAP has already admitted some wrongdoing by TomorrowNow employees, and SAP shut down TomorrowNow in October 2008.

PSOUG / OAUG (Oracle Applications Users Group) News
« on: May 13, 2009, 08:28:16 AM »
President’s Corner

2009 OAUG President Ray Payne

COLLABORATE 09: Technology and Applications Forum for the Oracle Community was, once again, a big success, bringing attendees an intensive and relevant learning experience. I was very pleased to hear from many attendees that the education sessions, executive presentations, hands-on labs and conversations with peers were invaluable and sure to translate into immediate and positive contributions back on the job — so critical as demands continue to grow while resources dwindle.

I also heard that it was a challenge for conference attendees to choose from the many, many excellent sessions presented at COLLABORATE — too many choices, not enough time. But it’s not too late to catch a session that you may have missed or share your favorite session with a colleague. And, if you were unable to attend the conference, the OAUG is making it possible for COLLABORATE 09 to come to you. How?

    * New this year, we recorded 150 hours of content from the COLLABORATE 09 — OAUG Forum. These recordings will be available for purchase in the next few weeks. You will have the flexibility to select a single session or create a customized learning package.
    * In addition, hundreds of informative papers from the COLLABORATE 09 — OAUG Forum will soon be available, free to OAUG members. We anticipate that the papers will be available for download before the end of June.

Watch for announcements about the availability of the COLLABORATE 09 conference papers and audio recordings.

Providing relevant, high-quality educational opportunities and resources for members is one of the cornerstones of the OAUG’s mission. We hope you find the conference papers and recorded sessions useful additions to your learning and development tool kit.

Let us hear from you. What did you like about COLLABORATE 09? What can we do better? The conference survey is open through Friday, May 22. Please take 10 minutes to share your opinions, which are important to us as we plan for COLLABORATE 10 and beyond.

For more on the happenings and highlights at COLLABORATE 09, read on in this issue of OAUG eNews.

OAUG Users Community Grows Through Geo/SIG Membership Campaign

Three groups participated in the 2009 Geo/SIG Membership Campaign for OAUG to recruit new OAUG members. We appreciate your participation in this program.

    * Atlanta OAUG, Andrew Snyder, Geo Coordinator
    * Contracts SIG, Chiranjib Sarkar, SIG Coordinator
    * Michigan OAUG, Betty Noel, Geo Coordinator

Thanks to these Geo/SIG groups for a job well done and for their support in expanding the outreach of the OAUG community.

Upcoming Geo/SIG Meetings

    * Process Manufacturing SIG Conference Call
      May 12, 2009
    * ORUG Functional SIG Teleconference
      May 14, 2009
    * British Columbia OAUG
      May 14, 2009
      Victoria, British Columbia, Canada
    * Twin Cities Financial OAUG
      May 21, 2009
      Bloomington, MN
    * Michigan OAUG
      June 3, 2009
      Warren, MI
    * Healthcare Industry Users Group
      Interact 09
      June 7 - 10, 2009
      Scottsdale, AZ
    * New England OAUG
      June 8, 2009
      Worcester, MA
    * Process Manufacturing SIG Conference Call
      June 9, 2009
    * Atlanta OAUG
      June 19, 2009
    * Ohio Valley OAUG
      June 19, 2009
      Wilmington, OH
    * Pittsburgh OAUG
      June 19, 2009
      Washington, PA
    * OTM SIG Conference
      June 21 - 24, 2009
      Philadelphia, PA
    * Southwest Regional OAUG
      July 24, 2009
      Newport Beach, CA
    * Michigan OAUG
      July 27, 2009
      Plymouth, MI

Oracle E-Business Suite Release 12.1 Now Available

Oracle has announced general availability of the Oracle E-Business Suite Release 12.1 to help companies and organizations more effectively compete in today’s economy. This latest release of the Oracle E-Business Suite provides product enhancements across human resources, supply chain management, procurement, projects, master data management, customer relationship management and financials.

PSOUG / Re: Web Service Application
« on: May 13, 2009, 08:17:34 AM »
So you wouldn't do it from inside Oracle within a PL/SQL-Package working as a daemon (would run once a day for two hours - I hope)?.
I personally wouldn't do it that way, but you could do it that way if you really wanted to. It's not the ideal way to do this kind of thing, however.

I suppose because of missing Oracle functions handling internet content?
But it would work with HTP, URI...packages?
The reason I wouldn't do it that way is because it's inefficient and it's the wrong tool for the job, in my opinion. Oracle is a database; let the database do what it's good at and use other tools or languages to do all the other stuff. Let the database do the heavy lifting where it excels, and don't waste its time or resources doing stuff it's not suited for. Oracle is a great database, but it's not the best tool to do text processing, remote content retrieval, or inline data reformatting. That's where I'd use something like PHP.

On the other side, with PHP + AppServer I would have another two instances to be maintained. And a problem, I don't speak PHP yet.
In general, PHP doesn't require any ongoing maintenance once it''s installed. It just runs.

A number of people here are fairly proficient in PHP, so feel free to ask for help if you need it. We may also be able to come up with some sample code for you if you can give us an idea of what you want to do.

PSOUG / Re: Web Service Application
« on: May 13, 2009, 05:51:43 AM »
It depends on several factors, such as how often you want to check the site contents for changes. You could easily use PHP and a cron job to retrieve and check the contents every 5 minutes (for example), and then process the retrieved data into the format you need.

PHP has plenty of functions that allow it to talk to an Oracle database directly.

Also, mySQL is typically the database that's used for web services, but if your ISP will install Oracle then you could certainly use it.


I have problem getting the missing information.

Intention: I want to set up a small web service/website using an Oracle database for storing the input information collected by checking other web sites HTML code and using this stored information newly structured as a kind of output information.

What I don't know: can I use PL/SQL programm daemon to check the websites? Is it useful to use PL/SQL or should use another language i. e. java-script, PHP...? Is there any code sample which I could use as basis?


BI Consulting Group Announces Support for Oracle Business Intelligence Applications Release 7.9.6

With the new release of Oracle BI Applications, BI Consulting Group extends its BI solution offering to include Project Analytics and Loyalty Analytics

Minneapolis, MN, May 07, 2009 -- BI Consulting Group today announced that it will be offering expanded professional services expertise based on the newly introduced Oracle Business Intelligence (BI) Applications Release 7.9.6. The new capabilities in Oracle BI Applications Release 7.9.6 surrounding Project Analytics and Loyalty Analytics will provide BI Consulting Group an opportunity to help organizations to manage and execute with greater business insights and agility.

In addition, BI Consulting Group continues to provide services around the enhanced Oracle Human Resource Analytics and Oracle Procurement and Spend Analytics in this latest release of Oracle BI Applications. Oracle Human Resources Analytics introduces new monitoring and reporting capabilities for Recruitment Learning Management and Leave and Absence Analytics to help organizations further improve overall workforce performance and managerial effectiveness. Oracle Procurement and Spend Analytics features enhancements to help purchasing and procurement organizations glean greater insight into spend, supplier performance, and expenses.

"BICG has developed tried and true best practices for implementing all of Oracle BI Applications. These best practices are part of our standard project protocol and have also been incorporated into our BICG University training courses. Our customers are leveraging this knowledge of the Oracle BI Applications to extend intelligence quickly and efficiently throughout their enterprise," said Mike Jelen, Vice President of BICG University, the education arm of BI Consulting Group.

"Oracle Project Analytics is certainly drawing the most excitement of the new and enhanced applications as most organizations in some way shape or form manage projects," said Amy Mayer, President of BI Consulting Group. "The content available in the new Project Analytics is extremely comprehensive allowing you to analyze project costs compared to budgets, project revenues, billings and collections allowing you to drastically reduce the risk and manage projects much more effectively. I see strong interest for this application amongst both Oracle and non-Oracle customers as the content, data models and ETLs can be leveraged no matter the back-end system," continued Mayer.

Oracle BI Applications are complete, pre-built BI solutions that deliver intuitive, role-based intelligence for everyone in an organization – from front-line employees to senior management – that enable better decisions, actions, and business processes. Based on best practices, these solutions enable organizations to gain greater insight and value from a range of data sources and applications including the Oracle E-Business Suite, Oracle’s PeopleSoft Enterprise, Oracle’s Siebel CRM, Oracle’s JD Edwards EnterpriseOne, and third party systems such as SAP.

About Oracle PartnerNetwork
Oracle PartnerNetwork is a global business network of more than 20,000 companies who deliver innovative software solutions based on Oracle software. Through access to Oracle’s premier products, education, technical services, marketing and sales support, the Oracle PartnerNetwork program provides partners with the resources they need to be successful in today’s global economy. Oracle partners are able to offer their customers leading-edge solutions backed by Oracle’s position as the world’s largest enterprise software company. Partners who are able to demonstrate superior product knowledge, technical expertise, and a commitment to doing business with Oracle qualify for the Certified Partner levels.

About BI Consulting Group
BI Consulting Group is a Oracle consulting partner focused exclusively on Oracle Business Intelligence. Service offerings include consulting services, education services, support services as well as product services. BICG's sole focus is Oracle Business Intelligence. BICG’s experience with Oracle Business Intelligence is rooted in the origins of the software suite. Their consultants began using the business intelligence suite of products offered by Minnesota-based nQuire Software in late 1999. Siebel acquired nQuire in 2001, and Oracle acquired Siebel in 2006. The experts at BI Consulting Group have collectively completed over 280 successful implementations of Oracle BI. Along the way, BICG has been honored with Oracle's Most Valuable Partner Award for Business Intelligence and the Oracle Excellence Award for creatively using Oracle Fusion Middleware with Oracle Applications (E-Business Suite, PeopleSoft, Siebel, JD Edwards etc) to create innovative and standards-based technology solutions.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates.

Jeremiah Johnson
BI Consulting Group
Minneapolis, MN

PSOUG / Welcome to the NWOUG Fall Conference!
« on: May 07, 2009, 06:11:52 AM »
Welcome to the NWOUG Fall Conference!

September 15th, 2009

Doubletree Hotel & Executive Meeting Center Portland - Lloyd Center

Lloyd Center Double Tree Hotel

1000 NE Multnomah Street, Portland, Oregon 97232

Mark Sunday, Oracle CIO, will be the Keynote Speaker

This exciting conference will bring the best of Oracle innovation and leadership to the Pacific Northwest!

Do you want to be at the forefront and be recognized as a leader in your field of expertise?

You can become a leader by being a supporter of the event through your presentation or participation in the vendor fair. Consider sponsoring lunch, breakfast or one of the breaks; this is a great way to raise your corporate visibility. Would you like a private “breakout room” to meet with your clients and prospects during the day without having to leave the premises? Let us know what you need so we can make necessary arrangements.

Members want to know what you have to say, and are eager to learn! Be a presenter in one of our Technical, Applications or Vendor tracks.

Presenters who wish to be considered for the Fall Conference must submit a 50 - 75 word abstract of their presentation to The time line and steps for presentation submittal, selection and preparation is as follows:

    *  presentation abstract submission opens NOW!
    *  presentation abstract submission closes: June 15, 2009
    *  presentation abstract selection results communicated: June 26, 2009
    *  full presentation due for conference package preparation: August 31, 2009
    *  presentation at the conference: September 15, 2009

This year, Vendor displays will be at the heart of the event, centrally located in the conference area; in the middle of traffic and the primary focal point of activities. You will have an excellent opportunity to interface with all the attendees. Visit the Vendor’s Corner of our website ( to download exhibit applications and regulations.

Additional information regarding the Fall Conference will soon become available on the NWOUG web site (

Do you want more information or have questions? Contact us at

PSOUG / Sample Classes Now Available In the Online Learning Center
« on: April 23, 2009, 10:14:59 AM »
The full version of the Online Learning Center (OLC)will be available shortly. In the meantime, please feel free to watch these excerpts of classes from Dan Morgan, Dr Steven Lewis, and Joe Celko.

FlashBack Database (Dan Morgan
Instructional video on using FlashBack to return the database to a point in the past using either the SCN (system change number) or a specified time.

FlashBack Drop (Dan Morgan
Instructional video on using FlashBack to recover a dropped table.

FlashBack Query (Dan Morgan)
Instructional video on using FlashBack to run queries against the database at any specific time in the past.

Date Functions Demystified (Dan Morgan)
Instructional video on working with some of the various date functions in Oracle 10g and 11g.

Thinking In Sets (Joe Celko)
The fantastic "Thinking In Sets" lecture by Joe Celko.

Three Programming Tricks (Joe Celko)
Joe Celko's "Three Programming Tricks" lecture.

Intro to Java I (Dr. Steven Lewis)
Instructional video by Dr. Steven Lewis, Java Basics, Part 1.

Intro to Java II (Dr. Steven Lewis)
Instructional video by Dr. Steven Lewis, Java Basics, Part 2.

PSOUG / Re: adding .dbf files to the existing database?
« on: April 20, 2009, 07:31:48 AM »
A couple of suggestions:

Try DBF-to-Oracle, a program to migrate DBase/FoxPro/Clipper (*.dbf) databases to Oracle server.
Available at:

Try using the Oracle Migration Workbench:

"Ask Tom" also has some tips on how to do this:

PSOUG / Re: Need a query
« on: April 20, 2009, 07:22:29 AM »
This is an example of syntax for the GROUP BY clause:

    SELECT column1, column2, ... column_n, aggregate_function (expression)
    FROM tables
    WHERE predicates
    GROUP BY column1, column2, ... column_n;

aggregate_function can be a function such as SUM, COUNT, MIN, or MAX.

Here's an example that uses the COUNT function:

SELECT department, COUNT(*) as "Number of employees"
FROM employees
WHERE salary > 25000
GROUP BY department;

Here's an example that uses the MIN function:

SELECT department, MIN(salary) as "Lowest salary"
FROM employees
GROUP BY department;

Pages: 1 ... 122 123 [124] 125 126 ... 128