Split List in to Multi-Column

2010-03-04 14:03:49
Ooops, this turning out be an example needed for each query i get.

Neway, i enjoy answering them.

Consider this request, you have list, but you dont want to put in one below other.

Rather, 4 in a row, or consider X in a row and rest X of them in next line and goes on.

You can do it in many ways.
First simple one would be have multiple for-each stmt's in each column.
Add a filter on mod, 1,... [read more]

Split into multi-column

2010-03-04 14:03:09
Ooops, this turning out be an example needed for each query i get.

Neway, i enjoy answering them.

Consider this request, you have list, but you dont want to put in one below other.

Rather, 4 in a row, or consider X in a row and rest X of them in next line and goes on.

You can do it in many ways.
First simple one would be have multiple for-each stmt's in each column.
Add a filter on mod, 1,... [read more]

How to build Excel Dashboards – 12

2010-03-04 13:26:58
Previous – Excel Dashboard Tutorial – 11 How do you share your Excel Dashboard with users? Now that you have built the dashboard, you can share the dashboard in multiple ways. ” &l... [read more]

Design:: It’s a WhatchaMCallIt?

2010-03-04 13:14:57
whatchamcallit1That’s right its a WhatchaMCallIt… Yes, yes wier... [read more]

There’s No Pop Left In Big Bang

2010-03-04 13:07:03
I have the opportunity to hear from lots of people in the ERP business: customers, ERP software vendors, service providers, consultants…the list goes on. All interesting people with interesting views on marketplace trends. Many of them are continually asking the same question: “When do you think the ERP implementation market is comi... [read more]

Deloitte Comments on SEC IFRS Announcement & Upcoming Webcast

2010-03-04 12:51:03
Regarding the SEC announcement on the IFRS roadmap on Feb 24, 2010, Deloitte recently released its comments in its Heads Up document:

"SEC Publishes Work Plan for Moving Forward With IFRSs for U.S. Issuers"
. This Heads Up provides: A brief background of the SEC's 2... [read more]

How to build Excel Dashboards – 11

2010-03-04 12:25:02
Previous – Excel Dashboard Tutorial Sales Dashboard using Excel Summary We buil... [read more]

Hinting Dynamic Generated SQL in Application Engine

2010-03-04 12:22:00
One of the clever things you can do in Application Engine is dynamically generate parts of a SQL statement.  However, this can produce challenges should decide that you also need to add an optimiser hint to a SQL statement.  In this post I want to demonstrate how you can also use the same techniques to dynamically generate valid Optimizer hints.

The following statement was generated by a step in a delivered Application Engine that had not been previous... [read more]

How to build Excel Dashboards – 10

2010-03-04 12:17:20
Previous – Excel Dashboard Tutorial – 9 Cleanup – Resize and Organize Give appropriate names to each portlet.
During the chart creation if we did not provide names, now is the time to provide them.
Right click on each title and click on “Edit” ... [read more]

Java Memory Management

2010-03-04 12:13:08
When writing programs it’s always good to know what’s happing in the core of the Framework you’re using. This allow you to get a better idea why things happen in a certain way or what to do in case you receive an error.

So if you’re a java programmer a good thing to read is this paper on memory management in the Virtual machine. It h... [read more]

How to build Excel Dashboards – 9

2010-03-04 12:04:25
Previous – Excel Dashboard Tutorial – 8 Finish the Dashboard Design and Development By now, your dashboard is quite chaotic. You have objects all around your dashboard canvas with different sizes. We will st... [read more]

Andrew Dunstan: XSLT working properly in Postgres at last

2010-03-04 11:21:48
Productive as ever, Tom Lane seems to have taken a break from making his head hurt on replication issues, and instead fixed some long-standing problems we've had with the xml2 contrib module's memory management. My small contribution was to get it building correctly on Windows.

This means (among other things) that we can now use xslt_process to transform XML in various useful ways. Examples could include generating HTML (or XHTML) from it, or preparing XSL-... [read more]

Overview Java Web Frameworks

2010-03-04 11:14:52
This week I came across a good overview of Java Web Frameworks:
... [read more]

Real Time SQL Monitoring, A Goodie Of 11g….

2010-03-04 11:08:48
Oracle’s newest database release 11g is having lots of goodies stored in it. Since now even the release 2 of it, (11.2.0.1) is also out, the number of goodies has just gone more higher! There are some things which are really very nice and are worth checking at least for once. This post is just about one of those goodies. The idea of this post is not about a new invention but about the introduction a worth-to-know kind of feature introduced with the Oracle 11g. Interes... [read more]

Use Oracle BI to Improve Project Performance with Primavera P6 EPPM

