Oracle Database Tips
Follow
Find
4.7K views | +0 today
Oracle Database Tips
All about Oracle Database (tricks, tips, docs, scripts)
Your new post is loading...
Your new post is loading...
Scooped by Antonio Turibbio Liccardi
Scoop.it!

‘Forcing’ Line Breaks in Oracle SQL Developer

‘Forcing’ Line Breaks in Oracle SQL Developer | Oracle Database Tips | Scoop.it
SQL Developer won't format your shorter SQL statements to multiple lines, unless you tell it to. Here's how.
more...
No comment yet.
Scooped by Antonio Turibbio Liccardi
Scoop.it!

Using Oracle SQL Developer to Setup SQL*Loader Runs

Using Oracle SQL Developer to Setup SQL*Loader Runs | Oracle Database Tips | Scoop.it
Yes, SQL Developer can suck data from Excel into an Oracle table, but what if you have a million rows to process? Is there a better way? Maybe.
more...
No comment yet.
Scooped by Antonio Turibbio Liccardi
Scoop.it!

Using XML Extensions in SQL Developer to Extend SYNONYM Support

Using XML Extensions in SQL Developer to Extend SYNONYM Support | Oracle Database Tips | Scoop.it
I want SQL Developer to provide more support for working with table synonyms.
more...
No comment yet.
Scooped by Antonio Turibbio Liccardi
Scoop.it!

Be careful when migrating – Difference between oracle 10g and 11g | Help 2 Oracle - Welcome to help2ora.com – Tips, tutorials, procedures

Be careful when migrating – Difference between oracle 10g and 11g | Help 2 Oracle - Welcome to help2ora.com – Tips, tutorials, procedures | Oracle Database Tips | Scoop.it
more...
No comment yet.
Scooped by Antonio Turibbio Liccardi
Scoop.it!

Impact of Updating a Row Using a PL/SQL Record Type

Before I talk about the topic of this post I’d like to demonstrate a bit of obvious information just to get it in the forefront of your mind. First off we create a test table holding 5000 rec...
more...
No comment yet.
Scooped by Antonio Turibbio Liccardi
Scoop.it!

An Introduction to SQL Developer Extensions

An Introduction to SQL Developer Extensions | Oracle Database Tips | Scoop.it
Oracle SQL Developer is made available to you for free, and is chock-full of features for the developer, DBA, or data-junkie.
more...
No comment yet.
Scooped by Antonio Turibbio Liccardi
Scoop.it!

Oracle/PLSQL: To_Number Function

In Oracle/PLSQL, the to_number function converts a string to a number.
more...
No comment yet.
Scooped by Antonio Turibbio Liccardi
Scoop.it!

Using SQL Developer to Debug your Anonymous PL/SQL Blocks

Using SQL Developer to Debug your Anonymous PL/SQL Blocks | Oracle Database Tips | Scoop.it
You CAN debug your anon plsql blocks with Oracle SQL Developer - here's how!
more...
No comment yet.
Suggested by Jeff Smith
Scoop.it!

SQL Developer

SQL Developer | Oracle Database Tips | Scoop.it

Welcome to my resource page for Oracle SQL Developer. Here I spotlight my favorite tips and tricks for getting the most out of Oracle's database IDE.

more...
No comment yet.
Scooped by Antonio Turibbio Liccardi
Scoop.it!

Oracle SQL Developer v3.2 is Now Available!

Oracle SQL Developer v3.2 is Now Available! | Oracle Database Tips | Scoop.it
Today we released the latest version of Oracle SQL Developer - v3.2.09.23.
more...
No comment yet.
Scooped by Antonio Turibbio Liccardi
Scoop.it!

How To Block Select Text in Oracle SQL Developer

How To Block Select Text in Oracle SQL Developer | Oracle Database Tips | Scoop.it
Just toggle off the 'wrap selection' option under the Edit menu. Then you can block select all you want in the Worksheet and Procedure Editor.
more...
No comment yet.
Scooped by Antonio Turibbio Liccardi
Scoop.it!

Including BLOB images in your PDF Reports

Including BLOB images in your PDF Reports | Oracle Database Tips | Scoop.it
Include your images stored as BLOBs in your Oracle SQL Developer PDF reports...
more...
No comment yet.
Scooped by Antonio Turibbio Liccardi
Scoop.it!

Running Multiple Queries in Oracle SQL Developer

Running Multiple Queries in Oracle SQL Developer | Oracle Database Tips | Scoop.it
2 ways to run queries in Oracle SQL Developer. What are the differences and how do they work? Plus a free bonus trick!
more...
No comment yet.
Scooped by Antonio Turibbio Liccardi
Scoop.it!

Top 10 Tips & Tricks for Oracle SQL Developer

Top 10 Tips & Tricks for Oracle SQL Developer | Oracle Database Tips | Scoop.it
10 tips guaranteed to improve your Oracle SQL Developer experience. These are the crème de la crème, and my personal favorite SQLDev features to show off.
more...
No comment yet.
Scooped by Antonio Turibbio Liccardi
Scoop.it!

Oracle Database 11g XE Installer Error | MacLochlainns Weblog

Oracle Database 11g XE Installer Error | MacLochlainns Weblog | Oracle Database Tips | Scoop.it
How to fix the Oracle Database 11g XE Installer Error on Windows 64-bit.
more...
No comment yet.
Scooped by Antonio Turibbio Liccardi
Scoop.it!

RMAN in Oracle SQL Developer

RMAN in Oracle SQL Developer | Oracle Database Tips | Scoop.it
I've already violated my oath to never use acronyms with the blog title, so for those that do not know what RMAN is, please go read the DOCS.
more...
No comment yet.
Scooped by Antonio Turibbio Liccardi
Scoop.it!

Toad World Blogs - Why can't I execute DDL natively in PL/SQL

Toad World Blogs - Why can't I execute DDL natively in PL/SQL | Oracle Database Tips | Scoop.it
Quest Experts' share their thoughts on Toad family products and the database industry.
more...
No comment yet.