Re: How to extract table contents to files?

In article <3ebhrd$h72_at_ctsc.hkbc.hk>, Bosco Tsang <btsang_at_ctsc.hkbc.hk> wrote:
>How can I extract the content of an oracle 7 table to a text file in the home
>directory (unix version)?

One way I did is: Using sqlplus

spool filename
select * from table
spool off

then you can find the content in filename. However, there is some other info which you need delete by manaully or by script.

>
>--
>/=======================================================================
>| Bosco Tsang | Department of Geography, Hong Kong Baptist University |
>| ´¿¼w¦¨ | ­»´ä®û·|¤j¾Ç¦a²z¾Ç¨t (Chinese Name) |
>| 224 Waterloo Road, Kowloon, Hong Kong |
>| Phone: (852)2339-7129, (852)2339-7185 (direct) Fax: (852)2338-6005 |
>|------------------------------ E-MAILS -------------------------------|
>| Campus: btsang_at_ctsc.hkbu.edu.hk GEOG Dept: btsang_at_geog.hkbu.edu.hk |
>| CWOL-HKG (Co-SysOp, Geo*): bosco.tsang_at_f29.n700.z6.ftn.air.org |
>=======================================================================/
> I
> --WISH YOU A--
> ,,-----HAPPY NEW YEAR-----,,
> ,,''' ''',,
> ,,'' '',,
> ;; ||' ,,,,,,,,,,||, ;;
> ;; || ;;
> ;; ,,,,||,||, ,,,,,,,,,||, ;;
> ;; ,|' || || ;;
> ;; ,|' || || ;;
> ;; ,|', ''''''''''' ;;
> ;; ,|| |, ,,,,,,,,,,,||, ;;
> ;; ,,' || '' || || || ;;
> ;; || || || || ;;
> ;; || ||''';;''''|| ;;
> ;; || || || || ;;
> ;; || ;;,,,;;,,,,;; ;;
> ;; ;;
> ;;,, ,,;;
> '';;,, ,,;;''
> '';;;HHHHHHHHHHHHHHHHHHHHHHHH;''
> HHHHHHHHHHHHHHH
> >> >> >> >>
> << << << <<
> >> >> >> >>
>
>
Received on Tue Jan 03 1995 - 19:55:55 CET