| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi,
I have rows like this (columns a b c):
1 20.06.2007 24.06.2007
2 21.06.2007 23.06.2007
and I need a SELECT-query that returns:
1 20.06.2007
Maija-Leena
|
06-25-2007 07:09 AM
rwijk72@gmail.com  | 12 | 52 |
| | | Hello World!
I searched the Website but i couldn't find the right site. Can you
please point me to the matrix with the Certified Versions for...
Stefan Wetter
|
06-25-2007 06:05 AM
Jeroen van den Broek | 1 | 27 |
| | | out of 3.5+ years exp relevant exp 3
Padre Jerome
gerardojero1977 (AT) gmail (DOT) com contact immediately with ur resume
Gerardo
|
06-25-2007 05:12 AM
Gerardo | 0 | 27 |
| | | It seems some DBAs have some sort of problem with using Oracle shared
mode vs. dedicated.
What happens is, we have several Asp.Net sites that...
cablito
|
06-24-2007 03:47 PM
sybrandb@hccnet.nl | 13 | 50 |
| | | Dereck L. Dietz wrote:
If I understand that you are planning to put table segment and index
segments into separate tablespaces ... my question would...
DA Morgan
|
06-24-2007 09:37 AM
yong321@yahoo.com | 4 | 23 |
| | | Please advice how to estimate in advance phisycal size of table in 9i
or give a reference on dbf (oracle data file) format. I tried to test
some...
dkornyushin@gmail.com
|
06-24-2007 12:49 AM
Michel Cadot | 3 | 26 |
 | | Hi,
