12c came with a very nice feature: privilege analysis. You don't know which privileges are required? then just grant DBA, run your application, and check which minimal privileges are needed. And today, I've discovered how it is very powerful: you can even see privileges used internally, even when not done by SQL, and even not documented.
It starts like that, with a question from Vladimir Sitnikov (who publishes very interesting stuff from his twitter account) in the tone of a challenge:
Our Black Friday special is a great way to get your blog ready for the new year. This weekend, every purchase of WordPress.com Premium will include a free year of unlimited access to all our premium themes — a $120 USD value — so you can use any theme at no extra cost.
The special sale starts just after midnight on Friday, November 28th, and ends just before midnight, on Monday, December 1st, for all time zones.
There was a question on OTN a few days ago asking the following question:
Here’s a query that ran okay on 11g, but crashed with Oracle error “ORA-01843: not a valid month” after upgrade to 12c; why ?
The generically correct answer, of course, is that the OP had been lucky (or unlucky, depending on your point of view) on 11g – and I’ll explain that answer in another blog posting.
Timesten in-memory Database :-ttisql DSN_NAMEttIsql (c) 1996-2005, TimesTen, Inc. All rights reserved.Type ? or "help" for help, type "exit" to quit ttIsql.All commands must end with a semicolon character.connect "DSN=DSN_NAME";707: Attempt to connect to a data store that has been manually unloaded from RAMThe command failed.
Recently a colleague suggested I take a fresh look at the mobile emulation button in Chrome's developer tools.
Apparently this was upgraded earlier in the year and it's a shame I didn't have this a year ago!
The long awaited date had finally arrived, New Zealand Oracle Users Group’s event NZOUG14. I was told about this event by my colleagues. Dbvisit employees often speak around the world at different Oracle conferences. But NZOUG14 is a bit special, as Dbvisit is headquartered in Auckland, New Zealand, the City of Sails. I was excited to […]
One of the reasons I like user group conferences is meeting new people in my “area” – these people at the conference not only like technology and probably some of the same technology I do but, as they are at a conference, are probably inclined to learn stuff, meet people and maybe share ideas. I’m not actually very good face-to-face socially with people I do not know, so I like to tilt things in my favour if I can!
But sometimes you have odd experiences.
If you want to update one table based on the values in another table, use ‘UPDATE = (SELECT) WHERE (SELECT)’ or ‘MERGE WHERE’, as in examples (3) and (3a) below.