Vijay's Technical Staircase

Linked-List Efficiency Insertion and deletion at the beginning of a linked list are very fast. They involve changing only one or two refer...

Bubble Sort:  public void bubbleSort() { int out, in; for(out=nElems-1; out>1; out--) // outer loop (backward) for(in=0; in if( a[i...

What is a traditional export? I shall use "traditional export" to refer to an export created with the exp utility. This is a ...

http://www.orafaq.com/node/854 Create a blocking lock To begin, create a situation where one user is actively blocking another. Open tw...

v$controlfile: Displays the location and status of each controlfile in the database .  Column Datatype Description STATUS VARCHAR...

Here is a script for example that I use to "recreateme" -- recreate my account, for testing purposes. It gives me access to all ...

PL/SQL developers are always trying to optimize their code to perform more efficiently.  As of Oracle 8.1.5, a utility exists that...

CASE Expressions From Oracle 8i one can use CASE statements in SQL. Look at this example: SELECT ename, CASE WHEN sal = 1000 THEN 'Mini...