 |
QRCODE
|
admin |
May 25, 2020 |
593 |
|
https://community.oracle.com/thread/4039160?start=15&tstart=0 https://www.youtube.com/watch?v=nCfMy_xiWmY
|
| 145 |
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...
|
| 144 |
SQL
ACTION
|
admin |
Jan 11, 2019 |
1954 |
|
declare M_action integer; begin select count(*) into M_action from MNEWS where MYEAR = :P18_YEAR and MMONTH = :P18_MONTH; if( M_action >= 1 ) then :P18_SELECT := 2; else :P18_SELECT := 1; end if; end;
|
| 143 |
SQL
SELECT last_name FROM
|
admin |
Dec 12, 2018 |
862 |
|
SELECT last_name FROM (SELECT last_name, ROW_NUMBER() OVER (ORDER BY last_name) R FROM employees) WHERE R BETWEEN 51 and 100;
|
| 142 |
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...
|
| 141 |
SQL
CREATE TABLE
|
admin |
Sep 25, 2018 |
691 |
|
CREATE TABLE DEDUCTION_RESULT ("DEDUCT_ID" NUMBER, "MISSIONARY_ID" VARCHAR2(20),"RECEIPT_NO" NUMBER,"SUPPORTER_ID" NUMBER, "AMOUNT" NUMBER,"CONTRIBUTION_DATE" DATE ,"DEDUCTION" NUMBER ) CREATE SEQUENCE "DEDUCTION_RESULT_SEQ" MINVALUE 1 MAXVA...
|
| 140 |
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...
|
| 139 |
SQL
VERY IMPORTANT
|
admin |
Jun 26, 2018 |
434 |
|
DECLARE SSID2 NUMBER; BEGIN delete from MISSIONARY_SUB; delete from MISSIONARY_SUB2; delete from MISSIONARY_YEAR; insert into MISSIONARY_SUB Select MISSIONARY_ID,SUPPORTER_ID,AMOUNT,to_number(to_char(CONTRIBUTION_DATE,'MM')) from CONTRIBUTIO...
|
| 138 |
IF/ELSE ... CASE WHEN
|
admin |
Jun 25, 2018 |
339 |
|
CREATE OR REPLACE PROCEDURE calsal IS new_sal number; CURSOR sal_cursor IS SELECT deptno, empno, ename, sal FROM emp; BEGIN FOR i IN sal_cursor LOOP if i.deptno = 10 then new_sal := i.sal *0.05 ; DBMS_OUTPUT.put_line ( ' Salary plus bonus of...
|
| 137 |
SQL
MISSIONARY_SUB
|
admin |
Jun 25, 2018 |
404 |
|
insert into MISSIONARY_SUB Select MISSIONARY_ID,SUPPORTER_ID,AMOUNT,CONTRIBUTION_DATE from CONTRIBUTION where UPPER(:P9_MISSIONARY_ID) = MISSIONARY_ID and :P9_YEAR = to_number(to_char(CONTRIBUTION_DATE,'YYYY')) order by SUPPORTER_ID,CONTRIBU...
|
| 136 |
General
eeeeee
|
admin |
Jun 21, 2018 |
458 |
|
Volvo Saab Mercedes Audi
|
| 135 |
SQL
TABLE PRINT
|
admin |
Jun 18, 2018 |
407 |
|
<table id="supporters"> <tr> <th>Supporter ID</th> <th>Missionary ID</th> <th>Amount </th> <th>MEMO </th> </tr> <tr> <td>&P4_SUPPORTER_ID.</td> <td> &...
|
| 134 |
SQL
GP PRINT
|
admin |
May 31, 2018 |
437 |
|
<img src="r/gpusa/104/files/static/v2/gp.png"> <p style="text-align: center;"><span style="font-family: sans-serif;"><strong><span style="font-size: 18px;">GLOBAL PARTNERS USA</span></strong></span><br> <style="text-align: center;"><span sty...
|
| 133 |
SQL
How to convert DATE to NUMBER
|
admin |
May 27, 2018 |
411 |
|
select to_char(CONTRIBUTION_DATE,'YYYY') from contribution select to_number(to_char(CONTRIBUTION_DATE,'YYYY')) from contribution
|
| 132 |
SQL
DATE Compare
|
admin |
May 22, 2018 |
410 |
|
select * from contribution where CONTRIBUTION_DATE >= to_date ('01/01/2014' ,'MM/DD/YYYY') and CONTRIBUTION_DATE <= to_date ('12/31/2014' ,'MM/DD/YYYY')
|
| 131 |
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...
|
| 130 |
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, ...
|
| 129 |
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...
|
| 128 |
General
All Data DELETE from Table
|
admin |
May 10, 2018 |
442 |
|
truncate table fred;
|
| 127 |
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...
|
