Database Software

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!

Need to Get latest 10 record from each table in a Schema with separate excel file

KumarnklOct 8 2021

Requirement : Need to create excel file. Each sheet in excel file should content latest 10 records from each table in a schema. Please provide suggestion to get SQL query OR any tools OR any other ideas.
Example
Schema - XX
IN that schema have 3 table (Table1, Table2, Table3). It's the scenario
Result should be : Create the EXCEL FILE, In the excel each sheet should content latest 10 records from each table in a schema.
Sheet1 Name -Table1 (Each sheet should content latest 10 records)
Sheet2 Name -Table2 (Each sheet should content latest 10 records)
Sheet3 Name -Table3 (Each sheet should content latest 10 records).

Please assist us by your valuable information.

Added on Oct 8 2021

#advanced-queueing, #database, #database-key-features, #export, #pl-sql, #sqldeveloper

2 comments

144 views