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

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;
/

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

Where will the Procedure have is memory and location?

How can we call fieldcontrols in PL/SQL programming?

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

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

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

How do you create nested tables?

User Interface accepts the Employee information and this data needs to be compared with the existing data and the differences needs to be populated through a Pl/SQL table.Create a type (EMP_DATA) to populate the Employee table data.Create a type (ERR_TABLE) with the following attributes:ERR_NO NUMBER,ERR_COLUMN VARCHAR2(50),ERR_RESULT VARCHAR2(500)Create a package USER5_PKG1 with two procedures....

For each hour, list the number of called, total transactions' values, and total duration?if you have these tables:1- 'calls'columns: called_number, Customer_ID, call_date, call_time_started, Call_time_ended,transaction_no.2- 'tariff'columns: Tarriff_per_Sec, country_code, time_started, time_ended.

For example: I have 100's of tables and I need to take the data from database and export as a xml file.