I would use a CLOB datatype to the table column and use PL/SQL for process logic.
On Fri, Dec 6, 2013 at 2:30 AM, Serious_Developer <ehabaziz2...@gmail.com>wrote: > 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>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 >>> >>> To unsubscribe from this group, send email to >>> oracle-plsql...@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...@googlegroups.com. >>> >>> 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. > -- -- 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.
