Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

Tuesday, 26 November 2019

On the PL/SQL you don't write when using APEX.

Fancy joining in on a discussion with PL/SQL and Oracle APEX community members from around the world?

I'm honoured join Karen Cannell and Scott Spendolini, to be hosted by Steven Feuerstein in the next AskTom PL/SQL Office Hours on December 3, 2019.

It seems a few people haven't heard of these "office hours" sessions, but they're worth a go - more than just your average webinar. And they're all recorded for later viewing.

Topic
This is just the PL/SQL sessions! Every month they have one for Oracle APEX, SQL, Spatial, JavaScript, JSON, Database Security, and even more.

Product segments

It's probably one of the richest learning resources Oracle currently produces, and I really need to tap into more of it.

If the timezone gods allow it, I recommend live participation, as you really do get your questions answered. The produce managers handle the chatline, ensuring questions get followed through.

I think Steven's ensuring we have a good 15 minutes for questions, because they always come through. They keep the chat transcripts, too. The one for Oracle Forms Modernisation was all about the questions!

And it's free - you only need to sacrifice your email address, though it's probably the best email feed I have. Concise, infrequent, except my forum feed, of course.

On December 3, in my 15 minutes of fame, I plan to (spark debate?) about "the PL/SQL you don't need to write". I delivered this as an APEX application, instead of whipping out the ol' powerpoint.

Join in next week, and Karen will start with some decent habits, and the other Scott will no doubt enlighten us about security, or some such.

Free training - from Oracle... well, in this case, delegated to some passionate volunteers. ;p

Monday, 18 June 2018

Free Oracle Learning Tools

This post is one of a series on what I learned while not at Kscope18.

Would you like to learn something from the Oracle technology stack?
Here's a slide probably in a bunch of Oracle employee decks.


