Have you ever noticed when running PL/SQL scripts in Oracle’s SQL Developer that an annoying “Enter Substitution Variable” dialog pops up, and you have no idea why? 212 more words
In my work as a consultant I often have the task of getting data from MS Excel spreadsheets into tables in the database.
If this is a one-time load, the process is simple – use either SQL Developer or, easier yet, use the Data Load Workshop in APEX: SQL Workshop –> Utilities –> Data Workshop. 1,150 more words
The objective of this post is to explain how to execute queries in different transactions using SQL developer. 410 more words
Skills: SQL Developer / SQL Report Writer – SSIS, SSRS, SSAS. My client based North of Leicester are currently looking for a SQL Developer / SQL Report Writer. 307 more words