Trigger question

Hallo, I would like to write the code to atrigger that makes insert into another table inly if there is the condition PREFERED_NUMBER = 1 and TELEPHONE_TYPE_ID in (1,2, 5) How can write this in a simple way? Thanks in advance. Roland -- Please see the official ORACLE-L FAQ:

Nextval in trigger

Hallo, I would like to make an insert statement into a table in atrigger, Iam trying to do: Insert into system_change values(system_change_id.nextval) but it gives me an error message which tells me that I havent declared any sequence. How can I fix this ? Thanks in advance. Roland --

Trigger, how?

Hallo all, Anyone whom know how to write the trigger if you just want a trigger to be fired if only two fields in a table is changed, not all of them? Any good example? Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET:

Trigger question

Hallo everyone, I have the table system_change and I I have the insert statement here below be run when there is an update or insert of a value in any ofthe fields ORGANIZATION_NUMBER LEGAL_NAME COMPANY_FORM_ID ORDER_STOP in table COMPANY insert into system_change

Trigger question

Hallo, I have the table system_change and I I have the insert statement here below be run when there is an update or insert of any of the fields ORGANIZATION_NUMBER LEGAL_NAME COMPANY_FORM_ID ORDER_STOP in table COMPANY The script bo be run is this one: insert into system_change

Sql question

Hallo, I have this sql query. I would like to change it so I could pick out the three forst three charachters in the between statements. How can I do that in the most simply way? and vgr in (between 101 and 101) and vgr in (between 104 and 104) order by Avdnr ,Datum1

Unix question

Hallo all of you, Is there anyone whom could help me with the unix command how to find all rows , that doesnt exists try in a file. I mean how to find all rows which doesnt have the characters try in. Maybe this is too simple, but would appreciate anyone whom could give me some quick help.

Question about pl/sql

Hallo, I am trying to create this statement but dont get it work. I would like to check if a field information from table one exists in table 2, and if that exists in table 2, then procedure test_proc would run, Please help me with this. Thanks in advance Roland -- Please see the

Pl/SQL-statement

Hallo, I would like to do the following with an sql( pl/sql) statement. I have table1 and table2 andtable3. I want to check whether field1 in table1 exists in table3. If so then I want an insert statement to be run...insert into table3. If it doesnt find that value then th escript will go

Datatypes

Hallo, I have a table, A: IMPEXCEL_EANNR which contains the field IMP_PRIS(= price) It looks like this: 12 1,50 11 This is a varchar2 field in this table. I want that field values to be inserted(or rather update the other table ) in other table called VARUKORGEANREL, but field in which

Datatype conversion

Hallo, I have a table, A: IMPEXCEL_EANNR which contains the field IMP_PRIS(= price) It looks like this: 12 1,50 11 This is a varchar2 field in this table. I want that field values to be inserted(or rather update the other table ) in other table called VARUKORGEANREL, but field in which

Question about datatypes

Hallo, Maybe this sounds simple for all of you, but I have a table with the field PRICE and that is with datatype varchar2 I want the data in that field to be inserted in another table with field PRICE, but that field has the datatype NUMBER. How can I deasiest do this sql statement? I really

datatypes varchar to number

Hallo, Maybe this sounds simple for all of you, but I have a table with the field PRICE and that is with datatype varchar2 I want the data in that field to be inserted in another table with field PRICE, but that field has the datatype NUMBER. How can I deasiest do this sql statement? I really

RE: datatypes varchar to number

In the varchar2(30) field PRICE , table1 it looks like this PRICE 12,50 37,50 The datype in table 2 is for that field NUMBER(7,2) Hope this would be of anyhelp Rolabd

Datatype conversions

Hallo, Maybe this sounds simple for all of you, but I have a table with the field PRICE and that is with datatype varchar2 I want the data in that field to be inserted in another table with field PRICE, but that field has the datatype NUMBER. How can I easiest do this sql statement? In the

Re: Question about datatypes

Yes but how should I write the sql statement when to make the incoming varchar2 field into a number? Roland Mladen Gogala

