today:
1,074
yesterday:
286
Total:
101,923

Database (SQL)

Articles 72
No.
Author
72 How to Update Oracle XE Version
admin
Feb 23, 2018 3
How to Update Oracle XE Version 2 to APEX Version 4 If you have installed Oracle XE Version 2 (msi file: OracleXE.exe) then you can upgrade to the latest Oracle Apex version using the steps below. Download and unzip the latest Apex kit from...  
71 Manufacturing resource planning (MRP II)
admin
Feb 14, 2018 3
Manufacturing resource planning (MRP II) is defined as a method for the effective planning of all resources of a manufacturing company. Ideally, it addresses operational planning in units, financial planning, and has a simulation capability ...  
70 Material requirements planning (MRP)
admin
Feb 14, 2018 3
Material requirements planning (MRP) is a production planning, scheduling, and inventory control system used to manage manufacturing processes. Most MRP systems are software-based, but it is possible to conduct MRP by hand as well. An MRP sy...  
69 What Is ERP?
admin
Feb 14, 2018 4
What Is ERP? Play VideoPlay Mute Current Time1:18 / Duration Time1:18 Loaded: 0% Progress: 0% ShareQuality Levels Fullscreen What is ERP System? (Enterprise Resource Planning) ERP stands for enterprise resource planning. It refers to the sys...  
68 Link- AbbaBeauty
admin
Feb 13, 2018 3
https://apex.oracle.com/pls/apex/f?p=139108:LOGIN_DESKTOP::::::  
67 Apex Interactive Report: The difference between CIR and RIR
admin
Jan 26, 2018 11
Apex Interactive Report: The difference between CIR and RIR You’ve probably already used the reset functionality in an Interactive Report, but do you know the exact the difference between CIR (Clear Interactive Report) and RIR (Reset Interac...  
66 QR Code plugin Process
admin
Nov 30, 2017 10
1. Zip File Download 2. Unzip 3. Plug-in Process Share Component Plug-in :Import src/item_type_plugin_com_jannavratil_apex_qr.sql Static Application Files : src/qrcode.min.js  
65 QR Code plugin
admin
Nov 30, 2017 7
QR Code pluginSelf contained QR Code item plugin for the Oracle Application Express. Plugin simply renders value of the item as a QR code. Users can easily scan the QR code with their smart phones directly from the screen or print the page a...  
64 QR-CODE
admin
Nov 30, 2017 11
......JavaScript Code....... $('.qrcode').each(function(){ var qrcode = new QRCode($(this).attr('id'),{ text:$(this).attr('data-qrcode'), width:65, height:65, colorDark:"#000000", colorLight:"#ffffff", correctLevel:QRCode.CorrectLevel.H }); ...  
63 APEX Connect 2016 - David Peake - New Features in Oracle Application Express 5.1
admin
Nov 25, 2017 28
 
62 Building Mobile Applications with Oracle Application Express 5.0
admin
Nov 25, 2017 9
 
61 image (products)
admin
Nov 24, 2017 1
decode(nvl(dbms_lob.getlength(p.product_image),0),0,null, '<img alt="'||apex_escape.html_attribute(p.product_name)||'" title="'||apex_escape.html_attribute(p.product_name) ||'" style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-...  
60 SQL Basics - Lesson 1 - Introduction
admin
Jun 17, 2017 56
This tutorial covers some basics of SQL queries and is meant for beginners.  
59 General APEX Password Change
admin
Aug 26, 2016 276
Microsoft Windows [Version 10.0.10586] (c) 2015 Microsoft Corporation. All rights reserved. C:UsersJong>cd c:/oraclexe/apex/ c:oraclexeapex>sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Fri Aug 26 09:42:30 2016 Copyright (c)...  
58 JAVA JavaScript for Member List
admin
Aug 17, 2016 287
ID정보를 입력하면 해당 ID의 이름을 갖고옴 <script language="JavaScript1.1" type="text/javascript"> function GET_SNATIVE_NM_P1() { var ajaxRequestN = new htmldb_Get(null,&APP_ID.,'APPLICATION_PROCESS=GET_SNATIVE_NM_P1',0); ajaxRequestN.a...  
57 SQL SQL
admin
Jul 16, 2016 273
select null, '#' || g.SGROUP_ID "SGROUP_ID", t.IMEMBER_SK, t.SMEMBER_ID, t.SFAMILY_ID, t.ISORT_ID, t.SFAMILYRELATION_ID, t.SNATIVE_NM || '' || case when substr (g.SGROUP_ID,4,1) = '1'and substr (g.SGROUP_ID,5,1) is null and t.GROUP_SORT_KEY ...  
56 General control break
admin
Jun 25, 2016 276
declare apply_yy number := 0; apply_yymmdd number := 0; intial_sw number(1) := 0; IDETIAL_NO number := 0; weekly_amount number := 0; offer_type_1_amt number := 0; offer_type_2_amt number := 0; offer_type_3_amt number := 0; offer_type_4_amt n...  
55 General Membership Management
admin
Jun 09, 2016 270
Searchable Member DirectoryYour member directory is always available online and always current. Powerful reporting features allow Administrators to search and display members based on criteria they specify. If you have an existing database ...  
54 General function get area
admin
Jun 08, 2016 221
create or replace function fun_get_area (n_length in number, n_width in number) return number is n_area number(5); begin n_area := n_length*n_width; RETURN n_area; end fun_get_area;  
53 General How to set a proxy in UTL_HTTP
admin
Jun 07, 2016 225
... utl_http.set_proxy('http://102.168.12.12:5678'); ...  
Korean Community