Oracle 12c

warning: Invalid argument supplied for foreach() in /www/oaktable/sites/all/modules/cck/content.module on line 1284.

PL/SQL function in SQL - short example - Oracle 12c

This is my first post about Oracle 12c. When I first time heard about PL/SQL functions inside SQL my first thought was - can I use it in my topaas.sql script to run it in loop ? I decided to give PL/SQL functions in SQL a quick try to and here are my results. My goal was to display results from SQL line by line with small delay. This is a code a decided to use:
SQL> set arraysize 1
SQL> col slow_me noprint
SQL> with function slow_me return number is
2 begin
3 dbms_lock.sleep(1);
4 return 1;
5 end;
6 select level, slow_me() slow_me from dual connect by level < 10;
7 /

LEVEL
----------
1
2
3
4

n/a
marco's picture

Oracle 12c: Database Parameters…

For those in a desperate need to learn all 3351 database parameter variations… x_ksppi.txt …if you break it, then… …please let me remind you some info mentioned on my “About”-page: The content presented has been tested as good as humanly possible. But be warned: always properly test it before you use them yourself… Applying ideas,

Read More...

marco's picture

Oracle 12c: Export by View

A small enhancement, but what a golden nugget! At least that’s what I think. It is now possible in Oracle 12c to export data via a view. I my realm, Oracle XMLDB, that can be an interesting feature to export stored XML content in a relational format and import it, for example, in a relational

Read More...

marco's picture

Oracle 12c: DB Express – Sneak Peek

The new Database Express or DB Express database utility is different from the former DB Console. It is based on flash and “built-in” the database. To give you a small overview (sneak peek) into this great new tool for, for example, database performance tuning, hereby some pictures to create some appetite. I created some have …

Continue reading »

marco's picture

Oracle 12c: Getting Started with DB Express

Oracle DB Express is the new replacement for Oracle DB Console in the Oracle 12c database. Here are some first steps to get started. Oracle DB Express makes use of what is called the “XDB Protocol Server”, which among others supports the Oracle APEX standalone PL/SQL Gateway. For people who are unknown still how to …

Continue reading »

marco's picture

Oracle 12c: Oracle XMLDB is now Mandatory!

Is this one of my highlights? No not really, but it is a remarkable one. Oracle XMLDB functionality is now mandatory and can not be uninstalled. As mentioned in the new feature section of the Oracle XMLDB Developers Guide for Oracle 12c: Oracle XML DB is now a mandatory component of Oracle Database. You cannot …

Continue reading »

marco's picture

OOW 2012 – The yearly AMIS Review from Oracle Open World and JavaOne

Yesterday (16th October), 10 days of the end of the yearly Oracle show in San Francisco, AMIS organized its ‘Review from Oracle Open World 2012′ session with an overview of news, trends, announcements, special finds and interesting rumors . This session was ‘sold out’ (even though it was free). For close to 4 hours, the …

Continue reading »

marco's picture

OOW 2012 – It will be a great Conference…

For me it all started out very stressful. I overslept yesterday, or the day before, and noticed that it already was 08.25 AM. My flight would leave at 09.50, so the rush to the airport was very painful. Seriously hope I won’t have too many speeding tickets in my attempt to checkin somehow anyway on …

Continue reading »

To prevent automated spam submissions leave this field empty.
Syndicate content