OraCmd - Oracle access without client tool »

Download OraCmd Free Trial »

More functions

desc

desc table

Oracle Command Tool - oracle desc table

desc schema.table

Oracle Command Tool - desc table

 

explain plan

	delete plan_table;

	explain plan for select /*+ rule */ * from jobs;

	select 
		substr (lpad(' ', level-1) || operation || ' (' || options || ')',1,30 ) "Operation", 
		object_name                                                              "Object"
	from 
		plan_table 
	start with id = 0 
	connect by prior id=parent_id;
		

Oracle Command Tool - explain plan