Hello, you need to enable JavaScript to use this network.

Please check your browser settings or contact your system administrator.

Oracle Community

The social network for Oracle people

Blog Posts Across Oracle Community

Stew Stryker SQL Injection prevention tutorial

[This isn't specifically about Apex, but definitely applies.] First, if you haven't read about the recently-published SQL exploit vulnerability, you should here: http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9080378&intsrc=hm_list and David's paper on Lateral SQL Injection is available at:… Continue

Posted by Stew Stryker on May 16, 2008 at 10:21am — No Comments

TongucY new bog post - Oracle Database 11g Roadshow and Release 2 Sneak Peek

http://tinyurl.com/4am85n Continue

Posted by TongucY on May 16, 2008 at 9:20am — No Comments

Siba Prasad 11g New Feature: Tablespace Encryption

The Transparent data encryption has got better from a column level to tablespace level. Read about tablespace encryption at my blog - http://tinyurl.com/42kxsz Continue

Posted by Siba Prasad on May 14, 2008 at 2:08am — No Comments

Gokhan TERCAN Gercek ve Gizli Amaç

Eski İskoçya’da “toprak sahipleri”, İngiliz Kralı’na “en ateşli şekilde karşı çıkarlar” ve köylüleri “sözde özgür İskoçya isteyerek” biraraya getirip, meydanlarda “İngiliz Kralı’nın” ordusunun karşısına çıkarırlardı... Savaşa bir saat kala “İngiliz Kralı’ndan”, orduyu oraya toplayan üç-beş isme yönelik “Şu toprakları kendilerine verdim” şeklinde mesaj gelir ve “ordular savaş olmadan dağılırdı.” O kalabalığı, “sözde özgür İskoçya” diye oraya toplayanlar, esas amaçlarına ulaşırlar ve “görünen amaç… Continue

Posted by Gokhan TERCAN on May 14, 2008 at 1:19am — No Comments

TongucY new blog post - Another Support Case Study : OCFS O_DIRECT flag, file system cache and RAC consistency among SGAs

http://tinyurl.com/3tge37 Continue

Posted by TongucY on May 10, 2008 at 1:23pm — No Comments

Stew Stryker Changing your application's Home Page

This was prompted by this question in the Apex forum: http://forums.oracle.com/forums/thread.jspa?messageID=2515201 It takes a few steps to change what you application considers its home page. 1) The home page # is hardwired into the Home Link. Go to Shared Components->Edit Security Attributes. In the Home Link field, change it at: f?p=&APP_ID.:your_home_page and replace the your_home_page… Continue

Posted by Stew Stryker on May 9, 2008 at 12:00pm — No Comments

TongucY new blog post - Data Lifecycle Management; How to find your unused or read only Oracle segments?

http://tinyurl.com/57bhdr Continue

Posted by TongucY on May 6, 2008 at 7:04am — No Comments

Fire-Tiger Panthera Progress

Hi, as usuall, just a little progress info about Panthera Development.

- We're implementing Schema Explorer - an advanced window to all Oracle features.

- Editor, ability to run any scripts, any PL/SQL blogs. Integrated DBMS_Output and very fast data fetching. Ability to see Oracle's LOBs right from the data grid etc.

- Smart DBMS_Output separate window with history.

- In Editor, Implementing various "smart & useful" features such as bookmarks, or… Continue

Posted by Fire-Tiger on May 5, 2008 at 11:00pm — No Comments

TongucY new blog post - Data Guard Redo Apply and Media Recovery Best Practices 10g

http://tinyurl.com/6ctk49 Continue

Posted by TongucY on May 5, 2008 at 1:02am — No Comments

TongucY new blog post - Revisiting data migration best practices for Oracle database

http://tinyurl.com/42gox2 Continue

Posted by TongucY on May 4, 2008 at 1:13am — No Comments

Michael McLaughlin Oracle Database LOBs In-depth

Last month I also presented the Oracle Database LOBs In-depth at the Utah Oracle User’s Group (UTOUG) Training Days. You can find the slides and sample programs here. The presentation includes scripts for uploading LOBs from the file system and across the network via PHP. A quick process for reclaiming lost space from LOBs is… Continue

Posted by Michael McLaughlin on April 28, 2008 at 10:00pm — No Comments

Siba Prasad Metalink getting a new look

Metalink is getting a facelift....Check out at my blog - http://tinyurl.com/6plj9x Continue

Posted by Siba Prasad on April 27, 2008 at 1:40am — No Comments

Jesus Armand Calejero Roman Valencia a la carta - www.citymenus.es -

Hi people!! This post is different that others but I'm happy because a few days ago I finished my work as a web developer. The website is a guide to restaurants in Valencia, Spain. You can visit the website in www.citymenus.es Esto se aleja un poco de mis últimos post en este blog pero es que estoy muy contento por mi último trabajo como desarrollador web. Se trata de una guía de restaurantes en Valencia (España). En ella puedes buscar por tipo de cocina,… Continue

Posted by Jesus Armand Calejero Roman on April 26, 2008 at 7:30am — No Comments

Eduardo Legatti My blog at blogger ... (Brazilian Portuguese)

My blog (pt-br)

Continue

Posted by Eduardo Legatti on April 25, 2008 at 12:30pm — No Comments

TongucY new blog post: Optimizing Oracle by Desing - my impressions after Jonathan Lewis’s three days seminar

http://tinyurl.com/53u4rb Continue

Posted by TongucY on April 24, 2008 at 11:45am — No Comments

Gokhan TERCAN Holistic

The general principle of holism was concisely summarized by Aristotle in the Metaphysics: "The whole is more than the sum of its parts." Continue

Posted by Gokhan TERCAN on April 24, 2008 at 6:50am — No Comments

Leah Purugganan Business Transformation-- Oracle E-Business Release 12 & Oracle Fusion

Hello, I follow the Oracle Networking sites extensively, as I am a Manager of Recruiting Services with Cutter Hinmann, executive search. We are currently engaged with a household brand name company based out of Michigan (beautiful area, I promise!) and assisting in locating key members to join the leadership team full-time, to ultimately play an integral role in the Business Transformation initiative (that is, to drive the "business solution" from a technical point of view.) The Manager of Ora… Continue

Posted by Leah Purugganan on April 23, 2008 at 12:37pm — 1 Comment

Carlos Regalado Oracle Expertise Needed

Hi, I have a client in Los Angeles who would like an assessment done of their environment. Our client is currently running an Oracle custom application that needs to upgrade it system/application. Current environment is Linux, Windows 98 & XP Pro, Oracle. If anyone is open to a part time or after hour’s opportunity please feel free to contact me. Thanks, Carlos Carlos@TenTek.com (949) 477-8070 - Office Continue

Posted by Carlos Regalado on April 22, 2008 at 3:31pm — No Comments

Michael McLaughlin Oracle Database 11g PL/SQL New Features

Last month I presented the Oracle Database 11g PL/SQL New Features at the Utah Oracle User’s Group (UTOUG) Training Days. You can find the slides here. My favorite new feature is that you no longer have to select a sequence into a variable to use it in a SQL statement in a PL/SQL block. Continue

Posted by Michael McLaughlin on April 21, 2008 at 9:35pm — 5 Comments

TongucY new blog post : Event 10046 as a vitamin

http://tinyurl.com/3nu3ne Continue

Posted by TongucY on April 16, 2008 at 5:25am — No Comments

Jesus Armand Calejero Roman Autotrace command

In last entry on my personal blog I talked about the possibility of optimizing our querys with autotrace command. Autotrace offers statement tracing and instant feedback on any successful SELECT, INSERT, UPDATE or DELETE statement. it requires the plustrace or DBA role for the user executing the trace. More information in http://calejero.blogsome.com (spanish) What others strategies do you know? En la última entrada de mi blog personal (que espero q… Continue

Posted by Jesus Armand Calejero Roman on April 13, 2008 at 10:22am — 2 Comments

TongucY new blog post - A DDL tacking application, if CASCADE option of DBMS_STATS needed everytime, ORA_HASH post update and others

http://tinyurl.com/3snqzu Continue

Posted by TongucY on April 13, 2008 at 6:12am — No Comments

Siba Prasad Oracle 11g New Feature: Automatic memory management

Memory management in Oracle 11g is much easier now. After introducing Automatic SGA management in 10g, Oracle has introduced "Automatic Memory Management" in 11g; Now only a single parameter is required to set the memory for the database.Read about automatic memory management in detail on my blog. Continue

Posted by Siba Prasad on April 10, 2008 at 11:40am — No Comments

Jesus Armand Calejero Roman Bitmap y B*-Tree: límites de columna

Hola a todos. Empecé mi andadura en Oracle community preguntando si los límites de columna en los índices de tipo Bitmap y B*-Tree eran 30 y 32 respectivamente ya que en un manual de Oracle 8 lo había leído y no sabía si a día de hoy, al menos en Oracel 10g continuaba siendo así. No tardaron en contestarme (gracias Gerald Venzl) y a demás de confirmarme estos valores me hicieron una gran pregunta: ¿realmente es interesante un índi… Continue

Posted by Jesus Armand Calejero Roman on April 9, 2008 at 9:00am — 1 Comment

Fire-Tiger Panthera Progress

Hi, just a little info about progress on Panthera:
- Multi-Session interface done in 90%. Stable. No bugs found by testing.
- Added effects that will signifinactly improve your performance while working
with more connected session simultaneously.
- SQL Editor performance and optimising issues. Faster data fetching. I will
put here some statistics when I'll make them.
- Starting Procedure Editor - implemented code folding that will help in larger
PL/SQL codes.… Continue

Posted by Fire-Tiger on April 7, 2008 at 11:00pm — No Comments

Siba Prasad 11g New Features - Incident Packaging

Here is the link to my new post on incident packaging using ADR Command Interpreter (ADRCI). Pretty useful tool and a nice addition to 11g. Continue

Posted by Siba Prasad on April 7, 2008 at 6:20am — 1 Comment

Jesus Armand Calejero Roman Hola a todos... los hispano-hablantes

Hola. Buscando en ning comunidades he encontrado esta sobre Oracle. Por ahora no he mirado mucho pero voy a empezar a echarle un vistazo de inmediato. Lo malo es que no esté en español... bueno, nadie es perfecto ;) Aquí iré escribiendo en español (más que en inglés en la plana principla ;) ). En mi blog personal voy colgando presentaciones que hago para la asignatura de Administración de bases de datos. Hay 3: Tablespaces, Tablas e Índices en Oracle. El enlace de mi blog es… Continue

