1 Reply Latest reply: Feb 4, 2013 6:34 AM by Tridus RSS

    executing sql*plus commands using odp.net

    988900
      Hi,

      we are developing query builder ,
      its working fine with sql commnads using cmd.executenonquery() and executereader() methods.but problem with sql*plus commands.
      please guide me how to execute sql*plus commands,
      (eg:desc tablename,show user etc).


      thanks in adv.
        • 1. Re: executing sql*plus commands using odp.net
          Tridus
          AFAIK, you can't. SQL*Plus (Or SQL Developer, depending on what you're using) are converting those into database queries for you when you're using them.

          You can do the same queries yourself, though. Here's some info on what desc is doing: http://stackoverflow.com/questions/9855209/how-can-i-describe-a-table-in-oracle-without-using-the-describe-command