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, yo

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

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 Netwo

Unix script

Hallo, I have this unix script. I would like to include code which checks if the oracle database is up and running so the procedure konto.fillbotables.anrop doesnt start at all.. I also want an errorlog file to be created. Please tell me how to write the code and where to include it in this she

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

Unix question

Hallo, I have this unix script. I would like to get a errorlog(a file) if the pl/sql procedure konto.fillbotables.anrop doesnt start at all. Please tell me how to write the code and where to include it in this shell script. Give me example on how to write the code too. #!/bin/sh . /usr/bin/or

Ang: RE: Unix script

yes, but please help me with that. Thanks roland "Boivin, Patrice J" <[EMAIL PROTECTED]>@fatcity.com den 2002-01-27 02:30 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Kopia: Well, how about just putting

Unix script

Hallo, I have this unix script. I would like to get a errorlog if the pl/sql procedure konto.fillbotables.anrop doesnt start at all. Please tell me how to write the code and where to include it in this shell script. #!/bin/sh . /usr/bin/orasetup.sh . /d31/appl/konto/bat/movefiles.sh sqlldr

Pl/sql help needed

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

Pl/sql help needed

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_tim

Ang: Re: Unisx question

Well doesthat answer reply to the question: I have for instance this script /konto/load.sh that line is included in the main unix script and I want it to be logged if that script( load.sh ) doesnt start at all. which is includedin the main unix Thanks Roland Steven Lembark <[EMAIL PRO

Unisx question

Hallo, Can anyone give me a good script on how to create a logfile in unix directory if a file(a script) in this script is not executed? Please help me. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City

Need some pl/sql help

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: Number_of_rows

Yes But I want thatthat number is inserted into the table. [EMAIL PROTECTED]@fatcity.com den 2002-01-25 10:39 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Kopia: Use SQL%ROWCOUNT. BEGIN insert in

Number_of_rows

Hallo all you gurus, How can I write in the pl/sql code if I want to insert in a table the number of rows that are inserted in the select statement in the procedure? Give me a good example, please. Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -

How can i receive name of the running procedure

Hallo, How can I select the name of the procedure, which is running.? I mean I am running a procedure and I want the name of the pocedure to be inserted in a table. Please help me with a simple pl/sql script on this. Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http:

Ang: RE: Access to Oracle

Can you please guide me how to do all these steps? Roland "MacGregor, Ian A." <[EMAIL PROTECTED]>@fatcity.com den 2002-01-24 08:15 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Kopia: Whose ODBC DRIVER are

Ang: Re: Ang: Re: PL/SQL procedure - error

But which query asks for the start date of the procedure an dwhich selectstatement is to display th etime when th eprocedure starts. Roland [EMAIL PROTECTED]@fatcity.com den 2002-01-22 08:25 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of l

Access to Oracle

Anyone who can help me with this: I have a Microsoft routin, whic calls oracle procedure in database "servername", which have a databaselink to other databases(located on computers with Linux system).That procedure is supposed to pick up data from tables which exist in the other databases.

Start - end time of procedure

Hallo, any one who canhelp me? How can I find out which time a pl/sql procedure starts and which time it ends?(Ends by any reason at all). Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Ser

Unixscript

Hallo, How can I change this unixscript so if the PL/SQL procedure konto.fillbilbotables.anrop;doesnt start for some reason, then I want a logfile to be created in a directory. 2002-02-23starterror.log. The message in that logfile could be for instance "The procedure didnt start today, some

Ang: Re: PL/SQL procedure - error

Thanks, and can you please tell me how to get hold of the time when the procedures starts and finishes.? Thanks in advance. Roland "Pullikol Kumar" <[EMAIL PROTECTED]>@fatcity.com den 2002-01-22 04:40 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple r

PL/SQL procedure - error

Hallo, anyone who can help me with a pl/sql procedure that I have four procedures that will run one after one: in an error table logs the procedurename, the start time of the procedure and the end time of the procedure.the number of rows inserted(there are insertstatements in the procedures),

Unix - errorlog

Hallo, How can I change this script so if the PL/SQL procedure konto.fillbilbotables.anrop;doesnt start for some reason, then I want a logfile to be created on the form: 2002-02-23starterror.log. The message in that logfile could be for instance "The procedure didnt start today, some problems

Sqlloader

Hallo all you gurus, Anyone who can help me with this: I have this unix script: In the script I wamt to create a logfile for every day that I run this script so that thel logfile will look like: 2002-02-22laddabsg.log and when i run the script tomorrow I want it to be: 2002-02-23laddabsg.log

Error handling

Anyone who can help me with this: I have 3 procedures which run one after one. Those 3 procedures does insert statements in tables in the database. Can anyone give me a good example on how to write the code to trap errors when the procedures fail. I want to log in a table, the name of the proc

From Access to Oracleprocedure

Anyone who can help me with this query? I have a Microsoft routin, whic calls oracle procedure in database "servername", which have a databaselink to other databases(located on computers with Linux system).That procedure is supposed to pick up data from tables which exist in the other databa

Ang: Re: How can I tell if a procedure/package is running?

Can anyone give me a good example on how this works? Thanks in advance Roland Connor McDonald <[EMAIL PROTECTED]>@fatcity.com den 2001-10-25 01:45 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Kopia: I

Ftp command

Hallo, anyone whom can tell me how to write the ftp command if I want to receive all files in the unix directory to the hard drive without to need reply yes for each file. using the command mget I suppose but ar ethere any options I might use. The same question if i want to copy files from hard

Ang: Re: Sql query!!

please explain i tried that but didntget it to work please give me an example [EMAIL PROTECTED]@fatcity.com den 2002-01-21 05:30 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Kopia: You may also need nis

Sql query!!

Hallo, Will this query work if I want to pick out the field id from nisse1, and that field doesnt hgave a value in nisse2. If it doesnt work please help me. select nisse1.NAMn, nisse1.id from nisse1, nisse2 where nisse1.id= nisse2.idn(+) and nisse1.namn = nisse2.name Thanks in advance Rol

Sql query

How can I write a select statement, which picks up a field in table1, that doesnt exist in table2. Thanks in advance Roland S -- 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

Unix question

Hallo, why do I get the error message "No such file or directory". when I try to run unix script loadfiles.sh which is located in the directory /konto/tmp. This file, loadfiles.sh really exists in that directory. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://

Unix - copyscript

Hallo, Can anyone tell me why I get this errormessage when I run this script. I know that there are files in the directory prod/sas/data/bilbo/indata Files that exists in that directory are for example customer.txt, cars.txt. I want to copy those files. But it doesnt sem to find them. The er

Ang: RE: Unix - script

So I have to use the ip-addresses? I cant use the name of the computer, for instance hakon5. Thanks in advance Roland "Gogala, Mladen" <[EMAIL PROTECTED]>@fatcity.com den 2002-01-09 07:11 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of l

Unix - script

Hallo, I would like to have an example of a unix script, which does the following: copy some files from directory /prod/sas/data located at "hardy".(which is a computer) to the other database hakon. Is it possible to do this. Please help me quick. Thanks in advance Roland S -- Please see t

ODBC CALL Failed

Hallo, I am running an Access application with connection to Oracle. But when I run an access procedure I get the errormessage " ODBC Call Failed". This procedure has worked fine. last week but now I get this erormessage. All procedures in oracle ar e valid. What could have happen? The ODBC s

Update query

Hallo, How can I update the field PRICE in table B with prices from field NEW_PRICE in table A. with condition LANGUAGE_CODE IS = 412 (that condition should be taken from table B) Please give me an example of a sql statementö. Thanks in advance Roland -- Please see the official ORACLE-L FAQ:

Update query

Hallo, How can I update the field PRICE in table B with prices from field NEW_PRICE in table A. with condition LANGUAGE_CODE IS = 412 (that condition should be taken from table B) Please give me an example of a sql statementö. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: h

Ang: SQL Loader Commit Point?

Well, you can runt the sqllodader again and then include this line after the name ofthe control file. log = C:\temp\error.log and that creates a logfile where you can see what has happened. The problem you are having can be caused by invalid length of the datafield in the database, or you

Listener

Hallo, Can anybody tell me simply how the listener works? Thanks in advance Roland S -- 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-- Pub

Ang: Testing

It is [EMAIL PROTECTED]@fatcity.com den 2001-11-30 10:40 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Kopia: Testing to see if the server is working properly. Jared -- Please see the official ORACLE-

Enterprisemanager?

Hallo, Does anyone know if there is a graphic interface in Oracle, which you can use to move data betwen tables and also to schedule tasks? Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Servi

PL/SQL problems

Hallo, I would like to know how to solve this problem: When this procedure runs, which makes an insert into table pbk.prisregister, it inserts the same value in field substitut where there exists a substitut. Please help me with this? It should be null in that field in case thre is a substiut

Inserstatement

How can I update one field in table X from another table, table P. Table P have 5 different fields but only one of them should be used to update table X. Give me an example on a sql statement for this. Sincerely Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Au

Ang: RE: Sql question - please reply fast

Thanks for all your repliesReally appreciate this.. next time I willtake more time to check the errors myself 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 Sa

Sql question - please reply fast

Hej Would like to have som help with this. Please give me an example of sql statement. I have field1. Pelle T Kalle S1000 Info missing Pelle Svensson T3 Bad info and want this result after the selectstatement. Pelle Kalle Info missing Pelle Svensson Bad info which means that I dont

Sqlimportante

Hallo, If I have this field1 Kenny Jenny A1000 Jenny L1000 No info Missing Info I would have: Kenny Jenny Jenny No info Missing Info How do I write the select statement to solve this I just want the last word in the field to be taken away in the result from the select statement. Rolan

Ang: RE: komplex sql

But if I have this field1 Kenny Jenny A1000 Jenny L1000 No info Missing Info I would have: Kenny Jenny Jenny No info Missing Info How do I solve this: I just want the last word in the field to betaken away in the select statement. Roland Robertson Lee - lerobe <[EMAIL PROTECTED]>@fa

komplex sql

Hallo, How can I do a select statement that creates this: I have the field1 Jimmy Y1000 Timmy L3 No Info Missing Info and I want the select to give me this: Jimmy Timmy No Info Missing Info You see It should still be 'No info' and 'Missing Info'after the select statement. How

Ang: RE: sql-important

Well in should be the the word 'Test today' to be included in the sql statement "Nicoll, Iain (Calanais)" <[EMAIL PROTECTED]>@fatcity.com den 2001-11-14 02:20 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED

sql-important

Hallo, How can I do a select statement that creates this: I have the field1 Jimmy Y1000 Timmy L3 No Info and I want the select to give me this: Jimmy Timmy No Info You see It should still be 'No info' after the select statement. How can I change this statement? SELECT ltrim(su

sqlquestion

Hallo, How can I do a select statement that creates this: I have the field1 Jimmy Y1000 Timmy L3 and I want the select the select to giv e me this: Jimmy Timmy How can I change this statement? SELECT ltrim(substr(mxurval_namn,instr(mxurval_namn,' '))) FROM mxurval; Thanks in adva

Ang: RE: Sqlloader - important

Yes and i should have checked the error more myself but was tired Roland [EMAIL PROTECTED]@fatcity.com den 2001-11-13 15:05 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Kopia: I think it's really amazi

Sqlloader

Hallo, I am running this sqlloader ctl-file load data infile 'C:\temp\arg\argdwfkt3.txt' TRUNCATE into table argdwfkt_kopia FIELDS TERMINATED BY ';' (BUTIKS_ID, BUT_NAMN, REGION_ID "DECODE(:REGION_ID,'!','98','?','97',:REGION_ID)", DISTRIKT_ID "DECODE(:DISTRIKT_ID,'!','98','?','97',:DISTRI

Sqlloader - important

Hallo, Why does this sqlloader ctl file give me this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)", KAMPANJTYP_NAMN) SQL*

Ang: RE: Sqlloader

Why does this sqlloader ctl file giveme this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)", KAMPANJTYP_NAMN) SQL*Loader-9

PLsql question

Hallo, How can I write in apl/sql code if I want to make an insert from table one into table two and in one of the fields delete the space in front of the first blank. For instance It says 1 John 2 Frederic 99 Jimmy in table one and I want the pl/sql code to delete the values in front of the

Sqlloader

Hallo all you DBA's How do I write in sqlloader if i want to replace, translate the caracter ? with 'No info' and the character ! with the value '99'. I have this statement already. BUT_OMS "TRANSLATE(:BUT_OMS, '!','99')", Thanks in advance Roland S -- Please see the official ORACLE-

Inserts with different conditions in pl/sql

Hallo, How can I write in a pl/sql block if I want to do an insert from one table to another table and at the same time translate the value '?' to 98 and the value 'X' to 'Missing info' Both those values can exist in the first table. The datatyupe in table one is varchar2 and in table two it i

Sqlloaderquetsion

Hallo you DBA's, How can I write in a sqlloader script, the ctl file if I want this to happen: If there is a ? in the file to be laded then I would like to have the number '98' in that field and if there is a ! in the file to be loaded, then I woul dlike to have the number '97' in that fiel

Ang: RE: Instance Name in Sql Prompt

Thanks it was great Roland "IT - Database (Do Not Use)" <[EMAIL PROTECTED]>@fatcity.com den 2001-10-25 07:15 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Kopia: I got this from someone on the list. It s

Slow query

Hallo , I am running this query but it is awful slow. (Embedded image moved to file: pic25554.pcx) When I check TOAD Server Stats there is a red dot on the following: - redo space wait ratio Value 145,0547 -parse/execute ratio Value 53,8402 high parse to exdecute ratio -DBWGR avg scan depth

Why does ittake long time?

Hallo, Why does this query take so longtime to run...At least 20 minutes it is just a simple count... (Embedded image moved to file: pic24685.pcx) Thanks in advance Roland Sköldblom Paintbrush

Move table to another tablespace

Hallo, Can you please tell how to move one table from one tablespace to another? I have data inthistable. Thanks in advance Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Sql not exists

Hallo you DBA' Can anyone give me a good example on a sql select statement checking which ids exists in table one but not in table two? Table two also contains the corresponding id field but with other field names besides. Like this Table 1: Id Name Year Table 2: :Id City

Check if a value in one table doesnt exist

Hallo you DBA' Can anyone give me a good example on a sql select statement checking if any value in id field in table one exists in table two's id field?Table two also contains the corresponding id field but with other field names besides. Like this Table 1: Id Name Year Table 2

Errormessage

Hallo I run this select statement and get this errormessage. What should I do to solve it? I have a databaselink from the actual schema to another schema. SELECT RIK2.VARE.EAN_NR, > RIK2.VARE.LEVNR, > RIK2.ART_HIERARKI_CALC.VGR, > RIK2.VARE.SORTIMENT, >

Errormessage

Hallo, what does this errormessage mean. I get it when i try to do this select statement. If I dont include the last two lines in the statement it works fine. What does this depend on? and which action shallI do to make it work? SELECT RIK2.VARE.EAN_NR, RIK2.VARE.LEVNR, RIK2

Unix batch job

Hallo, Anyone whom can give me a good example on how to write in a unix script if I want to run sqlloader every Sunday at 6 o clock pm? Please give me an example. Thanksin advance. Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROT

Sqloader

Hallo all you DBA's, Can anyone give me some examples on how to do this: I want a sqlloader to run, the sqlloader is doing an insert into a table(TABLE1) from a text file, immediately, after the insert into tthe table, there will be an insert into another table(TABLE2) with data from TABLE1. G

Sqlloader-problem

Hallo all you DBA's, Can anyone give me some examples on how to do this: I want a sqlloader to run, the sqlloader is doing an insert into a table(TABLE1) from a text file, immediately, after the insert into tthe table, there will be an insert into another table(TABLE2) with data from TABLE1. G

Create excelfile from pl/sql

Hallo, How can I create a excelfile with the UTL_FILE packet, I wantthe file to be able to opened directly in excel, without goingthrough the import step when I open the file. Give me an example, please. Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INE

Ang: RE: DBMS_JOB statement

So this means that every day at 6 pm th eprocedure 'procedure' runs. /Roland "Thomas, Kevin" <[EMAIL PROTECTED]>@fatcity.com den 2001-09-11 03:30 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Kopia: Hi Rol

Ftp from PL/SQL

Hallo, Is it possible to do ftp commands directly from PL/SQL procedur? Including logon to the ftp server.? Give me a code example please if possible. It is important for me. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [

From Access to Oracle

Hallo, Anyone who can help me, I have this query in Ms Access: How should I write this sql statement in oracle. SELECT RIK2.LEV.LEVNR, RIK2.VARE.EAN_NR, RIK2.VARE.VARENAVN, RIK2.AVD.KJEDE, Sum(BRT.BRTOMS_DAG.ANT) AS ANT, Sum(BRT.BRTOMS_DAG.UTVERDI) AS UTVERDI, BRT.BRTOMS_DAG.DATO, Left([

Ftp from Oracle

Hallo, Is it possible to do ftp commands directly from PL/SQL procedur? Including logon to the ftp server.? Give me an example please if possible. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Netw

DBMS_JOB statement

Hallo, Can anyone tell me a example on a script which does the following: - Starts a job, a pl/sql-procedur, at 6 pm every day, - If something goes wrong then I want information to be logged. (Should I include the logging in the pl/sql procedur) Thanks in advance Roland S -- P

Query from access to oracle

Hallo, Anyone who can help me, I have this query in Ms Access: How should I write this sql statement in oracle. SELECT RIK2.LEV.LEVNR, RIK2.VARE.EAN_NR, RIK2.VARE.VARENAVN, RIK2.AVD.KJEDE, Sum(BRT.BRTOMS_DAG.ANT) AS ANT, Sum(BRT.BRTOMS_DAG.UTVERDI) AS UTVERDI, BRT.BRTOMS_DAG.DATO, Left([RI

Choose different variables

Hallo, Can anyone tell me how I can send different variables into a procedure, depending on which action should take place? Please give me an example. Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services

sqlloader-bad file

Hallo all you gurus, How should l I write in the controlfile(.ctl-file) if i want to get a logfile, with all the explanation of the errors.? Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Sqlldr-help

Hallo, Can anyone give me an example on a control.file for th esql ldr that does the following: Truncate table X inthe database Loads data into table X Makes an insert from that table into another table in the database. And of course commit statement afterwards Thanks in advance Roland S --

Uniix-script-help

Hallo, Anyone whom has a good example on a unix-script that does this: I want it to run sqlloader script, which loads data into a table in the database and also make an insert from this table into anothertable? I wantthis to be scheduled every day. Also with a check if the file exists in the uni

Unix-script

Hallo Can anyone give me an example on how to write a unix script which schedules the run run of a sqlloader script from unix server into the database. I mean I could easily get the file tmanually o be imported if i use the ftp command, but how do i do if I want that to be scheduled? Roland

Unix-script

Hallo, Can anyone give me an eaxmple of a iunix script, which checks if the file in unixsystem exists and if it does then it runs th esqlloader script, which loads data into a database table.? Thanks in advance. Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Auth

DBMS_JOB

Hallo, How can I schedule a pl/sql job, I want this to happen: Every Sunday at 11 pm I want to do an insert into a table. How shoudl I write the code in the DBMS_JOB satement.? Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] F

Slow sql

Hallo you DBA'¨s Can anyonetell me why this insert statement takes 30-40 minutes to run? What can I do to make it go faster? insert into varukorgtemp ( varukorgid, ean, anvandarid, lagstapris, varutyp, varunamn, strl, leverantor, varumarke, sortiment,vgrp,vare_snr,varenr,levnr ) SELE

Records in pl/sql

Hallo all you experts, Can someone tell me when to use Records in a pl/sql procedure and why I should use them? Can I use PL/SQL records in all procedures i write? Thanks in advance. Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTE

How can I unsubscribe thislist?

Can anyone tell me how to unsubscribe from this list? Roland Sköldblom -- 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-- Public Internet access

sql-query

Hallo all you gurus, Anyone whom can help me withthis? I would like to see even art_grp that exists in rh but not in rik2.katsett_hgr. How can I change this select statement? select hgr, rh.VGRP, ART_GRP,TEKST from rik2.hierarki_tekst rh,rik2.katsett_hgr where rh.vgrp(+) =rik2.katsett_hgr.vg

PL/SQL

How can I change this pl/sql code. I want this to happen: I have for instance this blank 5 5 blank 55 which means 55 55 (the spaces ar ethe blanks.) and I want it to be like this: 00 How can I change this code to let this happen: vPOSTAL_NO:= lpad(nvl

Comparing pl/sql - sql

Hallo, I have a pl/sql code and when i run the procedure I get the result of 20 records(20 rows) but when I copy the sql query into the sql window and run only the query it gives me the result of 30 records(30 rows). What does this depend on? How can I solve this problem? Sincerely Roland

Invalid views

Hallo all you DBA's Can anyone help me with this? I would like to check if some views ar einvalid and then if there are I would like them to be compiled immediately . How can I write this in a pl/sql-procedure? Please give me some good examples, all you experts! Roland Sköldblom -- Please s

Check on invalid views

Hallo you DBA:s Can anybody help me with this: How can I check if a view is invalid and if it is invalid then automatically compiled it? I want to add code for this in a PL/SQL procedure. How can I do this? Please give me a good example on how to write. Roland Sköldblom -- Please see the of

Null values

Hallo you DBA's: How can I modify in this script to make it handle also null values. This script only handles 0-values. Hope anyone can help me with this. vOWNERSHIP_NO:= rpad(to_char(nvl(recCursor.OWNERSHIP_NO,' 0')),2,' '); Thanks in advance Roland Sköldblom -- Please see the official ORA

Using editor for unixfiles

Can anyone please tell me how to use emacs when i want to edit unix files. I am using vi but want to use emacs now. I have heard that that program is good for that purpose. Please give me some examples. Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

Ang: what's hash-join

Probably a cartesian product Roland S -- 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-- Public Internet access / Mailing Lists --

Subquery

Hallo you DBAs How can I write this sql query using subqueries? SELECT pbk.nielsenart.varunamn, pbk.nielsenart.strl, pbk.nielsenart.varutxt, null, pbk.nielsenart.vgrp, rik2.hierarki_tekst.tekst, null, pbk.sortiment_vgrp.sortiment, pbk.nielsenart.art_grp, pbk.nielsenart.art_ugrp, null FROM pbk.n

Slow query

Hallo you DBAs; How can I make a query run faster, I have some queries and they tend to be be very slow. Roland Sköldblom -- 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

<    1   2   3   >