| 86 |
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 /
|
| 85 |
General
test
|
admin |
May 11, 2016 |
354 |
|
|
| 84 |
General
BOOLEAN SAMPLE
|
admin |
May 11, 2016 |
359 |
|
declare v_access_level number; begin select e.employee_level_id into v_access_level from EMP e where lower(e.ou_name) = lower ('&USER.'); if v_access_level in (1,4) then return true; end if; EXCEPTION WHEN NO_DATA_FOUND THEN RETURN false...
|
| 83 |
SQL
Display Value, Return Value
|
admin |
May 10, 2016 |
318 |
|
SELECT STATE_NAME d, ST r FROM DEMO_STATES
|
| 82 |
 |
General
Fundamentals of PL/SQL
|
admin |
May 10, 2016 |
1148 |
|
Fundamentals of PL/SQL There are six essentials in painting. The first is called spirit; the second, rhythm; the third, thought; the fourth, scenery; the fifth, the brush; and the last is the ink. --Ching Hao The previous chapter provided an...
|
| 81 |
General
Interactive Report
|
admin |
May 07, 2016 |
350 |
|
Apex Interactive Report: The difference between CIR and RIRYou’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 Interact...
|
| 80 |
SQL
Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 )
|
admin |
May 06, 2016 |
309 |
|
SELECT b.customer_id, b.cust_last_name || ', ' || b.cust_first_name cust_name, SUM(a.ORDER_TOTAL) order_total FROM demo_orders a, DEMO_CUSTOMERS b WHERE a.customer_id = b.customer_id GROUP BY b.customer_id, b.cust_last_name || ', ' || b.cust...
|
| 79 |
SQL
EMPLOYEE_LEVEL_ID
|
admin |
May 03, 2016 |
282 |
|
declare v_access_level number; begin select e.employee_level_id into v_access_level from EMP e where lower(e.ou_name) = lower ('&USER.'); if v_access_level in (1,4) then return true; else return false; end if; EXCEPTION WHEN NO_DATA_FOUN...
|
| 78 |
SQL
HEAD TITLE (제목)을 조건에 따라 바꾸기
|
admin |
May 03, 2016 |
331 |
|
DECLARE NAME_sv VARCHAR2(30); --Detail_sv VARCHAR2(30) := 'Change Details'; BEGIN if :P18_CREATE_SW = 0 then select ENAME into NAME_sv from emp where EMPNO = :p18_EMPNO; :P18_NAME := initCap(NAME_sv); :p18_head_detail := ' * Modfy Detail Cus...
|
| 77 |
General
APEX ADMIN PASSWORD 바꾸기
|
admin |
May 02, 2016 |
329 |
|
1. DOS 에서 SQL로 이동 - cd C:/ C:> cd oraclexe/apex C: oraclexe/apex> sqlplus SYS as SYSDBA Enter Password: DB의 password ( jong123 ) SQL> @apxchpwd Enter a password for ADMIN user [] : Kim123!
|
| 76 |
General
wwv_flow_files
|
admin |
May 01, 2016 |
368 |
|
copy image table to wwv_flow_files insert into wwv_flow_files select * from FLOW_FILES_IMAGE_T select * from wwv_flow_files where FILENAME like '%.jpg' order by CREATED_ON desc
|
| 75 |
General
EXPORT & IMPORT
|
admin |
May 01, 2016 |
390 |
|
c:windowssystem32> imp file=c:haiwork_0410.dmp fromuser=haiwork touser=jongwork ignore=y commit=y exp file=c:haiwork_0410.dmp owner=haiwork compress =y ======================================================== When I do a backup in 9i using t...
|
| 74 |
SQL
Outer Join with Oracle SQL
|
admin |
Apr 29, 2016 |
332 |
|
https://community.oracle.com/thread/2255258?start=0&tstart=0A traditional outer join A "normal" join finds values of two tables that are in a relation to each other. In most cases, this relation is equality (=), but it can also be all so...
|
| 73 |
SQL
Report by Order / Product / Order and Product / By Order & Non Order
|
admin |
Apr 29, 2016 |
389 |
|
-- Customer by Order -- SELECT distinct c.CUSTOMER_ID , initcap(C.CUST_FIRST_NAME || ' ' || C.CUST_LAST_NAME) Name, o.ORDER_ID, O.ORDER_TOTAL FROM DEMO_CUSTOMERS C, DEMO_ORDERS O, DEMO_ORDER_ITEMS I where C.CUSTOMER_ID = O.CUSTOMER_ID and I....
|
| 72 |
General
Delimiter
|
admin |
Apr 29, 2016 |
362 |
|
A delimiter is a sequence of one or more characters used to specify the boundary between separate, independent regions in plain text or other data streams.An example of a delimiter is the comma character, which acts as a field delimiter in a...
|
| 71 |
SQL
SQL SELECT DISTINCT Statement
|
admin |
Apr 29, 2016 |
343 |
|
SELECT distinct c.CUSTOMER_ID , initcap(C.CUST_FIRST_NAME || ' ' || C.CUST_LAST_NAME) Name, o.ORDER_ID, O.ORDER_TOTAL FROM DEMO_CUSTOMERS C, DEMO_ORDERS O, DEMO_ORDER_ITEMS I where C.CUSTOMER_ID = O.CUSTOMER_ID and I.ORDER_ID = O.ORDER_ID --...
|
| 70 |
General
TAP ( Main & Sub ) / Button 의 Switch
|
admin |
Apr 28, 2016 |
368 |
|
* TAP 의 경우 1. 모든 Page 마다 Tap ( 메뉴 )을 지정 할수 있다. 2. SWITCH KEY를 사용하여 다른 페이지에서는 보이지 않게 할수 있다. 3. 예) P1_TAP_SHOW item을 만들고 이 item value에 따라 보이게 하는 조건 (Condition)을 사용. * Button 의 경우 1. C...
|
| 69 |
SQL
COUNT
|
admin |
Apr 28, 2016 |
338 |
|
* COUNT 1 * select distinct count (CUSTOMER_ID) from DEMO_CUSTOMERS; * COUNT 2 * select count (CUSTOMER_ID) from DEMO_CUSTOMERS where instr(upper(CUST_LAST_NAME), upper ( nvl (:P1_CUST_LAST_NAME,CUST_LAST_NAME))) > 0 AND instr(upper(CUST_FIR...
|
| 68 |
SQL
CREATING A TABLE / SEQUENCE / TRIGGER
|
admin |
Apr 28, 2016 |
352 |
|
* CREATING A TABLE * CREATE TABLE "CATEGORY_T" ( "CA_ID" NUMBER NOT NULL ENABLE, "CA_NAME" VARCHAR2(50), "LAST_MODIFIED_ON" DATE, "LAST_MODIFIED_BY" VARCHAR2(30), CONSTRAINT "CATEGORY_PK" PRIMARY KEY ("CA_ID") ENABLE ) / * CREATING SEQUENCE ...
|
| 67 |
SQL
CREATE (INSERT) PROCESS
|
admin |
Apr 28, 2016 |
335 |
|
* CREATE(INSERT) PROCESS * Begin INSERT INTO DEMO_CUSTOMERS (CUST_FIRST_NAME, CUST_LAST_NAME, CREDIT_LIMIT,NLS_TERRITORY,ACCOUNT_MGR_ID, CUST_EMAIL ) VALUES (:P9_CUST_FIRST_NAME, :P9_CUST_LAST_NAME, :P9_CREDIT_LIMIT,:P9_NLS_TERRITORY, :P9_AC...
|
