| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | We are using an integration broker (SAP PI) to poll an event table,
then update the status of the polled event row. Currently, the
following...
AudioFanatic
|
07-09-2010 11:32 AM
joel garry  | 2 | 129 |
| | | Hi %,
I have a user to which a role has been granted with admin option. So
this user now can grant/revoke this role to/from other users.
But how...
Peter Kallweit
|
07-09-2010 09:28 AM
Mark D Powell | 2 | 41 |
| | | Hello!
Wa are trying to create application for archive lots of documents about
15mln(1mb each). We will use oracle 11g database with cluster...
hehehe
|
07-09-2010 01:53 AM
hehehe | 0 | 19 |
| | | Ok, probably a simple question but, say I have an after update on a
table of maybe 20 columns, for each row.
If a column in the source table is...
The Magnet
|
07-08-2010 03:06 PM
Mark D Powell | 1 | 23 |
| | | Hi all, I'm trying to create a database link to a remote db.
SQL> create public database link iv_link
2 connect to user identified by password
3 ...
Sashi
|
07-01-2010 01:07 PM
Sashi | 2 | 69 |
| | | GHD MK4 MK5 cheap Wholesale, GHD hair straightener wholesale
Cheap Benefit GHD (http://www.jialiuonline.com/)
Cheap Black GHD...
PUMASHOES
|
07-01-2010 08:06 AM
PUMASHOES | 0 | 28 |
| | | For those of your who take interest in excellent infographics and
leading edge database reporting techniques.. check out this...
JTP PR
|
06-30-2010 11:53 AM
joel garry | 1 | 45 |
| | | 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 01:16 AM
Peter Nilsson | 3 | 32 |
| | | 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 07:25 PM
galen_boyer@yahoo.com | 5 | 73 |
| | | Position: Senior development team leader
Job Considerations:
-Excellent C++, MFC skills
-Advanced Programming Skills (OOP, COM, Threading,...
h recruitment
|
06-21-2010 05:12 AM
h recruitment | 0 | 35 |
| | | 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 03:19 AM
Vladimir M. Zakharychev | 2 | 64 |
| | | 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 07:40 PM
Tim X | 10 | 81 |
| | | 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 07:29 PM
Tim X | 4 | 46 |
| | | Hi friends,
Do u need Windows and Linux Tips?
Please visit the following site:
http://windowsandlinuxtips.blogspot.com/
pavelhaque
|
06-14-2010 07:23 AM
pavelhaque | 0 | 32 |
| | | 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 09:40 AM
Vikas Malik | 0 | 49 |
| | | 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 04:10 AM
iware | 0 | 35 |
| | | 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 10:25 AM
Vikas Malik | 0 | 48 |
| | | Dear Gurus,
I have written below function
FUNCTION Get_Loc_Dtl
(
No IN VARCHAR2,
Date_Cond IN VARCHAR2
)
RETURN VARCHAR2
Sanjeev
|
06-07-2010 05:56 PM
ddf | 1 | 48 |
| | | 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 01:57 PM
Frank van Bortel | 3 | 79 |
| | | 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 01:10 PM
joel garry | 3 | 40 |
| | | On May 28, 11:58*pm, xaingmei chen <chenxain... (AT) gmail (DOT) com> wrote:
sorry, couldn't resist.
joel garry
|
05-31-2010 02:25 PM
joel garry | 0 | 44 |
| | | 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 08:19 AM
Mark D Powell | 1 | 80 |
| | | Are there any book on Oracle DBMS's internal? Like Microsoft Press's _Inside
Microsoft SQL Server 2005_
dlion
|
05-26-2010 09:37 AM
Mark D Powell | 4 | 59 |
| | | 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 09:28 AM
Mark D Powell | 4 | 62 |
| | | 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 11:11 AM
joel garry | 4 | 63 |
| | | Has anyone used either of the following? Any thoughts?
MIS Training Institue
Auditing and Securing Oracle Databases -...
eAddict
|
05-20-2010 02:26 PM
Vladimir M. Zakharychev | 2 | 65 |
| | | 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 12:07 PM
Jens Kammler | 1 | 40 |
| | | 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 05:00 AM
Carlos | 6 | 69 |
| | | 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 01:15 PM
Mark D Powell | 6 | 72 |
| | | 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 03:19 AM
Frank van Bortel | 5 | 79 |
| | | 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 08:17 AM
Carlos | 3 | 91 |
| | | 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 05:00 AM
sandeep pande | 13 | 113 |
| | | 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 04:30 AM
sandeep pande | 2 | 78 |
| | | 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 04:19 AM
sandeep pande | 2 | 80 |
| | | 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 02:10 AM
sandeep pande | 3 | 59 |
| | | 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 01:58 AM
sandeep pande | 1 | 44 |
| | | 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 01:32 PM
Shakespeare | 5 | 103 |
| | | 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 09:51 AM
Carlos | 5 | 62 |
| | | Hallo!
Ich bin auf der Suche nach einem Datenbank-Design-Tool, hauptsächlich
für Oracle. Folgende Features sollten vorhanden...
stschemel
|
04-27-2010 09:23 AM
Terry Dykstra | 1 | 53 |
| | | 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 05:58 AM
JTP PR | 0 | 51 |
| | | 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 10:04 AM
George K. | 8 | 87 |
| | | 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 05:25 AM
iware | 0 | 52 |
| | | 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 09:49 AM
Mark D Powell | 2 | 70 |
| | | 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 10:46 AM
Norbert Winkler | 8 | 87 |
| | | 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 08:18 AM
Mark D Powell | 7 | 85 |
| | | 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 01:22 AM
iware | 0 | 56 |
| | | 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 07:44 PM
Malcolm Dew-Jones | 2 | 67 |
| | | 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 01:38 AM
guser78 | 0 | 75 |
| | | 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 01:33 AM
Nithyanandham M | 0 | 56 |
| | | 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 10:41 PM
ddf | 2 | 58 |
