Tags » SQL Developer

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

Recruitment

Oracle SQL: Least and greatest values across columns

The objective of this post is to explain how to obtain the least and the greatest values across the columns of a table, in Oracle SQL. 393 more words

SQL

Promising Use Of BIDS Or SSDT With Help From Mircosoft Sql Developer

Recent statistics have indicated that business intelligence design parts of SQL Server are going through identity crisis. You have to learn a bit more about the tools, recently used by… 583 more words

Oracle SQL: Order by list of values

The objective of this post is to explain how to perform the ordering of a table in Oracle SQL, using a list of values. 625 more words

SQL

Mircosoft SQL Developer Under Business Intelligence Development Studio

Business Intelligence Development is a studio under Microsoft Visual Studio 2008. It comprises of additional project types, which are specified to the SQL Server Business Intelligence. 792 more words

Custom Formatting in SQLDev 4.2

Formatting is one of the software development features that always steers controversy. To put it bluntly, everybody wants to format the code their own way. In previous SQL Dev versions the answer to that challenge was having elaborate tree-table widget spiced with several dozens of various options. 1,628 more words

SQL Developer

SQL Developer : Add Custom SQL Query as Template.

Daily for SQL plan reading and analysis, using below command quite often from SQL Developer Tool.

explain plan for statement_id = '';
select * from gv$sql where sql_text like '%%';
185 more words

Helper SQL