Recent Posts

Pages: 1 ... 5 6 [7] 8 9 10
61
Oracle News / Ask Tom: On Table Updates and SQL Plan Baselines
« Last post by Mike on July 07, 2014, 10:30:27 AM »
Ask Tom: On Table Updates and SQL Plan Baselines
26 June 2014, 3:16 pm

Our technologist--Tom Kyte--updates tables quickly via CTAS and optimizes queries for evolution.

Source: Oracle Magazine - Most Recent

62
Oracle News / From the Editor: The Cloud OS
« Last post by Mike on July 07, 2014, 10:30:27 AM »
From the Editor: The Cloud OS
30 June 2014, 12:52 pm

In cloud computing, the OS is more important than ever.

Source: Oracle Magazine - Most Recent

63
Oracle News / DBA: Managing Expressly
« Last post by Mike on July 07, 2014, 10:30:27 AM »
DBA: Managing Expressly
2 July 2014, 3:46 pm

Manage Oracle Database 12c with Oracle Enterprise Manager Database Express, a built-in browser-based graphical tool.

Source: Oracle Magazine - Most Recent

64
Oracle News / Interview: Big Data Integration
« Last post by Mike on July 07, 2014, 10:30:27 AM »
Interview: Big Data Integration
3 July 2014, 3:35 am

As NoSQL technology evolves, Oracle NoSQL Database 3.0 gets more involved in big data strategies and deployments. Dave Segleau, director of product management at Oracle, talks about the state of NoSQL, NoSQL use cases, and key features in Oracle NoSQL Database 3.0.

Source: Oracle Magazine - Most Recent

65
PSOUG / Re: Where are XSL files to be stored?
« Last post by SMerrill8 on June 23, 2014, 01:49:51 PM »
Thank you Mike - I already found those pages, but I don't have Oracle Business Intelligence Publisher or Oracle JDeveloper at my disposal.  I only have Oracle SQL Developer and Visual Studio 2010 with Oracle Developer Tools for Visual Studio (ODT) installed.

I'm looking for the simplest solution - hand-coded.
66
PSOUG / Re: Where are XSL files to be stored?
« Last post by Mike on June 23, 2014, 01:43:19 PM »
I don't know if this is of any help, but a quick google search found this:

http://docs.oracle.com/cd/E38689_01/pt853pbr0/eng/pt/tibr/task_DevelopingTransformsUsingOracleXSLMapper-0762e1.html

Also this page shows some info as well:

http://docs.oracle.com/cd/E23943_01/bi.1111/e22254/design_xsl_sub.htm

14.4.1 Importing the Subtemplate

Enter the import command anywhere in the main template prior to the call template command as follows:

<?import:xdoxsl:///{path to subtemplate.xsb}?> 
where
path to subtemplate.xsb is the path to the subtemplate .xsb object in the catalog.

For example:

<?import:xdoxsl:///Executive/Financial Reports/mySubtemplate.xsb?> 
67
PSOUG / Where are XSL files to be stored?
« Last post by SMerrill8 on June 23, 2014, 01:34:37 PM »
I would like to program an Oracle 11g stored procedure to mail-merge and transmit html e-mails to our clients.

However, the XSL code I have written is necessarily larger than 4000 characters so I think it must be stored in a file.

At my company, I am a Developer, not a DBA.  so I need to request of our DBA team to upload my XSL file to someplace on the server such that the stored procedure may see the file and use the content.

I will then try to find code on the web someplace which does the transform from XML to HTML.

This is a medium-volume mailing.

What do I tell my DBA team to do?
68
PSOUG / Re: ORA-01422: exact fetch returns more than requested number of rows
« Last post by Mike on June 17, 2014, 01:37:57 PM »
Thank you, Prakash!

We've added this information into the error code listing for the ORA-01422 error.
69
PSOUG / Re: ORA-01422: exact fetch returns more than requested number of rows
« Last post by Prakash on June 17, 2014, 09:21:00 AM »
In addition to above details to this error/exception:

ORA-01422: exact fetch returns more than requested number of rows

By default, a SELECT INTO statement must return only one row. Otherwise, PL/SQL raises the predefined exception TOO_MANY_ROWS and the values of the variables in the INTO clause are undefined. Make sure your WHERE clause is specific enough to only match one row

If no rows are returned, PL/SQL raises NO_DATA_FOUND. You can guard against this exception by selecting the result of an aggregate function, such as COUNT  or AVG(), where practical. These functions are guaranteed to return a single value, even if no rows match the condition.
70
PSOUG / Scholarship offering for Women Technology students in Puget Sound
« Last post by RSmithBothell on May 07, 2014, 05:30:16 PM »
The Association of Women in Computing, Puget Sound chapter annually offers two $1000 scholarships to two women attending school full time and pursuing a computing-related degree.

I'm the Scholarship director and the contact for this offering.  I'm also a member of this group and wanted to share this because I know that some of us might have an eligible daughter in school in the area.

If you have any questions please reply to this posting and I'll be notified.

This URL to follow includes www (dot) awcps (dot) org (slash) scholarships, has all the info needed for a student to find out more, and how to apply.


Thank you!

R. Smith
Scholarship Director
Pages: 1 ... 5 6 [7] 8 9 10