Menu

Storage clause in table definition

Strangerke
2004-06-10
2004-06-16
  • Strangerke

    Strangerke - 2004-06-10

    Hi,

    I've tried PLDOC and found it to be really great, as I had most of the documentation correct without any modification in my source code. Really a great and definitely usefull utility.

    I also tried the night build dated 9/june/04 juste to see the main differences and I happily saw that the table "comments" are now handled.

    I still have a little problem concerning the storage clauses of my table creation scripts.

    Is there something planned concerning this ?

     
    • Albert Tumanov

      Albert Tumanov - 2004-06-13

      Yes, sure.
      I did not have a storage clauses in my own scripts,
      that's why I forgot to handle them.

       
    • Strangerke

      Strangerke - 2004-06-14

      Well, this make me think of something.
      Why don't you use the grammar definition provided by Oracle in its documentation ?
      Wouldn't it be a lot easier than trying to redefine it on your own ?

       
      • Albert Tumanov

        Albert Tumanov - 2004-06-15

        Hmm, do you think I'm trying to define my own SQL grammar ? :)))

        The problem is, there is no official and complete (PL)SQL grammar provided by Oracle. They maybe don't even have one.
        The "grammar" that is in PL/SQL Developer's Guide is incomplete and sometimes even incorrect.

         
        • Barry J.

          Barry J. - 2004-06-16

          Ironically, the storage clause that started this is a good example of the documentation not matching reality.  The CREATE TABLE syntax suggests some constraints on the sequencing of physical properties that I don't believe is enforced by the parser. It would also be VERY time-consuming AT LEAST to convert ALL those railroad syntax diagrams into a machine-readable form such as BNF that could be plugged into a generic parser (and I don't think Oracle's textual descriptions are sufficiently rigorous in their construction to be used instead).

           
          • Albert Tumanov

            Albert Tumanov - 2004-06-16

            Yes, those are exactly the problems I face

             
          • Strangerke

            Strangerke - 2004-06-16

            Well, yes.
            I was mainly thinking that using those railroad syntax diagrams would allow to be sure not to forgot some parts of the syntax.

            I absolutely agree concerning the time it would take to integrate all these information. I just don't agree on the fact that not doing it is quicker ;)

             
    • Strangerke

      Strangerke - 2004-06-15

      Well, you're right, of course...
      I just thaught it would be easier to follow the schemas provided in the Oracle Docs...

       

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.