Recent Posts

Pages: 1 ... 6 7 [8] 9 10
71
Oracle News / Database Cloud: Many in One
« Last post by Mike on October 03, 2013, 05:01:40 PM »
Database Cloud: Many in One
3 October 2013, 3:24 pm

Create many databases in one database instance with the Oracle Database 12c multitenant architecture.

Source: Oracle Magazine - Most Recent

72
PSOUG / exact fetch returns more than requested number of rows
« Last post by Prakash on October 03, 2013, 01:49:11 PM »

-- Example to show error message - "exact fetch returns more than requested number of rows"
Code: [Select]
DECLARE
   x   DUAL.dummy%TYPE;
BEGIN
   SELECT dummy
     INTO x
     FROM DUAL, (SELECT * FROM all_users);
END;

--Solution to correct this is by fetching rows that can be accommodated into the catching variable.
Code: [Select]
DECLARE
   x   DUAL.dummy%TYPE;
BEGIN
   SELECT dummy
     INTO x
     FROM DUAL;
   -- SELECT * FROM all_users; --Can't do this here
END;

-- This error occurs when more number of rows are retrieved and being assigned to a variable
-- that can hold only one single value. You need to retrieve only row(s) that can be held in the
-- catching variable
73
Oracle News / Mash Up
« Last post by Mike on October 02, 2013, 05:04:05 PM »
Mash Up
2 October 2013, 12:17 pm

Get bite-size information on gadgets, apps, and books.

Source: Oracle Magazine - Most Recent

74
Oracle News / Feature: Faster
« Last post by Mike on September 30, 2013, 05:02:48 PM »
Feature: Faster
30 September 2013, 11:44 am

ORACLE TEAM USA uses Oracle technology to deliver extreme speed in the America's Cup.

Source: Oracle Magazine - Most Recent

75
Oracle News / News: Cloud Computing Breakthrough
« Last post by Mike on September 26, 2013, 05:04:10 PM »
News: Cloud Computing Breakthrough
26 September 2013, 12:00 pm

Oracle unveils new multitenant architecture in Oracle Database 12c.

Source: Oracle Magazine - Most Recent

76
Oracle News / Ask Tom: Oracle Database 12c, Part 1
« Last post by Mike on September 26, 2013, 05:04:10 PM »
Ask Tom: Oracle Database 12c, Part 1
26 September 2013, 12:00 pm

Now that Oracle Database 12c is here, our technologist takes you through some key features: improved defaults, bigger datatypes, and top-N queries.

Source: Oracle Magazine - Most Recent

77
Oracle News / News: Cloud Computing Breakthrough
« Last post by Mike on September 26, 2013, 05:04:10 PM »
News: Cloud Computing Breakthrough
26 September 2013, 12:00 pm

Oracle unveils new multitenant architecture in Oracle Database 12c.

Source: Oracle Magazine - Most Recent

78
Oracle News / Ask Tom: Oracle Database 12c, Part 1
« Last post by Mike on September 26, 2013, 05:04:09 PM »
Ask Tom: Oracle Database 12c, Part 1
26 September 2013, 12:00 pm

Now that Oracle Database 12c is here, our technologist takes you through some key features: improved defaults, bigger datatypes, and top-N queries.

Source: Oracle Magazine - Most Recent

79
PSOUG / Re: Date Diff Function Not provided by Oracle- Here is one
« Last post by Mike on September 25, 2013, 07:01:52 PM »
Nice!
80
PSOUG / Re: sf_week_day_order
« Last post by Mike on September 25, 2013, 06:58:02 PM »
Great stuff, Prakash! I'm sure this will come in hand for lots of people. :)

I'll add it to the code library as soon as I get a chance.
Pages: 1 ... 6 7 [8] 9 10