| 38 |
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;
|
| 37 |
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;
|
| 36 |
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...
|
| 35 |
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...
|
| 34 |
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...
|
| 33 |
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> &...
|
| 32 |
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...
|
| 31 |
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
|
| 30 |
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')
|
| 29 |
SQL
Oracle SQL Developer: Online Migration 3.1
|
admin |
Apr 25, 2018 |
308 |
|
|
| 28 |
SQL
How to Update Oracle XE
|
admin |
Apr 25, 2018 |
296 |
|
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 ...
|
| 27 |
SQL
SQL
|
admin |
Jul 15, 2016 |
558 |
|
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 ...
|
| 26 |
SQL
SUBSTR
|
admin |
May 26, 2016 |
458 |
|
SELECT SUBSTR('ABCDEFG',3,4) "Substring" FROM DUAL; Substring --------- CDEF SELECT SUBSTR('ABCDEFG',-5,4) "Substring" FROM DUAL; Substring --------- CDEF
|
| 25 |
SQL
FOR LOOP
|
admin |
May 20, 2016 |
462 |
|
FOR LOOP This Oracle tutorial explains how to use the FOR LOOP in Oracle with syntax and examples. DescriptionIn Oracle, the FOR LOOP allows you to execute code repeatedly for a fixed number of times. SyntaxThe syntax for the FOR Loop in Ora...
|
| 24 |
SQL
ROWNUM
|
admin |
May 19, 2016 |
439 |
|
ROWNUM For each row returned by a query, the ROWNUM pseudocolumn returns a number indicating the order in which Oracle selects the row from a table or set of joined rows. The first row selected has a ROWNUM of 1, the second has 2, and so on....
|
| 23 |
SQL
NVL
|
admin |
May 19, 2016 |
331 |
|
NVL Syntax Description of the illustration nvl.gif Purpose NVL lets you replace null (returned as a blank) with a string in the results of a query. If expr1 is null, then NVL returns expr2. If expr1 is not null, then NVL returns expr1. The a...
|
| 22 |
SQL
INSTR
|
admin |
May 19, 2016 |
532 |
|
INSTR Syntax Description of the illustration instr.gif Purpose The INSTR functions search string for substring. The function returns an integer indicating the position of the character in string that is the first character of this occurrence...
|
| 21 |
SQL
TREE
|
admin |
May 18, 2016 |
331 |
|
select PAGE_ID, PARENT_PAGE_ID , PAGE_NAME name from DEMO_PAGE_HIERARCHY connect by prior PAGE_ID = PARENT_PAGE_ID start with PARENT_PAGE_ID = 0 order by PARENT_PAGE_ID
|
| 20 |
SQL
CREATE VIEW
|
admin |
May 13, 2016 |
323 |
|
CREATE OR REPLACE FORCE VIEW "VIEW_COUNT" ("TOTALCOUNT") AS select count(p.PRODUCT_ID) TotalCount from DEMO_PRODUCT_INFO P /
|
| 19 |
SQL
Display Value, Return Value
|
admin |
May 10, 2016 |
318 |
|
SELECT STATE_NAME d, ST r FROM DEMO_STATES
|
