Kayshav.com
About Technology Information Sitemap



Application Development - Database Technologies
Oracle Database, Tools and Technology
Oracle Functions     Oracle 11g Features     Oracle 12c Features    
Systems Architect, DBA Tips
Database General Information
Create Database   Oracle DB Info.   DB Info - 2   DB Info - 3   DB Info - 4   Datafile
Compile Objects   - Schema
SYS_CONTEXT   Oracle DBA - Tips   Describe Table   Object Dependencies
Database Login   Audit   Manage User   Privileges
All_Tab_Columns   Insert Into   All_Objects
Oracle DB Memory/CPU    Two    Three    Four    AWR/IOPS
Buffer Cache   Hit Ratio
Library Cache   RowCache
Locked Objects   Longops Analysis
DBMS_SCHEDULER Jobs - One   Two  
Database Size   Object Size - Table, MVW   Segments   TableSpace   Temp Space
PGA   SGA   UGA
DDL Reference   Scripts   Oracle AWS-RDS
Manage Index   Manage Sequence  
Oracle Errors and Resolution
00603   06508
IOT   External Table   Temp Table   Nested Table   Object/Relational   Streams Table
Oracle Data Warehousing   Materialized Views
SQLLDR (csv)   - Fixed Width   - Skip/ContinueIF   - Streaming   - CLOB 1   - CLOB 2   XML Data
 
Developer Tips
Dual Table Queries   Data Load   Number Series
DateDiff   Calendar Creation   Quarters   Bi-Yearly   Range Query
Week Data Setup   Week Analysis
WHERE Clause Switching by DECODE
Hierarchy Query -> One   Two   Three   Four   NoCycle   30004
Oracle Developer -> One    Two    Three    ANSI Join    ANSI Outer Join    Input Parameter As A String To Oracle Stored Procedure
Grouping_ID, Grouping Sets    Group_ID/Rollup    CUBE    Bit Vector    3-Column    4-Column    Grouping_ID/Rollup
ERP PO Summary
MERGE (CRUD)
 
Oracle Analytic Functions
First/Last    Row_Number, Rank,..    Rownum, Rank,..    TopN Query    FIRST_Value
LAG    LEAD    Non-Linear    Sequence Gap    Date Overlap
Calendar Summary    Year Based    GL Calendar    N-th Business Day
Dynamic Annual Calendar    Compute Holidays
Ratio_To_Report
Data grouping using Count(*) Over (PARTITION BY ...)
Oracle Analytical Functions    Dense_Rank
Cummulative Totals - Sequential    Null Value    All Data    Yearly
Count(*) Over()   Comma Separated String   Sum() Over()   Compute Percent
Annual Sales    YTD-1    YTD-2    Year Over Year Analysis    Year Over Year - DW    Duplicates    Delete Duplicates
 
Oracle SQL Model Clause
Iterations    Factorial    Cummulative Sum    Compute ROI
Hemachandra/Fibonacci Sequence
Sales Analysis    Pivot Query
Sum() Over()    Upsert Sequential..    Current Value (CV)
 
Oracle - Java Development
Oracle - Java    Data Management    Execute Host Command
 
Oracle - XML Features
XML Functions
XMLElement    XMLElement With Namespace    XMLElement User-Defined Data-Type
XMLConcat    XMLForest    SYS_XMLGen    DBMS_XMLGen 1    DBMS_XMLGen 2
XMLTable (Query XML)    XMLTransform    XMLAGG    XMLDOM
DBMS_Metadata.Get_XML
XMLType Table
extractValue    getClobVal    getStringVal    XMLSequence
 
Oracle - PL/SQL
Recursive Call    Autonomous Transactions    Bind Variable    Dynamic SQL    Execute Immediate    Pivot Query/Report
Reverse LOOP   VARRAY   ROWTYPE   Bubble Sort
Associative Array
Auto Numbering    Data Audit    Block Delete
Conditional Compilation    Exception Handling    Encryption, Decryption    Data Reseting
DBMS_RANDOM - Numeric Array    String Generation    Prime Numbers    Evaluate String
 
Oracle - PL/SQL Nested Table
Multiset - Union    Distinct    Except    Intersect
ANSI Set Operations    Iteration    Sorting    Trim    Delete
 
Oracle - PL/SQL Advance Features For ETL
Bulk Collect   EXISTS   Forall .. Indices Of   Bulk Collect - LIMIT
Data Output by REF CURSOR   Function With Sys_Refcursor Input
Table Function - Factorials    Prime Numbers    Pipelined and Parallel Table Function
 
Complex Datatypes
DBMS_LOB   Append   WriteAppend BLOB   Insert BLOB Data   BFILE
WriteAppend CLOB   BLOB To CLOB   CLOB To Varchar  
LONG to Varchar2
SYS.ANYDATA
 
PL/SQL Performance Analysis and Tuning
DBMS_PROFILER   DBMS_SHARED_POOL
 
Oracle - PL/SQL Utility Features
DBMS_LOCK   UTL_FILE   UTL_MAIL   UTL_SMTP   Globalization   PL/SQL Wrap   Comma_To_Table   Error Logging
UTL_HTTP - Request   Request_Pieces
Security - SQL Injection Prevention  
 
Oracle - Data Validation
REGEXP   - LIKE   - REPLACE   - SUBSTR   - combinations
 
Oracle - Statistical Functions
Correlation   Covariance   Regression   Standard Deviation   Variance
 
Oracle - Miscellaneous Functions
BitAND   Bin_To_Num   CAST/MULTISET   Width_Bucket   CEIL, FLOOR, MOD   WM_Concat
CASE   CASE and DECODE
Execute SQL Script
 
Oracle - Miscellaneous PL/SQL
String Output

Web Technologies:
Dependent Drop Down

1. Non Relational Database - NoSQL
2. Centralized Repository - Data Lake
3. Data Warehouse/Data Mart - DW/DM    ETL Process    Slowly Changing Dimension    Operational Data Store
4. Data Warehouse Data Management - Backup Strategies
5. Database Storage/Data Recovery Strategies - RAID
6. Database Storage Systems - Storage Area Network

General Technology Reference Information Links:
1. Master Data Management - MDM
2. Data Management - LifeCycle
3. Data Transaction - ACID
4. Data (memory) - Designation
5. Java Technology - Overview

For corrections, comments or feedback, please contact webmaster

Last Revised On: April 27th, 2019
Oracle registered trademark of Oracle Corporation

  47170



335436