PL/SQL :: Remove Character From Text File

Apr 4, 2013

I create a text file with cobol, and now I need to remove the last character of each line with pl / sql. For example:

12 *
23 *
45 *

I need to remove *

View 7 Replies


ADVERTISEMENT

SQL & PL/SQL :: Remove / Trim More Than One Character?

Aug 15, 2010

How to write a pl/sql query to trim/remove more than one character from string.

Like the itemfield is 'Profit CY' I want it to show as 'Profit' but only for itemfields that say 'Profit CY' in the column for remaining items in column such as 'Loss CY' should stay as it is.

View 25 Replies View Related

Forms :: Export Text File With Same File As Imported Text File?

May 30, 2011

Is it possible to get the same name of file name from imported text file?

What i've is, I import the text file then I exported it.

can I get the same name of the imported text file?

View 2 Replies View Related

SQL & PL/SQL :: Unable To Remove Hidden Character From Field

Mar 9, 2011

I ran into the following issue as mention below.

select dump(column_name) from table where column_name2 = 'HP1';

dump(column_name)
--------------------------------------------------------------------------------
Typ=1 Len=5: 194,160,82,88,66

I am trying to get right of these hidden character 194 and 160. i tried different method as mention below,

1) translate(column_name, chr(194)|| chr(16),'')

View 7 Replies View Related

How To Remove Newline Character At Start In Attachment

Jan 9, 2013

I have been trying to attach a .dat file generated at an external source and send it as an attachment by mail using UTL_SMTP, all things are working but the .dat file which comes attached in mail contains a newline character i.e. chr(10) at the start line and the contents of the file are written from second line onwards. Below is some part of the code which deals with read/write of attachment of mail to be sent.

UTL_SMTP.write_data(c,
'Subject' || ': ' || P_SUBJECT || UTL_TCP.crlf);
UTL_SMTP.write_data(c,
'MIME-Version: 1.0' || UTL_TCP.crlf || -- Use MIME mail standard
'Content-Type: multipart/mixed;' || UTL_TCP.crlf ||
[code]....

View 5 Replies View Related

SQL & PL/SQL :: UTF8 - Unable To Remove Hidden Character From Field

Mar 20, 2012

My database is in UTF8 character set..

And it is not supporting chr(194)||chr(160)

what character set you were using then ?

And.. is there a way to handle non breaking spaces in UTF8..

View 16 Replies View Related

Forms :: Text Box To Accommodate Large External File Text

Dec 30, 2010

I have a requirement in one of my forms screen.I have a text box(large text area) which should display a help text file when i move my cursor on the topics displayed on the screen.know the code and the properties to be changed in the text box to accommodate large external file text.

View 1 Replies View Related

Backup & Recovery :: ORACLE Dump File To Text File

Apr 9, 2011

Oracle10g to Sybase12.5 Migration:- How a Oracle dump file can be converted to any text file/xls file which will be loaded in sybase database later through BCP.

means
1.Exporting objects as dump file from Oracle.
2.Is there any tool/process available that can convert this into csv/txt/xls file.
3.This files can be loaded in sybase.

View 2 Replies View Related

Server Administration :: How To Know Character Set As Single Character Or Multi Character

Sep 26, 2013

how do we know database character set is either single character set or multi character set?

While changing character-set from AL32UTF8 to WE8MSWIN1252 got "ORA-12712: new character set must be a superset of old character set".

Below are steps taken to resolve the issue -

ALTER DATABASE CHARACTER SET WE8MSWIN1252;

i got this error: ORA-12712: new character set must be a superset of old character set

below are the commands executed by me:

SQL> SHUTDOWN IMMEDIATE;
SQL> CONNECT SYS/password AS SYSDBA;
SQL> STARTUP MOUNT;
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL> ALTER DATABASE OPEN;
SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE WE8MSWIN1252;
SQL> SHUTDOWN;
SQL> STARTUP;
SQL> QUIT;

And its working...

I have not done it in proper order. Neither have done ccsscan. Still, no user reported any issues. Do my changes truncated the data?

View 11 Replies View Related

Globalization :: Bad Character Set In Dump File?

Jul 23, 2013

IMPDP-ing a dump file that someone has handed me over into Oracle XE results in special characters, i.e. Umlauts, being messed up.  

In a hex editor, the dump file shows  a) the token WE8MSWIN1252 near the beginning, but b) Umlauts obviously being encoded in DOS 850, for example "König" is encoded as 4b 94(!) 6e 69 67. Does this prove that the dump file is badly formatted and that I have to resign myself to the complicated approach mentioned at the end of [URL]...

