Tags » Oracle

Checking Data Type Consistency in Oracle

In large databases it can be a challenge to have data type consistency across many tables and views, especially since SQL does not understand PL/SQL’s… 1,609 more words

Oracle

Oracle WebLogic Server Now Running on Docker Containers

Monica Riccelli with Oracle posted over at The WebLogic Server Blog that Oracle WebLogic Server is now certified to run on Docker containers. There are Dockerfiles and scripts located on GitHub to build the images. Check out the article here!

Virtualization

FUNCTIONS TO CONVERT BYTES INTO CHARACTER AND CHARACTER INTO BYTES

Basically these are the two functions can be used in oracle to convert character into bytes and bytes into character.

1) LENGTH
2) LENGTHB

For Example: 28 more words

11g

Did You Know #4

Sometimes we need to delete an entry from our spfile. 134 more words

Oracle

How are Numbers Saved in Oracle?

I’ve been asked quite a few times about the difference between number and character columns in Oracle. So I decided to write this article in order to explain how things work. 1,479 more words

Oracle

Bitmap Indexes: Understanding Bitmap Indexes

Bitmap indexes are a great boon to certain kinds of application, but there is  a lot of mis-information in the field about how they work, when to use them, and  the side-effects. 3,148 more words

Oracle

Oracle system V shared memory indicated deleted

This article is written with examples taken from an (virtualised) Oracle Linux 6u6 X86_64 operating system, and Oracle database version 12.1.0.2.1. However, I think the same behaviour is true for Oracle 11 and 10 and earlier versions. 2,734 more words

Oracle