Posted by Jesus Armand Calejero Roman on April 6, 2008 at 6:53am — 2 Comments

TongucY take a visit to Istanbul online

take a visit to Istanbul online http://tinyurl.com/543t2l and see Topkapı Palace with a 360 degree view http://tinyurl.com/4fxe2t :) Continue

Posted by TongucY on April 5, 2008 at 8:32am — 2 Comments

Siba Prasad Oracle 11g New Features - Automatic Diagnostic Repository

Oracle introduced a new framework/structure to keep log/trace files starting 11g. Here is the link to the post on my blog which talks about this feature in detail. Continue

Posted by Siba Prasad on April 4, 2008 at 7:30pm — No Comments

Joon Bautista Oracle Functional Need in Europe!

I am currently looking for Oracle Functional Consultants in Europe with the following expertise. Functional Financials - AP, AR, GL, FA Functional SCM - OM, INV, PO Please contact me by email or by phone! THANKS! Joon Bautista CyberSearch joon.bautista@cybsearch.com 1-773-329-1359 Continue

Posted by Joon Bautista on April 2, 2008 at 11:48am — 1 Comment

Stew Stryker Report with Row Count on Break

I needed to include a count of rows in my report, which breaks by the first field. I found the simple suggestion of how to do this in the forum message: Sum/Count a Non Display Report field in Break . Simply create a column in your query with a value of 1: 1 AS row_cnt... Edit the Report Attributes and check the Sum column. Finally, edit this column's attributes and set the CSS Style to:… Continue

