Tag Archives: oracle

Oracle Cheat Sheet

1. get version of oracle database 2. get timestamp of last commit 3. get name of the database 4. get create table statement 5. select rowid (base64 encoded pseudocolumn) 6. Query all_tables 7. Get information about a table: 8. Query … Continue reading

Posted in Computers, programming, Software | Tagged | Leave a comment

How to iterate over all rows of a table in Oracle db

Recently I was writing a program to copy data from Oracle to Big Query. This program needs to fetch all rows in a given table (aka a table scan) and then write them to the destination. We should not fetch … Continue reading

Posted in Computers, programming, Software | Tagged | Leave a comment