I think this collection represents the commitment Oracle is making to the developer community, in part thanks to the developer advocates team. Upon seeing these listed together, and considering the amount of work done to keep raising the bar, I've learned Oracle really are serious about engaging with the greater community.

  1. quicksql.oracle.com - one of the packaged apps given it's own URL. Construct your DDL/DML really fast, if you're happy to learn more markdown syntax.
  2. livesql.oracle.com - it's ridiculously easy to start playing with the Oracle product at this site. Recently I wanted to check some behaviour with a JSON query in the database version above what we had available, and I was able to confirm a database upgrade would solve the problem we had.
  3. devgym.oracle.com - I spend 5-10 minutes a week playing 3 quizzes, targeting PL/SQL, SQL, and database design. Sometimes I learn something new, something re-enforce something I'm familiar with, something I'd forgotten, or something interesting the database can do but I might never use.
  4. apex.oracle.com - surely we've all been here, playing with the most up-to-date release of the best feature of the a great database.
  5. asktom.oracle.com - I learned all my best habits from here, and highly recommend anyone ask a question. Especially anyone learning (hint - that's all of us). It's also a great place to learn how to ask a question.

These are all included in the APEX shortcuts page, along with another learning tool that could fill that 6th spot (besides 18c XE) - the forum. Here I do what I used to do at AskTom - read anything comes through; start listening to topics I need/want to learn about; and here I also get to contribute where/when I can add some of my knowledge & experience. Or if I have a bookmark to a solution someone previously documented.

At the forum you'll find a collection of volunteers willing to help you with your APEX/Oracle questions. Remember, "the #orclapex community is like no other".

ps - we could probably also add the Oracle Learning Library.

Thursday, 14 June 2018

Oracle XE 18c and #OracleRAD

This post is one of a series on what I learned while not at Kscope18.

Oracle XE (Express Edition) 18c - which is more than just a free, limited db.
Combined with the notion of #OracleRAD, you've got a mongo killer ;p

#oraclerad

Quite a few people had a shot of the XE 18c feature list.


Impressive as that is, when you start putting it into context of the sort of things that can now be achieved with the technology available today, it's mind boggling.
And Connor knows just how to amaze us the potential of this technology, making amazing concepts sound just within reach.


But I think the best way to think about it is how this mini-stack adds up.


We've got a free Database; with a middle tier that can handle all our web services needs (REST), while still using SQL; and APEX in the middle, giving us access to pretty much every capability the web offers today, where the productive IDE lives within the browser. Simply, wow.

I'd like to end this post with this tweet I saw just before Kscope18 began


This XE 18c will be magnitudes more advanced than XE 11g, and I think I'm understanding the true potential of this. I can't wait to find a stream of Mike Hichwa expressing his passion for this release.

Wednesday, 21 June 2017

Annual Oracle release cycle coming?

Those of you on Twitter at the end of May, and certainly those at DOAG might have seen this announcement.

I'm no DBA, but that first sentence in the picture has the potential to be rather game changing.
Annual Feature Release of Oracle Database Software
More information is to come (from official channels), as so eloquently put in a comment on this only other post I've encountered on the topic, but I've been pondering this glimpse of change with some colleagues, here in the suburbs of our isolated Australian city.

We're navigating our way through a few upgrades now, and I've seen the same patterns before. Without a clear idea on event what month a major release may arrive, it can be difficult to engineer time into the schedule for an upgrade. It's like launching rockets, miss a window and you may have to wait months for another opportunity.

Other software vendors have set release schedules, and it an annual release cycle will no doubt influence the operations of Oracle consumers (and conferences) around the world, I think for the better.

And they probably won't need to worry about how to market the superstitiously tainted #13.

Thursday, 15 October 2015

The Oracle Development Community is Buzzing

I don't know about you, but it sure seems like a fire was lit somewhere in Oracle and now there are all sorts of things going on in the development community.

We've had some discussions about this over the water cooler and I think there are many positives we can take out of this engagement, and I think a deeper message being sent to veterans that Oracle is still up for the game against the younger competitors.

The Oracle Developer Advocates Team

I think this is one of the best initiatives to come out of Oracle for some time. They've basically recruited some of the most passionate voices in the Oracle community to help the rest of us create faster, secure, more maintainable applications.

I first noticed this with Dan McGhan running jsao.io, a site I have not been able to keep up with considering other projects this year, but what a site it is. There is a long term coupling of JavaScript, Node and APEX and I can't think of a better person to spearhead the sharing of knowledge in the community.

I'm lucky enough to live in the same city as another advocate, Connor McDonald. This actually means I work within a stone's throw, but we don't nearly enough catch-up beers. I can't say enough about his presentation ability, but his on the job passion is second to none.

Steven is obviously Mr PL/SQL, and I met Todd briefly at Kscope15. Given this pedigree, I trust the others in the group bring superb qualities.

AskTom

Tom Kyte has been running this site for a long time, just before I started my Oracle career. I'm impressed he's managed it by himself for so long, but now the reins have been handed over, and the choice of Chris Saxon and Connor for replacement is spot on.
When first started this site sure helped me form better practices in SQL and PL/SQL. I don't use it so much anymore, but I agree with the message from up high in Oracle that this site had to continue, and become more active.

LiveSQL.oracle.com

If you've encountered jsfiddle.net, then you might have also seen sqlfiddle.com. Today on Twitter I saw an announcement for livesql.oracle.com, complete with supplied scripts and tutorials.

This is a brilliant idea, and it's I think it's awesome they're using APEX for delivery. You'll no doubt find many AskTom answers and demonstrations linking to this site, and I think it will be a great repository for developers

Conferences

I'm a long way from Rome, but with the aid of modern technology I'm able to keep my finger on the pulse, and it sure seems strong. It seems these days you kind find yourself a reasonably close conference targeting developers regardless of where you live. If you haven't been to one I highly recommend it, for the experience, the learning and the camaraderie.

If you're unable to attend a conference, ODTUG hosts many webinars, one of which is coming up next week that apparently all APEX developers should tune in for. Midnight challenge accepted.

I have more experiences to share from my time at Kscope15, still some hand written notes and mental thoughts I'd like to translate to the blog. It's still got me thinking about the community, and how amazing the ODTUG team is at serving it. Become a member and have your say in the board.

Oracle Open Source

If I were to guess the topic of the Top Secret APEX Community Event, I would say it has something to do with the gathering momentum of an Oracle open source project at oraopensource.com. I've heard a bunch of ideas and promises come from that direction, and so far the organisation of a bunch of stubs.

They have big, useful things in the works, time for pay dirt?

Oracle Database Developer Choice Awards

Voting closes at some point as the planet rotates today, but I hope you voted for a few people. It's another new initiative, maybe not done quite right but it's early days and there are many years to come.

If you're on social media it would be hard to miss ongoing commentary about some of the issues faced in regard to voting. I'm not going to go into detail, but let's remember it's early days in a new idea and mistakes will be made and learned from. It sure took a long time for the Nobel prizes to sort the crap out, just ask Rosalind Franklin.

Internet voting is hard. The organisers inherited an existing framework with some unforseen pitfalls. Perhaps next year a shiny APEX application will take its place. maybe with a modified voting system.

The spread of categories is certainly developer centric, another win for us. I was humbled when asked to be involved in the judging process for the APEX category. I figured if I'm a judge in something, surely that means I would warrant nomination for such an offer, or so my ego went.

However, this means congratulations should be forwarded to not only those nominated (and the other judges of course), but the many skilled developers out there who were not nominated simply due to community apathy, something that Tim Hall had a little rant about. There were also nominees that became ineligible by virtue of residing in a particular country. One nominee couldn't be added, ironically while organising a separate competition.

The same can be said for passionate, skilled developers out there who are not recognised as ACEs. I still have a post drafted diving into my thoughts on the program, but for the awards the APEX judges decided nominated ACEs have already received deserved recognition, and we as a community wanted to find some more diamonds in the rough. Some future ACEs no doubt.

As a judge I was ineligible to vote, but now voting is closed I thought I'd share some thoughts on each category.

SQL

This first category demonstrates an interesting issue regarding internet voting. With all due credit to Emrah, I think an active local community has come together to support their nominee, and he will come out of this a more noticeable member of the global community - mission accomplished.

I would like to thank Kim Berg Hansen for his very active presence online. I haven't participated in the PL/SQL Challenge site since Steven Feuerstein started wearing red shirts, but Kim's SQL quizzes are excellent and that takes commitment.

PL/SQL

Kudos to some nominees here crossing categories, but for me the standout in helping my understanding of some of the most useful but slightly more complicated features of the database is Adrian Billington. The www.oracle-developer.net website has articles that effectively explain some tough topics. These OakTable fellows sure are made of the right stuff.

ORDS

I haven't had enough time to really play with this product. A colleague has done most of the infrastructure work for our current client and I'm waiting for a chance to eke some more leverage out of this maturing product.

I asked a question on the forum about ORDS recently and was reminded how much I didn't know, and how much Dietmar is all over this product. In my mind a deserved inaugural winner.

APEX

Being so involved in this product now I could say plenty about each of the nominees, and illustrate how hard it must be to compare apples to oranges to mangoes. They've all contributed in relatively uniquely ways, and Morten in nominated once again.

Trent is probably the quietest achiever of the group, though I know his blog posts are quality over quantity and I've learned from his plugin dabblings.

If anyone has used the forum they've encountered Paul MacMillan as fac586. I think everyone must have learnt at least something from his replies.

Karen is the IR queen. I think our circles and geography differ somewhat, but that's why they asked for geographically diverse judges.

Morten has done amazing work in building a library of useful libraries. Hard to top and at this point he may have pipped Juergen, a new kid on the block but what a demo app for dynamic actions! And awesome work starting an APEX podcast with very interesting interviews.

Kiran Pawar has been a recent star in the forums, quick to provide good references to people looking for information. I have criticised some of his answers recently but I'm sure the same could be said for some of my responses, and certainly questions. I made some doozies recently.

Jari Laine is a JavaScript wizard that I've learned plenty of practical applications for jQuery. I could not have built such a versatile tablet application without integrating some work he's shared.

Database Design

Surely this is the most esoteric of the categories, but at times I really do miss some of the best designers I've encountered. I can't add much beyond congratulating fellow Perth technologist Mark Hoxey as a nominee. Someone obviously thought enough of his contribution to best practice to place a nomination, well done.

Final Thoughts

If you think support for Oracle technology is waning, think again. There's plenty I've missed, stuff I don't know, and time & spirit to nurture and cultivate some great ideas. With such a large amount to learn, I find solace in a community that facilitates such a variety of options to learn. I'm glad I have freedom to contribute my part.

Friday, 21 August 2015

Inaugural Developer Choice Awards

Can you think of anyone worthy of being recognised in the following areas?

Developer Choice Awards Categories
Today is the last day for nominations, so visit the website and nominate the first person you think of - right now!

From mid next month you will have a chance to vote for the finalists.

It looks like Oracle are trying really hard to be more involved with the community, so I think good on them for this initiative.

Monday, 22 September 2014

Leisure Suit Larry Ellison

Larry Ellison 1978
So at 70 years of age, the man who's been heading Oracle since before I was born is stepping down.

While I admit I'm far removed from the reality of the situation, I find it a little amusing how it's been deemed as a 'shake up' when a few paragraphs before he's quoted as saying this (referring to new co-CEOs)
“I am going to continue to do what I have been doing the past several years and they are going to continue doing what they have been doing the past several years,” 

So I bet he's probably going to be working in the same office, just the title under his name on the door will read "CTO". So for us at the coal face, surely this means he will spend more time directing the nature of the beast and leave operations to those who specialise. That sounds to me like a good thing.

I enjoyed this New York Times article, but writer Quentin Hardy made me read one of the last paragraphs a few times
Mr. Ellison does not leave his company entirely untroubled. Besides continuing challenges in cloud computing, including acquisitions and new competition, the company faces a raft of new types of databases, first developed inside Google and Yahoo, that also threaten the dominance of the relational database.

I've been thinking recently what the next generation of databases will be like. The relational model was revolutionary at the time, but bigger data and intelligent networking will surely one day reach another punctuated equilibrium. No doubt it will come from somewhere like contemporary giant Google.

If I was a passionate billionare I think I would have left the business behind long ago, along with the suit.
Circa 1993 - no eyebrows then either

Wednesday, 26 June 2013

Oracle 12c now up for grabs

For many geeks out there, throw todays productivity out the window - Oracle 12c is now available for Linux/Solaris.

I'm not sure the official press release is out, the documentation sure isn't - but Twitter sure is abuzz.

While searching, I also spotted an article saying the pluggable database component will be a costed option.

Let's see how long it takes Tim Hall to release a string of articles on new features.

Here I was betting on a July release... at least all our Insync13 onference submissions for 12c can be ratified!

Monday, 3 June 2013

Ubuntu Milestones - Oracle

For many, many years I've yearned to move away from windows. Everyone has their reasons, some have motivation, I finally had opportunity to make some baby steps.

I needed to set up an environment using APEX 3.2, and I had an old XP laptop that I finally moved my ipod synch off so I figured it was free to experiment with. I was already running it with dual boot, but I never pulled my finger out to restart & play around with the Ubuntu half.

Earlier in the year I experimented a little with Ubuntu using VirtualBox on my existing Windows7 laptop - I've even drafted a blog post rambling about my experience, but I've got some fresh thoughts with my recent jump in the deep end.

First impressions - it's an OS worth me pursuing.

It's certainly a cultural change. Of course, you need to be able to do many of the same type of operations - move files, close windows, setup Oracle... but to use a balinese catch phrase - it's same same, but different.

Installing Oracle

I was a little bit of a cowboy with this - while I was keeping note of the websites that I was using as a reference, I didn't take note of each command I performed. This was going to be a temporary db, and I figured this first attempt justified a little gun-ho action.

Besides, my ultimate plan is to use Virtualbox to run different environments in their own confined buckets. This old laptop is destined to be a sandpit.

I used this Linoob address to help install the db. In the end I'm pretty sure the apt-get just opened up the software centre.
Oracle in Ubuntu Software Centre
I think it's a selling point for this particular distribution of *nix based systems, installing software is just like searching Google Play or the Apple Store - they aren't the scary domain of sysadmins anymore.

Setting up SQL Developer was a little more tricky since there is no download available specifically for Ubuntu. Instead, there is a package builder for .deb packages, so I still just needed to download the base file, run a few commands and it could be installed no problem.

Installing a JDK to support SQL Developer was a little more interesting. I used the manual option, which again is just a list of commands. I'm positive I haven't put the JDK folder in a 'typical' location, but that's the burn of learning.

Having to run commands like this in a way reminds me of the days of DOS, which you could take as no really progressing from the Windows environment of just clicking "Next" - but I don't see this as a con. I see it as liberation, a way to gain flexibility. Some of the commands seem foreign now, but I don't think it's far away from recognisable, then second nature.

All that being said, you could look at setting up SQL Developer in Ubuntu on par with setting it up in Windows. In the latter, I still need do download a set of files, extract, and on first run point it to the java.exe that I always need a few attempts with getting the path just right. In Ubuntu, I surprisingly got this path first go!

The only oops I did was download the latest and greatest JDK (7), which SQL Developer is not ready to support, though it ran anyway. I'll fix that later...

The closest I got to the OS was when I had to add my user account to the DBA group. I needed to do this before the database fired up. After an initial scare of making it all this way and not being sure why it wouldn't start - I found a pretty clear instruction on the OTN forum.

With all this gun slinging, I forgot to configure the DB.
/etc/init.d/oracle-xe configure

Configuring APEX

From here it was familiar territory in upgrading APEX from v2 to my target of v3.2.1

These commands I could run from SQL Developer
Upgrade
@apexins SYSAUX SYSAUX TEMP /i/

Load images to EPG (I wasn't game to attempt APEX Listener just yet)
@apxldimg.sql /home/scott

Unlock the public user account (I was doing this mostly from memory, after setting up APEX so often, I even remembered this one after my attempt to log in just stalled in the browser)
ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;

The only script that didn't want to run from SQL Developer was the one to change the ADMIN password (apxchpwd.sql)
Instead, I just pasted the code in the SQL worksheet and ran it from there.

Restarting the OS

After restarting, the database didn't restart (an option I chose), but the scripts in the menu did not work. Again, I think this just came down to me lacking understanding of some permission issues, and I found a command that worked for me.
sudo /etc/init.d/oracle-xe restart

Conclusion

I got up and running in a few distracted hours. While there was a few hurdles, there was never anything that really concerned me or had me stuck for too long. Google was my dear friend, but I'll keep perusing my Beginning Ubuntu Linux book.

Next I'll be looking for alternatives to some programs I regularly use in Windows.