Posted by Stew Stryker on April 1, 2008 at 12:46pm — 2 Comments

David Roberts Latvian Oracle Financials Functional Consultants needed

I have a client who is looking for an Oracle Financials Functional Consultant with experience of implementing in Latvia. Does anyone know someone who has or can suggest a line of enquiry that will help me to identify one? Continue

Posted by David Roberts on April 1, 2008 at 7:26am — No Comments

Jose luis eBusiness Suite

Hi all, I'm newbie with this wide world of blogs... So my idea is to begin with this little web space and be able to share here all our experiences, knowledgments and questions about Oracle eBusiness Suite world and of course about Oracle Developer in all of their faces, not only for technical issues ... So anyone who wants to participate, and write here is wellcome. Continue

Posted by Jose luis on April 1, 2008 at 2:42am — 2 Comments

Siba Prasad Oracle 11g new features - Virtual column

New post about 11g New Feature - Virtual Column; Read it on my blog Continue

Posted by Siba Prasad on April 1, 2008 at 1:00am — No Comments

TongucY MetaLink Outage Planned for Weekend of April 4, 2008

http://tinyurl.com/2hb4hc Continue

Posted by TongucY on March 31, 2008 at 11:48am — No Comments

shoblock What is actually running right now?

Oracle has always supplied tools to show us database activity, but they aren’t always user friendly, or formatted well. In version 5, there was ODS (Oracle Display System?), which showed connect sessions, locks and i/o, and not much more than that. In v6, they gave us the command line utility SQL*DBA, which included a “monitor” section. This section showed sessions, i/o, cpu, and other activity. But it just dumped everything to the screen, with very little options for ordering and filtering (an… Continue

Posted by shoblock on March 31, 2008 at 8:00am — No Comments

TongucY The Facts and Fallacies of Software Engineering

http://tinyurl.com/26zuat Continue

Posted by TongucY on March 26, 2008 at 11:01pm — No Comments

Fire-Tiger Hello

I decided to start this to blog, to let you know about my project's Progress. If you have any ideas feel free to let me know and if you don't know the project I'm working on feel free to take a look to my website at project Panthera. Thanks Continue

Posted by Fire-Tiger on March 26, 2008 at 12:24am — No Comments

Siba Prasad new post - Oracle 11g New Feature Case-sensitive passwords

Read it at my blog => 11g new feature : Case-sensitive passwords Continue

Posted by Siba Prasad on March 25, 2008 at 11:30pm — No Comments

Siba Prasad My Blog

http://dbathoughts.blogspot.com Continue

Posted by Siba Prasad on March 25, 2008 at 3:08am — No Comments

Cristian Cudizio Happy Easter and 10.2.0.4

Since nobody says nothing i wish you have an happy easter (for who celebrate it) but i want also remember that since few days it's out Patchset 10.2.0.4 for windows 32 bit platform and for linux x86-64 platform wich are the platforms on wich i work. I hope to start testing this new patchset. Continue

Posted by Cristian Cudizio on March 21, 2008 at 9:21am — 4 Comments

TongucY new blog post - Oracle Change Data Capture under magnifier; Async CDC with 10gR2

http://tinyurl.com/3xuj8j Continue

Posted by TongucY on March 21, 2008 at 6:24am — No Comments

Eddie Awad OracleCommunity.net Updated - What's New

The Ning platform, on which this site is built, has just been updated. This latest release introduced a slew of new features and brought many improvements to existing ones. Completely redesigned blog, group, photo, video and forum detail pages:… Continue

Posted by Eddie Awad on March 20, 2008 at 11:39pm — 2 Comments

Stew Stryker Apex_item tips for dummies like me

I struggled mightily with this, almost to the point where I thought I'd be better suited to a job asking "Would you like fries with that?". None of the tutorials seemed to show me the answers I needed and I couldn't even figure out the suggestions offered in the wonderful Oracle Apex forum. My issues were with the PL/SQL collections/arrays. I just couldn't get my update processes to update the correct database rows.… Continue

Posted by Stew Stryker on March 18, 2008 at 8:23am — 2 Comments

Savas Külah Go2Web20.net - The complete Web 2.0 directory

A comprehansive index of logos of the latest web 2.0 applications and services. Find what you need. http://www.go2web20.net/ Continue

Posted by Savas Külah on March 14, 2008 at 3:00pm — No Comments

TongucY new blog post - A little more on External Tables

http://tinyurl.com/35v7lk Continue

Posted by TongucY on March 10, 2008 at 10:40pm — No Comments

TongucY new blog post - Hundreds of reason why you might want(or have) to use R-Man!

http://tinyurl.com/2dh3tn Continue

Posted by TongucY on March 8, 2008 at 5:37am — No Comments

Stew Stryker Oracle Tutorial for creating Tabular Reports

Everybody else probably knows this already, but... Great links provided to me in the Apex forum by Bill Ferguson They're a little outdated (refer to HTMLDB), but still applicable. When you can get away with using the Tabular Report Wizard: http://download.oracle.com/docs/cd/B32472_01/doc/appdev.30… Continue

Posted by Stew Stryker on March 7, 2008 at 3:00pm — No Comments

TongucY new blog post - 10g’s ORA_HASH function to determine if two Oracle tables’ data are equal

http://tinyurl.com/22u399 Continue

Posted by TongucY on March 6, 2008 at 4:38am — No Comments

TongucY new blog post - 10g New Features for Administrators Resources a Summary

http://tinyurl.com/22w4r4 Continue

Posted by TongucY on March 3, 2008 at 11:39pm — No Comments

TongucY new blog post - PL/SQL based Oracle Database Loader(PSODL) Release 2.0 on sourceforge.net

http://tinyurl.com/2amrqg Continue

Posted by TongucY on March 3, 2008 at 12:21am — No Comments

Stew Stryker Apex Using Parent Tabs Retrospectively (for dummies like me)

I've struggled through changing to Two Level Tabs after starting with One Level, so I thought I'd share what I've learned in case others had similar problems. (I also posted a brief version of this in the Oracle Apex forum). Let's say you originally created your Apex application and chose One Level Tabs in the Create Application Wizard. And as you built your application organically (step-by-step, not without pesticides :-)), you created a tab for each page, so you have this long list of… Continue

