asked on How to manipulate two or more composite data type into single results set in oracle
Hi,
How to manipulate two or more composite data type into single results set
In SQL server, Temp table,
they are using two or more temp tables inside the single procedure.
Now i am consider those temp tables as a composite records
For example i have two composite data type rec1 and rec2
I need to combine with these composite two records for aggregation process and also they are need to grouped by grouping function
Is there is anyway to reach ?
Note: Multi-set operators doesn't required for my requirement.
Here only need aggregation process .
Kindly correct me if I am wrong.
Any help with be really appreciated
thanks
Alsatham Hussain
How to manipulate two or more composite data type into single results set
In SQL server, Temp table,
they are using two or more temp tables inside the single procedure.
Now i am consider those temp tables as a composite records
For example i have two composite data type rec1 and rec2
I need to combine with these composite two records for aggregation process and also they are need to grouped by grouping function
Is there is anyway to reach ?
Note: Multi-set operators doesn't required for my requirement.
Here only need aggregation process .
Kindly correct me if I am wrong.
Any help with be really appreciated
thanks
Alsatham Hussain
Oracle Database
Last Comment
alsatham hussain
do you have a sample ?
ASKER
Hi,
I have attached one sample procedure.
This SP doesn't meet above scenario
thanks
Alsatham hussain
sample-SQL-server-SP.docx
I have attached one sample procedure.
This SP doesn't meet above scenario
thanks
Alsatham hussain
sample-SQL-server-SP.docx
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi slightwv,
It would be of great help.
Thanks
Alsatham hussain
It would be of great help.
Thanks
Alsatham hussain