Tags » SQL Developer

Annoying "Enter Substitution Variable" Dialog Box


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


Read XLXS Files from APEX 5.0 and Higher - One (or Two) Ways

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


SQL Developer: Save a Package (thanks Jeff Smith)

Got this question: Hello @thatjeffsmith ! How I save packege body and packege spec in same archive? #SqlDeveloper — Felipe Pereira (@FelipeR_Pereira) April 27, 2017 Answer: YES.

43 more words

Oracle SQL: Row locking on select statement

The objective of this post is to explain how to lock a record on a Oracle Database, using a select statement. 739 more words


SQL Developer: Executing queries in different transactions

The objective of this post is to explain how to execute queries in different transactions using SQL developer. 410 more words


Migrate from Microsoft SQL Server to Oracle 11g

Hi guys

This time I am going to share my experience with migrating a small MS SQL database to Oracle database using Oracle’s SQL Developer… 828 more words

Windows 10

New Requirement! - SQL Developer / SQL Report Writer - East Midlands, Perm

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