Posted by Stew Stryker on February 29, 2008 at 10:04am — No Comments

Eddie Awad Oracle Support Wants to See and Hear Your Problem - DITO

Have an issue that you wish you could "show and tell" to Oracle support when you open a service request on MetaLink? then DITO (Demo It To Oracle). Using CamStudio or any other third party desktop recording software, you can now demonstrate your issue for Oracle Support just like you do on an Oracle Web Conference. You can do this offline at your convenience without having to arrange for the presence of a support engineer. You can make the recordings availabl… Continue

Posted by Eddie Awad on February 28, 2008 at 12:12pm — 5 Comments

Hisham Galal Oracle Universal Content Management Wins one Technology of the Year Awards

Oracle Universal Content Management Wins one Technology of the Year Awards According to InfoWorld, "Oracle Universal Content Management is a unified solution for securely managing documents, images, and other digital assets, plus Web sites...Version 10g R3 has extensive Windows Explorer and Outlook integration, works with Microsoft SharePoint, and includes comprehensive search, not to mention strong information rights and records management." Continue

Posted by Hisham Galal on February 28, 2008 at 5:31am — No Comments

TongucY Oracle Application Express 3.1 is ready

Here is a sample application for some of the new features; http://tinyurl.com/32x4hd Continue

Posted by TongucY on February 28, 2008 at 3:24am — 3 Comments

