a little sql question

2001-09-03 Thread Djaroud Salim

hi every body,
I need to insert in the end of a sql script, the number of rows returned.
how can i do that ?
thanks !!!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Djaroud Salim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



migrating from 8.0.5 to 8.1.7

2001-09-03 Thread Djaroud Salim

hi migrator,
any one have problems with packages or stored procedures ??

wait a feedback ! thanks
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Djaroud Salim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



special caracter

2001-08-28 Thread Djaroud Salim

I want to insert a simple caracter in my database 'EUR'.
is there any to do that because i have this caracter ''.

any suggestion will be very appreciate!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Djaroud Salim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Imp problem

2001-07-27 Thread Djaroud Salim

hi,
I have an export with WE8DEC,
and i want do a full import on a database With WE8ISO8859P1 character set.

But avery time i do it a have a problem when he want to create indexes with:

ORA-01115: erreur E/S en lecture de blocs a partir du fic. 9 (bloc # 13)
ORA-01110: fichier de donnJes 9: 'file'
ORA-07372: sfrfb: erreur de lecture, lecture impossible du bloc demandJ du
fich
de BDD.
HP-UX Error: 14: Bad address

is this a bug of oracle ???

Oracle 7.3.4.0.0
HP-UX 10.20

thanks in advance
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Djaroud Salim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



urgent synthax of DBV

2001-07-24 Thread Djaroud Salim

i need in urgence DBV synthax

thanks !!!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Djaroud Salim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



ora 1115

2001-07-19 Thread Djaroud Salim

hi,
i have an ora-7372 message when i do a simple select on a table.
what can i do for resolve that.
i'm on hpunix oracle 7.3.4

thanks in advance

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Djaroud Salim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



resize in 7.3.4 urgent

2001-07-17 Thread Djaroud Salim

hi,
i want if any body try to resize a datafile to a lower value.
i'm on oracle 7.3.4 on hpunix 10.0

thanks in advance

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Djaroud Salim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Temp

2001-07-16 Thread Djaroud Salim

hi every body,
I have a user with no quota on it's temporary tablespace.
is it normal 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Djaroud Salim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).