| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi,
I have installed Oracle 10.2 on my Windows XP laptop. The host for
the default ORCL database in my tnsnames.ora is (HOST = 192.168.1.101)
as I...
Ninja Li
|
11-02-2010 06:50 PM
Ninja Li  | 2 | 3 |
| | | Postgres tips. Visual FoxPro as Client and Postgres as Backend
examples.
http://postgres-tips.narod2.ru/
Psi Operator
|
11-02-2010 03:15 PM
Psi Operator | 0 | 1 |
| | | Hello,
I need to insert Google Analytics' javascript tracking code (either the
newer, asynchronous or the older, synchronous, mode) into...
Bob Hartman-Berrier
|
10-29-2010 11:58 AM
joel garry | 1 | 2 |
| | | Hi, I'm looking for an answer but also thought I can take a shortcut
here.
We have a query with a ton of calculations using DECODE and NULLIF...
The Magnet
|
10-22-2010 08:29 PM
Tim X | 4 | 5 |
| | | Can anybody recommend a free tool that can be run against a 3 node 10g
cluster for the purposes of reporting as much useful information as...
banzai
|
10-22-2010 11:52 AM
banzai | 0 | 1 |
| | | website:http://www.jialiuonline.com
In the world of sports fashion- Asics Onitsuka Tiger, provided there
are some products
that stand out and...
world-trade
|
10-22-2010 01:49 AM
world-trade | 0 | 1 |
| | | Hi!
I have the following problem:
select distinct to_char(wpa_timestamp, 'YYYY')
from view_waiting_time_book
where to_char(sysdate, 'YYYY') =...
Pelle
|
10-21-2010 05:02 AM
Tuomas | 6 | 7 |
| | | I wrote the book Economic Analysis of Information Systems (written in
Portuguese).
See my blog: http://sergiokaminski.blogspot.com/
The basic...
sergio kaminski
|
10-17-2010 01:03 AM
sergio kaminski | 0 | 1 |
| | | Hi folks,
let's say I want to do an insert of multiple rows, such as
"
insert into table ( id, column1 ) valuess ( idseq.nextval, 'abc');
insert into...
John
|
10-13-2010 12:58 AM
Michel Cadot | 1 | 2 |
| | | Hi,
We are running 10gR2.
We have a strange issue with our triggers, and it is probably
something we are missing. We have a table which has a...
The Magnet
|
10-11-2010 03:18 PM
The Magnet | 1 | 2 |
| | | Hello,
MyTable has missing records:
id_group id_column
-------------------------
1 1
1 2
1 3
1 5
Big George
|
10-05-2010 12:17 PM
Gerard H. Pille | 3 | 4 |
| | | Hi,
I have a simple table like the following:
CREATE TABLE TEST
(
ID NUMBER(10, 0) NOT NULL
, VEHICLE VARCHAR2(20 CHAR) NOT NULL
, TIMESTAMP...
MarkusSchaber
|
10-04-2010 04:34 AM
MarkusSchaber | 3 | 4 |
| | | Mr. Buffoon schrieb am 29.09.2010 in <i7vvhb$b5u$1 (AT) news (DOT) albasani.net>:
me, but even if so - this was not my question. I do not have the...
Andreas Mosmann
|
10-01-2010 04:21 PM
Peter Schneider | 5 | 6 |
 | | Ok, this is probably simple, what I'm lost. FYI: We're on 10gR2.
I'm trying to update a CLOB column. The procedure is being called
from PHP. If...
The Magnet
|
09-30-2010 01:53 PM
Gerard H. Pille | 18 | 19 |
| | | Hi All,
From what I understand the sql below should return 'Hello World',
however it actually returns 'HelloWorld' i.e. the whitespace is...
Kevin S
|
09-28-2010 07:35 PM
Tim X | 5 | 6 |
| | | My aim is to display the ‘special’ (NON-Ascii) German character/
diacritic umlaut or diaresis correctly on a browser. The browser calls
a cgi...
dn.perl@gmail.com
|
09-28-2010 05:31 PM
joel garry | 16 | 17 |
| | | guys,
im using rman to backup a database for physical standby. the command is
pretty simple:
backup incremental level = 0 format...
H. Steuer
|
09-28-2010 11:22 AM
gazzag | 1 | 2 |
| | | Hi,
the following script creates two tables. The problem causes due to an error
using a not existing YEAR column.
My error, in the real tables, dues...
Norbert Winkler
|
09-27-2010 04:00 AM
Kay Kanekowski | 5 | 6 |
| | | Hi,
there is f.e. the following table:
NAME FROM TO LENGTH
123456 O A 10 *
123456 A B 15 *
123456 B C ...
Andreas Mosmann
|
09-20-2010 04:20 AM
Andreas Mosmann | 7 | 8 |
| | | Hi,
I am having an issue while inserting data into an oracle table through
sqlldr. My requirement is to be able to enter data into a field with...
Sandy80
|
09-15-2010 03:57 AM
Sandy80 | 3 | 4 |
| | | I am trying to get a query right which uses multiple outer joins, bu
something somewhere is wrong.
There are three tables in the database : t_car,...
dn.perl@gmail.com
|
09-12-2010 08:57 PM
Peter Nilsson | 3 | 4 |
| | | hi,
I am trying to insert a record in a employee table 1 based on whether
a record already exists in table 1. If a record for that employee
already...
Sandy80
|
09-10-2010 03:00 AM
Robert Klemme | 4 | 5 |
| | | Hi all,
I'm trying to write a clever stored procedure that I can pass in a
table name and a where clause, and it'll display all matching rows in
a...
Knickerless Parsons
|
09-08-2010 05:36 AM
Knickerless Parsons | 3 | 4 |
| | | Hi all,
I'm trying to write a clever stored procedure that I can pass in a
table name and a where clause, and it'll display all matching rows in
a...
Knickerless Parsons
|
09-07-2010 09:45 AM
Knickerless Parsons | 0 | 1 |
| | | Hello,
Oracle 11.2.0.1.0 running on SunOS 5.10.
I have a problem extracting data and writing it to a flat file with PL/
SQL and can use
some...
Luke
|
09-03-2010 06:16 AM
Ed Prochak | 1 | 2 |
| | | i Just needed some tips.
We have an oracle DB running on 8i in production system. Its has a
standby which is getting synced using archive logs on a...
Ruddy
|
09-02-2010 11:59 AM
joel garry | 1 | 2 |
| | | For more information,please contact karen,
MSN:cntrade088 (AT) hotmail (DOT) com
Minimum order is one,factory price also! Paypal payment...
cntrade08
|
08-28-2010 02:58 AM
cntrade08 | 0 | 1 |
| | | Hello,
Please consider the following example:
CREATE TABLE TMP_ARTICLES
(
ARTICLE_ID NUMBER,
UNIT_PRICE NUMBER,
SOLD_UNITS NUMBER
)
Hans Mayr
|
08-27-2010 12:34 PM
joel garry | 4 | 5 |
| | | Hello,
maybe I'm lucky to find here any Oracle Spatial experts.
I would like to know if it is possible to create SDO_GEOMETRY objects
by reading...
Norbert Pürringer
|
08-19-2010 04:27 AM
Norbert Pürringer | 0 | 1 |
| | | Hi,
I would like to execute a SELECT * from table1 order by <XYZ>
and get the results into IN OUT cursor.
I want to pass XYZ as input parameter to...
Amritha
|
08-17-2010 08:44 AM
Mark D Powell | 3 | 4 |
| | | Hi ng,
(Oracle 11.2.0.1.0, Linux)
Following Situation:
There are 3 schemas:
DATA - holds all the data of my database
WORKER - prepares the data...
Andreas Mosmann
|
08-16-2010 12:31 PM
Gerard H. Pille | 5 | 6 |
| | | I was looking at this RMAN script. I see these commands:
STARTUP FORCE MOUNT
ALTER DATABASE MOUNT
STARTUP FORCE shuts it down and then restarts it...
The Magnet
|
08-14-2010 10:02 AM
Mark D Powell | 3 | 4 |
| | | Is there really any good way to track the changed columns in a trigger
on an update?
Say I have a table of 100 columns and I am doing some...
The Magnet
|
08-13-2010 05:32 AM
Robert Klemme | 4 | 5 |
| | | Hi,
several problems with external tables (on a PC w/ Oracle 10g
downloaded - I'm running Vista Home Premium - yes I know this
isn' t exactly the...
Ken Quirici
|
08-07-2010 09:49 PM
Ken Quirici | 0 | 1 |
| | | We are exporting data from MySQL to Oracle. According to the
developers the data from MySQL contains new lines and tabs (\n, \r,
\t).
Is there a...
The Magnet
|
08-06-2010 01:43 PM
The Magnet | 3 | 4 |
| | | Hi,
I'm using virtual columns and we've a datapump-solution for creating
test-schemas with the recent data on an other machine.
But all tables...
Norbert Winkler
|
08-06-2010 08:25 AM
Norbert Winkler | 0 | 1 |
| | | Dear all
It might be a trivial issue for you.. but it keeps me busy and I'd be
glad for help.
Lets say, we now have "23.07.2010 13:45:21" as...
Oliver
|
08-06-2010 04:31 AM
Oliver | 6 | 7 |
| | | Hello!
I would like to create a footer at the bottom of the each page on report on
Oracle Reports (Oracle 9/10 version).
The footer data are unique...
Netman
|
07-29-2010 08:26 AM
Netman | 0 | 1 |
| | | I have some insert statements with values that are > 2500 characters.
I cannot make it a .CSV because the text has commas in it. It is a
bunch of...
The Magnet
|
07-28-2010 08:02 AM
Frank van Bortel | 5 | 6 |
| | | Hello Partners,
We have urgent Multiple Java requirements in San Francisco, CA.
Please send resume only at amitsingh (AT) satincorp (DOT)...
amit
|
07-20-2010 12:09 PM
amit | 0 | 1 |
| | | Hi,
Please find the all open SAP requirements and let me know on which you
are interested and fit.
In case you are not available please forward this...
amit
|
07-20-2010 12:09 PM
amit | 0 | 1 |
| | | (This is about Oracle Calendar, not the oracle database product. I could
not find a more appropriate newsgroup, but if anyone knows of one...
John Gordon
|
07-20-2010 01:06 AM
John Gordon | 2 | 3 |
| | | On Oracle 10 hosted on a FreeBSD server, I am seeing a
disproportionate difference in response time between two queries which
should take same amount...
dn.perl@gmail.com
|
07-17-2010 01:10 AM
joel garry | 3 | 4 |
| | | Hi all,
I'm trying to connect to my dataserver via sqlplus, version 10.2.0.4.0
on a Solaris 10 machine.
I'm not sure of the server version.
I can...
Sashi
|
07-16-2010 04:19 PM
Mark D Powell | 1 | 2 |
| | | 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-12-2010 08:39 AM
Mark D Powell | 4 | 188 |
| | | 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 12:32 PM
joel garry | 2 | 1,103 |
| | | 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 02:53 AM
hehehe | 0 | 124 |
| | | 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 04:06 PM
Mark D Powell | 1 | 167 |
| | | 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 02:07 PM
Sashi | 2 | 198 |
| | | GHD MK4 MK5 cheap Wholesale, GHD hair straightener wholesale
Cheap Benefit GHD (http://www.jialiuonline.com/)
Cheap Black GHD...
PUMASHOES
|
07-01-2010 09:06 AM
PUMASHOES | 0 | 152 |
