PL/SQL Question

Hi all, i have 2 tables software and licence. 1 licence can have many softwares. softwares name platform Licence_id abc NT1 def WIN2K1 ghi all 2 i want to

outer join

Hi, Please can anyone let me know on how to deal with the problem where you want to outer join a table to more than 1 tables, at the moment i get error , ORA-01417: a table may be outer joined to at most one other table. Is there another way the results can be achieved? cheers -- Please see

outer join

Hi, im trying to create a view comprising of about 10 tables, trying to join them together.i need a few outer jojns, but i have been told this is not possible, i.e. having numerous outer joins in the where clause.. anyone got any info on these rules for outer joins? cheers -- Please see the

Re: outer join

That is whats happening, e.g. i have (cut down), create view all_data as(select swname ,business ,org,waf from licence l,business b, organisation o,wafs w where l.id = o.id (+) and l.wafid = w.id (+) etc. How can i get around this ?

whitespaces

Hi, What query can i run to to eliminate trailing whitespaces. e.g. i have 'abc ' and want to update the table so any such data is set without the whitespace, in this case 'abc' the fiels is varchar2 8.1.7. cheers -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

changing datatype

hi, i have a column set to NUMBER , i want to change it to NUMBER(10); is there any way of doing this without having to delete the data and avoid the error ORA-01440: column to be modified must be empty to decrease precision or scale using 8.1.7 cheers.. -- Please see the official ORACLE-L

SQL Insert question

Hi , this is puzzling me.. i have following table table name = Sierras. Columns = regno, platfrom, cost , licence_ref renewal_data i split this table up into 2: 1. Softwares cols= id, regno, platfrom, 2. Licences id, cost , licence_ref, renewal_data, i have a third table, a link table

Re: Scrolling Sideways in SQL*Plus

try exiting sql plus and login in again then set the linesize 1000 (e.g.) first before you run anything else [EMAIL PROTECTED]@fatcity.com on 07/02/2002 14:33:40 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL

Re: SQL Insert question

Im afraid i cant answer that question Stephane , as i dont have much to do with the design of this DB... thanks for the query... regards IA Stephane Faroult [EMAIL PROTECTED]@fatcity.com on 07/02/2002 14:53:32 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To:

SQL Loader error

i have these 2 errors in the log file 1.Record 2389: Rejected - Error on table IA_TEST, column COMMENTS. Field in data file exceeds maximum length 2. Record 885: Rejected - Error on table IA_TEST. ORA-01401: inserted value too large for column whats the differennce between the 2? cheers --

RE: SQL Loader error

heres the ctl LOAD DATA INFILE 'sierras.dat' INTO TABLE ia_test trailing nullcols ( SWREGNOterminated by ',' OPTIONALLY ENCLOSED BY '', commentsterminated by ',' OPTIONALLY ENCLOSED BY '') dat file looks something like:

Re: Sql query

Try, select col1 from table1 where col1 not in (SELECT col1 from table2) [EMAIL PROTECTED]@fatcity.com on 21/01/2002 08:55:25 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: How can I write a select

SQL question

Hi i am trying to insert records into a table by selectiog from table 2, i want to insert a sequence,, and the distinct values from table 1 but i get an error: Query used: INSERT INTO contacts (cont_id,cont_contact_surname) (SELECT seq_cont.nextval,distinct delegated_person FROM sierras

Uninstall oracle

As an experiment i tried installing oracle 8 (for NT) on my PC at home (which is win2k)it crashed at an early stage( with some OS error-obviously) How do i uninstall this crashed version? and why does oracle 8i (for NT) install without a problem? cheers all -- Please see the official ORACLE-L

SQL LOADER

using sql loader it is possible to populate fields with a sequnce e.g INTO TABLE dept (deptno sequence(2, 3), but i want to use my own sequence , i.e my_seq.nextval how is this done? reagards IA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL

sql loader-dates

Hi , In my data file i have dates in the format e.g. 12/19/2001, but when loader tries to insert this into the table , the table is expecting date in the format 19-DEC-01 so it rejects the data. What can i do to get around this? regards -- Please see the official ORACLE-L FAQ: