Results 1 to 9 of 9
  1. #1
    Join Date
    Jan 2004
    Posts
    15

    Lightbulb Unanswered: Steps to learn PL/SQL

    Hi

    For learns PL/SQL quickly I recommend you to follow these steps :

    The first step to learn PL/SQL is to get a knowledge base.

    http://pipetalk.quest-pipelines.com/~plsql

    The second step is to stop to use the rudimentary sqlplus and to use an IDE for development.

    DreamCoder for Oracle
    http://www.mentattech.com/

    TOAD
    http://www.quest.com


    The third step to read a book of the great Guru of the PL/SQL Steven Feuerstein.

    http://www.stevenfeuerstein.com/puter/plsql.htm

    The fourth step registers in Oracle Technet.

    http://otn.oracle.com/index.html

    Kind Regards,

  2. #2
    Join Date
    Jan 2004
    Posts
    492

    Re: Steps to learn PL/SQL

    I would not put learning an IDE as my 2nd step. Yes they are very useful and honestly I could not go back to SQL*PLUS. But I think sometimes they make you very lazy and give you bad habits sometimes. They create the entire syntax so you dont have to think, but if you ever need to add a column to a database without an IDE, you're not going to remember how to do so.

    IDE's are like calculators - yes in the longrun they are necessary, but for simple blocks, not necessary. I do however think SQL*PLUS could be improved to allow for at least syntax highlighting and the ability to select and delete text easier.

    And my third rant is that if you are learning anything, you dont need to be plunking down $600 for a stripped down TOAD version when you will use 5% of its available features.

    Though yes I cant remember what life was like before TOAD...LOL

  3. #3
    Join Date
    Jan 2004
    Posts
    15

    Thumbs up

    Hi

    You are right in some things , when your these learning and you face the SQLPlus it is a nightmare.

    "And my third rant is that if you are learning anything, you dont need to be plunking down $600 for a stripped down TOAD version when you will use 5% of its available features."

    This is completely true but in the market there are cheap products and free.

    Kind regards,

  4. #4
    Join Date
    Jan 2004
    Location
    North Haven, CT
    Posts
    110
    is expert-database a sales person from TOAD?

  5. #5
    Join Date
    Jan 2004
    Posts
    492
    There definitely are free tools out there, but I wouldnt deem it a necessity to download one to learn. For application development absolutely. I still maintain that if you learn things the tough way, you will have a better mindset and be more productive when you move over to a GUI tool. Its like when you learn to ride a bike, you dont start with a 21-speed mountain bike. When you get the basics down, you graduate. Same concept.

    Funny how Lynden mentions being a TOAD salesman - I was actually thinking expert-database is a DreamCoder salesperson because I must see dozens of posts a month on the OTN forums about that product. How it will save the world and so forth. I have never heard of this product, nor anyone actually using it, outside of forum posts.

  6. #6
    Join Date
    Jan 2004
    Location
    North Haven, CT
    Posts
    110
    TOAD is a typo. I saw his ad around in OTN too.

  7. #7
    Join Date
    Feb 2004
    Location
    India
    Posts
    6

    Thumbs up

    ss is absolutely right ... i'am a kinda beginner @ pl/sql, initially i was using sqlplus but then i started using toad (part of my job trng), and i really got addicted to the ide ... if i need to look for some record in the DB i use the schema browser !!! .. not a very good habit is it ? tryin' to get rid of it anyway .. (LORD gimme strength !). also ss mentioned abt improving the sqlplus, the sqlplus-worrksheet tht u get with 9i fits the bill i think.

  8. #8
    Join Date
    Jan 2004
    Posts
    15

    Thumbs up

    The use of a tool facilitates the work a lot in the database , the product that uses this is already his decision and there are many flavors and colors of these products.

    But the tool doesn't have you to the teacher and you has to be documented.

  9. #9
    Join Date
    Jan 2004
    Posts
    15

    Post

    I recomended this books :

    Learning Oracle PL/SQL
    Oracle PL/SQL Programming, 3rd Edition
    Oracle PL/SQL Best Practices
    Advanced Oracle PL/SQL Programming with Packages

    More info :
    http://www.oreillynet.com/cs/catalog/view/au/344


    Kinds Regards,

Posting Permissions

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