Oracle EBS
  • Show all
  • Hottest
  • Popular
  • Random
[Resolved] ORA-06550 PL SQL Error in Oracle
SaveSavedRemoved 0

[Resolved] ORA-06550 PL SQL Error in Oracle

00

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 +
SQL WHERE CONTAINS statement
SaveSavedRemoved 0

SQL WHERE CONTAINS statement

00

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 +
Explained: CASE in Oracle SQL PL SQL
SaveSavedRemoved 0

Explained: CASE in Oracle SQL PL SQL

00

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 +

Check it Out

Top 5 usages of Decode in SQL
SaveSavedRemoved 0

Top 5 usages of Decode in SQL

00

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. ...

$19.00 $109.99 SQL Course on Udemy
Using FND_REQUEST.SUBMIT_REQUEST in EBS PL SQL
SaveSavedRemoved 0

Using FND_REQUEST.SUBMIT_REQUEST in EBS PL SQL

00

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 +
2 Key Difference between YYYY and RRRR in Oracle SQL
SaveSavedRemoved 0

2 Key Difference between YYYY and RRRR in Oracle SQL

00

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 the YY DateTime format ...

READ MORE +
Oracle Forms Interview Questions|2021
SaveSavedRemoved 1

Oracle Forms Interview Questions|2021

00

Before we see Oracle Forms Interview Questions let's get some background. Oracle Forms is a great UI development tool from Oracle Corp and has been in use for decades. It is very useful to develop on-premise custom screen for transaction handling and processing. Oracle forms was also called developer 2000 in ...

READ MORE +
15 Important Oracle Workflow tables
SaveSavedRemoved 0

15 Important Oracle Workflow tables

00

EBS is an old war horse in managing enterprise business and with focus shifting to cloud applications, co-existence with Oracle Ebusiness suite is Key. Troubleshooting business processes requires knowledge of oracle workflow tables. Either its integration with cloud application or customizing EBS, you will need to ...

READ MORE +
Show next
Cloud Technologies Blog
Logo
Enable registration in settings - general
Compare items
  • Total (0)
Compare
0
Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock
Shopping cart