From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Using SQLplus command in LabView Database toolkit

Hi ,

 

I would like to ask something but before that this is my set up background

 

OS          : Win 7,

LabVIEW : 2012

 

I have successfully connected with Oracle database using Labview Database toolkit.

The problem now is since I need to query the data from the database,

it will takes time for the labview to process it (since there is so much data in a specific table),

 

let say that the table in database is "Serial Number", and the data that I want from that table is "SN123"

if I query the data from that table, the labview will process it in a long time since it will not only give me "SN123" but also other data inside the "Serial Number" table.

 

(Refer to attachment)

 

but if in SQLplus, there is a command that can be execute to specifically call the "SN123" data,

 

For the SQLplus, the steps to retrieve the data is like this:

1. Key in the command to get the ID of the "SN123"

2. Key in the command "SN123" ID to retrieve the data.

 

I wonder if there is a way to put this command on labview database so it will be faster to retrieve the data.

 

0 Kudos
Message 1 of 1
(2,026 Views)