Chris Muir Web Service Development Practicalities

With a current client we've attempted to capture larger issues and practical development ideas beyond just the technical ABCs on implementing web services. We've published it here to hopefully be useful to the casual reader. Check out the rest of my blog post here. Continue

Posted by Chris Muir on February 26, 2008 at 8:23pm — No Comments

TongucY new blog post - Chronicles of 11gR1

http://tinyurl.com/24mmvm Continue

Posted by TongucY on February 26, 2008 at 1:12am — No Comments

Stew Stryker Using Apex_item (for dummies like me)

Let's say you create a tabular report (an updateable SQL query shown in tabular layout) and you want to use some of the fancier column types, such as checkbox, radio button, or text. You run the wizard that creates the report and you include the columns you're going to change to the fancier types in it. Of course for these columns you tell the wizard that you want to update these columns. The wizard does its thing and you get a basic tabular report. Then you edit the query to add calls like:… Continue

Posted by Stew Stryker on February 25, 2008 at 7:30am — No Comments

Hisham Galal Oracle has acquired Captovation

Oracle has acquired Captovation, a leading provider of document capture solutions that streamline the process of capturing mission-critical content for access from within business applications and processes. In all Content Management projects, we need to integrate with a document capture solution, and Stellent provided an integration with KOFAX document capture solution. So Oracle acquiring for Captovation will enhance Content Management Products, and Oracle become the first company that have D… Continue

