https://www.realdbamagic.com/wp-content/uploads/2016/05/gift-575400_640.png608640Zohar Elkayamhttps://www.realdbamagic.com/wp-content/uploads/2014/10/Site-logo-for-header-340-x-156-300x137.pngZohar Elkayam2016-05-22 18:24:152016-07-19 23:40:34SQLcl New Version and Other Big Stuff

https://www.realdbamagic.com/wp-content/uploads/2015/08/IMG_20150610_162509.png5761024Zohar Elkayamhttps://www.realdbamagic.com/wp-content/uploads/2014/10/Site-logo-for-header-340-x-156-300x137.pngZohar Elkayam2015-08-27 12:40:162015-11-23 15:46:09OUG_SCOT: I was on fire and then the fire alarm went off

Just a quick note – I was quite busy in the last few days – first there was the Israeli ilOUG convention (it’s still on) but I had to leave early since today I’m speaking at Scotland!

So today I’m speaking at 15:25 – my session is about “Adding Real Time Reporting to Your Database: Oracle In Memory Option”. This is a great session I gave last year in ilOUG SIG group and I added the PoC part we did at Clarizen. I will upload the presentation later today and I will be available to questions on that if you’ve got any.

My seconds session is a joint session with ACE Director Oded Raz – “SQLcl: The Next Generation of SQL*Plus?”. I wrote about SQLcl just a few weeks ago and now we’re presenting it. I will upload the presentation and the live demo document as well.

I hope everything will go okay today – I was told the room we are speaking at is not very big (and that’s a good thing for me). I will upload some pictures later and if you want to read more about my adventures in lovely Scotland on Twitter… 🙂

The first time I started using commercial databases was in 1998, in my basic programming course. The course was split into segments and at the first databases lesson, if my memory serves me right, the instructor began the class with the words: “Today we will learn about databases – first, let’s connect to the database using SQLPlus”.

This amazing tool, which almost everyone who works with Oracle databases knows, is one of the simplest yet powerful command line interface for working with the database. SQLPlus has been with us for many, many years – I used to use it back when I was using Oracle 7 and that says a lot. Since this is one of the most convenient tools to understand, and while it’s not very user friendly it does work great with scripts and other automatic procedures. SQLPlus have great integration with the cluster tools – for example, if we’re using it to stop an instance (regular shutdown), the grid infrastructure is aware the shutdown was on purpose, and it will not try to start up the instance node again. It even has other Oracle tools provide its users and its capabilities often (AWR reports for example).

The fact that SQLPlus has been around for so many years could have been considered a disadvantage because we would think it might not have changed over the years but this is not the case. The tools did change over the years – features and other capabilities were added and that allows us to do cool stuff like output our result to HTML format or interact with our scripts. Unfortunately that’s pretty much everything and the basics of the tool did not change.

I Recently became aware of a new tool from Oracle which will ultimately replace SQLPlus. It’s name is SQLcl and I was really impressed.

https://www.realdbamagic.com/wp-content/uploads/2014/10/Site-logo-for-header-340-x-156-300x137.png00Zohar Elkayamhttps://www.realdbamagic.com/wp-content/uploads/2014/10/Site-logo-for-header-340-x-156-300x137.pngZohar Elkayam2015-03-29 16:40:092016-12-19 19:00:45I have seen the future and it is glorious: SQLcl the next generation of SQL*Plus

Cookie and Privacy Settings

How we use cookies

We may request cookies to be set on your device. We use cookies to let us know when you visit our websites, how you interact with us, to enrich your user experience, and to customize your relationship with our website.

Click on the different category headings to find out more. You can also change some of your preferences. Note that blocking some types of cookies may impact your experience on our websites and the services we are able to offer.

Essential Website Cookies

These cookies are strictly necessary to provide you with services available through our website and to use some of its features.

Because these cookies are strictly necessary to deliver the website, you cannot refuse them without impacting how our site functions. You can block or delete them by changing your browser settings and force blocking all cookies on this website.

Google Analytics Cookies

These cookies collect information that is used either in aggregate form to help us understand how our website is being used or how effective our marketing campaigns are, or to help us customize our website and application for you in order to enhance your experience.

If you do not want that we track your visist to our site you can disable tracking in your browser here:

Click to enable/disable google analytics tracking.

Other external services

We also use different external services like Google Webfonts, Google Maps and external Video providers. Since these providers may collect personal data like your IP address we allow you to block them here. Please be aware that this might heavily reduce the functionality and appearance of our site. Changes will take effect once you reload the page.

Google Webfont Settings:

Click to enable/disable google webfonts.

Google Map Settings:

Click to enable/disable google maps.

Vimeo and Youtube video embeds:

Click to enable/disable video embeds.

Privacy Policy

You can read about our cookies and privacy settings in detail on our Privacy Policy Page.