Home
More icon
Categories Tags
Links icon
Apex Tutorials Web Development
About
  • How to Remove New line from a String Using PL/SQL/ORACLE?

    Posted by - Vikas Pandey Apr 12, 2020 ORACLE PLSQL SQL New line REPLACE

    How to Remove New line from a String Using PL/SQL/ORACLE To Remove New line from the string: 1DECLARE 2p_sting VARCHAR2 (100):= 'This is Vikas from Delhi 3Now the next line. '; 4BEGIN 5DBMS_OUTPUT.put_line (p_sting); 6DBMS_OUTPUT.put_line ( 7REPLACE (REPLACE (p_sting, CHR (13), ''), CHR (10), ' …

    Read More

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