Question about sql

Hallo, Anyone whom could gíve me some good help on this. I have a table with one field, called Company_id Like this Company_id 16 45 50 In table 2 I have this field and values: Company_id Lev_idVare_id 16 45 56 34

Questiuon about unix

Hallo everybody, anyone whom can tell me what the command is to search for an empty field in a unix file. for instance if you want to find the empty spacelines if some lines looklike: 1;100;Name;; 2;200;Test;45; 3;300;Name;; I would like to find out line nr 1 and 3 here above. Anyone whom

logg error line in unix

Hallo again, I would like to get some help on this. I have a script called let us say test.sh and that script runs an sqlloader script, which loads semicolonseparated data into an oracle table. I would like to have an example on how to log an error when trying to insert the data intothe table.

RE: logg error line in unix

Please give me an example on this. Roland Jack van Zanen

Cron question

Hallo, anyone whom could help me with this. I am trying to use crontab -e to start a procedure. but I cant get it right. Anyone whom could help me with the command how to write if I want a program in unix to be scheduled to run every monday at 6 o´clock in the morning? Thanks in advance.

Question about unix

Hallo everyone, I have a unix question, hope you can help me. Maybe this is too simple but would appreciate any help. I would like to rename the files konkurrenter.txt.1,konkurrenter.txt.,,konkurrenter.txt.3 to be renamed to konkurrenter.txt at the same time. So the result would be 3 files,

How to give permission

Hallo, anyone whom could help me with a unix command how to give permission to delete files from a special directory? I am trying to use chmod command but it doesnt work with chmod 755 It says permission denied then. Thanks in advance Roland -- Please see the official ORACLE-L FAQ:

Sqlloader question

Hallo, Anyone whom could tell me if it is in an sqlloader possible to write for instance this if you dont know the exactly name of file. infile '/d31/datafiler/sema/incoming/konkurrenter.*' If there are going to be files with different extensions fo rinstance the first time a file is going to

Sql loader

Hallo, Anyone whom could tell me if it is in an sqlloader possible to write for instance this if you dont know the exactly name of file. infile '/d31/datafiler/sema/incoming/konkurrenter.*' If there are going to be files with different extensions fo rinstance the first time a file is going to

Question about Constraint

Hallo, I would like to gets ome help on this: I have this table IdCompanynumber First Name LastNameType 1 123 Jim Andersson 1 2 234 Tom Perkins 2 3 565 Henry Ford1 I would like to

Exact fetch

