↓ Skip to Main Content

Vollett Information Management Consultancy

Main Navigation

  • Home
  • Notes
Home › 2015 › June

Month: June 2015

Oracle: add many columns

By admin Posted on June 4, 2015 Posted in Oracle Tagged with add columns, column, oracle, repeatable, rerunnable

–Add new columns to <TABLE> if not already present SET ECHO OFF SET SERVEROUTPUT ON SIZE 1000000 SET FEEDBACK ON DECLARE P_TABLE_NAME VARCHAR(30 CHAR):='<TABLE>’; BEGIN FOR ICP IN ( SELECT FLIST.ORDR, FLIST.COLUMN_NAME, FLIST.DATA_TYPE, USER_TAB_COLS.COLUMN_NAME AS XCOL_NAME FROM ( SELECT 1 AS …

Oracle: add many columns Read more »

Search this site

Recent Posts

  • Join 2 SCD tables
  • Snowflake generate sequence without gaps
  • Snowflake JSON
  • JVM arguments: Massively parallel talend processes
  • Display Runtime SQL: Talend

Recent Comments

    Archives

    • December 2021
    • November 2021
    • October 2021
    • March 2021
    • January 2021
    • December 2020
    • November 2020
    • March 2019
    • November 2018
    • October 2018
    • August 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • May 2017
    • April 2017
    • March 2017
    • December 2016
    • August 2015
    • June 2015
    • April 2015
    • February 2015
    • December 2014
    • November 2014
    • October 2014
    • September 2014
    • August 2014
    • July 2014
    • June 2014
    • May 2014
    • March 2014
    • February 2014
    • January 2014
    • December 2013
    • November 2013
    • October 2013
    • September 2013
    • August 2013

    Categories

    • control-m
    • Database
    • Datastage
    • ETL
    • Information Analyzer
    • Information Server
    • JSON
    • Oracle
    • Powershell
    • QualityStage
    • Snowflake
    • Snowflake
    • Snowflake
    • sql
    • SQLServer
    • ssh
    • svn
    • Sybase
    • Talend
    • Talend
    • Unix
    • Windows

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org
    © 2025 Vollett Information Management Consultancy | Powered by Responsive Theme