Home > OraCmd, Oracle access without client tool > Execute sql command

OraCmd - Oracle access without client tool »

Execute sql command

support select,insert,update,delete,create,drop,alter,truncate.

example:

OraCmd > select * from tabs;

Oracle Command Tool - execute oracle sql


You can use "/1h" to prevent repeating the column name header:

Oracle Command Tool - execute oracle sql


Or use /g (\g, /G, \G) to display fetch result vertically.

example:

select * from employees where rownum<3/g;

Oracle Command Tool - display fetch results vertically


support bind variables.

example:

select * from jobs where min_salary > &min and max_salary < &max;

Oracle Command Tool - bind variables


OraCmd is a command-line tools that can run sql command, import/export data, even without Oracle client.

30-day free trial Download OraCmd US$49.95 Buy OraCmd