Sorry for the late : They are ASCII text but I will process some of the data . For example : I will read a unique key and use it as a primary key in certain line : line 3 : position : 6 length : 6. Similarly , I will use capture certain fields according to the line number and position and length . Page delimiter can be Form feed or any string . Any ideas about the code .
بتاريخ الأحد، 10 نوفمبر، 2013 UTC+2 6:02:02 م، كتب Michael Moore: > > What is the content of files? Simple ascii text? word .doc, PDF? > > You should read here > http://docs.oracle.com/cd/E11882_01/appdev.112/e23448/u_file.htm#ARPLS069 > and here > > http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_7002.htm#SQLRF54502 > > > > On Sun, Nov 10, 2013 at 2:06 AM, Serious_Developer > <ehabaz...@gmail.com<javascript:> > > wrote: > >> I need to store contents of a file to a database . Can I store each page >> in varchar2() data type column and every page detemined by a unique key >> (like account nmumber ) >> >> Page 1: account 001 >> .. >> .. >> Page 1: account 002 >> .. >> .. >> >> >> I do not know which language should be used with string capabilities : >> SQL or PL ? >> >> I need to use a program the store pages in two columns : >> Account_no,Contents of page >> >> Thks >> >> -- >> -- >> You received this message because you are subscribed to the Google >> Groups "Oracle PL/SQL" group. >> To post to this group, send email to oracle...@googlegroups.com<javascript:> >> To unsubscribe from this group, send email to >> oracle-plsql...@googlegroups.com <javascript:> >> For more options, visit this group at >> http://groups.google.com/group/Oracle-PLSQL?hl=en >> >> --- >> You received this message because you are subscribed to the Google Groups >> "Oracle PL/SQL" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to oracle-plsql...@googlegroups.com <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en --- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-plsql+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
