RE: comparing null values

') 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 -- Author: Witold Iwaniec INET

Using connection of another user

the APP_USER's connection to run queries, make changes etc. Can, what I am looking for, be done? If yes, could you pass references to some info? Thanks Witold -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services

RE: Using connection of another user

connection to run queries, make changes etc. Can, what I am looking for, be done? If yes, could you pass references to some info? Thanks Witold -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Automatic backup on Oracle 9i -- For Jared

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: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Oracle traffic

send over the network including the packets info, address, etc. I wonder if I could get the numbers just for the data? Thanks in advance Witold == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see

Oracle licensing

Hi There have been some postings related to Oracle licensing. An interesting article: http://www.sacbee.com/content/politics/story/2219532p-2613285c.html Witold -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City

RE: Good Article on differences between ORACLE and SQLServer

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Do programmers tune SQL?

. It took almost no time at all to rebuild it. And it happened in a test database. I understand restrictions in production databases but more access to development and test would make life easier and am sure more happy faces around. Witold == Witold Iwaniec Sr

RE: Make first character Versal

). == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

PO 9i and Windows Me

issue Thanks Witold == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network

Re: outer join

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official

SQL Loader and decimals

== Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: selecting on time

I need to do a select based upon the time element in a date column. i.e, eg where the time is greater than 14:00 Can anyone provide an example of how to do this? John -- == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED

Rollback Segments

Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Unbreakable Oracle - Metaslink

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: OT : howto RTFM

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). == Witold Iwaniec Sr

RE: Raw I/O

it, is there really a performance gain? Any other pros, cons? I have seen some info on Metalink but real life often is quite different... Thanks Witold == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http

Raw I/O

Hi all I am looking for some real life opinions about Oracle raw I/O - are people using it, is there really a performance gain? Any other pros, cons? I have seen some info on Metalink but real life often is quite different... Thanks Witold == Witold Iwaniec

RE: Becoming a DBA questions

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: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services

Re: using hints on views

may also send the HELP command for other information (like subscribing). == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold

Re: using hints on views

V1, which is referenced in the view V2. The second hint specifies a full table scan for the department table referenced in the view V2. Note the dotted syntax for the view tables. --- Witold Iwaniec [EMAIL PROTECTED] wrote: I had to use hints inside views number of times and it worked

Little OT: CLOB, Oracle Text, and ADO

be specific to ADO I wonder if some Oracle gurus know, or can direct to some info, why Oracle doesn't update the ctxcat index even though the record is written and apears correctly. Witold== Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED

Re: Little OT: CLOB, Oracle Text, and ADO

Jared Witold Iwaniec wiwaniec@novali

RE: Little OT: CLOB, Oracle Text, and ADO

Witold Iwaniec wiwaniec@novali To: Multiple recipients of list ORACLE-L

Re: Create a database without using DbAssist

://www.orafaq.com -- Author: Witold Iwaniec 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

Oracle text and CLOBs

. Can anyone explain this? Thanks Witold == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED

Re: Database link

the US.ORACLE.COM suffix. I don't care too much about the database, it's my test only, but don't want it appended in the links and maybe other objects... Thanks Witold == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL

Database link

== Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Adding intermedia Text to 8.1.6 database

so all the libraries must be installed. But search for file libct*.so on all my hard drives returns nothing. Something else must be used... Thanks Witold == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com

Re: Adding intermedia Text to 8.1.6 database

returns nothing. Something else must be used... Thanks Witold == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold

Commit trigger

event? Thanks Witold -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Commit trigger

be fired only at COMMIT and/or ROLLBACK event? Thanks Witold -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: OT -- the volume of job postings is way down

Another sign of the times is that ITI is closing its US schools. For those who don't know - it is a computer training school. They started years ago as a school in Atlantic Canada offering a 10 month course. Later they expanded to few Canadian and US cities. Last year they advertised on TV and

Re: Version of personal oracle that runs on Window ME

to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Witold Iwaniec/ATL_BLUECROSS_CA) Hi All, Does anyone know where I can get/download copy of Oracle that runs on Window ME I downloaded 8i for 98 but BSOD. Thanks Rick -- Please see the official ORACLE-L

RE: Version of personal oracle that runs on Window ME

On this site you can find the steps - it solved my problem with installer http://www.orafaq.com/msgboard/windows/messages/209.htm Witold Cale, Rick T (Richard) [EMAIL PROTECTED] on 07/31/2001 13:58:07 To: Witold Iwaniec/ATL_BLUECROSS_CA@ATL_BLUECROSS_CA cc: Do you know what

OT: Encryption software

Hi We are looking for a product that can be used to encrypt an Oracle report. In short a process will run a report, the file will be encrypted, and sent by email. And we would like to be able to use the product from command line so that the entire process can run automatically. I have already

Re: Privilege problem ?????

] on 07/10/2001 20:00:29 Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Witold Iwaniec/ATL_BLUECROSS_CA) Hi all, I wrote a script for developers to run. I have svrmgrl, connect internal in the script. The developer got error since he

Re: need to recreate database

Lyuda That's not terribly difficult and you mentioned registry so I guess it is NT. Make sure the files were copied after the original database was shut down. The easiest way would be to reinstall Oracle and create the default database with the same SID as your original database (maybe you

