Tag Archives: Oracle

(日本語) ORA-01799: 列は副問合せに対して外部結合されません。


Sorry, this entry is only available in 日本語.


(日本語) 複数のSQLを一度に実行するためのスクリプト


Sorry, this entry is only available in 日本語.


VBA: How to List Table Definitions in Access File


In this article, we will introduce code that converts a list of table definitions within Microsoft Office Access(アクセス) (.mdb) files into Oracle-compatible table definitions and outputs them as a list.

Overview

  • We will use Excel and VBA for this process.
  • By running the VBA function GetTableDefinitions, you can output a list of table definitions from an Access file to the open Excel sheet.
  • We will create text data intended to be pasted into a table definition document (.xls).
  • For Access tables converted to Oracle, text columns, for example, will be displayed as VARCHAR2.
  • We won’t output system tables (you can modify the code to include them if needed).
  • Link tables will display the contents of the links. The definitions of linked destination tables will not be output.

How to Use

  1. Open Excel.
  2. Open the Visual Basic Editor from the development tools.
  3. Add a module.
  4. Check Microsoft DAO in the Tools > References settings.
  5. Paste the code below.
  6. Execute the GetTableDefinitions function.
Continue reading VBA: How to List Table Definitions in Access File

Oracle: Concatenate Strings in Grouping


Sorry, this entry is only available in 日本語.