What is ODBC? How Does ODBC Work?
Open Database Connectivity (ODBC) provides a standard interface that allows application access to many different database implementations without writing special code for each one.
Latest Articles
Understanding PL/SQL Blocks
Block Types A PL/SQL program comprises one or more blocks. These blocks can be entirely separate or nested within …
"Communication Error With the OPMN Server Local Port" When Starting OPMN
The Problem When attempting to start the OPMN services the following error occurs: opmnctl: starting opmn and all …
How to Check and Set Max Size of PDB Storage
You can specify the maximum size for any PDB database using STORAGE clause in CREATE PLUGGABLE DATABASE command. If we …
How to Shrink the Datafile of Temporary Tablespace in Oracle
The database has a program that performs a huge sort operation (e.g. end of the year reporting process). This may cause …
Queries to Find Information and Work With Oracle Container Database (CDB) and Pluggable Database (PDB)
This post lists out different administrative tasks you can perform in a container database (CDB) and pluggable database …
How to Shrink a Temporary Tablespace in Oracle
Question: How to resize the TEMPFILE(s) for a temporary tablespace after they have grown larger than needed? Large sort …
Temporary Tablespaces Group in Oracle
This post explains why and how to create groups of temporary tablespaces. Grouping temporary tablespaces within a single …
UNIX/Linux: Finding Out Who Is Logged In
The who command shows you: Who is logged in Where users are logged in The who command has three forms.
Java Type Casting Basics
In this post, you will learn to: State the two types of type casting. Describe implicit type casting. Describe explicit …
How to Use Comments in Java
Single-line Comments Comments help easy understanding of code. A single-line comment is used to document the …