| 39 |
General
JK
|
admin |
Feb 05, 2019 |
1019 |
|
Welcome to JK Gardening Supply! We supply replacement parts for a wide assortment of small engine machines as well as providing all the tools and equipment your lawn and garden business requires. We are your leader in low prices Our high qua...
|
| 38 |
General
IMP
|
admin |
Oct 08, 2018 |
907 |
|
C:oraclexeapporacleproduct10.2.0serverBIN imp file=c:exp_gracework.dmp fromuser=gracework touser=gracework ignore=y commit=y log=c:imp_gracework.log C:oraclexeapporacleproduct10.2.0serverBIN exp file=c:exp_gracework.dmp fromuser=gracework to...
|
| 37 |
General
Change Admin PASSWORD
|
admin |
Jul 31, 2018 |
483 |
|
To change the password for the ADMIN account: 1) Change your working directory to the apex directory where you unzipped the installation software. 2) Start SQL*Plus and connect to the database where Oracle Application Express is installed as...
|
| 36 |
General
eeeeee
|
admin |
Jun 21, 2018 |
458 |
|
Volvo Saab Mercedes Audi
|
| 35 |
General
If you want to use EXISTS in a PL/SQL function returning BOOLEAN
|
admin |
May 19, 2018 |
466 |
|
If you want to use EXISTS in a PL/SQL function returning BOOLEAN,try this DECLARE v_exist NUMBER; BEGIN SELECT 1 INTO v_exist FROM DUAL WHERE EXISTS (select id_referencia from items where id_referencia = :P2_REFERENCIA) IF v_exist IS NOT NUL...
|
| 34 |
General
use a validation function for an element in apex 5.0
|
admin |
May 19, 2018 |
469 |
|
You could do a count(*) instead declare l_cnt integer; begin select count(*) into l_cnt from items where id_referencia = :P2_REFERENCIA; if( l_cnt >= 1 ) then return true; else return false; end if; end;If you really wanted to do an exists, ...
|
| 33 |
General
Validation to detect text in numeric field
|
admin |
May 19, 2018 |
468 |
|
DECLARE v_test_nbr NUMBER; v_check_exists NUMBER; BEGIN BEGIN v_test_nbr := to_number(:P6_TEXT_FIELD); EXCEPTION WHEN OTHERS THEN -- or catch 1722 (invalid number) and 6502 (char to number conversion error) v_test_nbr := NULL; END; IF v_test...
|
| 32 |
General
All Data DELETE from Table
|
admin |
May 10, 2018 |
442 |
|
truncate table fred;
|
| 31 |
General
Process
|
admin |
May 05, 2018 |
467 |
|
1. UNZIP - Oracle DB 11g - APEX 5.1 - SQL Developer 4.2 2. Oracle DB 11g 설치 C:UsersJongDocumentsOracleXE112_Win64 (1)DISK1 RUN SETUP PW: Kims123! (case sensitive) 3. OPEN Folder C:UsersJongDocumentssqldeveloper-4.2.0.17.089.1709-x64sqldeve...
|
| 30 |
General
Oracle APEX 5.1.4 Installation
|
admin |
Apr 17, 2018 |
347 |
|
|
| 29 |
General
APEX Password Change
|
admin |
Aug 26, 2016 |
658 |
|
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)...
|
| 28 |
General
control break
|
admin |
Jun 25, 2016 |
617 |
|
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...
|
| 27 |
General
Membership Management
|
admin |
Jun 09, 2016 |
653 |
|
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 ...
|
| 26 |
General
function get area
|
admin |
Jun 08, 2016 |
552 |
|
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;
|
| 25 |
General
How to set a proxy in UTL_HTTP
|
admin |
Jun 07, 2016 |
544 |
|
... utl_http.set_proxy('http://102.168.12.12:5678'); ...
|
| 24 |
General
APEX Web Services Proxy Settings
|
admin |
Jun 07, 2016 |
584 |
|
https://community.oracle.com/thread/1382356?tstart=0 the web services call will be made by the database server, so authentication isn't just an issue for APEX, but you would give the host running the database server access. APEX itself only ...
|
| 23 |
General
DBMS_NETWORK_ACL_ADMIN
|
admin |
Jun 07, 2016 |
568 |
|
SELECT host, acl, DECODE( DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE_ACLID(aclid, 'SCOTT', 'resolve'), 1, 'GRANTED', 0, 'DENIED', NULL) privilege FROM dba_network_acls WHERE host IN (SELECT * FROM TABLE(DBMS_NETWORK_ACL_UTILITY.DOMAINS('www.us....
|
| 22 |
General
DBMS_NETWORK_ACL_ADMIN
|
admin |
Jun 07, 2016 |
559 |
|
http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_networkacl_adm.htm#insertedID0
|
| 21 |
General
Assign a network host to Access Control List
|
admin |
Jun 07, 2016 |
540 |
|
BEGIN DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL ( acl => 'UTL_HTTP.xml', host => 'google.com'); COMMIT; END; / ---------------------------------------. BEGIN DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL ( acl => 'UTL_HTTP.xml', host => 'localhost', lower_port ...
|
| 20 |
General
ADD_PRIVILEGE (2nd STEP)
|
admin |
Jun 07, 2016 |
570 |
|
BEGIN DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE ( acl => 'UTL_HTTP.xml', principal => 'PYANGWORK', is_grant => TRUE, privilege => 'connect', position => null); COMMIT; END; /
|