Hallo, anyon who can tell me whatthis mean`? I get it while I am trying to load some data in some tables? ORA-01422: exact fetch re turns more than requested number of rows Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

Question about cursors

Hallo, I would like to get a goood example on how to do this in a pl/sql block, maybe this is too simple but I cant get it work. I would like to do a select from table A, like this select id from A where id 10 This sql statement gives me about 10 rows. I want those rows(the id) to be

Question about sql

Hallo, I would like to pick out distinct both of the field Code and Id from this sql statement? Anyone who has an example of this? Maybe this sounds simple but really appreciate somehelp. I have this query, Select code, id, name, address, city, year, and would as told like to have distinct of

Create index script in pl/sql

Hallo all, anyone whom could help me with this: I would like to have an example of pl/sql procedur which does the following: CREATE INDEX ART_HIERARKI_LOCKEDIX1 ON ART_HIERARKI_LOCKED(SELSKAP, SETT_ID, VGRP, ART_GRP, ART_UGRP) TABLESPACE PBKIX PCTFREE 10 STORAGE(INITIAL 65536 NEXT

Anyone whom could explain this?

Hallo, anone whom could explain what new. means in this pl/sql procedure. for instance: new.kundeoms := new.kundeoms + (in_diff); new.mva := new.mva + (in_diff_mva); How do I get hold of it so i can see which sql it runsor is new.kundeoms just a value from a table?

What is wrong with this?

Hallo, I have this sequence, CREATE SEQUENCE SYS_STORE_ID START WITH 1 INCREMENT BY 1 NOMAXVALUE NOCYCLE CACHE 10; I am trying to run this script, sys_store_id.nextval: but get this errormessage: unknown command beginning SYS_STORE_... - rest of line ignored.

Unix command

Any one whom could help me with grep command. I would like to catch all files in a directory which ends with .txt The files in the directory that fits that condition is: ia123456.txt ia654321.txt How should I write the unix command? Thanks in advance Roland -- Please see the

Questions about constraints

Hallo, I get this errormessage while inserting to this table. How can I check this constraint problem? Any wrong with the table definition 9.03.2003 09:46:38 Db_Transfil.AVSTEM - ORA-2: db_filtype_ik.AVS TEM: - ORA-2: db_filtype_ik:OVERFOR_TIL_KUN:

Force to use a tablespace

Hallo, anyone who knows how to force a table to use a special tablespace? Thanks in advance. Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,

Ftp command

Hallo, anyone whom can tell me how to write ftp command to connect to a port at an ip-address? Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Sql query

I have this sql query. I am wondering why this query takes so long time, Do I need more conditions to make it run, or it it just that this query take so long time to run? Anything wrong with the query? Please help me with this. SELECT distinct PBK.VARUKORGEANREL_ULAG.ean, 0, 0, 0,

Delete duplicate records

Hallo, I have this sql, SELECT * FROM varukorgtmp where varukorgid= 120 That makes the result of this testfile.xls (See attached file: start.xls) There are two values in EAN-field, which are the same 23324614 in row 2 and 3 Now I want in an sql script to check out which are the duplicates

How to delete duplicate records with condition

Hallo, I have this sql, SELECT * FROM varukorgtmp where varukorgid= 120 That makes the result of this testfile.xls (See attached file: start.xls) There are two values in EAN-field, which are the same 23324614 in row 2 and 3 Now I want in an sql script to check out which are the duplicates of

Delete duplicate records with condition

Hallo, I have this sql, SELECT * FROM varukorgtmp where varukorgid= 120 That makes the result of this testfile.xls (See attached file: start.xls) There are two values in EAN-field, which are the same 23324614 in row 2 and 3 Now I want in an sql script to check out which are the duplicates

Anyone knowing about Unix groups

Hallo, anyone whom knows about any website where you can ask questions about unix and shell-programming? Thanks in advance. Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Ltrim?

Hallo, Anyone whom could help me how to write in cron when scheduling the start of a unixprogram. I would like that the unix script will run every monday on 6 am. I have tried but it fails. Any suggestions, please help Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Count rows in textfile

Anyone whom has a good example on how to check how many rows (without opening the file) does a text file consists of? What is the command? Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network

Unix - scheduling

Hallo, anyone who has a good example on how to write in the crontab if you want to schedule a job to run every four week. Is it possible to do that in unix cron job schedule. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL

SQLLOADER - please help

Hallo, anyone whom can help me with this: I am running sqllodaer and gets this errormessage in the log: Record 18729: Rejected - Error on table RIK2.IMP_NIELSEN, column MONTH_DISTR_W Column not found before end of logical record (use TRAILING NULLCOLS) ORA-01631: max # extents (20) reached in

Sql query

Hallo, anyone whom can give me an example on how to pick out field id and name from table one and get only the id's that exists in table one doesnt exist in table2. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL

Question about sql loader - help

Hallo all you gurus, I have a question: Is it possible that every time the sql loader script runs change the field names to the field names specified in the file to be loaded.: The field names should be different dates. The next time the script sqlloader run sit will be a new field name,

Pl/Sql renaming columns

Hallo, Anyone who has any good hint on how to write pl/sql if i wantto chang ethe name of the fields everytime the procedur runs? The field names should be 1-JULI-2002 the first time the procedur runs, the next time the procedur runs the name of procedur should be 1-AUG-2002 etc. Please help

Sql loader question

Hallo I am running this script but gets this errormessage: Why is it so? I get the errormessage The system cannot find the file specified.(I:dvh\tuppy.txt) but this file really exists: What is wrong. I include the textfile and also the ctl file. (See attached file: nielsen.ctl)(See attached

Textfile into oracle

Hallo, I have this excelfile. Is it possible to import this into an oracle table. This file is supposed to be located on unix machine from the beginning and the import into an oracle table would be done from unix. How should I name the fields in the oracle table. I mean should I use the 9-10

Ang: Re: Textfile into oracle

Could anyone please give me an example on how the sqlloader script would look like , How many fields would it be,? I cant find anything ofthis in themanual. I have 100 fields in the excel file but only 9-10 field names... Thanks in advance Roland Alexandre Gorbatchev [EMAIL

Oracle - Access

Hallo, anyone who has a good hint on this: I have an appplication which goes against Oracle and when I am inthe application and run VBA code which connects to linked tables everything works fine. But when I have an icon on the desktop and runs that icon as shortcut then I get error messagelike

pl/sql

Hallo, I have a package which includes 5 different procedures. I would like an exception which tells me an error message if any of the procedures fail. So if procedure 1 fails I would get an error message or if procedure number 2 would fail, or proc number 3 e tc then I would get an error

Ms Access user forum

Hallo, any one whom knows how where to find a good MsAccess user forum where I can ask questions? Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Cronjob

Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh /d31/appl/konto/log/laddabilbo.log 21 Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Constraints

Hallo, I am trying to run this script, ALTER TABLE PBK.K1 ADD CONSTRAINT idx_rollson PRIMARY KEY (BUTIKS_NR) but gets the erormessage ORA-02437: cannot validate (PBK.IDX_ROLLSON) - primary key violated what can I do to solve this? Please help me. Wouldnt it be enough to have unique values

Cronjob

Anyone whom can tell me how to delete a job that is created by crontab. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Send mail from PL/SQL

Hallo, anyone whom can help me. I would like this code to send email to two recipients, what is missing? Thanks for all help I can get. PROCEDURE sendmailtestny2( inRecipient1 IN VARCHAR2, inRecipient2 in VARCHAR2,

Ang: RE: Send mail from PL/SQL

it helped with CC: Thanks /Roland Abdul Aleem [EMAIL PROTECTED]@fatcity.com den 2002-04-19 03:48 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: In Outlook, when I put two addresses in TO or CC or BCC

Import excelfile into Oracle table

Hallo, anyone who can give me a good example of pl/sql code, which does the folllowing: Import an excelfile into a table. (I know I can use sqlloader(which I have used several times) but i would like to make a call to that pl/sql procedure from MsAccess. Thanks in advance Roland --

Ang: Re:Import excelfile into Oracle table

Ok, thanks can you give me a good example on how to write the pl/sql code? Thanks in advance. Roland [EMAIL PROTECTED]@fatcity.com den 2002-04-18 01:10 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia:

Unix - need some help

Hallo, I have this unix script, please tell me how to change it so it also does the following: (See attached file: laddabilbo.sh) counts the time between start time and end time of the process(I mean time difference between Jobb startat(Job started) and Job Klart(Job Finished). IThis log

Unix help

I have this unix script, please tell me how to change it so it also does the following: counts the time between start time and end time of the process(I mean time difference between Jobb startat(Job started) and Job Klart(Job Finished). loadbilbo.sh: #!/bin/sh . /usr/bin/orasetup.sh .

Unix script

Hallo, I have this unix script, please tell me how to change it so it also does the following: (See attached file: laddabilbo.sh) counts the time between start time and end time of the process(I mean time difference between Jobb startat(Job started) and Job Klart(Job Finished). IThis log

Utl_file

Hallo, Is it possible to do a select from some tables in the database and then use utl_file package to create an excel file. And also to make the headers in the columns bold and right positioned. Please give me an easy example on how to write the code. Thanks in advance Roland -- Please

Pl/sql question - if statement

anyone whom can tell me why this statement fails in a pl/sqll code: I get this error message PLS-00103: Encountered the symbol ||AvdNr|| when expecting one of the following: . ( * @ % = - + / at in mod not rem then an exponent (**) or != or ~= = = and or like betwe when i run

Ang: RE: Pl/sql question - if statement

Yes but then it fails onthe word borttags_flagg, thi serrormessage : PLS-00103: Encountered the symbol BORTTAGS_FLAGG when expecting one of the following: . ( * @ % = - + / at in mod not rem then an exponent (**) or != or ~= = = and or like I reallydont see what the error is:

Pl/SQL code help

Hallo, I have some trouble with this pl/sql procedure. I would like that this lvsql to be run only if the field Borttags_flagg = 0 but i get an error in the if statement, whatis wrong with this? It get the erromressage: LS-00103: Encountered the symbol ||AvdNr|| when expecting one of the

PL/SQL help - need some quick help

Hallo, I have some trouble to get this pl/sql code right. Anyone whpom could help me with this. It is important. Hallo, I have some trouble with this pl/sql procedure. I would like that this lvsql to be run only if the field Borttags_flagg = 0 but i get an error in the if statement,

Ang: RE: Pl/SQL code help

But when I have fixed that error and then have the then statement put before the lvsql statement I get this errormessage: What does that mean? How to fix it? PLS-00103: Encountered the symbol THEN when expecting one of the following: ( - + mod null an identifier a double-quoted

Ang: RE: Send mail from pl/sql

I am using Notes mail system Roland Abdul Aleem [EMAIL PROTECTED]@fatcity.com den 2002-04-05 01:18 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Which mail client are you looking it for. If it is for

Copy tables and indexes etc from one db to another

Hallo, anyone whom can tellme the easiest way to copy tables etc from one database to another. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Pl/SQL debug

Hallo, I am trying to insert things into the table PRISREGISTER_KOPIA_WED but why doesnt the insert statement work. It says Missing expression when the insertstatement runs and when i look at the sql code which is trying to be run to insertinto the table it says just missing expression and it

PL/SQL again

I sent the wrong pl/sql code in last message. I want the field BORTTAGS_FLAGG to be inserted in prisregister_kopia_wed. (See attached file: regicarol.txt) What is missing? Thanks in advance Roland S regicarol.txt Description: Text - character set unknown

Trigger question

Hallo, What is wrong with this trigger: I want the trigger to fire(to run the statement : UPPER(SUBSTR(:OLD.namn, 1, 1)) || SUBSTR(:OLD.namn,2); after new record is inserted in this table. The thing to happen should be this: I want that script to be run on the same record that has been

Trigger question

Hallo, anyone who can please helpme with a trigger script that does the following: I want this script to run when I have updated a field in a table. update test set namn = upper(substr(namn,1,1) || substr(namn),2) I want this trigger to fire only for the selected record(row), that is going

Make first character Versal

Hallo, I know this question sound a bit simple, but can anyone give me a select statement which make the first character of the word in a field Would appreciate very much. I have checked the manual but cant get it right. I am starting with this sql statement: select (substr (namn,0,1)) from

Ang: Re: Make first character Versal

I found out what was wrong: wanted to do an update too... update test set test = upper(substr(namn,1,1)) || substr(namn,2) then my update worked Roland S Jan Pruner [EMAIL PROTECTED]@fatcity.com den 2002-03-27 04:23 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL

PL/SQL - procedure

Hallo, Can anyone give me an example on a pl/sql code, which does the following: I have 4 procedures, and I want the following to be logged in a status table. Procedure names Start_time of procedure End_time_of procedure Error_code(if anything goes wrong) Error_message Please give

Create info about table definition

Hallo, is there any way to create a table of the definition of table( list of field names and their datatypes, indexes etc) Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services--

PL/SQL - procedur

Hallo, Can anyone give me an example on a pl/sql code, which does the following: I have 4 procedures, and I want the following to be logged in a status table. Procedure names Start_time of procedure End_time_of procedure Error_code(if anything goes wrong) Error_message Please give me example

pL/SQL PROCEDUR

Hallo, Can anyone give me an example on a pl/sql code, which does the following: I have 4 procedures, and I want the following to be logged in a status table. Procedure names Start_time of procedure End_time_of procedure Error_code(if anything goes wrong) Error_message Please give me

Sql loader - schedule

Hallo, How is it possible to schedule an sql loader script, which is running on network(not unix). Let us say this should run at 6 pm every day. This sqlloader simply loads a textfile into a table in the database. Thanks in advance Roland -- Please see the official ORACLE-L FAQ:

MsAccess group

Hallo, anyone know knows any webpage where I can ask MsAccess questions about error messages? Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Copy files to hard drive from unix server

Hallo, anyone who can give me an easy example on a unix shell script that copies files from a unix directory /test/files to the hard drive directory c:\temp Thanks in advance. Would appreciate very much. Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Unixscript

Hallo, Anyone who has a good example on a unix script, which does the following: Copies files from a unix directory. to the hard drive, for instance from the directory /konto/test to the hard drive C:\temp Would appreciate this if you could help me with this. Thanks in advance Roland --

From MsAccess to Oracle

Hallo, Please tellme how to write the MsAccess procedure to call the pl/sql procedure proc_konk, I am not using ADO in MsAccess The pl(/sqlprocedure looks like this: Procedure proc_konk (v_butiks_nr in pbk.konkurrentbutik.BUTIKS_NR%type, v_namn in pbk.konkurrentbutik.NAMN%type,

Call PL/SQL from MsAccess

Hallo, anyone whom can give me an example onhow to write an MsAccess procedure which make a call to a pl/sqlprocedure. I want the MsAccess procedure send 5 parametsrs through to pl/sql. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

MsAccess calling PL/SQL

Hallo, anyone whom can give me an example onhow to write an MsAccess procedure which make a call to a pl/sqlprocedure. I want the MsAccess procedure send 5 parametsrs through to pl/sql. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

MsAccess to Oracle

Hallo, anyone who has an example on a Ms Access procedure that makes a call to a pl(/sql procedure? My pl/sql procedure does an insert of oneline into the database.Or anyone who can tell me where to get help on this. Thanks in advance Roland S -- Please see the official ORACLE-L

Download a database

Anyone who knows ifthere is a possibility to download some edition of oracle database to your harddrive? I am running Windows 2000 Millenium Edition. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City

Book suggestion

Hallo, Is there anyone who knows about any book which deals with the connection Oracle(PL/SQL) and Access.. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

Ang: RE: How to find out what caused job to fail?

But how do I use the alert log and where canI find the trace file? Roland [EMAIL PROTECTED]@fatcity.com den 2002-02-04 01:05 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Hi, you can find the reason

Pl/sql - shell script

Hallo, is there anyone who can tell me if it ispossible run unix shell script from PL/SQL Anyone who has a good example too that I can use. Thanks in advance. Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network

Pl/sql question

Hallo, anyone who canhelp me with this? I have PL/sql procedure and if something goes wrong I would like the following things to occur. Please help me with them If some errors occur I want this to happen. - pick out the name of the procedure thatis currently running, -pick out the start_time

Ang: RE: Pl/sql question

Oki thanks for info can you please show me an example with autonoumus transactions? Please. Thanks in advance Roland [EMAIL PROTECTED]@fatcity.com den 2002-01-28 03:30 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL

PL/SQL

How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City

Access support

Hallo, anyone who knows about a website with good Access tips? Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--

Ang: Re: RE: Pl/sql question

Ok sorry i found out this answer myself:-) Igor Neyman [EMAIL PROTECTED]@fatcity.com den 2002-01-28 08:25 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Roland, With this sort of questions, you are

Ang: RE: sqlplus question

Well, you can check the manual but use the package dbms_output.put_job that willfix it when you are inoracle but ifyoua re in unix environment you must use crontab Hope this is of help for you Roland Weaver, Walt [EMAIL PROTECTED]@fatcity.com den 2002-01-28 14:45 PST Sänd svar till

  1   2   3   >