Skip to main content

Blogs

DECODE vs CASE in Oracle SQL

Avinash Jaiswal's picture
DECODE and CASE both provides IF-THEN-ELSE functionality in Oracle SQL. Decode Function and Case Statement is used to transform data values at retrieval time. Before Oracle 8.1 version, only DECODE function was there for providing IF-THEN-ELSE functionality and this can compare only discrete values (Not in range). In Oracle version 8.1.6, Oracle introduced the CASE Statement, which allowed the use of operators like <,> and BETWEEN, IN etc. 

Everything DECODE can do, CASE can. There is a lot else CASE can do though, which DECODE cannot. We’ll go through detailed examples in this article.


Convert Rows into Columns or Transpose Rows to Columns In Oracle SQL

Avinash Jaiswal's picture

SQL Database LanguageHello Friends, 
Have you ever been in a situation where you as a developer knows that your data is stored in your table rows, but you would like to present the data as a column ??

There are many way to handle this situation. Here I am sharing few of them which I know.​

 

Taking a Quantum Leap into Wireless Technology

Administrator's picture

Quantum mechanicsQuantum Internet may be closer than what many people may believe. Based on quantum mechanics, information can be shared between two points without traveling through the space in between. In 1935, Einstein theorized of a "spooky" behavior that particles are still somehow connected through entanglement although they have been separated. The ability to tap this behavior could create security and ultra-fast access to information.

Null Hyderabad, May Presentation on various InfoSec Topics

Sanjeev Kumar Jaiswal's picture

As it was said that Null Hyderabad, May chapter would be fire talks session and yes it was. There were six presentation on various Information Security topics with proper explanation, images, demo etc.  Null Hyderabad is really doing great job in Information Security Awareness domain and I personally convey my special thanks to all speakers for delivering mind blowing presentation along with Imran and Raghu for leading Null Hyderabad chapter successfully all the time :D

You can follow their events and activities very well at Facebook and Twitter

Basic information about i386, i686 and x86_64 architectures

Sanjeev Kumar Jaiswal's picture
32 bit vs 64 bitI was going through mails and in one mail a person asked me, what is this 32 bit and 64 bit things and how do I know if my system is 32 bit or 64 bit. Which application my system would support and so on…
So, I thought better to document one small article which will answer those questions with minimal essential explanation of the terms involved using simpler way. I googled and collected few important paragraphs from various tech sites and posting it at one place.
Syndicate content