Add Background Image to Page in Oracle APEX — Javainhand Tutorial

In this Oracle APEX Tutorial Blog post, We will explore Add background Image to Page in Oracle APEX.

Here we are talking about the adding background image to the entire page.We will add background image on the body section with the help of background-image css property.

Add Background Image to Page in Oracle APEX

Step 1:- First of all you have to upload your background image file in the static application files section. This option available in your application shared components section.The below screenshot will help you out to understand.

Oracle Apex CapsLock(On/Off) Indicator with Javascript in Oracle APEX- Javainhand Tutorial

In this post, We explore the Caps Lock(On/Off) Indicator with Javascript in Oracle APEX.

Sometimes it is necessary to check whether caps lock is on or off. Capslock(on/off) indicator functionality is useful on the login page. Sometimes user not realized this, caps lock is on or off and that is why he enter wrong password.Due to enter wrong password user getting locked.

If We inform or alert to user that caps lock is on then user will not getting locked.

<span id="caps-lock-on">Note : Your CapsLock key is currently turned on</span>#caps-lock-on { font-size: 12px; font-weight: 700; margin: -10px 0 0 0; color: #c0392b; display: none; }

Originally published at https://www.javainhand.com.

Welcome to Javainhand.com , if you searching for a good website for Learn Oracle APEX Tutorial . We are trying to provide good stuff Oracle APEX.

All the post which we have posted on our sites it is not written by any type of content writers. It is written by an experienced industrial person .

We have posted around 60+ Oracle APEX Tutorials in Our Website.Also,
We have posted around 60+ Oracle APEX Videos Tutorials on Our youtube channel.

We always ready to give the answer to your questions. Being a part of our website viewers we want your supports.

Join Our Facebook Group:-Join Our Facebook Page:- Follow On Twitter:-Subscribe My Youtube Channel:- Facebook Group Facebook Page Twitter Youtube Channel

Originally published at https://www.javainhand.com.

In this post, We explore the Dynamic Image Carousel Slider in Oracle APEX

What is the Image Carousel Slider?

Image Carousel Slider is a way to display multiple rotating images. You can add text also add links that can be linked to a specific page.

If we are talking about a real-time example or scenario then…

In this Tutorial, We will explore the Difference Between Function and Procedure in PL/SQL.

What is Difference Between Function and Procedure in Oracle PL/SQL?

Function:-

1. Function must always return a value.
2. Function can be used in SQL statement.
3. Function used for computational purpose.

Procedure:-

1. Procedure can not return value but using IN and INOUT parameter procedure can return the value.
2. We can not run procedure in SQL statement.
3. Procedure is basically use for the bussiness logic.

That’s all for today, I hope this (Difference Between Function and Procedure in Oracle PL/SQL) post will be helpful for you. If you like the post then share your view in the comment box.

What is NVL2() function in Oracle?

1. NVL2() is another way to handling NULL value in Oracle.
2. It is advanced version of NVL function.
3. NVL2() function have functionality to handle both NULL Values and NOT NULL Values in Oracle.

Syntax of NVL2() function in Oracle

nvl2(value_to_check,value_to_not_null,value_to_null);

In NVL2() function used three parameter first parameter check the value if it return not null values then second parameter executed if first parameter return null values then third parameter executed.

Example of NVL2() function in Oracle

SELECT NVL2('Javainhand Tutorial','found','Not Found') as nvl2_example FROM DUAL;

DECODE is a function in Oracle which help to implement if-then-else logic in SQL query.

DECODE is use for transform the data to one value to another value.

DECODE only use for equality check logic in Oracle SQL.

DECODE function is used in different database versions like Oracle 9i,Oracle 10g,Oracle 11g and Oracle 12c.

Syntax of DECODE() function in Oracle

DECODE(value,search_value,result,default_value)

Let’s understand the syntax so we can easily use the DECODE() function in Oracle SQL.

Originally published at https://www.javainhand.com.

In this Oracle APEX Tutorial Session, We will explore the 5 Different Methods to Set Oracle APEX Page Item Value.

$("#P28_SECOND" ).val(20);
$x("P28_SECOND").value = 30; document.getElementById('P28_SECOND').value=40; apex.item('P28_SECOND').setValue(50); apex.items.P28_SECOND.value=60;

I hope the above JavaScript Code will help you out to Set Oracle APEX page item values with different methods. If you learn something for this blog then please share this post to your social sites and others plateforms.

Originally published at https://www.javainhand.com.