Home
More icon
Categories Tags
Links icon
Apex Tutorials Web Development
About
  • How to Install Apex in Oracle 19 C

    Posted by - Ashish Sahay Mar 26, 2020 ORACLE APEX SQL DBA

    How to install APEX in Oracle 19 C Download APEX from Oracle products. Download APEX 19.2 Oracle 19 C is multi tenant architecture database. We can create multiple Pluggable databases (PDBs ) and each database can have one APEX instance. Extract the Zip file in the system folder. Open Command Prompt (CMD) as …

    Read More
  • How to open pluggable database (PDBs) in Oracle 19 C

    Posted by - Ashish Sahay Mar 25, 2020 ORACLE PLSQL SQL DBA

    How to open pluggable database (PDBs) in Oracle 19 C? First need to log in and check the PDB status 1C:\WINDOWS\system32>sqlplus /nolog 2SQL*Plus: Release 19.0.0.0.0 - Production on Wed Mar 25 21:53:59 2020 3Version 19.3.0.0.0 4Copyright (c) 1982, 2019, Oracle. All rights reserved. 5SQL> conn sys/orcl as sysdba …

    Read More
  • How to install ORACLE 19 C on windows 10

    Posted by - Ashish Sahay Mar 25, 2020 ORACLE PLSQL SQL DBA

    How to install ORACLE 19 C on windows 10 (64 bit) To install ORACLE 19 C we need to check system requirements first. Oracle Database for Windows x64 is supported on the following operating systems: Windows 8.1 x64 - Pro and Enterprise editions Windows 10 x64 - Pro, Enterprise, and Education editions Windows Server …

    Read More
  • Create user in Oracle 12 C

    Posted by - Ashish Sahay Feb 24, 2020 ORACLE DBA

    Create user 12C: 1connect system/manager as sysdba 1alter session set "_ORACLE_SCRIPT"=true; 2/ 1create user lime identified by limeoracle; 2/ 1grant dba to lime; 2/ 1connect lime/limeoracle 2/ 1create table test(lime number);

    Read More
  • Get Current Schema and DB name

    Posted by - Ashish Sahay Jul 25, 2017 ORACLE PLSQL DBA

    Some times we do not know about our schema exist in which db and which is our schema hare is the method to find db and schema name. 1DECLARE 2 CURSOR ashish_db_name 3 IS 4 SELECT NAME 5 FROM v$database; 6 My_db_name VARCHAR2 (4000); 7BEGIN 8 OPEN ashish_db_name; 9 FETCH ashish_db_name 10 INTO My_db_name ; 11 CLOSE …

    Read More

Ontoor Soluions


APEX, PLSQL and Web development Blogs
Read More

Featured Posts

Recent Posts

  • Dynamic position Navigation Menu Oracle Apex
  • 2 ways to get total sum of Interactive Grid Column 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

categories

APEX 98 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 105 APEX 102 SQL 94 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 APEX102 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 PLSQL105 PLUGINS23 POP-UP-LOV1 RDS2 REPLACE1 RSS1 SCRUM1 SELECT-LIST1 SPECIAL-CHARACTER1 SQL94 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