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 ...
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...
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 ...
Check it Out
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. ...
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 ...
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 ...
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 ...
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 ...
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 ...
wpsbutton is a Blog on Cloud Computing PaaS SaaS and Cloud Security. Focus of the blog is on Oracle Fusion SaaS, Oracle Integration Cloud , VBCS, PCS , Fusion Apps Tech and Ebusiness Suite.
Affiliate Disclosure: Some of the links may be affiliates links which may earn us a commission without any extra cost to you. As an Amazon Associate, we may earn from qualifying purchases.
All the articles and views are of the author and do not necessarily be of Oracle or any other Cloud provider. All Logos and trademarks belong to respective owners.
All articles are for educational purposes only.
Copyright © 2021 All Rights Reserved
