Tags » SQL

Caching in - Oracle Sequences and Performance

Several years ago, the BBC found itself a little financially embarassed. Appropriately enough, given the topic at hand, it was a bit strapped for cache…er…cash. 1,709 more words

Oracle

SQL SERVER - Fix - Error - 11553 - EXECUTE statement failed because its WITH RESULT SETS clause specified a non-nullable type for column #%d in result set #%d

EXECUTE statement failed because its WITH RESULT SETS clause specified a non-nullable type for column #%d in result set #%d, and the corresponding value sent at run time was null… 408 more words

SQL

.NET Software Developer: Benefits Administration

Lee Shipman & Providence Technology Solutions is hiring a .NET Software Developer for a full-time role.

Position Summary:

Seeking a well-rounded developer that has knowledge in all aspects of building ASP .NET and VB.NET Web Applications. 179 more words

Providence Technology Solutions

Cara Mengambil Data Dari Database

Untuk mengambil dan menampilkan data dari database MySQL biasanya query yang digunakan yaitu “SELECT”. Kali ini saya akan berbagi sedikit cara mengambil data yang berasal dari beberapa tabel yang berbeda. 336 more words

Komputer

PL/SQL LINE NUMBER

SQL> set serveroutput on
SQL> begin
2 null;
3 dbms_output.put_line('At line : '||$$plsql_line);
4 end;
5 /
At line : 3

PL/SQL procedure successfully completed.

SQL>
ORACLE

Alternative for Do While in SQL

Since there is no DO WHILE concept in SQL to achieve the functionality of DO WHILE. We will use either While Loop along with Break or Start and GoTo to get DO WHILE. 85 more words

SQL

How to Get last date of any given month with Simple use of Date logic

For example we are given Month June as input and we have to find out the last date of June. In two simple line of code we can do it. 117 more words

SQL