| 106 |
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 ...
|
| 105 |
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;
|
| 104 |
General
How to set a proxy in UTL_HTTP
|
admin |
Jun 07, 2016 |
544 |
|
... utl_http.set_proxy('http://102.168.12.12:5678'); ...
|
| 103 |
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 ...
|
| 102 |
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....
|
| 101 |
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
|
| 100 |
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 ...
|
| 99 |
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; /
|
| 98 |
General
CREATE_ACL (1st STEP)
|
admin |
Jun 07, 2016 |
529 |
|
BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL ( acl => 'recapcha.xml', description => 'Permissions to access http://www.google.com', principal => 'PYANGWORK', is_grant => TRUE, privilege => 'connect'); COMMIT; END; /
|
| 97 |
General
ACL 보기
|
admin |
Jun 07, 2016 |
534 |
|
select acl , host , lower_port , upper_port from DBA_NETWORK_ACLS;
|
| 96 |
General
Oracle 11g Access Control List for External Network Services
|
admin |
Jun 07, 2016 |
499 |
|
http://www.oracleflash.com/36/Oracle-11g-Access-Control-List-for-External-Network-Services.html
|
| 95 |
General
Access Control List (ACL)
|
admin |
Jun 07, 2016 |
587 |
|
Access Control List (ACL)An access control list (ACL) is a list of access control entries (ACEs). By default, order in the list is relevant (see "ACL and ACE Evaluation"). Example 27-2 shows a simple ACL that contains only the ACE of Example...
|
| 94 |
General
CAPTCHA PLUG-IN
|
admin |
May 27, 2016 |
515 |
|
http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-plug-ins-182042.html
|
| 93 |
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
|
| 92 |
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...
|
| 91 |
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....
|
| 90 |
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...
|
| 89 |
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...
|
| 88 |
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
|
| 87 |
General
3D Pie Chart
|
admin |
May 17, 2016 |
441 |
|
How-To Document Build a Chart with a Drill Down to a Report Date: 06-Nov-2003 Based on Oracle Application Express (formerly called HTML DB) version 1.5 After completing this How-To, you should be able to understand: How to Create an SVG char...
|