Posted by Hisham Galal on February 22, 2008 at 5:32pm — No Comments

Hisham Galal IdcoScript vs Javascript

I'd like to explain the difference between IdocScript and Javascript because it is an important step for template pages in Oracle Content Server. IdocScript is a server scripting language created for Oracle Content Server (formally Stellent Content Server) template pages. It consists of the basic functionality you need to create pages that display content or execute services. We should note IdocScript is designed only for the content server. Javascript is a client side scripting language, that… Continue

Posted by Hisham Galal on February 22, 2008 at 1:46pm — No Comments

Hisham Galal Changing Vault and Weblayout folers to another network location or to another drive

I asked Stellent support before they moved to metalink, about If I want to change the current environment in which I have Vault and Weblayout folders on the local hard disk. Where I want to change it to be on SAN storage, they gave me the following guidelines To change the location of the Vault folder: 1. Move the Vault folder to its new location. 2. Modify the following configuration files by adding the entry "VaultDir=\\\\hostname/stellent/vault/". (this is an example please use actual pat… Continue

Posted by Hisham Galal on February 22, 2008 at 1:30pm — No Comments

Chris Muir "Oracle's Ellison: SOA migration a slow process" no surprise

Just before Christmas, InfoWorld published an article quoting Larry Ellison on the slow uptake of SOA. Among other things, Ellison said "It takes about 10 to 20 years before [you can] rewrite all of your applications [to take advantage of SOA]" therefore implying the benefits of SOA are a long way off yet. Check out the rest of this post on my blog. Continue

Posted by Chris Muir on February 19, 2008 at 5:04am — No Comments

TongucY new blog post on interesting comments and questions of “Why Oracle?” seminar

http://tinyurl.com/3adyck Continue

Posted by TongucY on February 19, 2008 at 2:35am — No Comments

Eddie Awad Is It Time for a Complete RDBMS Rewrite?

The answer is yes, according to a group of academics including DBMS pioneer Mike Stonebraker, Ingres founder and a Postgres architect. In a paper (pdf), they have argued that the current DBMS code lines, while attempting to be a “one size fits all” solution, in fact, excel at nothing. Hence, they are 25 year old legacy code lines that should be… Continue

Posted by Eddie Awad on February 18, 2008 at 10:19pm — 3 Comments

Stew Stryker Apex - Custom authentication/authorization framework from Oracle

Maybe everyone else has seen this before, but it was new to me. While surfing the web over breakfast, I found that some kind soul at Oracle (Tony Jedlinski) had published and documented a custom framework for authenticating and authorizing users across multiple Apex applications. The writeup is pretty thorough, though they promised a detailed follow-up which I didn't find. (Maybe they rolled the follow-up into the original?) You can download the framework as an Apex application installer file.… Continue

Posted by Stew Stryker on February 18, 2008 at 7:30am — No Comments

TongucY new blog post on some recent news

1. Steven Feuerstein was in Istanbul for a two days seminar .. 2. There are 184 registered people for our FREE “Why Oracle?(10g Release 2)” seminar on this Saturday .. 3. ubTools Suite 3.2.0 is now available .. 4. Last weekend we studied Jonathan Lewis’s latest book Cost Based Fundamentals of Oracle .. 5. And I will be out of service for a while :) http://tinyurl.com/23ouma Continue