For large output which is not able to fit in a single window, scrolling the results can skip data while it looks messy as well. to get rid of scrolling, you can use the command “set pause on”. With pause ON, the output will come in small chunks and will continue only when you press […]
Continue reading about How to get rid of scrolling for long SQL output in Oracle
This post will guide you how you can play with SQL using the interactive variable values inside the statement. To begin with, suppose we even don’t know which table we want to query from. To check all the tables inside the logged in database, you can query the TABLE_NAME from user_tables. To get all the […]
Continue reading about How to run SQL commands with an input variable
This is one of the most commonly observed error in Oracle database. The exact error description is as follows: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SUN OS Error: 2: No such file or directory Due to this error, the DBA is unable to login to the SQL prompt. This […]
Continue reading about How to resolve Oracle Error “shared memory realm does not exist”