desc

desc table

desc schema.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;
		

OraCmd is a command-line tools that can run without Oracle client.

US$49.95