For those of your who take interest in excellent infographics and leading edge database reporting techniques.. check out this...

JTP PR

06-30-2010 12:53 PM
joel garry

Hi, The following works *everywhere* I've ran it: $ echo rbcde_fghijkl_mnopq|sed "s/_\(\)/\u\1/g" rbcdeFghijklMnopq (in vi, at several Unix...

Spendius

06-30-2010 02:16 AM
Peter Nilsson

I use Oracle SQL Developer, ver 2.1, to access an Oracle 10g server. I would like to export a LONG field into an excel sheet. Sometimes it works,...

dn.perl@gmail.com

06-22-2010 08:25 PM
galen_boyer@yahoo.com

Position: Senior development team leader Job Considerations: -Excellent C++, MFC skills -Advanced Programming Skills (OOP, COM, Threading,...

h recruitment

06-21-2010 06:12 AM
h recruitment

Hi, We're on Oracle 10g. I have a huge dynamic query that is built in a PL/SQL procedure. The query works and it dynamically puts together the...

The Magnet

06-19-2010 04:19 AM
Vladimir M. Zakharychev

We have a dynamic cursor with a dynamic IN clause: SELECT article_id, subject, teaser_message, message, category_id, category_name, publish_date,...

The Magnet

06-18-2010 08:40 PM
Tim X

Hello, I'm following my own practices to document my job on databases, but also I'm wondering if they are correct or how other DBAs manage their own...

Big George

06-18-2010 08:29 PM
Tim X

Hi friends, Do u need Windows and Linux Tips? Please visit the following site: http://windowsandlinuxtips.blogspot.com/

pavelhaque

06-14-2010 08:23 AM
pavelhaque

Job Title: Oracle DBA Job Location(s): * MO - St. Louis Duration: 6 months Position Type: Full-time Hours: 8am-5pm Education Level: Bachelor's...

Vikas Malik

06-10-2010 10:40 AM
Vikas Malik

Join us on Wednesday, June 16th, 2010 11:00 am – 12:30 pm UTC/ GMT In this compelling session you will be introduced to OBIEE repository, Oracle BI...

iware

06-10-2010 05:10 AM
iware

OLM Functional Lead - St. Louis, MO Location - St. Louis, MO Duration - 4 months ROLE: OLM Functional Lead REQUIRED SKILLS: - Strong functional...

Vikas Malik

06-08-2010 11:25 AM
Vikas Malik

Dear Gurus, I have written below function FUNCTION Get_Loc_Dtl ( No IN VARCHAR2, Date_Cond IN VARCHAR2 ) RETURN VARCHAR2

Sanjeev

06-07-2010 06:56 PM
ddf

We're trying to insert a value that is like 50,000 characters long into a CLOB column from PL/SQL. It is passed in as a parameter to a CLOB...

The Magnet

06-03-2010 02:57 PM
Frank van Bortel

So if you have a table that has a date time type and you want to sum the qty by account but want to do it in such a way that it fetches the data once...

Robert Nicholson

06-03-2010 02:10 PM
joel garry

On May 28, 11:58*pm, xaingmei chen <chenxain... (AT) gmail (DOT) com> wrote: sorry, couldn't resist.

joel garry

05-31-2010 03:25 PM
joel garry

I have a question about configuring Oracle RAC. I have never done any RAC or ASM installation before. Might be a stupid question for some of you. Is...

Ora_DBA

05-27-2010 09:19 AM
Mark D Powell

Are there any book on Oracle DBMS's internal? Like Microsoft Press's _Inside Microsoft SQL Server 2005_

dlion

05-26-2010 10:37 AM
Mark D Powell

We have 2 database which have DB links between. The user in both database have the same name. We cannot figure out how to grant...

The Magnet

05-26-2010 10:28 AM
Mark D Powell

select INQMSIS.mine_tbl.sic_desc, COUNT (INQPROD.ACC_INJ_TBL.AI_DOC_NUM), COUNT (INQPROD.ACC_INJ_TBL.AI_DOC_NUM) * 200000 from...

Don B

05-21-2010 12:11 PM
joel garry

Has anyone used either of the following? Any thoughts? MIS Training Institue Auditing and Securing Oracle Databases -...

eAddict

05-20-2010 03:26 PM
Vladimir M. Zakharychev

I've modified this select statement so that it will take a column from multiple rows and concatenate them and delimit them. The value returned is...

The Magnet

05-20-2010 01:07 PM
Jens Kammler

Hi, I'm tryng to use the Analytical function COUNT(*): SELECT tag_id, tag_name, tag_count FROM (SELECT t.tag_id, tag_name, COUNT(*) OVER (PARTITION...

The Magnet

05-18-2010 06:00 AM
Carlos

Hello, My Business case: In a Multiuser application the users need exclusive access to records in a table, to avoid lost updates. My solution: If a...

Thomas Blankschein

05-15-2010 02:15 PM
Mark D Powell

The target is Window server 2003 with 10g 10.2.0.2.0 oracle and the Auxiliary is Windows XP with 10g 10.2.0.1.0 oracle. Can I user rman duplicate...

moongeegee

05-12-2010 04:19 AM
Frank van Bortel

We have a source database which is Oracle 11g RAC. The target database is a stand laone database (11g). We need to create Materialized View in the...

Ora_DBA

05-11-2010 09:17 AM
Carlos

We have a large schema and packages that compile find on Oracle 11.1. When I try the same procedure to build our schema and packages on a new Oracle...

Martin

05-11-2010 06:00 AM
sandeep pande

Is Supplemental logging mandatory when using streams Replication ? I am trying to replicate about 100 plus tables in a schema. All the tables in the...

Ora_DBA

05-11-2010 05:30 AM
sandeep pande

I have a windowsXP with Oracle 10g installed and using RMAN backup. I got an error as below, someone set the RMAN backup before I take over this...

moongeegee

05-11-2010 05:19 AM
sandeep pande

I am using 10g. I want to do a select statement that will give me the name of the fields in a table. And I also want to know the field type and...

Rich

05-11-2010 03:10 AM
sandeep pande

Hi, I've created some code that uses PL/SQL type of OBJECT. I used an example I found. The code works fine, but I am trying to understand exactly...

The Magnet

05-11-2010 02:58 AM
sandeep pande

Hello, we have a forms application and would like to run it on a windows 2003 terminal server, but the user experience is very bad. When the...

Andreas Moroder

04-30-2010 02:32 PM
Shakespeare

Hi all Basically I have this, which gives me a tree of the product and subasseblies. SELECT level, stuff from products CONNECT BY PRIOR...

jodleren

04-28-2010 10:51 AM
Carlos

Hallo! Ich bin auf der Suche nach einem Datenbank-Design-Tool, hauptsächlich für Oracle. Folgende Features sollten vorhanden...

stschemel

04-27-2010 10:23 AM
Terry Dykstra

Yellowfin has released its latest Business Intelligence Whitepaper, this time on "In-memory Analytics" * No signup or email handover required, just...

JTP PR

04-26-2010 06:58 AM
JTP PR

Hello all, Let me start by saying that I am new to Oracle so please excuse my ignorance. I have this problem whereby when I insert any characters...

George K.

04-23-2010 11:04 AM
George K.

Upgrading 11i E-Business Suite to R12 Join us on Wednesday, April 28th, 2010 10:30 am – 12:00 pm UTC/ GMT (Check Local Time Zone) In this webinar you...

iware

04-23-2010 06:25 AM
iware

Ok, it's a dummy question, but we have some doubts about an outsourcing service. We need in our office to implement Oracle 10gR2 RAC, two nodes in...

Big George

04-22-2010 10:49 AM
Mark D Powell

We're about at the end of our rope. We have a script that runs at night and re-created some materialized view. The SQL simple drops the view and...

The Magnet

04-19-2010 11:46 AM
Norbert Winkler

Hi, for creating a unique index with a date-column A_DATE I'm using a calculated column X_DATE as (trunc(A_DATE)): CREATE UNIQUE INDEX...

Norbert Winkler

04-14-2010 09:18 AM
Mark D Powell

Dear All, iWare logic Conducted knowledge session on – “R12 Inventory Management, New Features”. You can access the Recording of the session (Video)...

iware

04-14-2010 02:22 AM
iware

Hi, is there a way to browse all e.g. sys_context(USER, <xy>) elements (or sys_context('USERENV', <xy> elements) and displaying their values - w/ o...

Frank Bergemann

04-12-2010 08:44 PM
Malcolm Dew-Jones

Are OLAP cubes meant only for the cases where the aggregate operations are involved for major set of records? I have a case where I have to maintain...

guser78

04-08-2010 02:38 AM
guser78

Are OLAP cubes meant only for the cases where the aggregate operations are involved for major set of records? I have a case where I have to maintain...

Nithyanandham M

04-08-2010 02:33 AM
Nithyanandham M

Hi all, I have a table with details of phone calls. The call date is given as DD-MMM-YYYY HH:MI:SS. I have a couple of other fields that give the...

Sashi

04-07-2010 11:41 PM
ddf

With Oracle 10g the RULE command will not be supported. So far as good, we removed all RULE statements inside Queries and views. Mostly it works...

Nicolas Bronke

04-07-2010 06:18 PM
Kay Kanekowski

Gurus, In some versions of Oracle, one cannot use the @ symbol in a password. Are there any other forbidden characters out there which cannot be...

Spin

04-07-2010 09:31 AM
Mark D Powell

Hi, anyone have code snippets on how to list out user functions and procedures? perhaps there is a table or view that contains this information,...

seannakasone

04-02-2010 09:57 AM
Mark D Powell

Quick demo on the power of Location Intelligence to visualise your data http://www.youtube.com/watch?v=uhD1NtNdj8E

JTP PR

03-30-2010 07:58 AM
JTP PR

In some of the other posts that I have posted, I have mentioned the business usecase that I'm dealing with. Anyway, here is a brief overview of what...

guser78

03-30-2010 04:43 AM
guser78

hi all After installing Oracle database 11.2 on Solaris 10 x86 the dbstart script doesn't work because of the interpreter is set to /bin/sh but the...

Sven Hilmer

03-26-2010 02:43 AM
Sven Hilmer