Results 1 to 4 of 4

Thread: Get value from tables

  1. 09-05-2003, 11:50 AM #1
    btal00
    btal00 is offline Registered User
    Join Date
    Sep 2003
    Posts
    2

    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
    Reply With Quote Reply With Quote
  2. 09-05-2003, 01:18 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can use OSQL.EXE utility in SQL Server to run a query and save result in a text file.
    Reply With Quote Reply With Quote
  3. 09-05-2003, 01:49 PM #3
    btal00
    btal00 is offline Registered User
    Join Date
    Sep 2003
    Posts
    2
    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.
    Reply With Quote Reply With Quote
  4. 09-05-2003, 03:40 PM #4
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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