Transparent Gateway Question

Title: Transparent Gateway Question Hello all, I have a problem inserting data from a local 8.1.6 table into a Sybase table through the Transparent Gateway. I first used 'insert into sybs_table select * from local_table' which gave an ora-02025. I just rtfm and saw that I need to use th

RE: [Q] exp from 8.1.7 and import to 8.1.6?

de 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: Woody McKay INET: [EMAIL PROTECTED] Fat City Net

Need Good OUTER Join

Title: Need Good OUTER Join Hello all, I'm having trouble figuring out the proper Outer join (duplicate titles) for the following: I need a list of all the page_id (id's) and page_title (titles) from PAGES along with the security_id from USERS_X_PAGES where the user exists.  USERS_X_PAGES

RE: Need Good OUTER Join

SQL     60 State Group Insurance  SQL    SQL     57 State Purchasing   SQL    SQL     59 Supplier Diversity SQL    SQL 20 rows selected. [Woody Mckay]  There are three tables involved: USERS - user_id PK USERS_X_PAGES - us

RE: Need Good OUTER Join

Good OUTER Join What's wrong with the output you see? Do you not like the results because you are seeing rows where u.user_id is != 5 ? >-Original Message- >From: Woody McKay [mailto:[EMAIL PROTECTED]] > >I'm having trouble figuring out the proper Outer join

Selecting into Var with no recs returned

ideas? SELECT my_id INTO v_temp FROM my_tablee WHERE my_id = v_number; IF SQL%FOUND THEN p_error_code := 100; RETURN; END IF; TIA, Woody -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Woody Mckay INET: [EMAIL PROTECTED] Fat City Ne

call stored procedure from a stored procedure

http://www.orafaq.com -- Author: Woody Mckay 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 ma

How to test for all digits in string

Hello gurus, Could someone tell me the best way to check a string to ensure that it contains all numeric digits before converting it to a number with to_number? I don't see a function like ISNUM. TIA, Woody -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

How to drop a database

http://www.orafaq.com -- Author: Woody Mckay 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

ORA-12545 client with multiple listener service handlers

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