http:\/\/oracledoug.com\/test.sql<\/a>, you’ll see the script that this is running.<\/p>\nWe were talking about this at work and perhaps the main use I could think of would be a centralised script repository that didn’t need distribution to multiple servers or any NFS mounts. I’m not sure I can see too many people using this extensively, but it’s nice to learn a new quirk.<\/p>\n","protected":false},"excerpt":{"rendered":"
This one is courtesy of Andrew Campbell at Sun Microsystems. He noticed in an Oracle Magazine article that you can use a URL as a script name in sqlplus. SQL> select * from v$version;BANNER—————————————————————-Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – ProdPL\/SQL Release 10.2.0.1.0 – ProductionCORE 10.2.0.1.0 ProductionTNS for 32-bit Windows: Version 10.2.0.1.0 – ProductionNLSRTL… Continue reading Something Else I Didn’t Know<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-884","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":913,"url":"http:\/\/orcldoug.com\/blog\/2005\/11\/04\/resetting-vfilestat-timings\/","url_meta":{"origin":884,"position":0},"title":"Resetting v$filestat timings","date":"November 4, 2005","format":false,"excerpt":"As I mentioned in a previous blog, I learnt something new from Anjo Kolk's SAN presentation at the Oak Table day at the UKOUG conference. Instead of looking at the maximum read time for a file since the instance started or the average in a statspack report, you can reset\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1030,"url":"http:\/\/orcldoug.com\/blog\/2006\/07\/21\/monitoring-index-usage\/","url_meta":{"origin":884,"position":1},"title":"Monitoring Index Usage","date":"July 21, 2006","format":false,"excerpt":"A common requirement cropped up this week. A new Data Warehouse has just gone live and is still in the 'do we have the right indexes here' phase. In this case, the suspicion is that there are too many indexes in a specific schema and that a number of them\u2026","rel":"","context":"With 8 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":883,"url":"http:\/\/orcldoug.com\/blog\/2006\/01\/15\/windows-orion-numbers\/","url_meta":{"origin":884,"position":2},"title":"Windows ORION Numbers","date":"January 15, 2006","format":false,"excerpt":"Prompted by Jeff Moss' blog, I decided to use ORION to measure the performance of various I\/O configurations I'm testing for the upcoming Hotsos presentation. I've already blogged about the Linux results on a couple of configurations but I'm still tempted to include a Windows Laptop test (although I haven't\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1597,"url":"http:\/\/orcldoug.com\/blog\/2014\/05\/02\/statistics-on-partitioned-tables-part-6c-copy_table_stats-bugs-and-patches\/","url_meta":{"origin":884,"position":3},"title":"Statistics on Partitioned Tables – Part 6c – COPY_TABLE_STATS – Bugs and Patches","date":"May 2, 2014","format":false,"excerpt":"I wanted to talk about a few of the bugs and patches you need to be aware of if you plan to use DBMS_STATS.COPY_TABLE_STATS. Believe me, when entering the world of stats on (sub-)partitioned objects, you had better be prepared to spend a lot of time on My Oracle Support\u2026","rel":"","context":"With 4 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1046,"url":"http:\/\/orcldoug.com\/blog\/2006\/08\/05\/statcounter-blocking-cookie\/","url_meta":{"origin":884,"position":4},"title":"Statcounter Blocking Cookie","date":"August 5, 2006","format":false,"excerpt":"My website stats have shot up since making the case, decode and px papers accessible again using server side redirection from the old Tripod site. Spot the bit where the redirections were missing \ud83d\ude09In fairness to Pete S, though, I should point out that the number of page hits is\u2026","rel":"","context":"With 1 comment","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":989,"url":"http:\/\/orcldoug.com\/blog\/2006\/06\/13\/spamming-orablogs-again\/","url_meta":{"origin":884,"position":5},"title":"Spamming Orablogs again?","date":"June 13, 2006","format":false,"excerpt":"Sigh Look at http:\/\/oracledoug.blogspot.com Now look at http:\/\/feeds.feedburner.com\/DougsOracleBlog Now look at http:\/\/oracledoug.com\/serendipity\/index.php?\/feeds\/index.rss2 Now look at http:\/\/orablogs.com","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/884","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=884"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/884\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=884"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}