I am in search of a downloadable oracle data profiling/quality tool.
Any recommendation is highly appreciated. Thanks!
goog
|
06-22-2007 06:07 PM
joel garry | 16 | 63 |
| | | I have a syntax question.. Below is a ficticious version of what data
I'm working with, but it gets the point of my question across.
Pulling from an...
justsomeschmuck@hotmail.com
|
06-22-2007 03:44 PM
DA Morgan | 6 | 28 |
| | | My apologies if this subject has been discussed. I searched the
groups, and I couldn't find a good thread.
We've been having performance problems...
beth.stover@gmail.com
|
06-22-2007 01:40 PM
hpuxrac | 20 | 99 |
| | | Hi,
We have problems in importing an Oracle 8 database into Oracle 9 server.
Polish national characters do not transfer correctly.
The import comes...
majster
|
06-22-2007 01:28 PM
Frank van Bortel | 8 | 25 |
| | | I am on Oracle 10.2.0.3 on Linux.
Search on this group, I saw a lot of posting saying that sysman is not
part of database, etc. But after I...
emdproduction@hotmail.com
|
06-22-2007 11:03 AM
Michel Cadot | 1 | 34 |
| | | hi everyone:
on 20070418, i'd ask some question about oracle 10g group by bug(bug:
4604970)
thread address as...
Havel Zhang
|
06-22-2007 10:43 AM
DA Morgan | 15 | 56 |
| | | Hi
I am trying to configure RAC 10g R2 on Oracle Enterprise Linux
2.6.9-42.0.0.0 on my two home systems. Doing for testing purpose using
NFS mount...
Jagjeet Singh
|
06-22-2007 09:58 AM
Jagjeet Singh | 18 | 82 |
| | | The story so far..
I have created a link using generic connectivity from a 10.2.0.1
instance running on windows 2003 32 bit server to an...
ahogan
|
06-22-2007 09:09 AM
Jeroen van den Broek | 2 | 30 |
| | | After restoring my database to a new server for testing purposes i get
the following error whe i try to logon or start the listener.
TNSLSNR for...
cptkirkh
|
06-22-2007 01:17 AM
Frank van Bortel | 12 | 42 |
| | | Just got a free copy of this today with my subscription to Oracle
Magazine. Has anyone installed this? I don't want to start the
installation unless...
Chuck
|
06-21-2007 06:43 PM
NetComrade | 14 | 44 |
| | | 10gR2
there're many many records in "dbms_lock_allocated" from my previous
testing, and I recognize the names
I know they're useless now
If they...
klabu
|
06-21-2007 04:13 PM
klabu | 8 | 29 |
| | | Hi All,
I am a bit confused in the exact relation between a Flashback Log and
corresponding Archived Log / Redo Log.
Can someone explain to me /...
Ganesh
|
06-21-2007 11:19 AM
Mladen Gogala | 4 | 24 |
| | | CREATE TYPE Course AS OBJECT (
course_no NUMBER(4),
title VARCHAR2(35),
credits NUMBER(1));
CREATE TYPE CourseList AS TABLE OF Course;
CREATE...
Lucas Carvalho Teixeira
|
06-21-2007 08:15 AM
Chris L. | 6 | 17 |
| | | Anybody else had issues with values from analytic functions
disappearing when wrapped in an XMLAGG function?
Apologies for the noddy...
Matt T
|
06-21-2007 05:28 AM
Matt T | 2 | 30 |
| | | Dear,
We have a problem with 2 Oracle Server 10.2.0.0 on Windows 2003
Server.
The number of threads in the oracle.exe process keeps increasing,...
Jimmy
|
06-21-2007 04:19 AM
Jimmy | 30 | 101 |
| | | My test PC have a hostname like ITVAW2k3DEV02 with a IP
162.162.162.2.
Into my host file in windows I have overwrite the default settings
127.0.0.1...
Alen Cappelletti
|
06-21-2007 02:42 AM
Alen Cappelletti | 6 | 20 |
| | | All, I have the dbf files, ctl files, etc... from an old good instance
of Oracle. Is there a simple way to start up a new instance of oracle
on a...
rich
|
06-20-2007 05:11 PM
sybrandb@hccnet.nl | 8 | 20 |
| | | I am trying to learn how to restore an oracle server. I have the
backup files being shared and I am attempting to restore to a new
host. We run...
cptkirkh
|
06-20-2007 04:26 PM
sybrandb@hccnet.nl | 1 | 27 |
| | | Hi,
I have a query that just hangs for hours when I execute the query or
do an explain plan. It shows wait event "db file sequential read". The
v$...
pratap.deshmukh@gmail.com
|
06-20-2007 02:53 PM
pratap.deshmukh@gmail.com | 2 | 22 |
| | | Hi,
Currently I have Windows XP SP2. I want install Linux and VMware to
work on Oracle.
Can I install both? please advice.
Thanks
DK
DK
|
06-20-2007 02:51 PM
klabu | 2 | 24 |
| | | I am looking for clients, hopefully in NYC/tri-state area
using ASM or OCFS with RAC. I would be grateful for any
information, either to this forum...
Mladen Gogala
|
06-20-2007 11:57 AM
Mladen Gogala | 3 | 4 |
| | | All, it is a very unfortunate situation. The prior DBA was there for
13 years, during which time he wrote many 15+ triggers to handle a
single batch...
rich
|
06-20-2007 11:21 AM
madhusreeram@gmail.com | 12 | 52 |
| | | I run ORacle 10g on windows and and I want to perform a levle 0 backup
every friday and then level 1 backups the rest of the days of the
week. In...
cptkirkh
|
06-20-2007 10:54 AM
Brian Peasland | 1 | 30 |
| | | Some ISSUE with combination.
Issue Is :--> I am firing a query on database to fetch single value
from the XYZ table and
query is getting fired...
vikas Rosal
|
06-20-2007 09:11 AM
vikas Rosal | 0 | 23 |
| | | Good Afternoon,
I am hoping someone can help me out. I want to drop a global
temporary
table in classic asp after my recordset has completed...
juan
|
06-20-2007 08:21 AM
DA Morgan | 11 | 44 |
| | | Hi,
I have 2 collections that are basically an array of numbers.
I'm looking for some slick code that will compare collection #1
against collection...
amerar@iwc.net
|
06-20-2007 08:08 AM
Connor McDonald | 4 | 22 |
| | | Hi, in the statement below I am trying to insert multiple rows into
the HAND table. CARDID is the primary key of HAND
INSERT INTO...
juneauej@gmail.com
|
06-20-2007 08:04 AM
Connor McDonald | 3 | 23 |
| | | What does the value of 0 in the del_lf_rows_len in index_stats signify
or say what does this value mean.
sd2611
|
06-20-2007 07:59 AM
Richard Foote | 3 | 20 |
| | | I have two types of tables, for sake of argument lets call it these:
1) product 10,000,000 rows
2) product_activity 1,000,000,000...
Timasmith
|
06-19-2007 07:13 PM
DA Morgan | 3 | 20 |
| | | Oracle 10g:
I create a small table with:
create table foo (bar number(10), bletch varchar(32));
Insert one row:
insert into table foo (bar, bletch)...
Ron Schnell
|
06-19-2007 01:16 PM
joel garry | 9 | 40 |
| | | Hi,
I don't understand following, Just wonder if it is possible to do what
I am trying to do.
I have following procedure:
PROCEDURE TEST_V_PROC
(...
ciapecki
|
06-19-2007 01:04 PM
Frank van Bortel | 5 | 19 |
| | | Hello,
I am planning to upgrade my 10.2.0.1 database to 10.2.0.2 and I had a
question the following command:
RMAN> UPGRADE CATALOG
I have a...
howard
|
06-19-2007 01:00 PM
Frank van Bortel | 1 | 23 |
| | | I am on Windows 2003 server.
In Oracle 10g r2, Oracle provides a load balancing advisory to
distribute load
among various noads when connections are...
zigzagdna@yahoo.com
|
06-19-2007 12:36 PM
Frank van Bortel | 11 | 38 |
| | | Dear all,
I have a Servlet Java which invokes a Stored Procedure.
Inside the stored procedure I need to retrieve the IP address or
machine name of...
Laura
|
06-19-2007 10:21 AM
Ana C. Dent | 3 | 32 |
| | | On 18 Giu, 04:33, Rodrigo De León <rdele... (AT) gmail (DOT) com> wrote:
Perfect! I've already put in production your tips and it works great.
It's...
sviluppo.sw@gmail.com
|
06-19-2007 07:30 AM
rwijk72@gmail.com | 7 | 18 |
| | | Kind of an odd question, I know..
A couple of times a year I get asked for various reasons how much total
disk space are all of our databases taking...
GS
|
06-18-2007 05:32 PM
camhodge@gmail.com | 3 | 23 |
| | | Hi Gurus,
I have table as follows
create table T1
(
id number,
name varchar2(30)
)
sanjeev.atvankar@gmail.com
|
06-18-2007 03:26 PM
joel garry | 4 | 31 |
| | | Hello,
Several times I've been asked, if there are any object-oriented databases having
relevance to the IT market.
IMHO there is no such...
Marc Blum
|
06-18-2007 11:45 AM
Marc Blum | 5 | 44 |
| | | question,
is there a best practice philosophy on looping thru a cursor of
results in SQL (to tally things and whatnot)? im just curious if...
spacemarine@mailinator.com
|
06-18-2007 09:50 AM
spacemarine@mailinator.com | 13 | 38 |
| | | Hi,
We are running Oracle 8i on Windows 2003. While imporing / Exporting
it is giving I/O errors. Now we would like to increase the...
pvr.murthyind@gmail.com
|
06-18-2007 07:07 AM
sybrandb | 1 | 25 |
| | | On 18 Jun, 09:26, Recruiter - Kiran <kiran23... (AT) gmail (DOT) com> wrote:
Please do not spam this newsgroup. Posts such as this belong...
gazzag
|
06-18-2007 04:35 AM
gazzag | 0 | 25 |
| | | HI
I would like to understand the index puropse in oracle:
When to use it?
What columns?
What is binary and uniqe options that i am having...
odelya
|
06-18-2007 03:11 AM
Michel Cadot | 1 | 31 |
| | | Hello All,
I am using Actuate Reporting tool to connect to Oracle10G using Oracle
Native connection to retrieve the data. I need to capture all...
Raj
|
06-18-2007 02:18 AM
Raj | 7 | 39 |
| | | On another issue with DBA paradigms, I have strong reasons to believe
that leaving the Oracle memory settings on "0", auto is not the ideal.
We are...
cablito
|
06-17-2007 03:58 PM
cablito | 2 | 25 |
