-
Get value from tables
I currently do a verification of value in table to match with in the website. I normally verify using small SQL commands for related tables. Somehow it is a time consuming. I was wondering if you help me with creating a SQL script by getting values from tables and throwing the result or output in text file format as part of verification that the values are matched in database and in website
Thanks a lot
-
You can use OSQL.EXE utility in SQL Server to run a query and save result in a text file.
-
The company I work is using Oracle server. In addition to this, I don't have access using Oracle scripts that Oracle provided to run it.
-
You can use sql plus from command line and redirect the output to a file.
You can save your query in a file and pass the file as a parameter to sql plus together with login information.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|