Search this site
tech@padipa.net
  • Padipa
  • 4 Ways to Execute script
  • Administration using stored procedure
  • Advance Queries
  • AIX
    • IBM AIC Miscellaneous
    • Logical Volume Manager
  • AIX Paging Space
  • Analytical Functions
  • Apache
  • ASM (Oracle - Automatic Storage Management)
  • Basic Select Operations
  • Conditional Functions Decode, NVL, Case etc
  • Database Technologies
    • DB Tech Scene
    • MSSQL
      • About MSSQL
      • Administration and Monitoring SQL Databases
      • Administration Tools
      • Backup & Restore
      • Data storage
      • Databases
      • DBCC Database Consistency Checker
      • DBCC Dealing with Corruption
      • DBCC ShrinkDatabase
      • Exam
      • Index Rebuild and Re-org
      • Log Shipping
      • Miscellaneous
      • Miscellaneous
      • Monitoring Scripts
      • MSSQL User-Logins Backup
      • Profiler
      • Restoring Master DB from backup
      • SQL Cluster
      • SQL Server Emergency Mode
      • SQL Server Error Logs
      • SQL Server Memory Mangement
      • Standby Server
      • Transactional Log
    • Mysql Database
      • Monitoring Processes Mysql
      • mysql backup and restore (dump and restore)
      • Mysql Import and Export
      • MySQL Installation -Solaris 10
      • Mysql Mysqladmin client - Administration of mysql
      • Mysql Replication - Master and Slave
      • MySQL Storage Engines viz MyISAM, innodb, archive, memory, csv..etc
      • Mysql User Administration
    • Oracle
      • Auditing
      • Automatic Storage Management
      • Block Corruption
      • Changing database name and/or database id using NID
      • Corrupted or deleted datafile from production - Restoration from Standby dr server
      • creating oracle database
      • Data Blocks, Extents, Segments
      • Data Moving
      • Database and instance
      • Database Recovery Types
      • Flasback Technology
      • Miscellaneous
      • Monitoring Scripts
        • Monitoring Sessions, Performance, Killing sessinos
        • Oracle Alert Log checking through SQL Plus
        • scripts
      • Networking & DB links
      • Opatch
      • Oracle Data Pump
      • Oracle Database Diagnostic .. ADR, DRA..
      • Oracle Database Hardening and Best Practises
      • Oracle Managing Indexes
      • Oracle PL/SQL
      • Oracle Session Monitoring, Locks, Latches and Waits
      • Oracle Startup and Shutdown Process
      • Performance Tunin
      • Performance Tuning
      • RMAN
        • RMAN DUPLICATE DATABASE
        • RMAN Single Tablespace Restoration
      • Scheduling jobs ../ in progress
      • Session Information
      • Shared Server and Dedicated Server Architecture.
      • Shrinking Tables, High Water Mark
      • Standby database
      • Tablespaces
      • Undo Management
      • User Management
    • Reading Statspack and AWR Reprots
    • Sybase
      • Account Lock/Unlock
      • Creating a database
      • Dump and Load
      • Sybase information
      • Sybase Introduction
      • Sybase Startup and shutdown
      • System Databases
  • DB Creation, Advance Options, Table Creation Advance Options, In-memory Tables, Temporary Tables.
  • DML Data Manipulation Language
  • Error Logs
  • File Systems
  • Gaurav Nandgaye
  • Generating create scripts through dbms_metadata package
  • Hierarchical Queries
  • IBM AIX Devices
  • IBM AIX Miscellaneous
  • IIS 7
  • Imp Oracle INIT parameters
  • Indexes
    • Tracing Session / System
  • Installation Oracle Application E-Business Suite
  • Logical Volume Manager
  • Microsoft SQL Server 2016
  • Microsoft SQL Server 2016 Installation and Advanced Installation Options
  • Microsoft SQL Server Various Tools SSMS,Configuration Manager, Activity Monitor, Profiler etc
  • Monitoring Tool , SNMP
  • MSSQL T-SQL
  • MSSQL Backup Up User Logins
  • Network Administration
  • Oracle -RAC Cache Fusion Technology
  • Oracle 11 g New Features
    • Oracle 11G FlashBack Technology
    • RMAN Duplicate Database Command
  • Oracle 12c In-Memory Database
  • Oracle 12c Installation
  • Oracle 12c New Features
    • Oracle 12c Adaptive Execution Plans
    • Oracle 12C Multitenant Architecture
    • Oracle 12c Partitioning Features
    • Oracle 12c RMAN Backup and Recovery
    • Oracle Database 12c Security
  • Oracle Applicaiton E-Business Suite - Cloning
  • Oracle Application Database Structure Schemas etc
  • Oracle Application E-Business Suite - Discoverer
  • Oracle Application E-Business Suite - Patching
  • Oracle Application E-Business Suite : Configuration Details Technical Parameters
  • Oracle Applications DBA
    • Oracle Applicaiton ,Context Files, Environment Files, Control Scripts, File System
    • Oracle Container for Java - OC4J
      • Command Line Management Utilities
    • Oracle E-Business Architecture
    • Oracle HTTP Server
  • Oracle Database 11g RMAN - Recover Manager
  • Oracle Errors , ORA-
  • Oracle Patched CPU and PSU
  • Oracle RAC on Windows
    • Oracle RAC Administration
  • Oracle SQL and PL/SQL
  • Oracle SQL Joins
  • Oracle Standard Edition Manual Standby
  • Oracle Transparent Data Encryption
  • Performance Monitoring
  • RAC Oracle ( Real Application Cluster ) Linux x86_64
  • Recent articles
    • Azure
    • Domains and DNS
    • Excel VBA Programming
    • Important Windows Command / Programs
    • IP Address
    • Linux
    • Microsoft Exchange 2007
    • Monitorint, SNMP
    • Solaris
      • Device and Drivers
      • Disk Management
      • file permissions
      • GRUB
      • init
      • shell basics
      • System Information
      • User Management
    • Storage Area Network
    • Tomcat
    • Unix AIX
    • Virtualization
    • Weblogic Suite
    • Windows Batch Files
  • Regular Expressions
  • Service Management Facility- SMF
  • Set Operators (union, union all, minus, intersect)
  • Solaris System Boot
  • Solaris Virtualization - Zones
  • SQL - Development T-SQL, PL/SQL
    • DDL Data Definition language
    • DQL Data Query Language
  • SQL Queries For DBA
  • SQL Server 2005 in single user mode
  • SQL Server 2008
    • SQL 2008 Cluster Installation
    • SQL Server 2008 Optimization
  • SQL Server 2008 High Availability
  • swap space
  • Sybase components
  • Sybase device
  • System Logs (syslogd) and Performance Management
  • Unix Scripting
    • Scripting Essentials
  • View and Advanced View Options
  • VMWare ESX Server
  • Working with JSON
  • Working with XML
  • Zettabyte File System ZFS
tech@padipa.net

DML Data Manipulation Language

1) Basic Select Operations

2) Joins

3) Set Operators (Union, Union all, Minus, Intersect)

4) Conditional Functions Decode, NVL, Case etc

Report abuse
Page details
Page updated
Google Sites
Report abuse