An objective of this task is to discover SELECT statement from a given query processing plan. Consider the following fragment of query processing plan. Operation SELECT STATEMENT HASE JOIN RIGHI ANTI VIEN HASH JOIN stama TABLE ACCESS FULL TABLE ACCESS FULL ORDERS TABLE ACCESS FULL VW_350_1 fit="_TX" 1000 AND "0_CUSIKEY">-0) 214X Discover SELECT statement that may have a query processing plan listed above. If you are not be able to get exactly the same query processing plan then, try to find SELECT statement with a query processing plan the most similar to the given one. Use EXPLAIN PLAN statement of SQL and SQL script showplan.sql to find a query processing plan of a given SELECT statement. Save EXPLAIN PLAN statement and invocation of a script showplan.sql in SQL script solution4.sql When ready start SQLcl client, connect to Oracle database server, and process SQL script solution4.sql. Save a report from processing of the script in a file solution 4.1st. It is explained in Cookbook, Recipe 1.5, Step 9, "How to create and to save a report" how to save a report from processing of SQL script in a text file. The script must be processed with SQLcl options ECHO and FEEDBACK set to ON such that all SQL statements processed are included in the report ! A good habit is to put SQLcl statements SPOOL solution4 SET ECHO ON SET FEEDBACK ON