2010-03-04 11:03:44
One of the best ways to drive performance of your projects in your organization is to publish the latest reports, trends, analysis and results on an internal website for your stakeholders, PMO and team members. One of the best ways that we have seen to do this since our acquisition by Oracle in 2008 is to publish your project portfolio data through Oracle BI (OBIEE) so that you do not require folks to log into a P6 client in order to gain visibility into... [read more]

Monitoring session for an Web Application in Weblogic

2010-03-04 11:01:27
Make sure you have the following entry in weblogic.xml.   <container-descriptor>    <session-monitoring-enabled>true</session-monitoring-enabled>  </container-descriptor>
The above entry enable the respective MBean in weblogic. You can override it i... [read more]

APEX 4.0 EA2 - Websheets

2010-03-04 10:35:00
In APEX 4.0 EA2 the Websheet functionality is enabled. Websheets allow you to share information with others in a very quick, user friendly and secure way.

Let's have a look at an example. If you go to Application Builder in APEX 4.0 there is a new type there called "Websheet Applications".

... [read more]

SQL Server 2

2010-03-04 10:21:26
Following on from my posting about the presentation (about Enterprise databases) that I did at a Microsoft event on SQL Server 2008, I’ve just had an article on how to design efficient SQL published on a website that’s strongly biased towards SQL Server developers – using an example of SQL written in the SQL Server dialect. It’s [...] ... [read more]

SQL Server 2

2010-03-04 10:21:26
Following on from my posting about the presentation (about Enterprise databases) that I did at a Microsoft event on SQL Server 2008, I’ve just had an article on how to design efficient SQL published on a website that’s strongly biased towards SQL Server developers – using an example of SQL written in the SQL Server dialect. It’s [...]... [read more]

Escaping wildcard searches

2010-03-04 10:17:00
What if the character you want to search for is one of Oracle's wildcards?
&... [read more]

Apex 4.0 - no more dummy branches required

2010-03-04 10:00:47
How many times do you see this error page while building an Apex page?ERR-1777: Page 1 provided no page to branch to.Please report this error to your application administrator.To avoid that, I have a habit of creating an unconditional branch back to the same page in every page I build, with a sequence number higher than all the conditional branches. If I then add new conditional branches I have ... [read more]

Data Warehousing, ODTUG and the World Cup

2010-03-04 09:24:00
It happens every four years and it happens when ODTUG is a guest in Washington DC. What is the fuss about, the FIFA World Cup is coming to ODTUG and so is data warehousing... The world cup of course starts on June 11 in South Africa, ODTUG starts on June 27 in Washington DC. The noise in the stadiums in South Africa will be deafening because of the many Vuzuvelas that will be tooted ove... [read more]

Don’t Assume – Transactions

2010-03-04 09:01:50
MySQL by default is a NON transactional database. For the hobbyist (See The Hobbyist and the Professional), startup entrepreneur and website developer this may not appear foreign, however to the seasoned Oracle DBA who has only used Oracle the concept is very foreign. In MySQL you have to be concerned with two situations that will catch the unprepared out. The first is the default autocommit mo... [read more]

links for 2010-03-04

2010-03-04 09:01:19
Event: Oracle at OpenFabrics Alliance (OFA) International Sonoma Workshop Oracle Session: "Infiniband- Enabling Massively Scalable Database" by Tim Shelter (VP Oracle Product Management), Monday March 15, 2010 at 8:30 a.m.... [read more]

How to build Excel Dashboards – 8

2010-03-04 08:56:13
Previous – Excel Dashboard Tutorial – 7 Create Pie Chart We will now create a pie chart by product name Image   ... [read more]

'Io exception: NL Exception was generated' running IRCA

2010-03-04 08:34:16
Shahed pinged me about this during SOA installation:

$ sh irca.sh
Integration Repository Creation Assistant (IRCA) 10.1.3.1.0
(c) Copyright 2006 Oracle Corporation. All rights reserved.

Enter database "host port serviceName" [localhost 1521 orcl]: justanexample 1521 soa11g
Enter sys password:
Running IRCA for all product(s):
connection="justanexample 1521 soa11g", , orabpelUser=ORABPEL, esbUser=ORAES... [read more]

Absent Code attribute in method that is not native or abstract

2010-03-04 08:11:03
I ran into the following problem yesterday while building a rest service using resteasy: the code would compile ok, but the unit tests wouldn’t run. I got the following exception in the output of the unit tests: java.lang.ClassFormatError: Absent Code attribute in method that is not native or abstract in class file javax/ws/rs/ext/RuntimeD... [read more]

How many fsync / sec FusionIO can handle

2010-03-04 08:09:44
I recently was asked how many fsync / sec ( and therefore durable transactions / sec) we can get on FusionIO card. It should be easy to test, let's take sysbench fileio benchmark and run, the next command should make it:
./sysbench --test=fileio --file-num=1 --file-total-size=50G --file-fsync-all=on --file-test-mode=seqrewr --max-time=100 --file-block-size=4096 --max-requests=0 run
... [read more]

