2.11 FAQ-419 Can I import data from a database and save and re-use queries?

Last Update: 11/18/2024

For an introduction to importing data from a database, please refer to the OriginLab blog post Connecting to a Database and Importing Data.

  • To save a defined query in the SQL Editor Dialog Box, choose File: Save Connection and Query As. Alternately, you can Save to Active Worksheet (Good option if you want to save that information but don’t want to import data immediately).
  • To reuse an existing query, click the Load ODQ File button Button db Load ODQ File.png to browse the query file. You also can open the ODQ file directly in SQL Editor by (a) choosing Data: Connect to Database: Open, then browsing to the file or (b) from the Editor menu, choose File: Open.

Keywords:Oracle, SQL, source, query, reuse, database