in the world
- Eleanor Roosevelt
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohan, Karthik (GEP)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Title: MS access
Ido not seem to have exactlyunderstood
u r problem..but try this anyway
select count(*) from
awhere l_id in
(selectb.bl_idfroma,bwherea.o_id =
17anda.o_id = b.bo_id )OR(a.o_id = 17)
COUNT(*)--
2
1 row selected.
The
table data is as listed below
Title: RE:
Hi ,
When trying to exceute a PL/SQL program which reads data from a file into a record (using utlfile) , I get an error as listed below
ORA-04030: out of process memory when trying to allocate 8208 bytes (PLS
non-lib hp,PL/SQL STACK)
ORA-07324: smpall: malloc error while
Title: RE: how to install Oracle Developer2000 on Windows98 ?
Hi Bamabang,
Did you check the entry for the database in your tnsnames ora file ?
Regards,
Karthik Mohan
TCS Consultant at GEP (HK)
DialComm 3310962
ISD : 852-26290962
-Original Message-
From: Bambang Setiawan
Title: RE: about analyse table..
Hi Saurabh,
The Analyse command helps to collect information on the specified table and updates the system table called user_tables with this info
This helps to optimize any query which is run on the table after the table is analyzed. You can take help