PL/SQL-question

Hi, I have imported a text-file into a table in the database. Now I find that there are many bad things in some fields, for instance there is a ? instead of the value 0. Can anyone give me a good example on a procedure that loops through a table and if found a ? in some fields, replace it

Left position

Can anyone tell me which function to use if I want a string to be left positioned, not centre positioned ? 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

Question about PL/SQL-Unix

How can I create a file, and the send it through mailsystem imediately to a mail recipient.We use Lotus Notes mailsystem. Any good example? Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services--

Example of pl/sql

Anyone who has a good example on a procedure that first deletes all the records in a table and then does an insert? 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)

Sqlloader

How can I in a sqlloader, the control file replace a ? with a 0 at the same as it i sloading the data into the database? The ? could be anywhere in any field. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City

Check the constraints

Hallo Anyoine know about any program that can check all the constraints after the database is designed? Roland Skldblom -- 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

Which CD?

On which installation CD can I find sqlloader setup? Roland Skldblom -- 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

Help with sqlloader

Hi folks, (See attached file: mondaytest.txt)(See attached file: describetable.txt) Can anyone help me to write a ctl-file, for instance called test.ctl, to use when i use sqlloader to import a textfile into the oracle database? I am including two files here, which you might need. Thanks in

sqlloader

Hallo, Can anyone tell me how to get sqlloader, how can I try and find out to see if I have it already installed ? How do i Install it? Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services--

Errors in Oracle

Anyone who can give me a link to a website, where I can see the description of the Ora-errors I get in sql statements and pl/sql-code, so I understand what the error is about and how to fix it. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Slow database

We are running an oracle database 8i, we have several Ms Access applications connected by ODBC to this database. The database is very complex ,in total about 300 tables and of course PL/SQL procedures We also have many different schemas in this database. But we have a big problem, when we

Is there any Access user group?

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

olap?

Hallo, Can anyone tell me: What is OLAP and how does it work, a short description, thanks. Roland Skldblom -- 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,

Reverse engineering

Hallo, I am doing a reverse engineer of the Oracle database, which means that I am loading the database into the program Erwin. When it i simported into erwin I willbe able to seeall the relations, tables, views etc of the database. But when i am doing the reverse engineer I get many error

Updating table2 from table1

Thanks for all your advices to me. How can I write a procedure, that does a selection from table a and then puts that data into table nr 2. In the new fields in table2 I am supposed to put for instance sums from table1 of certain fields. Roland S -- Please see the official ORACLE-L FAQ:

Make a character format from number format

How can I make a character format from a number format in an insert statement? For instance insert into table_name values(10, 1960); where 1960 is supposed to be put in the column, which is in character datatype. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Data into another table

How can I create a select statement from table1 including some division or multiplication , and then include the result into table2. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

Slow database

Hallo all you experts, I have an Oracle database, every night it is read many files into the database, but all the procedures take so long, it keeps taking all the next day almost. It shouldnt do that, because the system is very slow because of this. When I run other things during the day,

If-statement

Hallo, Do you have any good example on how to write a procedure, that checks if there is a ? in a column in tna table in te database. If it is a ? then it will be put a "0" in the place where it is a ?. If it is not a ? then it will be the no change in that place. Please help me with this

DBMS_OUTPUT.PUT_LINE

Hello, Anyone who has a suggestion how to write the DBMS_OUTPUT.PUT_LINE command if I want to display the numbers of inserts done in that script? Would appreciate it very much if anyone could help.. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Insert without telling column names

Hallo, How can I create an insert statement without telling all the names of the columns? Give an example, please. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Reading a textfile into the database

Hallo, you all experts and thanks for all your advices about my utl-file ... Here is another: Does any one have a good example of pl/sqlscript which reads a text-file into the database? Thanks a lot to anyone who canhelp me with this. Roland Skldblom -- Please see the official ORACLE-L

Utl_file question

Hallo all experts, I have written this procedure but get this error message. What is wrong? 1 DECLARE 2 emp_data UTL_FILE.FILE_TYPE; 3 BEGIN 4 emp_data := UTL_FILE.FOPEN ('c:\', 'pelle.xls', 'W'); 5 FOR BAKERS IN ( 6 select AVDNR, DATO 7 FROM BAKERS) LOOP 8

Question about PL/SQL

Hallo, all you experts Does anyone have any good example of procedure, that does a select statement from the database and afterwards automatically save this resultat to an excel file.? Sincerely Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

<    1   2   3