While SQL Developer installs with a dbms_output view, some organizations close it before they distribute images or virtual machine (VM) instances. This post shows you how to re-enable the
Dbms Output view for SQL Developer.
- You need to open SQL Developer, which may look like this when the
DBMS_OUTPUTview isn’t visible.
- You need to click on the View menu option in SQL Developer and choose the Dbms Output dropdown menu (more...)
If you’re searching for “export Oracle BLOB”, the article, by Jeff Smith, titled “Exporting Multiple BLOBs with Oracle SQL Developer” using Oracle SQL Developer” is usually at the top of the search result. The SQL Developer features the Shopping Cart without using scripts to export BLOBs out of database. I don’t want to go into detail as Jeff already explained well in his post what it is and how to use it. One (more...)
You can follow Twitter yourself searching for this hash tag: #apexcompetition
Oracle APEX Tips: APEX Dashboard Competition for English Locale https://t.co/ovtkMuL3Zn #apexcompetition— Trent Schafer (@trentschafer) January 23, 2016
3-part series on building dashboards. 1. 6 Golden Rules to Successful Dashboard Design: https://t.co/LTuHOEKXH3 #apexcompetition— Trent Schafer (@trentschafer) January 22, 2016
2. Data (more...)
Why Export Connections?
First of all, why would you want to export your connections?
There are a few reasons I can think of.
- Keep a separate file that contains your connections in case your computer crashes
- Save time setting up your computer (more...)
What Is SQL Formatting?
SQL formatting is the process of neatly arranging your code to make it more readable.
When you write SQL, the format of the code is not relevant to the database. By this, I mean that the SQL statement will execute if the syntax is correct and the formatting is terrible.
Formatting the (more...)
What Are Line Numbers in SQL Developer?
Line numbers are numbers that are next to each line in the Code Editor. They indicate which line of code you’re working on.
They are helpful for developers for many reasons:
- They let you see how many lines of code you’ve written
- They help with debugging errors, (more...)
In this post I’m going to show to synchronize the remote and local repositories after an existing file in local gets modified. What I’ll do is modify the sp_test_git.pls file in our local repository and then push those changes to the remote repository (GitHub).
First, I proceed to open the sp_test_git.pls file using SQL Developer, add another dbms_output line to it and save it. The moment I save the file, the Pending Changes (more...)
In my previous post, I showed how to clone a GitHub repository using SQL Developer. In this post I’m going to show to synchronize the remote and local repositories after remote gets modified.
Here I use GitHub to commit a file called sp_test_git.pls. You can create files by clicking on the icon the red arrow is pointing to.
The content of the file is a PL/SQL procedure that prints a message.
At this (more...)
SQL Developer 4 provides an interface that allows us to interact with Git repositories. In this post, I’m going to show how to clone a GitHub (A web based hosting service for software development projects that uses the Git revision control system) repository.
First you need to sign up for a GitHub account. You can skip this step if you already have one.
Your account will give you access to public repositories that could be cloned (more...)
See http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-releasenotes-v4-1925251.html for the details.
The PL/SQL Debugger works pretty much out of the box when used with a previous Oracle version. These are the things we needed in place before we could start debugging PL/SQL:
- A grant of the DEBUG CONNECT SESSION privilege.
- EXECUTE privilege on DBMS_DEBUG_JDWP.
- EXECUTE privilege on the stored procedure you want to debug.
- Make sure the stored procedure is “Compiled for Debug”.
Jeff Smith talks about it in this post.
But what happens when you (more...)
Well, I've had enough of that. (more...)
In the next version of SQL Developer, you'll be able to hold the ctrl key down and click on the file name and have it open up. This also works (more...)
Now I have a script, how do I run it in SQL Dev? In SQL*Plus, I would run it like @clean_tables. Two things to note there, 1, I didn't have to put the extension on the file and b, I assumed SQL*Plus was running from the directory where my file was located. If I was running the script from a different directory, I would have to use either a relative path...or something, but I digress.
I wanted to be able to run my (more...)