Good morning. I have a table with a date column. I want to find the next latest date in the data in that table. I have got this far: SELECT...

Chaihana Joe

01-04-2008 03:59 AM
vitalisman@gmail.com

Good day, Whenever a transaction reads a block, it compares its SCN with the transaction's SCN, and based on whether the block's SCN is...

markpapadakis

01-04-2008 03:55 AM
markpapadakis

Using Oracle 9i - Using PL/SQL Is there a command like SQL's show table command that will show all the information for a specific table, like the...

Rosie

01-04-2008 01:02 AM
Mladen Gogala

Is there a way to run a SQL in a RAC instance #1 from instance # 2 ? thanks, i.d.

ibodogan

01-04-2008 12:30 AM
DA Morgan

Poll: How fast is YOUR database in rows per second, on a full bore table scan??? This is for those who like Tom Kyte's work, and empirically get...

dba_222@yahoo.com

01-04-2008 12:27 AM
DA Morgan

Hello all, I am trying to set up Oracle for Dataguard in 10g for a Physical standby and its working correctly. Now I have the following doubt...

maadhuuranjan.m@gmail.com

01-04-2008 12:18 AM
DA Morgan

Hi! SQL> select systimestamp from dual; SYSTIMESTAMP ---------------------------------------------------------- 04-Jan-08 05.40.38.275785 AM...

leo@tech-trans.com

01-03-2008 11:42 PM
leo@tech-trans.com

hi all, i ve been struggeling with this function and i can not see what is the problem. i am using it for getting the following...

Totti

01-03-2008 10:31 PM
Ed Prochak

On Jan 3, 1:04*pm, Walt <walt_ask... (AT) SHOESyahoo (DOT) com> wrote: Thanks!!! I agree with you 100%. I would love to ditch this CMDB vendor,...

DP

01-03-2008 10:22 PM
Ed Prochak

Hi DB Gurus, I have an application which tries to access data from more than one identically structured databases. Each of the databases has the...

saurangshu

01-03-2008 09:05 PM
saurangshu

I have a database, I did level 0 backup using RAMN, let us say it took t1 minutes. Now I deleted lot of data in database using delete staements (as...

zigzagdna@yahoo.com

01-03-2008 07:55 PM
Bob Jones

Hello, Oracle 9i 9.2.0.1.0 on Windows 2003 Server. Client = Omnis Studio on windows xp pro sp2. Being an Omnis developer used to SQL Server 2005,...

Bram Mariën

01-03-2008 03:01 PM
fitzjarrell@cox.net

How can I 'select' all items from a table variable? Actually, I want this syntax to use to create a subquery that I can use to join against. I have...

michael.young@paetec.com

01-03-2008 01:11 PM
sybrandb@hccnet.nl

Dear all, I have an Oracle 8.0.5 in Windows 2000 Server. Please, give me a light, when i execute PROGRAMS-- oracle for windows nt -- Oracle Database...

chijar

01-03-2008 01:01 PM
Maxim Demenko

Upgrading a database from Oracle 9i to 10g. I have encountered a problem with the ODBC 10.1.0.2.0 driver, it transforms the 21 numeric digits from a...

valigula

01-03-2008 12:18 PM
richard.drouillard@gmail.com

Hello, I installed OC4J on RHEL to use as a reporting server together with Apex 3.0. The installation went fine, but I have 1 important problem....

Matthias Hoys

01-03-2008 08:52 AM
Frank van Bortel

Hello, I have tried to autostart an oracle instance by following the instructions...

ton de w

01-03-2008 06:53 AM
Maxim Demenko

Hello! I am traying to upgrade database source : 9.2.0.8.0 destination : 10.2.0.3 with 10.2 Database Upgrade Assittant. At the end when program...

anotnio12

01-03-2008 06:26 AM
Maxim Demenko

Hi All, I need help on database design which can manage many to many relationship between "N" number of tables. for last 2 days i'm thinking over...

steven.p24@googlemail.com

01-02-2008 10:42 PM
DA Morgan

dcruncher4 (AT) aim (DOT) com wrote: No one has said that Bora is a liar. What has been said is that there is more to the story and that is...

Bora Yuret

01-02-2008 10:41 PM
DA Morgan

Hi I want to perform a cartesian outer join with the old plus-sign syntax. So far I've come up with (and it works) SELECT ... FROM A,B WHERE case...

Jaap W. van Dijk

01-02-2008 03:55 PM
Arun Mathur

http://coderbuzz-programming.blogspot.com

raae

01-02-2008 02:35 PM
Ed Prochak

There are two type to write select qurey left or right outer join 1. from table1 left outer join table2 on...

nova1427@gmail.com

01-02-2008 11:55 AM
Robert Klemme

Hi, Does anyone have oracle 10g training slides. Please forward me if there any slides are available. Thank you RA

RA

01-02-2008 10:32 AM
DA Morgan

Hi All, I have been reading about the datapump and came to know about "compression" parameter. As per doc it will compress all the metadata before...

lyxx09@gmail.com

01-02-2008 08:21 AM
robertgfreeman@yahoo.com

Consider the table myTable: first_name varchar2(25), last_name varchar2(25), regNum number, status varchar(20) -> nullable ...

amitabh.mehra@gmail.com

01-02-2008 02:32 AM
Frank van Bortel

Let's face it: the code quality of Oracle 10 is worse then dirt. There are many bugs, for various platforms, some of them extremely critical (wrong...

Mladen Gogala

01-01-2008 06:14 PM
hpuxrac

Hmm, let's see. What is this NG about? Oracle? (Civil war?) I really don't have much to say about Oracle. But let's talk about Larry Page and Sergey...

Ramon F Herrera

01-01-2008 05:48 AM
Ramon F Herrera

Hi, We have a query in one of our stored procedures, which I think may have a logic bug in it given the dta it selects. However, I do not...

amerar@iwc.net

12-31-2007 10:11 PM
Charles Hooper

I have an oracle 10g database in archivelog mode. It runs for a few days generating archive log files and I do a hot backup, a few more days go by...

zipRoberts@gmail.com

12-31-2007 01:17 PM
joel garry

dear all, i connect through svrmgr30 but it shows me an error: ORA-12203: TNS:no se ha podido conectar con el destino SVRMGR> SVRMGR> connect...

chijar

12-31-2007 08:44 AM
fitzjarrell@cox.net

We have an oracle 8.1.0.5 instance over sun solaris, during a hard user deletetion instance crashed, and during startup this is what always...

KCS

12-31-2007 01:24 AM
KCS

Hi, We are using replication concept in our project. It contains different schemas which is location wise created. Data flows vertically in both...

ajaysm85@gmail.com

12-30-2007 11:26 PM
ajaysm85@gmail.com

Dear All, I have problem, Please help. There is table called t: with t as ( select 1 Col1, 1 Col2, 1 Col3 from dual union all select 1, 1, 2 from...

nova1427@gmail.com

12-30-2007 09:31 PM
Charles Hooper

Source: Informix Target: Oracle 10gR2 std Edition / LINUX RHEL AS v.4 Dear all, i have to migrate data from several plain text files...

chijar

12-30-2007 07:26 PM
Fernando Nunes

Hi, We are looking into the possibility of virtualizing a number of our servers with VMWare ESX. This includes some Oracle 10g servers. We know...

Matthias Hoys

12-30-2007 05:00 AM
KCS

Hi all, I have been asked to move an SAP system using an Oracle database from Solaris to AIX (on an IBM P590). Most of the move is straightforward,...

chris.kernaghan@gmail.com

12-29-2007 11:48 PM
maxodyne

Hi, Currently im using 17gb for temp tablespace. Im received a error stating, "cannot allocate temp segment for temp tablespace". I increased the...

calms

12-29-2007 05:51 PM
hpuxrac

Hi, In one of our production database response time of transactions suddenly went down. When we have investigated in awr report it reports high JS...

AshishTheGreat

12-29-2007 05:38 AM
AshishTheGreat

On Dec 26, 5:10 pm, "Dereck L. Dietz" <diet... (AT) ameritech (DOT) net> wrote: Hello Dereck, You would have to either rebuild or recreate. ...

Arun Mathur

12-27-2007 08:38 PM
DA Morgan

Does anyone have any experience with EM Agent configuration with Vertias Active/Active clusters? I found Metalink note 406014.1 and it seems to...

tecveg@gmail.com

12-27-2007 06:06 PM
NetComrade

When I enter the credentials in SQL Plus, it hangs. This happens both in the server machine (Oracle 10.2.0) and the clients. But I am able to login...

raghu

12-27-2007 01:02 PM
Frank van Bortel

http://coderbuzz-programming.blogspot.com

lawryy

12-27-2007 12:17 PM
lawryy

http://coderbuzz-programming.blogspot.com

lawryy

12-27-2007 12:16 PM
lawryy

Hi i need to zip a csv inside an oracle procedure. I create this file (120 MB) inside a procedure and i leave it in a shared folder but i need to...

mpacilio2005@gmail.com

12-27-2007 06:00 AM
mpacilio2005@gmail.com

Hi Consider a test table - mytable: id number pk name varchar2(20) not null, addr varchar2(100) not null default 'local' I populated...

amitabh.mehra@gmail.com

12-27-2007 12:34 AM
amitabh.mehra@gmail.com

Merry Christmas Oracle OS specs process 9.2.0.5 aix 5.2 rman archived redo log files backup From time to time there is RMAN-20242:specification...

Massa Batheli

12-26-2007 10:36 AM
fitzjarrell@cox.net

Does anyone have a script that can list all database users and thier privileges Do not want to try to reinvent the wheel if some one out there...

Massa Batheli

12-26-2007 10:20 AM
Massa Batheli

Hi, I want to grant right to a Oracle user by using "grant insert,select,delete,update, on table1 to ABC" generally. However, the owner has more...

leo@tech-trans.com

12-26-2007 10:09 AM
EdStevens

Junction Intl Traders Inc. 3772 Fleet Ave South plainfeild NJ 07080 Ph: 516 707 5000 www.junctiontrader .com PLEASE KEEP US IN YOUR MAILING...

TRADERJUNCTION@gmail.com

12-25-2007 11:54 PM
TRADERJUNCTION@gmail.com