For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Can you please let me if we can create a SOAP Based Webservices in Apex. Apex will be the provider of the webservice and my other 3rd party application will be consumer.
SQL> explain plan for SELECT * 2 FROM emp 3 UNION 4 SELECT * 5 FROM emp; Explained. SQL> select * from table(dbms_xplan.display); PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------- Plan hash value: 3774834881 ---------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ---------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 28 | 1036 | 8 (63)| 00:00:01 | | 1 | SORT UNIQUE | | 28 | 1036 | 8 (63)| 00:00:01 | | 2 | UNION-ALL | | | | | | | 3 | TABLE ACCESS FULL| EMP | 14 | 518 | 3 (0)| 00:00:01 | | 4 | TABLE ACCESS FULL| EMP | 14 | 518 | 3 (0)| 00:00:01 | ---------------------------------------------------------------------------- 11 rows selected. SQL> explain plan for SELECT * 2 FROM emp 3 UNION ALL 4 SELECT * 5 FROM emp; Explained. SQL> select * from table(dbms_xplan.display); PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------- Plan hash value: 1301082189 --------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | --------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 28 | 1036 | 6 (50)| 00:00:01 | | 1 | UNION-ALL | | | | | | | 2 | TABLE ACCESS FULL| EMP | 14 | 518 | 3 (0)| 00:00:01 | | 3 | TABLE ACCESS FULL| EMP | 14 | 518 | 3 (0)| 00:00:01 | --------------------------------------------------------------------------- 10 rows selected. SQL> select count(*) from (SELECT * FROM emp UNION SELECT * FROM emp); COUNT(*) ---------- 14 SQL> SELECT count(*) from ( select * FROM emp UNION ALL SELECT * FROM emp); COUNT(*) ---------- 28
select * from emp where emp_no=2 union select * from emp where emp_no=3;
MAT_VIEW ACCESS BY INDEX ROWID OC_MVT SNAP_UAT_T_CANDIDATE 26817 27326 1338974 INDEX FULL SCAN OC_SYS IX2_CANDIDATE_NAME 1354 27326
MAT_VIEW ACCESS STORAGE FULL OC_MVT SNAP_UAT_T_CANDIDATE 5058 27326 1338974