Displaying the File Type Icon in Oracle APEX Reports

CLICK HERE

Oracle APEX Bar Chart Colors (Conditional)

Step 1: Create a new blank page. Step 2: Create a bar chart region and your bar chart series query would then look something like this, ————————————————————————————— select null,STATUS as STATUS, case when STATUS = ‘VACANT’ then ‘#d1f5e0’ –light green when STATUS = ‘ALLOCATED’ then ‘#fff4dd’ –light orange when STATUS = ‘MAINTENANCE’ then ‘#fdd5cc’ –light red else […]

Difference between WHERE vs HAVING in SQL

1) WHERE clause is processed right after FROM clause in the logical order of query processing, which means it is processed before GROUP BY clause while HAVING clause is executed after groups are created. 2) If used in GROUP BY, You can refer any column from a table in WHERE clause but you can only […]

What is ROWID and ROWNUM in SQL?

What is ROWID and ROWNUM in SQL? In this article i will try to explain ‘What is ROWID and ROWNUM in SQL?’. Pseudo columns are actually associated with the table data but it has nothing to do with table data.ROWID & ROWNUM are pseudo columns which are not actual columns in the table but behave […]

CRUD operation in PL/SQL:

In this tutorial, we are getting to find out how to use SQL in PL/SQL. SQL is that the actual component that takes care of fetching and updating of knowledge within the database whereas PL/SQL is that the component that processes these data. Further, during this article, we’ll also discuss the way to combine the SQL within the PL/SQL block. DML Transactions in PL/SQL DML stands […]

CRUD operation in SQL:

(INSERT): Create table dept: CREATE TABLE departments ( deptno NUMBER(2) CONSTRAINT departments_pk PRIMARY KEY, dname VARCHAR2(14), loc VARCHAR2(13)); Insert a single row into a table: INSERT INTO dept VALUES (10, ‘Branding’, ‘Dhaka’); Insert rows from one table into another table: INSERT INTO emp2 SELECT * FROM emp; CREATE TABLE emp3 AS SELECT * FROM emp; […]

CRUD operation in ORACLE:

What is CRUD operation? Within programming , the acronym CRUD stands for create, read, update and delete. These are the four basic functions of CRUD. Also, each letter within the acronym can ask all functions executed in electronic database applications and mapped to a typical HTTP method, SQL statement or DDS operation. The first regard […]

Brief History of Oracle Database

Brief History of Oracle Database: The current version of Oracle Database is a results of over 30 years of innovative development. The main highlights within the evolution of Oracle Database include the following: Founding of Oracle: In 1977, Larry Ellison, Bob Miner, and Ed Oates started the consultancy Software Development Laboratories, which change name to […]

ORACLE Data Type

DATA TYPE: একটি Table তৈরি করার সময় কলাম সমুহ কোন ধরনের DATA ধারন করবে তা নির্ধারন করে দিতে হয়। নিচে Data Type সমুহের একটি তালিকা প্রদান করা হলঃ Data Type কে কয়েকটি ভাগে বিভক্ত করা যায়ঃ Character Data Type Numeric Data Type Date/Time Data Type Large Object Data Type ROWID Data Type Character Data types […]

GROUP FUNCTIONS

GROUP FUNCTIONS Group functions will be applied on all the rows but produces single output Sum Avg Max Min Count SUM This will give the sum of the values of the specified column. Syntax sum (column) EX SQL> select sum(sal) from emp; SUM(SAL) ———- 38600 AVG This will give the average of the […]

ORACLE