Posts related to tag: oracle

Oracle PL/SQL: Triggers

On this page, we’ll see how to create triggers in the Oracle database. Triggers are powerful database objects that automatically […] Continue reading »

Oracle: LIMIT Clause

The LIMIT clause, also referred to as the “row limiting clause” is a SQL feature that enables you to restrict […] Continue reading »

Oracle: TRUNC(number) Function

In this article, we’ll explore the TRUNC(number) function. The TRUNC(number) function in Oracle SQL is used to truncate or shorten […] Continue reading »

Oracle: TRUNC(date) Function

Oracle’s TRUNC(date) function is a useful tool for trimming or eliminating the time component from dates. The TRUNC(date) function allows […] Continue reading »

Oracle: RANK() vs. DENSE_RANK() Function

In Oracle SQL, both RANK() and DENSE_RANK() are window functions that are used to assign a ranking to each row […] Continue reading »

Oracle: RANK() Function

In this blog, we will explore the concept of the RANK() function in the Oracle database. The RANK() function in […] Continue reading »

Oracle: DENSE_RANK() Function

The DENSE_RANK() function in Oracle is used to assign a unique rank to each distinct row within a result set […] Continue reading »

Top 5 SQL Developer Shortcut Keys

This article will help you to get familiar with the Top 5 Oracle SQL Developer Shortcut Keys. Getting handly with […] Continue reading »

ORA-01045: user xxx lacks CREATE SESSION privilege; logon denied

In the Oracle database, if you have created a new user and tried to log in with a newly created […] Continue reading »

How to set .bash_profile in Linux for Oracle

This page will walk through How to set .bash_profile in Linux for Oracle. .bash_profile is executed to configure your login shell before […] Continue reading »

Overview and Architecture of Oracle Database Server

This page will walk through overview and architecture of Oracle Database Server. An Oracle Database consists of at least one database […] Continue reading »

1 2