Databases
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”
Let’s discuss the processes running in Oracle database and their functions. DBW`: Database Writer, this process writes the data from buffer cache to the DB file and this operation of reading and writing is done in blocks. The default block size in Oracle is 8192 bytes, however it can be modified as required. Starting from […]
Usually, we use the SCOTT/tiger account to login to the system after installing the database but that account is locked in the beginning for security reasons. So, if you try to enter using that user, you get the following error: C:\Documents and Settings\Administrator>sqlplus SQL*Plus: Release 10.1.0.2.0 – Production on Sun Feb 20 21:15:21 2011 Copyright […]
The default port to access iSQL*PLUS is 5560. You can access iSQL*PLUS with the following URL given that the oracle is installed on the local host ‘http://localhost:5560/isqlplus/’ To change the port number, modify the file “http-web-site.xml” as given below:
Continue reading about How to change the port number for iSQL*PLUS in Oracle
If you need to drop a table in informix and create it again, you require the script which was initially used to create that table. To get the SQL script, we use dbschema command. Most frequently, the command is used in the following format. dbschema -d <database> -t <tablename> -ss <file_name> |__ To Generate Server […]
Continue reading about How to retrieve SQL script for table creation from Informix