Technical Blog

Pages

  • Home
  • Oracle DBA
  • ERP
  • Oracle Apps
  • Data Warehouse
  • Java
  • UNIX
  • Hadoop
  • JOBS4U

Sep 25, 2008

References

1) www.orafaq.com/wiki/Main_Page

2) www.orafaq.com/wiki/Scripts

3) www.orafaq.com/wiki/SQL_FAQ
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Reference, Scripts

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Total Pageviews

TOPICS

  • ►  2024 (2)
    • ►  October (1)
    • ►  June (1)
  • ►  2023 (6)
    • ►  September (3)
    • ►  May (3)
  • ►  2022 (8)
    • ►  June (7)
    • ►  April (1)
  • ►  2021 (16)
    • ►  December (13)
    • ►  July (1)
    • ►  February (2)
  • ►  2020 (2)
    • ►  December (1)
    • ►  July (1)
  • ►  2019 (6)
    • ►  December (6)
  • ►  2018 (5)
    • ►  December (1)
    • ►  August (1)
    • ►  May (1)
    • ►  February (2)
  • ►  2017 (2)
    • ►  June (1)
    • ►  January (1)
  • ►  2016 (29)
    • ►  December (2)
    • ►  August (1)
    • ►  July (1)
    • ►  June (1)
    • ►  May (5)
    • ►  April (1)
    • ►  March (10)
    • ►  February (6)
    • ►  January (2)
  • ►  2015 (11)
    • ►  August (2)
    • ►  June (2)
    • ►  April (6)
    • ►  February (1)
  • ►  2014 (8)
    • ►  November (1)
    • ►  October (3)
    • ►  August (2)
    • ►  July (1)
    • ►  April (1)
  • ►  2013 (13)
    • ►  December (5)
    • ►  May (4)
    • ►  February (3)
    • ►  January (1)
  • ►  2012 (6)
    • ►  October (1)
    • ►  September (3)
    • ►  May (2)
  • ►  2011 (24)
    • ►  December (3)
    • ►  November (4)
    • ►  October (1)
    • ►  August (3)
    • ►  July (6)
    • ►  June (3)
    • ►  May (2)
    • ►  March (1)
    • ►  January (1)
  • ►  2010 (24)
    • ►  November (4)
    • ►  October (3)
    • ►  September (2)
    • ►  August (1)
    • ►  July (1)
    • ►  June (2)
    • ►  April (3)
    • ►  March (5)
    • ►  February (2)
    • ►  January (1)
  • ►  2009 (51)
    • ►  November (2)
    • ►  September (1)
    • ►  July (3)
    • ►  May (14)
    • ►  April (4)
    • ►  March (12)
    • ►  February (12)
    • ►  January (3)
  • ▼  2008 (11)
    • ►  December (1)
    • ►  November (4)
    • ▼  September (6)
      • References
      • OS-Version
      • MOVE
      • Alphabets,Level, Analytic Query
      • Calender,Dates,Objects created
      • Lock,Month,Week Query

Popular Posts

  • Scrum vs Kanban
    Scrum & Kanban are Lean and Agile. Kanban is not an Agile Method! With agile methods such as Scrum,customer or the product is on foc...
  • UNDERSTANDING EXPLAIN PLAN 6
     Miscellaneous Operations FOR UPDATE ...
  • Oracle Exdata
    Exdata is a hardware machine which runs oracle database; supports OLTP, Database Exologic is a hardware machine for application and primar...
  • Azure Blob
  • Database vs. Data Warehouse vs. Data Lake
    In the world of data management, these three concepts play distinct roles in handling and organizing data. Let's explore their key diffe...
  • Azure Redis
     
  • DBMS_JOB VS DBMS_SCHEDULER
    - logging of job runs (job history) (maintain history and a copy of the log file in the database) - simple but powerful scheduling syntax (...
  • Pragma RESTRICT_REFERENCES
    The fewer side-effects a function has, the better it can be optimized within a query, particular when the PARALLEL_ENABLE or DETERMINISTIC ...
  • Oracle Spatial index
    Spatial index creation -- Create the index without any parameters CREATE INDEX geod_counties_sidx ON geod_counties(geom) INDEXTYPE IS MDSYS....
  • Interanl execution during Disable versioning a table
    Step 1: SELECT 1  FROM DUAL WHERE EXISTS (SELECT 1 FROM  scott.experiment_lt   WHERE VERSION IN (SELECT VERSION FROM wmsys.wm$version_hie...

Explore ORACLE4U
Oracle4u.com

Labels

  • Oracle Workspace (15)
  • ORACLE EXPLAIN PLAN (10)
  • Oracle Text (6)
  • Performance Tuning (6)
  • dbms_wm (6)
  • Dev OPS (5)
  • DevOps (5)
  • wmsys.wm_concat (5)
  • Check constraint (4)
  • DBMS_WM.ENABLEVERSIONING (4)
  • INDEXTYPE (4)
  • Improve Performance (4)
  • Index (4)
  • REGEXP_REPLACE (4)
  • Agile (3)
  • Analytic Functions (3)
  • Block Chain (3)
  • CONTAINS() (3)
  • Create (3)
  • DBMS_WM.BEGINDDL (3)
  • Execution Plan (3)
  • FOREIGN KEY (3)
  • Git Hub (3)
  • LIKE (3)
  • REGEXP_LIKE (3)
  • SCORE() (3)
  • Scrum (3)
  • Solidity (3)
  • Type (3)
  • extract() (3)
  • fetch (3)
  • gotoworkspace (3)
  • sys_connect_by_path (3)
  • Avoid Duplicates (2)
  • CTXSYS (2)
  • CTX_DDL (2)
  • CTX_REPORT (2)
  • CUBE (2)
  • Calender (2)
  • Constraints (2)
  • Containerization (2)
  • DATABASE (2)
  • DBMS_SQLTUNE (2)
  • DBMS_WM.COMMITDDL (2)
  • DBMS_WM.DISABLEVERSIONING (2)
  • DIMENSION (2)
  • Examples of Ref Cursor (2)
  • FOR UPDATE (2)
  • FULL SCAN (2)
  • GLOBALIZATION SUPPORT (2)
  • INLINE VIEW (2)
  • Insert (2)
  • JOIN (2)
  • Left outer join (2)
  • Level (2)
  • Lock Query (2)
  • MDSYS (2)
  • MODEL (2)
  • NOT NULL (2)
  • Nested tables (2)
  • OLTP (2)
  • ORA-20229 (2)
  • Oracle ADF (2)
  • PGA (2)
  • PROJECTION (2)
  • RAID (2)
  • RAID 0+1 (2)
  • RAID 1 (2)
  • RAID 10 (2)
  • RAID 2 (2)
  • RAID 3 (2)
  • RAID 5 (2)
  • REF Cursor (2)
  • SELECT (2)
  • SEQUENCE (2)
  • SINGLE VALUE (2)
  • Spatial (2)
  • Split Values (2)
  • Sql (2)
  • Stragg (2)
  • Tablespace (2)
  • UPDATE (2)
  • VIEW_WO_OVERWRITE (2)
  • Varrays (2)
  • Version Control (2)
  • WITH (2)
  • WMSYS.WM$VERSIONED_TABLES (2)
  • XMLTYPE (2)
  • _LT table (2)
  • alter table (2)
  • bulk collect (2)
  • connect by (2)
  • create workspace (2)
  • cursor (2)
  • dbms_xplan (2)
  • docker (2)
  • lt_ctx_pkg (2)
  • merge join (2)
  • open (2)
  • row_number () (2)
  • set operation (2)
  • to_char (2)
  • virtualization (2)
  • * (1)
  • /*+NO_QUERY_TRANSFORMATION*/ (1)
  • /*+index(table index_name)*/ (1)
  • :alpha (1)
  • :punct (1)
  • A funny Error (1)
  • ADA (1)
  • AL32UTF8 (1)
  • ALL (1)
  • ALL_ARGUMENTS (1)
  • ALT32UTF8 (1)
  • ANALYZE (1)
  • ANTI (1)
  • APEX_UTIL (1)
  • API (1)
  • AWS Lamda (1)
  • Advance Scrum Master (1)
  • Alphabets (1)
  • Alter database (1)
  • Ansible (1)
  • Associative Array (1)
  • Audit (1)
  • Availability (1)
  • Azure Blob (1)
  • Azure CDNS (1)
  • Azure Container Registry (1)
  • Azure Databases (1)
  • Azure Functions (1)
  • Azure Redis (1)
  • BY GLOBAL INDEX ROWID (1)
  • BY INDEX ROWID (1)
  • BY LOCAL INDEX ROWID (1)
  • BY ROWID (1)
  • BY USER ROWID (1)
  • Benchmark (1)
  • Big Data (1)
  • Big Table (1)
  • BigTable (1)
  • Bitcoin Halving (1)
  • Blind SQL Injection (1)
  • Blob (1)
  • Buffer Aging (1)
  • Buffer Cache Problems (1)
  • Bulk Processing in Oracle (1)
  • Business Area (1)
  • Business Intelligence (1)
  • CAP Property (1)
  • CARTESIAN (1)
  • CATSEARCH (1)
  • CLOB (1)
  • CLOSE (1)
  • CLUSTER (1)
  • COLLECTION ITERATOR (1)
  • CONCATENATION (1)
  • CTXCAT (1)
  • CTX_CLS (1)
  • Carbon emission (1)
  • Character Set (1)
  • Chineese Lexer (1)
  • Cloud - Iaas / Paas /SaaS (1)
  • Cloud Architecture (1)
  • Combined Index (1)
  • Composite partitioning (1)
  • Compress index ; performance (1)
  • Conflict management (1)
  • Connection Pool (1)
  • Consistency (1)
  • Context (1)
  • Context Switches and Performance (1)
  • Continuous Integration (1)
  • Convert number to word (1)
  • Cosmos DB (1)
  • CouchDB (1)
  • Cursor Execution Cycle (1)
  • DATABASE LINK (1)
  • DBA (1)
  • DBA Scripts (1)
  • DBA_ADVISOR_LOG (1)
  • DBA_ARGUMENTS (1)
  • DBA_TAB_MODIFICATIONS (1)
  • DBMS_ASSERT (1)
  • DBMS_CRYPTO (1)
  • DBMS_JOB (1)
  • DBMS_LOB (1)
  • DBMS_OUTPUT.PUT_LINE (1)
  • DBMS_SCHEDULER (1)
  • DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO (1)
  • DBMS_WM.CompressWorkspace (1)
  • DBMS_WM.SetDiffVersions (1)
  • DBWR (1)
  • DDL (1)
  • DENSE_RANK (1)
  • DETERMINISTIC (1)
  • DIANA (1)
  • DISABLING_VER (1)
  • DML (1)
  • DOMAIN INDEX (1)
  • DUMMY table (1)
  • Data Center (1)
  • Data Warehouse (1)
  • Data mining (1)
  • DataStore (1)
  • DataWAREHOUSING (1)
  • Dates in a Year (1)
  • Deadlock (1)
  • Delete Duplicates (1)
  • Descriptive Intermediate Attributed Notation for Ada (1)
  • Detail Calender (1)
  • Differences of Varchar2 Bytes & Char (1)
  • Different ways to declare REF CURSORS (1)
  • Dirty List (1)
  • Discoverer Desktop (1)
  • Discoverer Plus (1)
  • Discoverer Viewer (1)
  • Disk Storage (1)
  • Document store (1)
  • Duplexing (1)
  • Dynamic Cursor FOR Loops (1)
  • Dynamic SQL (1)
  • ESB (1)
  • ESCAPE (1)
  • ETL (1)
  • EXECUTE IMMEDIATE (1)
  • EXTRACTVALUE (1)
  • Elastic scaling (1)
  • Encryption (1)
  • Export Acess to Oracle (1)
  • Export And Import (1)
  • FACEBOOKBOUNDARY (1)
  • FILTER (1)
  • FIRST (1)
  • FIRST ROW (1)
  • FIXED INDEX (1)
  • FIXED TABLE (1)
  • Faster recovery (1)
  • Fault Tolerance (1)
  • Features in Outer Join (1)
  • Feeding Hadoop Data to Oracle (1)
  • Flashback (1)
  • For numeric overflow round function will not work (1)
  • Freeze (1)
  • GROUP BY CUBE (1)
  • GROUP BY NOSORT (1)
  • GROUP BY ROLLUP (1)
  • Graph (1)
  • Green Computing (1)
  • HASH (1)
  • HASH JOIN (1)
  • Hadoop (1)
  • Hadoop and Oracle (1)
  • Hidden Table (1)
  • High Water Mark (1)
  • Hints (1)
  • Histograms (1)
  • How to read explain plan (1)
  • Hybrid Columnar Compression (1)
  • IDENTIFIED (1)
  • INITRANS (1)
  • INLIST (1)
  • INLIST ITERATOR (1)
  • INTERSECTION (1)
  • INVALID (1)
  • ITERATOR (1)
  • Inband SQL Injection (1)
  • Index Monitoring (1)
  • Index Operations (1)
  • InfiniBand Networks (1)
  • Insertion with condition (1)
  • Instead of Stragg (1)
  • Instead of Trigger (1)
  • Integration of Hadoop with Oracle (1)
  • Intelligent Storage Grid (1)
  • Isnumber (1)
  • JSP (1)
  • Japaneese Lexer (1)
  • Jenkins (1)
  • Job (1)
  • Julian date (1)
  • Key-value store (1)
  • Koerean Lexer (1)
  • Kubernates (1)
  • LAG (1)
  • LEAD (1)
  • LIKE clause hint (1)
  • LIVE (1)
  • LOAD AS SELECT (1)
  • LRU (1)
  • LRU Lists (1)
  • LRU algorithm (1)
  • LT (1)
  • Lean (1)
  • Lexer (1)
  • M-code (1)
  • MAXTRANS (1)
  • MDSYS.MD (1)
  • MDSYS.MDERR (1)
  • MDSYS.PRVT_IDX (1)
  • MEASURES (1)
  • MINUS (1)
  • MRU algorithm (1)
  • MULTIBYTE (1)
  • Manager Query (1)
  • Map Reduce (1)
  • Materialized view (1)
  • Minimal data loss (1)
  • Mirroring (1)
  • MongoDB (1)
  • Month Query (1)
  • Move (1)
  • MultiLexer (1)
  • MySQL (1)
  • NCHAR (1)
  • NESTED LOOP (1)
  • NLS Data Dictionary (1)
  • NLS_DATABASE_PARAMETERS (1)
  • NLS_INSTANCE_PARAMETERS (1)
  • NLS_LENGTH_SEMANTICS (1)
  • NLS_SESSION_PARAMETERS (1)
  • NO SQL (1)
  • NOSORT (1)
  • NOSQL (1)
  • NOT EXISTS (1)
  • NOT IN (1)
  • NOVALIDATE (1)
  • NO_ACCESS (1)
  • NVARCHAR2 (1)
  • Nagios (1)
  • Namespace (1)
  • Native Compilation (1)
  • New Features in Oracle 11g (1)
  • No Erros (1)
  • Numbers to Words (1)
  • ODBC (1)
  • ODCIAggregateTerminate (1)
  • OLAP (1)
  • OLAPSYS (1)
  • ORA-00604: error occurred at recursive SQL level 1 (1)
  • ORA-00932 (1)
  • ORA-01400 (1)
  • ORA-01407 (1)
  • ORA-01450: maximum key length (1)
  • ORA-01555 : snapshot too old (1)
  • ORA-01790 (1)
  • ORA-01830 (1)
  • ORA-01854 (1)
  • ORA-02290 (1)
  • ORA-02293 (1)
  • ORA-06512:at "WMSYS.LT" (1)
  • ORA-13249: SDO_NN cannot be evaluated without using index (1)
  • ORA-14400: inserted partition key does not map to any partition (1)
  • ORA-20056 (1)
  • ORA-20061: versioned objects have to be version (1)
  • ORA-20100 (1)
  • ORA-20104: cannot version disable this table (1)
  • ORA-20123 (1)
  • ORA-20129:table does not exist (1)
  • ORA-20132:table is not version enabled (1)
  • ORA-20136:table names are limited to 25 characters (1)
  • ORA-20171: WM error: 'CREATE TABLE' and 'CREATE SEQUENCE' privileges needed (1)
  • ORA-20171: WM error: Versioned objects cannot be altered (1)
  • ORA-20200: UNSUPPORTED CONSTRAINT (1)
  • ORA-20229: statement 'delete from mdsys.sdo_geom_metadata_table' failed during EnableVersioning. Error (1)
  • ORA-20229: statement 'select count(*) from mdsys.sdo_geom_metadata_table where upper( (1)
  • ORA-20231: failed during DisableVersioning. Error (1)
  • ORA-29913 (1)
  • ORA-30483 (1)
  • ORA-39726: unsupported add/drop column operation on compressed tables (1)
  • ORA-56901 (1)
  • ORA-56902 (1)
  • ORACLE ADVANCED COMPRESSION (1)
  • ORACLE ARCHITECTURE (1)
  • ORA_NCHAR_LITERAL_REPLACE (1)
  • ORDERED (1)
  • OUTER (1)
  • OVER (1)
  • Objects created (1)
  • Optimistic (1)
  • Oracle (1)
  • Oracle ADF or Oracle Apex (1)
  • Oracle Analytic functions (1)
  • Oracle BI (1)
  • Oracle Baseline (1)
  • Oracle Cloud (1)
  • Oracle Collections (1)
  • Oracle Cursors (1)
  • Oracle Discoverer (1)
  • Oracle Exadata (1)
  • Oracle Exdata (1)
  • Oracle Forms to ADF (1)
  • Oracle Golden Gate (1)
  • Oracle Grid Computing (1)
  • Oracle Histograms (1)
  • Oracle Information Architecture Capability Model (1)
  • Oracle Managed Datafiles (1)
  • Oracle Memory area (1)
  • Oracle Network Topology (1)
  • Oracle Overlaps (1)
  • Oracle Questions (1)
  • Oracle RAC (1)
  • Oracle Spatial Errorcodes (1)
  • Oracle Text Operators (1)
  • Oracle Trace - tkprof (1)
  • Oracle Trace File (1)
  • Oracle VM (1)
  • Oracle hint (1)
  • Oracle in Big Data World (1)
  • Outband SQL Injection (1)
  • P-code (1)
  • PARALLEL_ENABLE (1)
  • PCTFREE (1)
  • PCTUSED (1)
  • PL/SQL (1)
  • PLSQL Table (1)
  • PRAGMA RESTRICT_REFERENCES (1)
  • PRESENTATION (1)
  • PRIMARY KEY (1)
  • PROCEDURE (1)
  • Parallel Pipelined Table Functions (1)
  • Parameterized (1)
  • Parity (1)
  • Partition Operations (1)
  • Partition tolerance (1)
  • Performance (1)
  • Pesimistic (1)
  • Pivot (1)
  • Pivot rows to columns without aggregate (1)
  • Points Explain Plans (1)
  • Popular Algorithms for Data Mining (1)
  • Power-BI (1)
  • Private Database Cloud (1)
  • Product Management (1)
  • Pyramid (1)
  • QlikView (1)
  • Query Analyzer (1)
  • Query Optimizer (1)
  • Query to convert comma separated values into rows Query to split number and character into two different columns ;XMLTYPE (1)
  • Quote Operator (1)
  • R & its Examples (1)
  • RAID 1+0 (1)
  • RAID 4 (1)
  • RAID 50 (1)
  • RAID 6 (1)
  • RANGE (1)
  • RANK (1)
  • RAWTOHEX (1)
  • REFERENCIAL INTEGRITY (1)
  • REGEXP_INSTR (1)
  • REMOTE (1)
  • RNDS (1)
  • RNPS (1)
  • ROW_NUMBER (1)
  • Rapid deployment (1)
  • Real-time (1)
  • Recommended Applications (1)
  • Recursive Subquery Factoring in Oracle (1)
  • Redis (1)
  • Redis DB & its use case (1)
  • Redolog tablespace (1)
  • Reference (1)
  • Relational databases (1)
  • Resource hierarchy (1)
  • Right outer join (1)
  • Roll back (1)
  • Row Migration (1)
  • Row chaining (1)
  • Rownum (1)
  • SAMPLE (1)
  • SAVEPOINT (1)
  • SDO_AGGR_UNION (1)
  • SDO_NET.CREATE_LOGICAL_NETWORK (1)
  • SDO_NN_DISTANCE (1)
  • SEMI (1)
  • SGA (1)
  • SINGLE RANGE (1)
  • SORT (1)
  • SQL Area (1)
  • SQL Injection Points (1)
  • SQL PLUS (1)
  • SQL to avoid the logical duplicate (1)
  • SQL with Bind Variables (1)
  • STORE AS (1)
  • SYS_CONTEXT (1)
  • Save point (1)
  • Scalability (1)
  • Scripts (1)
  • Scrum vs Kanban (1)
  • Sectioner (1)
  • Select FOR UPDATE (1)
  • Select (SQL) (1)
  • Setting Software Port in Oracle (1)
  • Smart Flash Cache (1)
  • Space management Scripts (1)
  • Spatial Index (1)
  • Sql Injection (1)
  • Standard (1)
  • Strong REF Cursor (1)
  • Sudokko Solver in Oracle (1)
  • TABLE ACCESS FULL (1)
  • TEMP TABLE GENERATION (1)
  • TIMESTAMP Datatypes (1)
  • TNS (1)
  • TNS Listener (1)
  • TO_CLOB (1)
  • TRANSLATE (1)
  • TRUST (1)
  • Tableau (1)
  • The System Identifier (1)
  • Timer (1)
  • To Remove Special Characters using regexp_replace (1)
  • To Remove Special Characters using translate (1)
  • To get how may records are inserted after import (1)
  • Toad (1)
  • Transparent Network Substrate (1)
  • Trigger to detect SQL Injection Attacks (1)
  • Tuning the LIKE-clause (1)
  • UNDO & TEMP Tablespace (1)
  • UNDO_CODE (1)
  • UNLOCKED ROWS (1)
  • USERENV (1)
  • USER_ARGUMENTS (1)
  • USER_SDO_NETWORK_METADATA (1)
  • USER_WM_RIC_INFO (1)
  • USING clause of EXECUTE IMMEDIATE (1)
  • UTF8 (1)
  • Unindexed Foreign Keys (1)
  • Unpivot (1)
  • V$ADVISOR_PROGRESS (1)
  • V$NLS_PARAMETERS (1)
  • V$NLS_VALID_VALUES (1)
  • VALIDATE_NETWORK (1)
  • VIEW_W_OVERWRITE (1)
  • Version (1)
  • Virtual Machine (1)
  • WE8ISO8859P1 (1)
  • WHERE CURRENT OF (1)
  • WIDTH_BUCKET (1)
  • WMSYS.LT (1)
  • WNDS (1)
  • WNPS (1)
  • Weak REF Cursor (1)
  • Week Query (1)
  • Working with Java Data Types Using Operators and Decision Constructs Creating and Using Arrays Using Loop Constructs Working with Methods and Encapsulation (1)
  • Workload (1)
  • Workload Resource Management (1)
  • Workspace Manager (1)
  • XML databases (1)
  • XMLAGG (1)
  • XMLELEMENT (1)
  • XMLSEQUENCE (1)
  • [[:alpha:]] (1)
  • [[:punct:]] (1)
  • _LTS (1)
  • aggregate operation (1)
  • all_sdo_geom_metadata (1)
  • and SQL Server (1)
  • append (1)
  • between (1)
  • boolean (1)
  • cannot decrease column length because some value is too big (1)
  • cant reduce size of datatype (1)
  • case (1)
  • column to be modified must be empty to decrease precision or scale (1)
  • commit (1)
  • compress_view_wo_overwrite (1)
  • connect by level (1)
  • connect by prior (1)
  • connect_by_isleaf (1)
  • conventional insert operations (1)
  • convert NUMBER to words (1)
  • count (1)
  • crypto (1)
  • cursor for loop (1)
  • datafile (1)
  • db link (1)
  • dba_tables (1)
  • dbms_flashback (1)
  • dbms_rowid (1)
  • dbms_shared_pool (1)
  • dbms_spm (1)
  • dbms_sql (1)
  • dbms_stats (1)
  • dbms_xdb.getftpport (1)
  • dbms_xdb.gethttpport (1)
  • dbms_xdb.sethttpport (1)
  • dbms_xplan.display_cursor (1)
  • differences of execute and & statements (1)
  • diminfo (1)
  • direct-path insert (1)
  • do_relatemask_table (1)
  • dsn (1)
  • dual (1)
  • exception (1)
  • exec (1)
  • executed (1)
  • fitst_value() (1)
  • for all (1)
  • for loop (1)
  • framework (1)
  • freezeworkspace (1)
  • from (1)
  • full-table scan (1)
  • function (1)
  • getStringVal() (1)
  • grant (1)
  • group by (1)
  • hasura (1)
  • heterogeneous systems (1)
  • index by pls_integer/ binary_integer (1)
  • instead of wm_concat (1)
  • interval (1)
  • is table of (1)
  • last executed query (1)
  • last executed statement in session (1)
  • line 9175 (1)
  • line 9355 (1)
  • listagg (1)
  • listagg function in oracle (1)
  • listagg in Oracle 11G (1)
  • lists the arguments of the procedures and functions (1)
  • merge$actions (1)
  • middle tier (1)
  • non-relational databases (1)
  • nth_value (1)
  • old outer join is complex (1)
  • operations during disable versioning a table (1)
  • or (1)
  • ora-01440 (1)
  • ora-01441 (1)
  • oracle data cracking/hacking (1)
  • oracle hacking (1)
  • order (1)
  • order by (1)
  • organization index (1)
  • outer join (1)
  • partition (1)
  • partition by (1)
  • password (1)
  • pattern search in a subquery using LIKE (1)
  • query to remove duplicate records (1)
  • regexp_substr (1)
  • replace (1)
  • resource contention (1)
  • return (1)
  • reverse (1)
  • row operation (1)
  • rows between (1)
  • sdo_geom.sdo_min_mbr_ordinate (1)
  • sdo_geom_metadata_table (1)
  • sdo_nn (1)
  • sdo_num_res (1)
  • sdo_relation (1)
  • sdo_within_distance (1)
  • segment (1)
  • select 1/0 from dual (1)
  • sort join (1)
  • space (1)
  • stop key (1)
  • sys.odcinumberlist (1)
  • sys.odcivarchar2list (1)
  • sys_fbt_insdel (1)
  • sys_op_c2c (1)
  • sys_op_cl2c (1)
  • sys_op_descend (1)
  • sys_op_lvl (1)
  • sys_op_rawtonum (1)
  • sys_op_rpb (1)
  • sys_op_vecand (1)
  • sys_op_vecbit (1)
  • sys_op_vecor (1)
  • temporary table (1)
  • temporary tablespace (1)
  • to get the arguments of the procedures and functions (1)
  • trigger (1)
  • unbounded following (1)
  • unbounded preceding (1)
  • unique (1)
  • unique constraint IN Oracle Workspace (1)
  • user_wm_versioned_tables (1)
  • v$version (1)
  • virtual column (1)
  • when (1)
  • window (1)
  • windowing clause (1)
  • wm$ric_table (1)
  • wmsys (1)
  • wmsys.wm$nextver_table (1)
  • wmsys.wm$version_hierarchy_table (1)
  • wmsys.wm$vt_errors_table (1)
  • xml (1)
  • xmlagg instead of listagg (1)
Share in FACEBOOK

Translate

Wikipedia

Search results

Technical Blog. Picture Window theme. Powered by Blogger.