SaveSavedRemoved 0

A Quick Guide to Delete Column in SQL: Oracle Database

Introduction: Overview of Deleting Columns in SQL: Syntax for Deleting Columns in Oracle Database: Considerations before Deleting Columns: a. Data Preservation:b. Dependencies:c. Constraints:Examples of Deleting Columns in Oracle SQL:a. Deleting a Single Column: Result b. Deleting Multiple Columns: Resultc. ...

READ MORE +

SaveSavedRemoved 0

How to check last dml statement executed on a table in oracle

In Oracle, you can check the last DML (Data Manipulation Language) statement executed on a table by querying the data dictionary view called DBA_HIST_SQLTEXT. This view contains the history of all SQL statements executed in the database. Here's a sample query to retrieve the last DML statement executed on a ...

READ MORE +

SaveSavedRemoved 0

[Resolved] ORA-06550 PL SQL Error in Oracle

ORA-06550 PL SQL Error in Oracle: While working on Oracle technologies, especially PL SQL or any tool or programming language interacting with the Oracle database, you might encounter ORA 06550 error. What is this and how do we resolve it, We will look at it in this post. A Successful call to an existing ...

READ MORE +

Check it Out

SaveSavedRemoved 0

SQL WHERE CONTAINS statement

SQL where contains is used to check the value if present in a column. Mostly used in Unstructured data testing on text based fields. In oracle, the column where we need to apply contains needs to be indexed. In SQL Server CONTAINS is a predicate used in the WHERE clause of a Transact-SQL SELECT statement to do ...

READ MORE +

SaveSavedRemoved 0

Explained: CASE in Oracle SQL PL SQL

In this post, we see how to use CASE in Oracle with examples expressions. USE CASE statement is an example of IF then ELSE condition in SQL programming Syntax CASE [ expression ] WHEN condition_1 THEN result_1 WHEN condition_2 THEN result_2 ... WHEN condition_n THEN result_n ...

READ MORE +

SaveSavedRemoved 0

How to check oracle version of database in Linux, Sql developer & Windows

One of the most pressing questions for techies who are new to Oracle is How to check oracle version of database be it Windows, Solaris or Linux there are commands which can be executed with right permission to get the version details. So let's start, Prerequisite is that you should be able to login to the ...

$74.99 Oracle DBCS Course

SaveSavedRemoved 0

Top 5 usages of Decode in SQL

Decode in SQL is an Oracle Function that can be used as an if-then-else statement in SQL. This function is named DECODE. This function allows us to add an if-then-else procedural logic to our SQL statements. DECODE statement is a very powerful function and many complex logics can be handled easily with this. ...

$20.00 $109.99 SQL Course on Udemy

SaveSavedRemoved 0

Using FND_REQUEST.SUBMIT_REQUEST in EBS PL SQL

FND_REQUEST.SUBMIT_REQUEST is a PL SQL Public API of Oracle e-business suite and is used to submit concurrents programs in ORACLE Applications from the Standard Request window. Basically when you submit a concurrent program from SRS (Standard Request Screen) internally the fnd_request.submit_request API is ...

READ MORE +

SaveSavedRemoved 0

2 Key Difference between YYYY and RRRR in Oracle SQL

In this post, we will see the difference between YYYY and RRRR in Oracle SQL. If not already knowing YYYY and RRRR are Date formatting predicates. Actually both of them impact the Year of the date to be presented to the calling program. The RR DateTime format element is similar to ...

READ MORE +