The relevant query is as follows:
SQL> set long 10000
SELECT text
FROM user_views
WHERE view_name = ‘<VIEW_NAME>’;
Tuesday, 10 May 2016
Subscribe to:
Post Comments (Atom)
Follow us:
End to End Topics With SQL,PL/SQL,Reports,Forms,XML Reports,OAF,Oracle Apps
Home » APPS QUERIES » Query to Get The Code For a View
Hi There,
ReplyDeleteGreat 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
Hello Dayakar,
ReplyDeleteYour 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
Hi Dayakar,
ReplyDeleteGrazie! 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
Hello There,
ReplyDelete11/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.
Superbly written article, if only all bloggers offered the same content as you, the internet would be a far better place.. كوبون خصم نمشي
ReplyDeleteThis comment has been removed by the author.
ReplyDelete