1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Utl_file_dir

Discussion in 'SQL PL/SQL' started by lucky, Jul 1, 2009.

  1. lucky

    lucky Active Member

    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    80
    Hi All,

    i want to know about UTL_FILE_DIR.
    actually i want to keep some data(files/images which are large in size) on the OS file system instead of keeping it in side the Database.
    for this we can use UTL_FILE utility in oracle. but am not aware of this.

    so, i kindly request can any one help me with a simple example on the usage of UTL_FILE.

    Thanks in Advance,
    Lucky.
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Following links may give you a kick starts of UTL_FILE functionality.

    link1
    link2

    You can have a look at external tables also if interested.

    link1
    link2
     
  3. lucky

    lucky Active Member

    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    80
    hi,

    thank you very much for the information provided. it was very helpful.

    Thank you,
    lucky.