Re: SGA Parameters ...

2001-03-21 Thread SuzyV
want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: Meeting at IOUG

2001-04-17 Thread SuzyV
LP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Californi

Re: Tracking JDBC clients in V$SESSION

2001-04-26 Thread SuzyV
-- Name: InterScan_Disclaimer.txt InterScan_Disclaimer.txtType: Plain Text (text/plain) Encoding: 7bit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED

select for update...

2001-05-09 Thread SuzyV
What are the negatives of using 'select for update'? Seem to recall it locks all rows within a block causing other transactions to wait on rows needed in the same block. What about performance impacts?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET

Re: Oracle books

2001-05-09 Thread SuzyV
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services

Re: Order of columns in a table

2001-05-10 Thread SuzyV
://www.orafaq.com -- Author: SuzyV 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

Re: change filename case

2001-05-10 Thread SuzyV
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

Re: Order of columns in a table

2001-05-10 Thread SuzyV
Am I an idiot?? Meant to say, you can eliminate the COLUMN list not VALUES, doh! SuzyV wrote: select table_name, column_name from dba_tab_columns where table_name = 'SOMETABLE' order by column_id ; The column order is the same as you'd see with describe or select * You can eliminate

Re: ORA-06553: PLS-707: unsupported construct or internal error [2603]

2001-05-10 Thread SuzyV
://www.orafaq.com -- Author: SuzyV 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

Re: Do you know any good concentrated short cut book for Orac

2001-05-10 Thread SuzyV
to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: OT RE: comp.oracle.databases.server vs ORACLE-L: deathmatch

2001-05-10 Thread SuzyV
want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: function index for like '%string%'

2001-06-01 Thread SuzyV
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: LDAP/OID

2001-06-01 Thread SuzyV
') 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET