I'm not sure what are the question marks are lately...I can't think of better titles so perhaps it's me guessing at the title.
I'm sadly dependent on SQL*Plus...and when I mean "sadly" I mean I go to great lengths to get the Windows version which was obsolesced (sp?) in 11gR1. I could never get it quite right, the output I mean, but it was just so easy. Type in your SELECT statement, hit Enter and go. Easy. Yes, yes, I know, you can use the shell version too...I just liked the Windows version despite all it's quirks.
Then I found a Metalink note: WIN NT - Generic Connectivity using ODBC [ID 114820.1]
What software do you need? MySQL ODBC driver
Now follow these steps:
Let's say you have DEGREE set at the table and index level.
I ask you if this is appropriate, instead offering up using whatever tool accessing the data to provide the PARALLEL hint.
The DOP is set pretty low, given our current system.
But it's still set and can't be easily turned off.
I'm all for PARALLEL, but it's been beaten into my head that it should be used, specifically for batch operations. In other words, transforming or loading data.
This may sound trivial but the question is one of the frequently asked question in the forum. I just created an example showing how to check a tabular form on duplicate entries prior to saving the new added rows. You will find the example here. Try adding some rows and enter an already existing name for the ename.
Just a quick note to say that the APEX Listener Early Adopter 2 is out.
Kris Rice blogged about the features and fixes available in this EA, I just quickly tested out the XLS upload (turns it into an APEX collection….very very cool!).
The APEX Listener is definitely introducing some interesting features (like the ability to [...]