Multiple strings in oracle -


i make multiple strings in oracle following table

http://sqlfiddle.com/#!4/546b1

create table test ( client varchar(20), dat varchar(20),secuence varchar(20),cod1 varchar(20),cod2 varchar(20), personal varchar(20),comments varchar(140), area varchar(20),phone varchar(20)); insert test values ('2869', '17/04/2010 03:12','2','..', '','','drummer lars ulrich in local newspaper.','','');      insert test values ('2869', '17/04/2010 03:12','1','..', '','','formed in 1981 when vocalist/guitarist james hetfield responded advertisement posted by','','');      insert test values ('2869', '17/04/2010 03:12','0','ls', 'te','1abfrn','metallica american heavy metal band formed in los angeles, california. metallica wasadvertisement posted drummer lars ulrich in a,','01442','2236087'); insert test values ('3532', '18/04/2010 09:20','2','', '','','the expression "relative theory" (german: relativtheorie) used in 1906 max planck','','');         insert test values ('3532', '18/04/2010 09:20','1','', '','','albert einstein: special relativity , general relativity term "theory of relativity" based on','','');      insert test values ('3532', '18/04/2010 09:20','0','ls','tx','1catar','the theory of relativity, or relativity in physics, encompasses 2 theories by','01871','7142175');

i have no idea how , check out board should fit me attachment below. suggestion appreciate help

|20022869|     17/04/2010 03:12|    8lsfe|  sandst| paper. abfrn                    | |20022869|     17/04/2010 03:12|    7lsfe|  sandst| d drummer lars ulrich in local news    | |20022869|     17/04/2010 03:12|    6lsfe|  sandst| ield responded advertisement poste    | |20022869|     17/04/2010 03:12|    5lsfe|  sandst| 1981 when vocalist/guitarist james hetf     | |20022869|     17/04/2010 03:12|    4lsfe|  sandst| ed drummer lars ulrich in formed in    | |20022869|     17/04/2010 03:12|    3lsfe|  sandst| ifornia. metallica wasadvertisement post    | |20022869|     17/04/2010 03:12|    2lsfe|  sandst| vy metal band formed in los angeles, ca     | |20022869|     17/04/2010 03:12|    1lsfe|  sandst| 014422236087metallica american hea    | |20023532|     18/04/2010 09:20|    8lstx|  sandst| 06 max planck catar              | |20023532|     18/04/2010 09:20|    7lstx|  sandst| ory" (german: relativtheorie) used in 19    | |20023532|     18/04/2010 09:20|    6lstx|  sandst| based on expression "relative    | |20023532|     18/04/2010 09:20|    5lstx|  sandst| tivity term "theory of relativity" w    | |20023532|     18/04/2010 09:20|    4lstx|  sandst| ein: special relativity , general rela    | |20023532|     18/04/2010 09:20|    3lstx|  sandst| encompasses 2 theories albert einst    | |20023532|     18/04/2010 09:20|    2lstx|  sandst| r relativity in physics,     | |20023532|     18/04/2010 09:20|    1lstx|  sandst|  018717142175 theory of relativity, o   |

something this:

select '|2002'||cast(client char(4))||'|'||chr(9)||cast(dat char(20))||'|'||chr(9) ||cast(secuence char(1))||cast(cod1 char(2))||cast(cod2 char(2))|| '|'||chr(9)||cast(personal char(6))||'|'||chr(9)|| cast((area||phone||' '||comments) char(180))||chr(9)||'|' test;

but you'd better have length personal 6 symbols , 2 code in example.


-

Popular posts from this blog

c# - ODP.NET Oracle.ManagedDataAccess causes ORA-12537 network session end of file -

overview i want replace oracle.dataaccess orcale. managed dataaccess, opening connection latter throws ora-12537 network session end of file exception. exception message / stack trace {oracleinternal.network.networkexception (0x000030f9): ora-12537 : netzwerksession: dateiende @ oracleinternal.network.readerstream.read(orabuf ob) @ oracleinternal.ttc.orabufreader.getdatafromnetwork() @ oracleinternal.ttc.orabufreader.read(boolean bignoredata) @ oracleinternal.ttc.marshallingengine.unmarshalub1(boolean bignoredata) @ oracleinternal.ttc.ttcprotocolnegotiation.readresponse()} i trying connect oracle 11g database , not have client installed on local machine. working test application (unmanaged) using oracle.dataaccess works fine . using system; using oracle.dataaccess.client; namespace app.odp.unmanaged { internal class program { private static void main(string[] args) { //dummy connection string...
Read more

matlab - Compression and Decompression of ECG Signal using HUFFMAN ALGORITHM -

i want compress , decompress ecg signal stored text message text file , find out file size, cr,prd ratio,and qs. here code compression , decompression of ecg signal using huffman algorithm. i'm trying find out file size, compression ratio,prd ratio,qs. but error i'm getting the ecg file in text format. %clearing variables , screen enter code here clear all; close all; clc; [file1]=uigetfile('*.txt'); %fprintf('enter ecg file name :%s',file1); p=file1; t=sprintf('%s',p); b1=dlmread([file1]); len=length(b1); lead=input('enter lead number :'); %lead=str2double(lead); col2=b1(1:end,lead); e=fix(sqrt(len)); m=1; i=1:e j=1:e g2(i,j)=fix(col2(m)*1000); %amplifying 1000 m=m+1; end end g3=g2; i=1:e j=1:e ...
Read more

utf 8 - split utf-8 string into bytes in python -

i trying split utf-8 string bytes in python 3. problem is, when use bytearray, byte, encode etc functions array size of element 14 bytes, not 1 byte expected. need split text file sequence of bytes , send them byte after byte using sockets. tried this: infile = open (file, "r") str = infile.read() byte_str = bytes(str, 'utf-8') print("size of byte_str",sys.getsizeof(byte_str[0])) print gives me 14, need 1... suggestion? quoting official documentation : sys.getsizeof(object[, default]) return size of object in bytes. object can type of object. built-in objects return correct results, not have hold true third-party extensions implementation specific. only memory consumption directly attributed object accounted for, not memory consumption of objects refers to. if given, default returned if object not provide means retrieve size. otherwise typeerror raised. getsizeof() calls object’s __sizeof__ method , adds ...
Read more