View 4 Replies View Related

Generate A Text File

Apr 28, 2008

i have be requested to create a .txt file. Its for a program that will read the txt file i create to produce a letter i.e I will be extracting, TITLE, FORENAME, SURNAME etc

MR
JOE
BLOGGS

Here is the my code so far,

SELECT
LPA_INPUT.INPUT_TITLE,
LPA_INPUT.INPUT_SURNAME,
LPA_HISTORY.LPA_AMT,
LPA_HISTORY.ELIG_RATE,
LPA_HISTORY.RATE_REBATE,
LPA_HISTORY.RR_AMT,
LPA_HISTORY.LPA_APPLIC,
LPA_HISTORY.LPA_AMT
FROM LPA_HISTORY, LPA_INPUT
WHERE LPA_HISTORY.CLAIM_NO = LPA_INPUT.CLAIM_NO
----------------------------------------------------
Iv been asked to have these eight fields looping over and over for all the records in the database, So im not sure how to do that and how to generate it in a txt file?! I have to produce it in a script and not by a Export/Import wizard in sql server mangement studio!!!

View 11 Replies View Related

SQL & PL/SQL :: Convert PLB To Text File?

Feb 11, 2011

is there anyway to convert plb file to sql file or text file

View 20 Replies View Related

Reports & Discoverer :: Unable To Generate To File XML In Character Mode

Feb 17, 2012

I have a Report which run in character mode format, well i cannot convert or Generate to File as a XML File.

XML Conversion Error:

REP-1401: 'cf_1formula': Fatal PL/SQL error occurred. ORA-01403: no data found

PDF Conversion Error:

REP-1920: Character mode runtime incompatible with DESFORMAT of PDF, HTML, HTMLCSS, or RTF

But, when i change Character Mode to Bitmap or Default i can able to Generate to File.

So i Like to know is it possible to Generate to File in Character Mode?

View 1 Replies View Related

Import From Text File To Table

Dec 14, 2006

I want to load data to a table and from a simple file text, using a Vb.net application which will connect to a oracle 10g , or a SqlServer or a MySql database, depending the params.

When i connect to a SqlServer Database i use the sql command "BULK INSERT CODPOSTAL2 FROM file.txt with( DATAFILETYPE = 'char',FIELDTERMINATOR = ';', ROWTERMINATOR = '
')"m" and it works fine.

With a DB Mysql i use "LOAD DATA INFILE file.txt INTO TABLE CODPOSTAL2 FIELDS TERMINATED BY ';''" and also works.

My problem is with Oracle. I tried the same example as MySql, but it gaves the error "wrong" ou "unknown command". I also tried in Sql*Plus but it seems to not recognised the command "LOAD".

Another thing, i can't use the Oracle Loader, it must be like this.

View 5 Replies View Related

SQL & PL/SQL :: Convert Excel File Into Text?

Aug 2, 2010

i want to convert an excel file into text and then into oracle table.

View 6 Replies View Related

SQL & PL/SQL :: How To Write Text At Specified Position In File

Apr 11, 2013

suppose i have a file named chk.txt and I have write 10 line in that file and i just want to write some text at line 5 or line first then how we can do this ?

View 3 Replies View Related

SQL & PL/SQL :: Query Output Into Text File

Mar 9, 2011

I am trying to get query output into textfile.The following procedure is working fine by creating directory as follows in sys user.The output is getting onto text file and it seen on server machine even.My question is I want to see the text file on local machine also instead of everytime connecting to server machine drive.How can I perform that?

create or replace directory INFO_DIR as 'D:Swapna';
grant read, write on directory INFO_DIR to fairpoint;
CREATE OR REPLACE PROCEDURE FAIRPOINT.utl_file_test_write_xls(filename in VARCHAR2 )
IS
output_fileutl_file.file_type;
v_pathVARCHAR2(500);
v_stringVARCHAR2(4000);
v_sqlstrVARCHAR2(2000);
BEGIN
BEGIN
[code]....

View 5 Replies View Related

SQL & PL/SQL :: Formatting The TEXT In Exported File?

Nov 15, 2011

How to make the multiple lines of character in single line. Below is the example where i am getting the value when we export the data from the database table.

----------------------
Welcome Aboard customer contact based on Account activation.

The current selection criteria for Welcome Aboard is based at the service level. Therefore, each time a customer connects a service, Welcome Aboard material is mailed to the customer. This is causing the following problems;

Customer complaints. If a service or a number of services are connected on a particular day, it will result in (ie except for some minor exclusions) a single Welcome Aboard pack being sent to each individual customer. As you can expect for corporate accounts, they receive a high volume of this material. Other problems occur when, service/s are deactivated and reactivated, each time a Welcome aboard pack will be distributed.

High costs to Telstra. Each MNET service connected may produce a Welcome aboard pack. This volume of material currently costs Telstra over $500,000 per quarter for Welcome Aboard alone.

------------------------------

here is what i want to the above data to export:

----------------------
Welcome Aboard customer contact based on Account activation.The current selection criteria for Welcome Aboard is based at the service level. Therefore, each time a customer connects a service, Welcome Aboard material is mailed to the customer. This is causing the following problems;Customer complaints. If a service or a number of services are connected on a particular day, it will result in (ie except for some minor exclusions) a single Welcome Aboard pack being sent to each individual customer. As you can expect for corporate accounts, they receive a high volume of this material. Other problems occur when, service/s are deactivated and reactivated, each time a Welcome aboard pack will be distributed. High costs to Telstra. Each MNET service connected may produce a Welcome aboard pack. This volume of material currently costs Telstra over $500,000 per quarter for Welcome Aboard alone.

View 3 Replies View Related

PL/SQL :: How To Write To Text File Using Oracle

Feb 23, 2013

How to write to text file using oracle? And how do I handle spaces/next line? (i was trying to use spaces(ch(32)), however it is just converted into squares in the text file.)

View 5 Replies View Related

SQL & PL/SQL :: Copy Bulk Data In Text File?

Oct 9, 2013

i want table data exported to txt file, data is around 3200000,

View 14 Replies View Related

Forms :: Import Text File In Oracle 9i

May 3, 2011

I want to import text from text file. How i can import in oracle forms ( oracle 9i)

View 7 Replies View Related

Server Utilities :: Load From A Text File

Aug 8, 2012

I would like to load a text file into an oracle table.

View 10 Replies View Related

SQL & PL/SQL :: Empty Text File With Data In UNIX

Apr 14, 2010

I have text file with data in UNIX. I want to clear only records(make empty the file) using UTL_FILE..

I know we can remove the text file from UNIX and create file again with same name...

Is there any other way??

View 5 Replies View Related

Receiving Data From Upstream Through Text File

Feb 9, 2011

We are receiving data from our upstream through text file, they are extracting that text file from their oracle table.In the table in ename colmn some names are having the special character like

Chng
OReilly

We are loading the data from that text file into our oracle tables and the names are loading as it is.Now we are extracting data as text file from our tables which is loaded from or upstream,then the special character is changing as the names are changing as Chng OReilly. We are loading the data from the text file into our tables and the names are loading as

Chng OReilly and i tried to replace the special character with while loading but it is loading as .If I try to change the character with '(Apostrophe) while loading it is changing.

The data type of the column is VARCHAR2(20)

NLS_CHARACTERSET is UTF8

Version Oracle 9i

View 6 Replies View Related

SQL & PL/SQL :: Load Data From Oracle To Text File?

Jun 18, 2013

I want to load data from oracle table to flat file(csv/text file). Is there SQL query to do this?

View 14 Replies View Related

Reports & Discoverer :: REP-1219 With Text File

Sep 4, 2012

I have a report that runs fine if I run it from the developer whether to preview or to file. The users are running this report from an Oracle Forms app and have a drop down for the destination format. If they run it to PDF for example, the report runs fine. If they run it to TXT132, TXT180, or TXT they get a "REP-1219 'FIELD_NAME' has no size -- length or width is zero".

Of course I am unable to get into the test application right now and as I mentioned above, I am unable to duplicate the error when I run the report from the developer. I am not sure why I would get a REP-1219 only when running to a Text file.

View 9 Replies View Related

SQL & PL/SQL :: Writing Turkey Characters To Text File?

Oct 8, 2013

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

I am trying to write the Turkey character stored in the table in VARCHAR2 to Unix file. But when the text is written to the unix, the characters are coming as junk.

The output of the file it is writing is as below after the execution

Fis Içe Aktarma Olusturuldu Header
Fis Içe Aktarma Olusturuldu
Fiş İçe Aktarma Oluşturuldu

Instead I expect the chararecter to be as "Fiş İçe Aktarma Oluşturuldu Header" which when converted to English will show as "Created Import Plug Header".

DROP TABLE TEST_JUNK_CHAR
/
CREATE TABLE TEST_JUNK_CHAR (primary_description VARCHAR2(400))
/
INSERT INTO TEST_JUNK_CHAR VALUES('Fiş İçe Aktarma Oluşturuldu Header')

[code]....

View 13 Replies View Related

Forms :: How To Export Text File In Oracle 8

May 27, 2011

Just want to know on how to export text file from oracle? I have here the query on how to import.

begin
in_file := TEXT_IO.FOPEN(:path_file,'r');
LOOP
BEGIN
SYNCHRONIZE;
TEXT_IO.GET_LINE (in_file, linebuff);
v_no_errors := TRUE;

[code].....

But this is my first time to export the text file.

View 2 Replies View Related

SQL & PL/SQL :: Receiving Data From Upstream Through Text File

Feb 9, 2011

We are receiving data from our upstream through text file, they are extracting that text file from their oracle table.In the table in ename colmn some names are having the special character like '

Ch'ng
O'Reilly

We are loading the data from that text file into our oracle tables and the names are loading as it is.Now we are extracting data as text file from our tables which is loaded from or upstream,then the special character ' is changing as ¿the names are changing as Chang Reilly.

We are loading the data from the text file into our tables and the names are loading as Chang O¿Reilly and i tried to replace the special character ¿ with ' while loading but it is loading as ¿.

If I try to change the character ¿ with '(Apostrophe) while loading it is changing.

The data type of the column is VARCHAR2(20)

NLS_CHARACTERSET is UTF8

View 27 Replies View Related

Reports & Discoverer :: From Report To Text File

Dec 24, 2010

I'm working on a report (written with Oracle report builder 6i) for the SMS system.I want the the report results (list of mobile numbers) to be outputted directly into a text file.I have accomplished that with the following parameters:

DESTYPE = File
DESNAME = C:file_name
MODE = character

this work well for the first time but in the subsequent runs, the report rewrite the same file deleting the result from the run before.can I manage to have each run result written in separate file with the name formatted in specific way like (sms_parametervalue_date) or something. or at least is it possible to change the system parameter DESNAME via user parameter at runtime, so I can input the new file name into the parameter form.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved