How do you create nested tables?

How to set time in pl/sql(Toad) JOB

What steps should a programmer should follow for better tunning of the PL/SQL blocks?

How a SOAP web service can be called from PL/SQL block?How can we handle the result set returned by the SOAP service?

How can we call fieldcontrols in PL/SQL programming?

Where will the Procedure have is memory and location?

If amount s transfers from one account to another in banking, how will you update it with packages?

Case 1:
Create package with body only it contains only one private sub program
CREATE PACKAGE BODY no_spec AS
PROCEDURE myproc AS BEGIN null;
END;
END no_spec;
/

Case 2:
Create package with body only it contains no sub programs
CREATE PACKAGE BODY no_spec AS

END no_spec;
/

Difference between RANK TRANSFORMATION TYPE and RANGE by PARTITION. Simple Code in loading data into FACT Table using the above Two methods