RE: rewriting query without using UNION

moved from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,

RE: How to call unix shell scripts from 'C'?

inal Message- Sent: Wednesday, October 22, 2003 11:45 AM To: Multiple recipients of list ORACLE-L The unix and C forums are pretty inactive. Hope its ok to ask this here. Anyone know how to do this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung INET:

RE: How to get the source code of the trigger without using any t

e removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

What is _NEXT_OBJECT

o far. What is this thing, and how do I fix it (and I don't really want to do a re-imprt per the experts-exchange web page.) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.f

RE: tables and views

Title: Message   All columns from view and tables appear in ALL_TAB_COLUMNS; to differentiate the source of the columns, you need to join to ALL_TABLES for the table columns, or to ALL_VIEWS for view columns, or if you need to know what type of object the column came from (instead of somethi

Limits on PL/SQL block?

rmining where to break up the blocks dynamically, so the answer I'm really looking for is what is the limit or how Oracle determines the size limit, and not workarounds, which we're exploring anyway.) TIA ..Rudy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author:

RE: Job to run first Wednesday

To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:RE: Job to run first Wednesday > > > > > > Josh, > > > > With the following functions, you could probably get it to work: > >

RE: Job to run first Wednesday

TED] (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). -- Please see the official ORACLE-L FAQ: ht

RE: need help with execute immediate from a script

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.net -- Author: Rudy Zung INET:

RE: need execute immediate and script help

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.net -- Author: Rudy Zung INET:

RE: SHOW ERRORS not working

on (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and

RE: shell question

cat(1) -Original Message- Sent: Thursday, July 17, 2003 3:09 PM To: Multiple recipients of list ORACLE-L hi all , how can I read a text file and print line by line. Rgds. Arslan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung INET: [EMAIL

RE: security without using different usernames

Title: Message Consider DBMS_RLS for row level security (or as in some other Oracle marketing-speak has been called the Virtual Private Database.)   Essentially: you create a package/stored procedure function that returns a predicate that can be plugged into a WHERE clause; in your case, in y

RE: ROWNUM -- HOW ARE ROWS SELECTED?

'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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

RE: ROWNUM is driving me nuts - queries suggested produced no res

FROM EMP2 4 WHERE ROWNUM <= 20) 5 WHERE ROWNUM > 10; no rows selected SQL> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Which one is faster ???

TIA Regards Dhanvir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services ---

RE: Which one is faster ???

a Database Function to achieve the same functionality, which one would be faster and why? TIA Regards Dhanvir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Dieg

RE: unique constraint violation problem

- 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 remov

RE: retrieving BLOB

pt--- -Original Message- Sent: Wednesday, July 02, 2003 4:56 PM To: Multiple recipients of list ORACLE-L Hi, I have a file called file1.doc stored in a BLOB column that I would like to retrieve and save it to the filesystem. Can someone post a sample PLSQL code or tell me wh

RE: CASE in PL/SQL

Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services ----- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT s

RE: CASE in PL/SQL

ist, 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). -- P

RE: fine grained access

P command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and w

RE: Tech meetings

Title: Message Don't know if what we do in our shop here qualifies for your question or not, but our dev groups do "stand-up meetings." Relatively quick meetings (that can be done standing up; no meeting rooms required) that are usually finished in about 20 minutes. In the stand-ups, we get

RE: Why didn't datafile autoextend?

ontaining: 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.net -- Author: Rudy Zung INET: [EMAIL PROTECTED] Fat City Network Service

RE: How to get user's IP address?

acle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.c

RE: Outer join in SQL server - A very simple question

= == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --