Skip to content

Data, data and more data

Tom's playground

  • Home
  • A theory of data warehousing
  • About
  • Old pages
  • Toms’ Speeltuin

PL SQL that creates a table

3. May 2019 tom

The situation is simple. We have to create a table that contain data on a certain variable outcome. Normally, one would like to create a field in the table and […]

 Allgemein

Hot backup in Oracle

27. April 201927. April 2019 tom

It is possible to make a hot backup in Oracle. This implies that we do not have to shutdown the database before creating a backup. The steps are as follows: […]

 Allgemein

Take latest values

16. April 201916. April 2019 tom

The situation is as follows. We have a table with records that are added over time. The request is to produce a resultset that only contains values that are added […]

 nice to know

Cold backup in Oracle

12. April 201913. April 2019 tom

Actually, taking a cold backup in Oracle is quite simple. If you choose to undertake a cold backup by copying tables, it consists of 5 steps. Step 1 is identifying […]

 Allgemein

Changing granularity

5. April 20195. April 2019 tom

Let us suppose, we have a table that has a granularity in two dimensions. Think of a customer and a product dimension. So each record has a combination of customer […]

 Allgemein

The ORACLE_HOME

31. March 20195. April 2019 tom

Oracle needs to have a set of context variables that allow Oracle to know where the programmes are located. Upon installation, you have to check if these variabled are set. […]

 nice to know

SQL in steps

23. March 20195. April 2019 tom

Let us assume we have a request to show results from a query that is too massive to run on-line. Let us also assume that we may distinguish in this […]

 nice to know

Writing content from Oracle

17. February 20195. April 2019 tom

This note provides a PL/SQL programme that writes the the content of a table to a file. It also uses a steering table (emp_ids) that contains a series of ids […]

 nice to know

Working with XML in Oracle

14. February 201918. February 2019 tom

Oracle has nice features to export data as an XML file. Let us discuss a few of them. The first one is to use SQL Developer. We could already export […]

 Allgemein

Data miner in Oracle

6. February 201914. February 2019 tom

I have played a bit with Oracle data miner. This feature is available in the enterprise edition of Oracle version 11 or above. It can be accessed from SQL developer. […]

 nice to know

Posts navigation

← Older posts
Newer posts →

Recent Posts

  • ODI and SCD
  • Oracle – provide a rank
  • Keeping a journal in Oracle
  • Oracle – trigger example
  • Oracle: writing to a file
  • tom on Sqoop

Archives

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

Categories

  • a theory
  • Allgemein
  • data warehousing
  • nice to know
  • Uncategorized

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Proudly powered by WordPress | Theme: Moesia by aThemes