1 Reply Latest reply on Feb 4, 2013 12:34 PM by Tridus

    executing sql*plus commands using odp.net


      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
          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