Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create a view to get 50% of the records in the table

User_36PFMJun 27 2022 — edited Jun 28 2022

I am having a table which is having more than 2 billion rows. The count is 2439371821
The table is not having a primary key colomns.
I need to create 2 view, The first view gets the 50% of the rowsand second view gets the next 50% of the rows.
Example : if the table is having 75 rows, i need to create a 2 views.
First view should return 37 rows and second view should return 38 rows.
My table is not having any primary key colomuns

Comments
Post Details
Added on Jun 27 2022
8 comments
2,737 views