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