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

Pages

Tuesday, 10 May 2016

Query to Get The Code For a View

The relevant query is as follows:

SQL>     set long 10000

SELECT text
FROM    user_views
WHERE view_name = ‘<VIEW_NAME>’;
Share this article :

4 comments:

  1. Hi There,


    Great info! I recently came across your blog and have been reading along.
    I thought I would leave my first comment. I don’t know what to say except that I have

    We have a linked server "LinkSQL" defined on SQLServerA against the same server, ie, SQLServerA and the server has Named Pipes disabled. Isn't communication among'st applications within one server happens primarily through Named Pipes. If so, would it be better if we have Named Pipes enabled on this SQLServer box?
    We are seeing intermittent TCP/Semaphore errors and I was wondering if enabling this option would help.
    But nice Article Mate! Great Information! Keep up the good work!


    Thank you,
    Rani

    ReplyDelete
  2. Hello Dayakar,

    Your blog is such a complete read. I like your approach with Query to Get the Code for a View. 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.
    Cursor is a named private SQL area from where information can be accessed. Cursors are required to process rows individually for queries returning multiple rows.

    Could you help me in getting this?

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

    Best Regards,
    Jordon

    ReplyDelete
  3. Hi Dayakar,

    Grazie! Grazie! Grazie! Your blog is indeed quite interesting around Query to Get The Code For a View I agree with you on lot of points!

    how to get the first non space character from a string in Oracle. Could you help me on this?

    Anyways great write up, your efforts are much appreciated.

    Many Thanks,
    Nandu

    ReplyDelete
  4. Hello There,

    11/10!! Your blog is such a complete read. I like your approach with Query to Get The Code For a View. 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,
    Preethi.

    ReplyDelete