This discussion is archived
1 Reply Latest reply: Feb 4, 2013 4:34 AM by Tridus RSS

executing sql*plus commands using odp.net

988900 Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points