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

Pages

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 :

4 comments:

  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.

    Cheers,
    Kevin

    ReplyDelete
  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.

    ReplyDelete

  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

    ReplyDelete
  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,
    Radhey

    ReplyDelete