Blogs about: Sql Developer
Featured Blog
SQL-Developer: Copy result grid cells (columns) with headers
We will use the following Select during this post: SELECT c.owner, c.table_name, c.column_name, c.data_type FROM ALL_TAB_COLUMNS c WHERE table_name = 'ALL_TAB_COLUMNS' AND c.column_name like 'DA… more →
Oracle Deli
Liferay – SQL – Select FileEntries tagged with tag A but not tagged with tag B
wrote 3 days ago: SELECT UNIQUE /*csv*/ * FROM ( SELECT fileentryid, title FROM dlfileentry WHERE fileentryid IN ( SEL … more →
Liferay - SQL - Select JournalArticles tagged with tag A but not tagged with tag B
wrote 3 days ago: This is not an optimized SQL script but it gets job done. SELECT UNIQUE /*csv*/ * FROM ( SELECT arti … more →
Connecting Oracle SQL Developer to database without tnsnames.ora
— 3 comments
wrote 2 weeks ago: Just a quick tip if you need to reconfigure an Oracle database connection for use in Oracle’s … more →
Get thee to KScope13!
— 1 comment
wrote 1 month ago: Jeff Smith (@thatjeffsmith) just posted a great little piece about why you can’t afford to mis … more →
connect mysql via sql developer
wrote 2 months ago: grant命令： grant 权限1,权限2,…权限n on 数据库名称.表名称 to 用户名@用户地址 identified by ‘连接口令’; 例子： mysql> … more →
Deleting Duplicate rows in SQL Server
wrote 2 months ago: One of the most common tasks that any DBA or Developer does is to identify and delete true duplicate … more →
SQL-Developer: Copy result grid cells (columns) with headers
wrote 2 months ago: We will use the following Select during this post: SELECT c.owner, c.table_name, c.column_name, c.da … more →
SQL-Developer: How to change the date format of the result grid - "Why does my date column have no time?"
wrote 2 months ago: You can decide how SQL-Developer display date and timestamp columns. Go to the “Tools” m … more →
Mark or colour NULL values in SQL Developer
wrote 3 months ago: By default SQL Developer shows null values in the following way: Screenshot – SQL Developer … more →
SQL DEVELOPER - Detroit, MI - USA
wrote 3 months ago: Posted Date: 13th Feb 2013 by Relevante Consulting at Detroit JOB POSITION: SQL DEVELOPER Min Expe … more →
RMOUG Training Days 2013 - OTN Lab Day
— 2 comments
wrote 3 months ago: Today I arrived in Denver to attend the annual Rocky Mountain Oracle Users Group (RMOUG) Training D … more →
Oracle Auto-Increment Made Easy
wrote 3 months ago: One of the tedious task I have to deal with when working with Oracle is when I need to create an aut … more →
Connecting to Oracle database from Windows Forms application using C#
wrote 4 months ago: Download source code In this article I will explain how to connect to Oracle database from Windows a … more →
APEX 4.2.1 and APEX Listener 2.0 released!
— 7 comments
wrote 4 months ago: First of all: a happy New Year to all my blog readers! I wish you an exciting 2013 with lots of inte … more →
Data Warehouse / SQL Developer - Permanent - Suffolk - to £35k plus benefits
wrote 5 months ago: This exciting new role will see you joining a very strong, well-populated IT department creating and … more →
Migration From SQL Server To Oracle Using SQL Developer
— 1 comment
wrote 5 months ago: Migration is the process of copying the schema objects and data from a non-Oracle database, such as … more →
SQL-Developer: Speed up program start
— 2 comments
wrote 6 months ago: Starting SQL-Developer takes too long? Here’s what you can do: 1. Use native look and feel Sel … more →
SQL Developer Dbms Output Pane gone...
wrote 6 months ago: I already managed to remove the Dbms Output pane a couple of times from my SQL Developer, probably b … more →
Quickly copy, compare, and synchronize databases with Oracle SQL Developer.
— 1 comment
wrote 6 months ago: Dear All, The below url is very useful if you want to migrate/move the schema/object to another data … more →