Evidence Based Medicine - Textual ETL Makes It Possible

2010-03-04 08:05:54
I have been researching on this subject for the past few months. It is becoming clear that to control errors in diagnosis and treatment of medical conditions, Evidence Based Medicine can be defined as "the conscientious, explicit and judicious use of current best evidence in making decisions about the care of the individual patient. It means integrating individual clinical expertise with the best available ext... [read more]

HUGmn techday2010 - March 11 in Minneapolis

2010-03-04 07:46:28
I will be presenting next week at the Hyperion User Group - Minnesota 'TechDay 2010' event next week in Minneapolis.  The user group has lined up a number of great speakers including fellow Oracle ACE Directors Edward Roske from interRel Consulting and Eric Helmer from The Hackett Group.  Oracle Essbase product managers Alan Lee and Karen Zubetz and HFM product manager Mike Malwitz will also be doing presentations along with a number of other consultants.&n... [read more]

Issues in WebLogic Portal integration with Oracle Entitlement Server

2010-03-04 07:17:21
In previous posts I have specified the supported and working WebLogic JDK versions for Oracle Entitlement Server. I have tested protecting the WebLogic Server application where OES Admin is installed on WLS 10.3.1 and it went fine. However, when I used WLS 10.3.1 for Admin server and tried to install the WebLogic Portal sample application (SimplePortalExample present in ales32-ssm/wls-ssm/examples) , I am stuck... [read more]

Dan Langille: PGCon 2010 - schedule

2010-03-04 06:17:49
The PGCon 2010 schedule has been announced. Have a read of our outstanding lineup, see where people come from to PGCon, and get your registration started.... [read more]

Why Doesn’t this Trigger Code Work?

2010-03-04 06:00:06
March 4, 2010 A couple of days ago I received an interesting email from an ERP mailing list.  That email contained an Oracle trigger that looked like it would be helpful, but the author of the trigger was struggling a bit with the PL/SQL code and asked for some assistance with the trigger code.  The trigger code contained in the email looked like this: CREATE OR REPLACE ... [read more]

SMS Coupons

2010-03-04 05:49:35
I text on my phone on rare occasions, usually when I need an immediate response like, "where are you?" It seems like a crude way to do advertising, unless its contextual as in the case of Placecast and the like. But its one advantage is that every mobile phone supports SMS/texting, so it has maximum customer reach. <... [read more]

Live RAC SIG Web-cast Today: Oracle ASM 11g — The Evolution

2010-03-04 05:38:23
Just a quick announcements… If you didn’t manage to attend my presentation, Oracle 11g ASM — The Evolution, during RMOUG or other conferences, you have a chance to see it online today. I’m doing it a ... [read more]

Live RAC SIG Web-cast Today: Oracle ASM 11g — The Evolution

2010-03-04 05:38:23
Just a quick announcements… If you didn’t manage to attend my presentation, Oracle 11g ASM — The Evolution, during RMOUG or other conferences, you have a chance to see it online today. I’m doing it a ... [read more]

Design:: It’s a WhatchaMCallIt?

2010-03-04 05:14:57
whatchamcallit1That’s right its a WhatchaMCallIt… Yes, yes wierd random blog post - I was playing with photoshop last night and randomly ... [read more]

Predictions from Financial Executives

2010-03-04 05:00:00
I read something this week that merits sharing and reinforces why business performance management is so critical during challenging economic times. In February of this year, a poll - the Business Volatility and Variables Survey - was conducted by Adaptive Planning and the Business Performance Management Forum. Financial executives were polled, and here are some of the survey findings.

Fifty-one percent of these financial executives predic... [read more]

The NoSQL That Must Not Be Named!

2010-03-04 04:00:03
I would have named it the DB Horcrux. Think about it.... [read more]

The NoSQL That Must Not Be Named!

2010-03-04 04:00:03
I would have named it the DB Horcrux. Think about it. ... [read more]

The NoSQL That Must Not Be Named!

2010-03-04 04:00:03
I would have named it the DB Horcrux. Think about it.... [read more]

APEX 4.0 EA2 - Websheets

2010-03-04 03:27:05
In APEX 4.0 EA2 the Websheet functionality is enabled. Websheets allow you to share information with others in a very quick, user friendly and secure way.

Let's have a look at an example. If you go to Application Builder in APEX 4.0 there is a new type there called "Websheet Applications".

... [read more]

Overview Java Web Frameworks

2010-03-04 03:14:52
This week I came across a good overview of Java Web Frameworks:
... [read more]

Congratulations Amy on an outstanding TEDTalk

2010-03-04 02:33:07
While I didn’t get to go to the talk I did get to hear people raving to Amy about how i... [read more]
 1 2 3 4 5 6 >>  Last › Total pages: 2814