locked
Select query RRS feed

  • Question

  • User-1578974752 posted

    SELECT * FROM xxtec_tss_exp_receipt_lines_if WHERE NUMBER ='10' AND ITEMSs=NVL(:ITEM, ITEMSs)

    it is working in toad

    HOW CAN I do thi in vb.net. Thanks

    Tuesday, January 22, 2019 11:05 AM

Answers

All replies

  • User197322208 posted

    From NVL I assume you are using an Oracle Database.

    Learn about ADO.NET and Oracle Connection

    https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/oracle-and-adonet

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, January 22, 2019 1:37 PM
  • User61956409 posted

    Hi shsu,

    shsu

    SELECT * FROM xxtec_tss_exp_receipt_lines_if WHERE NUMBER ='10' AND ITEMSs=NVL(:ITEM, ITEMSs)

    it is working in toad

    HOW CAN I do thi in vb.net.

    As ignatandrei mentioned, ADO.NET technology can help create data access applications. If you are using Oracle Database, please make sure you import the System.Data.OracleClient.

    Imports System.Data.OracleClient

    With Regards,

    Fei Han

    Wednesday, January 23, 2019 1:45 AM