In my previous post, I discussed with you how to installing SQLcl 18.1.1 on your machine or system. Once you have deployed this funny tool on your machine, next you’re necessary to discover some new feature from there. About “SET SQLFORMAT” is a very interesting function. Here’s the operation steps connecting to my Oracle Database test server via SQLcl 18.1.1,
A the end of last month I posted 2 questions of “how to generate some big test tables and rapidly export their SQL data” on Oracle Ask TOM. Apart from Connor McDonald (a significant member of AskTOM teams) answered my first question on my post first time (afterwards I replied to Connor, I also had submitted this issue with the topic – “test table *test1* has generated and how to export pure data via *CSV* rapidly”) at the same time another reviewer Rajeshwaran Jeyabal from American Samoa (also known as Eastern Samoa) replied my second question as well. His nice review attracted my attention and he introduced 2 options to generate CSV output. One method is using Oracle 12.2 and another is SQLcl. I never heard of SQLcl than before. Just for curiosity’s sake so I wanna try to use the interesting and funny tool. It’s also the reason why I write this post.
These days I re-read my a number of posts on WordPress and occasionally discover that there is several different writing format on those posts. At least I haven’t become aware of this significance of standard writing format on my post heretofore (up to now). Therefore I must draw up some basic regulations to come into being a unified and standard writing format.
After considering again and again, I make a decision that I will adopt following 7 points as a unified and standard writing format from now on (before this post I’ve also proofread the content and corrected some mistakes of all of my previous posts).
Yesterday afternoon I was honored to take part in the event which has been organized by OCMU. The entire meeting had chiefly total 3 themes and its agenda was as follows:
- Experts of OCM had shared 2 cases (they’re all come from Production Environment) with others
- 14:00 – 14:50 Haihua Mao, Rewriting thirteen scalar subquery via left join clause – making the elapsed time of a little complex SQL statement be reduce to 2 seconds from 200 seconds
- 15:00 – 15:50 Pengju Lan, A weird trouble-shooting process of connecting to oracle database server via client
- 15:50 – 16:00 Pengju Lan, the experiences of my Oracle DBA‘s professional career
- 16:10 – 17:00 Shengwen Hou, Leading everyone to read and practice the New Features of the official documentation of Oracle 18c and MOS (My Oracle Support)
Oracle DBA, exactly, operating post could be divided into “Devs DBA” and “Ops DBA”. Nevertheless, as far as I know that’s some discussing ideas 3 years ago at least. Currently there is a very common parlance on IT industry. It highly suggests that it should combine “Devs DBA” and “Ops DBA” to become “DevOps DBA” (It means that “Devs + Ops”).
You who have seen the content of my blog regularly maybe notice that I have published an original article about Switching to use oracle on multiple versions a few days ago last month. Recently I think that some details which is important hasn’t been mentioned, hence I’ll explain it clearly on this post.
By the way, I have upgraded to Windows 10 from Windows 7 previous on my laptop during the Chinese New Year (02/15/2018 – 02/21/2018). And then I have installed 3 versions of oracle – 220.127.116.11.0/18.104.22.168.0/22.214.171.124.0 (it’s different than 4 versions last time). Continue reading
When I have seen a funny logo on the OS of Linux from system administrator that hit keyboard for logining to his command line interface a few days ago, and that logo indeed makes me amazing, such as, what he has demonstrated is as follows,
At this very moment, there has a similar ideas in my mind’s eye – even if I am used to doing some operation on my oracle database server, why not I add a banner & logo of oracle company (Here I didn’t give oracle for advertising) on it? With this idea, I get on the action immediately … Continue reading