Oracle EBS
  • Show all
  • Hottest
  • Popular
  • Random
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.USECASE statement is an example of IF then ELSE condition in SQL programmingSyntaxCASE [ 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. ...

$13.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 +
50+ New Oracle Apps Technical Interview Questions
SaveSavedRemoved 0

50+ New Oracle Apps Technical Interview Questions

01

Welcome ! If you are starting out in Oracle E-business Suite aka Oracle EBS there are lot of technical area you may need to cover. Even if you have gone through some training these Oracle Apps Technical Interview Questions will help you to get an understanding of what is expected from a apps technical resource in ...

READ MORE +
Show next
Cloud Technologies Blog
Logo
Compare items
  • Total (0)
Compare
0
Shopping cart