Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Sunday, 3 April 2016

Comments in PL/SQL

To comment line or lines in a PL/SQL program use,
-- for single line comment

/*    */ for multi-line comment
Share this article :


  1. Hi Dayakar,

    What a brilliant post I have come across and believe me I have been searching out for this similar kind of post for past a week and hardly came across this.

    I am using SQL server 2014 standard edition.
    I am using Drill Through action to display a detail report for my cube data, which is working fine. Only issue I see is when I drill through year and quarter it displays data for months in a haphazard manner instead of sorted by month.
    How do I set it to sort by month, and Item Number (which is a fact dimension for this measure) within month?
    The System Global Area in an Oracle database is the area in memory to facilitate the transfer of information between users. It holds the most recently requested structural information between users. It holds the most recently requested structural information about the database. The structure is database buffers, dictionary cache, redo log buffer and shared pool area.
    Once again thanks for your tutorial.


  2. Well, it shouldn’t take you longer to generate or convert icons, and with this free Icon Maker and Converter it surely won’t! Now you can save time and focus on what’s actually important.


  3. The great service in this blog and the nice technology is visible in this blog. I am really very happy for the nice approach is visible in this blog and thank you very much for using the nice technology in this blog
    Oracle course in chennai

  4. Hello,

    11/10!! Your blog is such a complete read. I like your approach with Comments in PL/SQL . Clearly, you wrote it to make learning a cake walk for me.

    how to find first nonspace character from end of the string

    ex: 'abc def g '

    I should get 4 in this case. (the first nonspace character from backwards in the above example is g and the position is 4 from backwards.

    Could you help me in getting this?

    I am so grateful for your blog. Really looking forward to read more.

    Best Regards,

  5. Hey, Wow Provided Post will be Very much Informative to the People Who Visit this Site. Good Work! Thank You for Sharing.
    SEO Training

  6. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check

  7. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.