Home
More icon
Categories Tags
Links icon
Apex Tutorials Web Development
About
  • Table Blob to Oracle Directory

    Posted by - Vikas Pandey Jun 28, 2020 ORACLE PLSQL SQL Directory

    How to save table images to oracle directory? Files from table to Oracle directory 1DECLARE 2 l_file UTL_FILE.file_type; 3 l_buffer RAW (32767); 4 l_amount BINARY_INTEGER := 32767; 5 l_position INTEGER := 1; 6 l_blob_length INTEGER; 7BEGIN 8 FOR l_cnt IN (SELECT filename, product_image FROM demo_product_info) 9 LOOP 10 …

    Read More
  • Oracle NULLIF() Function

    Posted by - Vikas Pandey Jun 9, 2020 ORACLE PLSQL SQL NULLIF

    Oracle NULLIF() Function: The Oracle NULLIF() function accepts only two arguments. If the both arguments are equal it returns a null value. In case the arguments are not equal, the NULLIF() function returns the first argument and if any arguments will null then function return an error. Syntax of the NULLIF() …

    Read More
  • Oracle NVL2 Function

    Posted by - Vikas Pandey Jun 4, 2020 ORACLE PLSQL SQL NVL2

    Oracle NVL2 Function: NVL2() function is an extend version of the NVL() function with different options based on whether a NULL value exists. Oracle NVL2() function allow three parameters. If the first parameter is not null, then it returns the second parameter. In case the second parameter is null, then it returns the …

    Read More
  • Oracle Decode Function

    Posted by - Vikas Pandey Jun 3, 2020 ORACLE PLSQL Function SQL

    Oracle Decode Function: Oracle DECODE() function compares the first argument with the second argument. IF they are equal, the function returns the third argument otherwise return default value. The Oracle/PLSQL DECODE function has the functionality of an IF-THEN-ELSE statement: 1SELECT DECODE (1, 1, 'ONE', …

    Read More
  • Oracle NVL Function

    Posted by - Vikas Pandey Jun 3, 2020 ORACLE PLSQL SQL NVL

    Oracle NVL Function: The NVL function allow you to replace null values with a default value. If the first parameter is null, the function returns the second parameter. If the first parameter have some value then always return first value. Note := NVL function replaces null value with same type data. Syntax of the …

    Read More
  • Oracle NULL-Related Functions

    Posted by - Vikas Pandey Jun 3, 2020 ORACLE PLSQL SQL

    Oracle NULL-Related Functions. There are different type of null related function in oracle. NVL 1NVL function will check whether the first input parameter is null, if its null value, 2 it returns the second parameter value. DECODE 1The Oracle/PLSQL DECODE function has the functionality of an IF-THEN-ELSE statement. …

    Read More
  • Coalesce in oracle

    Posted by - Ashish Sahay May 21, 2020 Coalesce PLSQL SQL PLUGINS TEMPLATES

    Coalesce in ORACLE COALESCE return first not null value out all the parameter passed into this function. NOTE: All the parameters have be same datatype 1DROP TABLE coalesce_func_test; 2 3CREATE TABLE coalesce_func_test 4( 5 id NUMBER, 6 col1 VARCHAR2 (10), 7 col2 VARCHAR2 (10), 8 col3 VARCHAR2 (10), 9 col4 NUMBER 10); …

    Read More
  • Coalesce in oracle

    Posted by - Ashish Sahay May 21, 2020 Coalesce PLSQL SQL PLUGINS TEMPLATES

    Coalesce in ORACLE COALESCE return first not null value out all the parameter passed into this function. NOTE: All the parameters have be same datatype 1DROP TABLE coalesce_func_test; 2 3CREATE TABLE coalesce_func_test 4( 5 id NUMBER, 6 col1 VARCHAR2 (10), 7 col2 VARCHAR2 (10), 8 col3 VARCHAR2 (10), 9 col4 NUMBER 10); …

    Read More
  • NULL in ORACLE

    Posted by - Ashish Sahay May 12, 2020 PLSQL SQL ORACLE NULL

    NULL in Oracle NULL = NULL ? 1SELECT CASE 2 WHEN NULL = NULL THEN 'NULL Equals to NULL' 3 ELSE 'NULL is NOT Equals to NULL' 4 END NULL_ 5 FROM DUAL; NULL_ NULL is NOT Equals to NULL COUNT with NULLs 1WITH tab 2 AS (SELECT 10 a FROM DUAL 3 UNION ALL 4 SELECT NULL a FROM DUAL 5 UNION ALL 6 …

    Read More
  • Pipelined Functions in Oracle

    Posted by - Ashish Sahay Apr 12, 2020 PLSQL SQL PIPELINE

    How to create Pipelined Functions in Oracle? Pipeline functions are used to return data in tabular format. It returns the data in the nested table type. Pipeline functions are useful to dump data derived from the complex queries. Create the types 1CREATE TYPE g_emp_row AS OBJECT 2( 3 empno NUMBER (4), 4 ename …

    Read More
    • ««
    • «
    • 1
    • 2
    • 3
    • »
    • »»

Ontoor Soluions


APEX, PLSQL and Web development Blogs
Read More

Featured Posts

Recent Posts

  • Dynamic position Navigation Menu Oracle Apex
  • Add Tooltip on Side Navigation Menu Oracle APEX
  • Creating a custom template oracle apex part-1
  • Add Search Option On Nav Bar Oracle Apex
  • Refresh region of base page when closing modal dialog | Oracle APEX
  • Interactive Grid Checkbox
  • Mega Menu Oracle Apex
  • Table Blob to Oracle Directory

categories

APEX 97 ORACLE 24 PLSQL 13 DBA 5 GITHUB 4 BLOGGER 3 JAVASCRIPT 3 ORDS 3 APEX_JSON 2 CSS 1 PLSQLAPEX_WEB_SERVICE 1 PLUGIN 1 SCRUM 1 SQL 1

tags

PLSQL 104 APEX 101 SQL 93 ORACLE 32 PLUGINS 23 TEMPLATES 14 DYNAMIC-ACTION 9 ONTOORPLUGINS 9 JAVASCRIPT 7 CLASSIC-REPORT 5 DBA 5 UNIVERSAL-THEME 4 API 3 BLOGGER 3
All tags
AGILE1 APEX101 APEX+CSS2 APEX-20.11 APEX-AND-CSS1 APEX.SERVER2 APEX_DATA_PARSER1 APEX_DATA_PASER2 APEX_JSON2 APEX_UTIL1 APEX_WEB_SERVICE2 APEX_ZIP1 API3 BLOB1 BLOGGER3 CASCADE1 CLASSIC-REPORT5 CLOB1 COALESCE2 CSS3 CUSTOM1 DBA5 DBMS_LOB2 DELETED1 DIRECTORY1 DOWNLOAD1 DYNAMIC-ACTION9 FUNCTION1 GITHUB3 GOOGLE2 HTML1 IG1 INDEX1 INTERACTIVE-ACTIVE1 INTERACTIVE-GRID2 INTERACTIVE-REPORT2 IR1 ITEM2 JAVASCRIPT7 JQUERY1 LOV1 MARKDOWN2 MEGA-MENU1 NAVIGATION1 NEW-LINE1 NULL1 NULLIF1 NVL1 NVL21 ONTOORPLUGINS9 ORA1 ORACLE32 ORACLE_TO_XML1 ORDS3 PAGE1 PAGE-GROUP1 PAGE-ZERO1 PIPELINE1 PLSQL104 PLUGINS23 POP-UP-LOV1 RDS2 REPLACE1 RSS1 SCRUM1 SELECT-LIST1 SPECIAL-CHARACTER1 SQL93 STICKY1 SUBSCRIPTIONS1 SYS_CONTEXT1 TABULAR-FORM1 TEMPLATE2 TEMPLATES14 UI3 UNIVERSAL-THEME4 USER-STORIES1 UTL_FILE1 WEB_SOURCE1
[A~Z][0~9]

Tweets by OntoorSolutions

Copyright ©   Ontoor Solutions Blogs. All Rights Reserved