Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2009
    Posts
    4

    Unanswered: Why used extension .spc,. bdy, .sql in oracle

    Hi all,

    I am new in oracle database , so can any one help me why this extension
    like .spc, .bdy and .sql used in oracle

    Thanks
    Gajanan

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >like .spc, .bdy and .sql used in oracle
    Neither Oracle nor OS know care about "extension".
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    It's just "convention".

    I have never seen .spc and .bdy but I would guess they are for packages. The first stores the package specification and the second the package body.

    Having naming conventions like that is nice because you normally know what the content of the files is.

    Even though the operating system - strictly speaking - might not care about extensions, most OS (or better: their windowing system) do know about extensions or have other means of identifying the application the user associated with a specific file type.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Oh, and I thought that .spc must have been a "stored procedure". But OK, a package specification makes more sense (especially when together with .bdy).

  5. #5
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by Littlefoot
    Oh, and I thought that .spc must have been a "stored procedure".
    That depends completely on your naming conventions

    (I guess that's what anacedent was referring to...)

  6. #6
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Absolutely; in fact, my procedures are .prc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •