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 ... 121 122 [123] 124 125 126
1831
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]
SELECT CASE
          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]
SELECT CASE
          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

1832
PSOUG / Oracle Lawsuit Against SAP Delayed Until 2010
« on: June 02, 2009, 08:21:58 AM »
http://money.cnn.com/news/newsfeeds/articles/djf500/200906020738DOWJONESDJONLINE000239_FORTUNE5.htm

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.

1833
PSOUG / OAUG (Oracle Applications Users Group) News
« on: May 13, 2009, 08:28:16 AM »
OAUG News
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.

1834
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.

1835
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.




Hi,

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?

Martin



1836
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.
http://oraclepartnernetwork.oracle.com

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. http://www.biconsultinggroup.com

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

Contact:
Jeremiah Johnson
BI Consulting Group
Minneapolis, MN
866-953-4757
jeremiah.johnson@biconsultinggroup.com
http://www.biconsultinggroup.com

1837
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
503-281-6111

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 chair@nwoug.org. 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 (http://www.nwoug.org) to download exhibit applications and regulations.

Additional information regarding the Fall Conference will soon become available on the NWOUG web site (http://www.nwoug.org).

Do you want more information or have questions? Contact us at chair@nwoug.org.

1838
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.

1839
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: http://www.convert-in.com/dbf2ora.htm


Try using the Oracle Migration Workbench:
http://www.oracle.com/technology/tech/migration/workbench/index.html


"Ask Tom" also has some tips on how to do this:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:711825134415

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

1841
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.

1842
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
+1.503.224.3400
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.

Agenda:

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

1843
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.

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

Errors
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.

1845
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: http://www.crn.com/security/216500197

Conficker Eye Chart:
http://www.confickerworkinggroup.org/infection_test/cfeyechart.html


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