Re: Date / Time

Hi The script below may help you - it will display different components in separate columns, modify it with your two dates and proper table name and remove what you don't need select sysdate, sysdate - to_date('0307200100', 'DDMMHH24MISS') diffr, trunc(sysdate -

Select only one of three tables

Hello list I have a scenario in which I have to check three tables. If there is record in table A, take it otherwise check table B, if there is record in table B, take it otherwise check table C. Let say I am looking for DEPT column and the tables are DEPT_ONE, DEPT_TWO, and DEPT_THREE. At

RE: Select only one of three tables

ORACLE-L [EMAIL PROTECTED] cc:(bcc: Witold Iwaniec/ATL_BLUECROSS_CA) Witold, have you tried using the UNION operator? like: select dept from dept_one union select dept from dept_two union select dept from dept_three order by 1; this will give you only one occurrence of the value of dept

RE: Select only one of three tables

] on 07/03/2001 14:17:41 Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Witold Iwaniec/ATL_BLUECROSS_CA) Hi Witold, Try this: select * from ( select dept from dept_one union all select dept from dept_two union all select dept from

Java, Vector, and PLSQL

Hi In a web application taht I write in java I need to pass a number of parameters to a PL/SQL stored procedure. Since the number of parameters can be different a Vector, ArrayList, or HashTable on the java side would be a good choice. Can you pass a Vector to a PL/SQL stored procedure? If I

RE: TRUNCATE IN PL/SQL

Not 100% sure but I think only the table owner can use TRUNCATE Witold Raymond Lee Meng Hong [EMAIL PROTECTED] on 06/21/2001 01:10:52 Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Witold Iwaniec/ATL_BLUECROSS_CA) Got

RE: SyncSort - Unix - Datawarehousing.

Lange [EMAIL PROTECTED] on 06/15/2001 09:51:52 Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Witold Iwaniec/ATL_BLUECROSS_CA) -Original Message- Hi, I want some informarmation about SyncSort for Unix. If anyone is using

RE: SyncSort - Unix - Datawarehousing.

Rajaram Look at inline comments Rajaram [EMAIL PROTECTED] on 06/15/2001 12:16:08 Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Witold Iwaniec/ATL_BLUECROSS_CA) Hi, Thanks Witold for the info. I have some more Q's. 1

Full user export

Hi DBA's What is the proper syntax of the exp command to get export of all objects owned by a user - tables, views, stored procedures, synonyms, grants. And will the import require special parameters too? I have a small development database on Windows NT and would like to create a copy on

Re: What columns are in the Primary Key

://www.toadsoft.com) and you can find a lot through database - Schema Browser HTH Witold Helmut Daiminger [EMAIL PROTECTED] on 05/10/2001 14:22:34 Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Witold Iwaniec/ATL_BLUECROSS_CA) Hi

RE: date+time in milliseconds

If you get milliseconds in the data and want to keep it, you have to store it in a field different than date, If you don't need to keep the milliseconds, you can use different functions to convert the data. If you need to get the time in milliseconds, you can write a Java stored procedure. You

RE: Performance of views

in different ways. IN the final result the view select statement may be slow but the select statement from the view has to be fast. If you need more details, let me know HTH Witold === Witold Iwaniec IT Consultant [EMAIL PROTECTED] Hi! Some of our developers are having concerns

Re: call stored procedure from a stored procedure

Witold Woody Mckay [EMAIL PROTECTED] on 05/03/2001 12:25:49 Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Witold Iwaniec/ATL_BLUECROSS_CA) Please help, Sorry if this sounds like a dumb question but I'm having a hard time finding

Oracle Reports

Is there a version of Reports that runs on Windows Me? You can download only reports for NT, Sun, and Linux. Thanks Witold -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Oracle Reports - SQL

Hi I started to work with Oracle Reports (2.5.5). My first task to maintenance of existing reports. On one of them I need to change the SQL - whenever I change it, the data model changes - some columns get moved between groups. Is it the reports' behavior or do I miss a setting? Thanks

RE: sql*loader default value

bvious please let me know... the sql*loader documentation seems designed to confuse. (-: Cheers! ========== Witold Iwaniec Senior Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: h

Re: olap?

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

OLAP again

== Witold Iwaniec Senior Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

OLAP info

Hi all I would like to learn about OLAP in Oracle. I have looked at OTN and found Express Objects and other Express ... tools. Is it a place to start or someone can recommend something better Thanks Witold == Witold Iwaniec Senior Software Developer

Re:

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). ====== Witold Iwan

Columns in triggers

of each column and if it is not NULL write the log, and on UPDATE I can compare the NEW and OLD values and write the log if different but wonder if there is better/nicer solution. Thanks Witold == Witold Iwaniec Senior Software Developer NovaLIS Technologies

Invoking svrmgrl

? Or maybe there is another way - in my application I am already connected to the database using ODBC API. Thanks Witold == Witold Iwaniec Senior Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official

RE: Invoking svrmgrl

@s2.sql eof s2.sql = connect system/manager @my_sql.sql eof my_sql.sql select * from scott.emp / exit / eof -Original Message- From: Witold Iwaniec [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 7:16 PM To: Multiple recipients

RE: Anyone using CA products?

-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists