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 127
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;

PSOUG / Oracle Buys Sun
« on: April 20, 2009, 06:59:00 AM »
Oracle Buys Sun

Oracle Corporation (NASDAQ: ORCL) and Sun Microsystems (NASDAQ: JAVA) announced today they have entered into a definitive agreement under which Oracle will acquire Sun common stock for $9.50 per share in cash. The transaction is valued at approximately $7.4 billion, or $5.6 billion net of Sun's cash and debt.

'We expect this acquisition to be accretive to Oracle's earnings by at least 15 cents on a non-GAAP basis in the first full year after closing. We estimate that the acquired business will contribute over $1.5 billion to Oracle's non-GAAP operating profit in the first year, increasing to over $2 billion in the second year. This would make the Sun acquisition more profitable in per share contribution in the first year than we had planned for the acquisitions of BEA, PeopleSoft and Siebel combined,' said Oracle President Safra Catz.

Register online now for this complimentary event featuring successful grid techniques for the next-generation data center. Or call 1.800.820.5592 ext. 6257.

Master Change: Consolidate, Virtualize, and Standardize Your Data Center

Learn proven grid computing best practices for reaching new levels of efficiency and agility

Join us for a free half-day seminar, Grid Computing: The Next-Generation Data Center. You'll learn best practices for transforming your central IT operations into a high-performance next-generation data center.

Today's data centers must be ready for rapid and unpredictable changes driven by dynamic business demands, market and regulatory pressures, and operational imperatives for green computing and lower costs. At this Grid Computing seminar, we will show you how grid computing pools and provisions groups of networked computers on demand to meet the changing needs of your business. And you will see how multiple applications can share the same computing infrastructure for greater efficiency, agility, availability, and scalability than dedicated servers and storage can provide.

Wednesday, April 29, 2009
8:30 a.m. – 1:15 p.m.

Governor Hotel - Jakes Catering
614 SW 11th Ave
Portland, OR 97205
Map & Directions

Oracle experts and customer success stories will illustrate how you can:

    * Improve efficiency with server clustering, load balancing, and application grid technologies
    * Drive IT agility with on-demand provisioning, automation, and real-time predictive monitoring
    * Boost availability with disaster protection, failover strategies, and quality-of-service management
    * Green your operations with server consolidation, virtualization, and energy-saving best practices

Come meet with your peers and Oracle technology professionals to discuss how grid techniques can transform your business, budget, and timetable. See how grid best practices are helping thousands of customers modernize their operations to create the next-generation data center.

Register online now for this complimentary event. Or call 1.800.820.5592 ext. 6257.


8:30 a.m.    Breakfast and Registration
9:00 a.m.    Oracle Keynote: Grid Techniques for the Next-Generation Data Center
10:00 a.m.    Break
10:15 a.m.    Breakout Session 1: Achieving Agile IT Operations
11:15 a.m.    Breakout Session 2: Ensuring Continuous Availability
12:15 p.m.    Lunch and Demo
1:15 p.m.    Wrap Up and Raffle

Thank you very much. I finally got the procedure to be executed without errors.  However I have a different problem which I will describe after I explain what I am trying to do.
Maybe someone else can chime in on this and give you some ideas; I'm not sure exactly how this might be done.

Code: [Select]
CREATE or REPLACE procedure INPUT_RECORDS(p_ename in varchar2,
p_deptID in number, p_dname in varchar) as
INSERT into emp(ename, deptID)
dept where dname = p_dname);

SQL statement ignored after line 4
ORA 00947 : not enough values

Hmmm, my guess is that although you're telling it to insert both the ename and deptID, you're only supplying the deptID as a value.

PSOUG / Conficker Update: Creating Spam-Spewing Drones?
« on: April 10, 2009, 10:15:45 AM »
By Stefanie Hoffman, ChannelWeb
8:16 PM EDT Thu. Apr. 09, 2009

More than a week after its April 1 deadline, the Conficker C worm released an update that could activate the botnet to deliver spam and turn infected PCs into zombies.

Researchers say that the latest update could include a connection between the Conficker worm to the active spam bot W32.Waledac. Specifically, researchers said they have seen circumstantial evidence that the latest strain of Conficker, known as Downadup E, might drop a Waledac binary on machines infected with Conficker C. That binary is designed to steal information and turn infected PCs into spam-spewing drones under the control of the malware authors, experts say.

Full Article:

Conficker Eye Chart:

PSOUG / RSA Conference: April 20-24, Moscone Center, San Francisco
« on: April 09, 2009, 07:38:52 PM »

RSA Conference 2009

Then RSA® Conference 2009 is your information security event! As the information security field continues to grow in importance and influence, RSA® Conference plays an integral role in educating and connecting security professionals across the globe.

RSA® Conference 2009 offers enterprise and technical professionals one-stop learning. With targeted classroom sessions, innovative and interactive programs, provocative keynotes and a solutions-filled expo hall, RSA® Conference 2009 is the unbiased third party resource information security professionals rely upon.

Don’t miss events include the First-Time Attendee Orientation, Welcome Reception, "Table for 6" Dinners and topic-driven Peer2Peer Sessions to the renowned RSA® Conference Codebreakers Bash - among many others.

PSOUG / Enterprise Manager 10gR5 Released
« on: April 09, 2009, 05:00:30 PM »
Enterprise Manager 10g Release 5 Now Available

Lower cost with faster performance diagnostics and tighter integration with Oracle Applications and Oracle Fusion Middleware

Oracle Enterprise Manager's unique top-down approach to application management enables customers to reduce complexity and increase efficiencies in their IT environments and optimally run their enterprise applications. Oracle Enterprise Manager achieves this through an unrivaled blend of broad application management and quality assurance solutions with deep management solutions for Oracle technologies including Oracle packaged applications, Oracle Fusion Middleware, Oracle Database and Oracle VM.

"Customers are battling economic conditions that require a rigorous focus on delivering business operations and IT efficiencies at a lower cost," said Richard Sarwal, Oracle senior vice president Product Development. "Oracle Enterprise Manager supports both endeavors through automated management of business workflows, processes and services, as well as supporting the full Oracle software stack through its unique top-down application management approach."

    * Watch the first video OTN TechCast with Justin Kestelyn, Richard Sarwal, and Leng Tan
    * Watch the announcement Webcast on demand
    * Learn more about Oracle Enterprise Manager 10g Release 5

COLLABORATE 09 to Feature Educational Sessions from BI Consulting Group
Collaborate is the Technology and Applications Forum for the Oracle Community in Orlando

Added: 04/06/2009 - Jeremiah Johnson

Orlando, FL, USA, April 06, 2009 -- For the fourth consecutive year, the Independent Oracle Users Group (IOUG), the Oracle Applications Users Group (OAUG) and Quest International Users Group (Quest) join forces to host the leading technology and applications forum for the Oracle community.

BI Consulting Group, Oracle’s premier partner for Oracle Business Intelligence.

BI Consulting Group is a 2009 conference exhibitor and is presenting during two educational sessions during the conference.

At BI Consulting Group’s booth, attendees can:

  • See demonstrations of BICG IMPACT, the data-lineage and impact analysis tool for OBIEE.
  • See demonstrations of IDENTITY, BICG’s comprehensive branding & customization service for OBIEE interfaces.
  • Speak with members of BICG leadership who can provide insight into all BICG’s service offerings and share their thoughts on all things related to Oracle Business Intelligence.
  • Learn more about UGOBI. BICG is a proud sponsor of the User Group for Oracle Business Intelligence (UGOBI).

BI Consulting Group is conducting the following educational sessions:

Bulletproof Single Sign-On (SSO) for OBIEE. Monday, May 4 at 3:45pm. Room 1128.
Buy vs. Build - What's The Real Value of Pre-Built BI Analytic Applications?. Wednesday, May 6 at 11am. Room 1129.

May 3-7, 2009

BI Consulting Group Exhibit: Booth # 4358
Orange County Convention Center West, Orlando, Florida, USA

About Bi Consulting Group

BI Consulting Group is Oracle's premier 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. Our experience with OBIEE is rooted in the origins of the software. Our consultants began using the business intelligence suite of products offered by Minnesota-based nQuire Software in late 1999. Siebel aquired nQuire in 2001, and Oracle aquired 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. For further information about BICG, visit


COLLABORATE 09 is designed to help users of the full family of Oracle business applications and database technologies gain greater value from their Oracle investments. Created by and for users, COLLABORATE 09 offers an expert blend of customer-to-customer interaction and insights from technology visionaries and Oracle strategists. Representation at COLLABORATE 09 will include Oracle users, solution providers, consultants, developers and representatives from Oracle Corporation.

Jeremiah Johnson
Sr. Marketing Manager
BI Consulting Group
Orlando, FL

PSOUG / Re: Still curious about what really happened
« on: April 02, 2009, 10:06:42 AM »
We are out of state as well and would be interested in some affordable distance-learning. Please update this forum if you have any further details.
Thank you for your interest; we certainly will update this as things develop.

Lol, April Fools!  ;D

PSOUG / Re: Still curious about what really happened
« on: March 30, 2009, 12:41:59 PM »
Yes, actually I asked my question because I read that blurb.   ;)
Well, there you have it. We're not sure what else to say, but if there's anything else you want to know, please ask.

To be honest, I am out of state (way out of state). I really was excited about the Boot Camp ideas and was hoping to bring some of that more local (ie, perhaps Niemiec's Chicago-based MOUG).
Well, perhaps MOUG members might be interested in some distance-learning, like what we'll be offering through the OLC. I mentioned they have some good courses up now and they'll be adding more shortly which we'll probably mirror (possibly at a reduced cost). We're still working out the details but it's going to happen.

We will also likely be offering some Boot Camp courses here at a local vendor's site, and the possibility exists that we would have instructors have courses at other interested user groups as well. Stay tuned, there's lots of stuff in the works. :)

PSOUG / Re: Still curious about what really happened
« on: March 30, 2009, 11:16:27 AM »
In the interests of telling the whole truth without lying, disparaging, casting libel, disambiguity, etc, what really happened? =) So Mr. Dan Morgan left to pursue his own interests; great, fine.
A short explanation can be found on the PSOUG News page.

For example, Dan seemed to have been the spokesperson for the PSOUG Online initiative. Although he had a schedule and was taking orders, now I see that the Online Learning Center is suddenly dark ("coming soon"). When is "coming soon"?
We hope to have a number of the video-based courses available within a week or so, in cooperation with These will include courses by Dan Morgan, Joe Celko, Steven Lewis, PhD, and others.

What happened to the previous schedule? For those of us who registered for classes, is anything going on next week, or is the whole thing canned?
To be honest, we don't know. We're not involved with Mr Morgan's current activities and can't speak for him or what he intends to do.

Again, I am not interested in the dirty details, nor the politics of why things happened. I am more curious about what the future of PSOUG looks like, specifically things like the famed DBA Boot Camp. Obviously, Mr. Morgan will still be heavily involved in his own efforts - I cannot help but to wonder what PSOUG's role will be.
We'll be re-forming the User Group for the Seattle/Pacific Northwest area, and there's a post detailing that here: Oracle User Group.

We intend to pick up where the PSOUG user group left off and support the Oracle community in ways that the old PSOUG never did. For example, job placement assistance, regular meetings, mentoring programs, code exchanges, networking, etc.

As we re-form the User Group, we'll be looking for a number of people to help make it happen by taking on key leadership roles (President, VP, Chairpersons, Membership Directors, etc).

We don't want to continue the past policies that included a somewhat haphazard schedule and a rather loosely-coupled management style. Our goal would be to have a group of Oracle professionals who see the value in a well-respected User Group, the way PSOUG was a year or so ago.

The key thing to keep in mind is that this sort of thing doesn't happen in a vacuum- we want to hear from people who would like to take an active role in the User Group. If this is something that you're interested in seeing happen, PM us and let us know, or discuss it here. We'd love to see some discussion about this and find out if there's a desire for this and a willingness to make it happen. It's not hard, but it will take some people to make it happen. Those people will share in the benefits of the group at every level.

Let us make it clear: The PSOUG site is going to grow and expand, including its reach and services. We sincerely want to support the Oracle community.

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