MARKS TUTORIAL

ORA-00942: table or view does not exist Oracle Server uses the concept of “Schema” to hold the objects  in the database. Hence a Schema acts as a container for  database’s object(s). It also provide security model to  the database itself. What it means is that the USER must have sufficient privilege(s)  to access the database object for the intended purpose,  like if you want to see the data in a table of Schema X  then you must have select privilege on that table.  You will see an example for that later on… Reason for ORA-00942 ~~~~~~~~~~~~~~~~~~~~~~~ 1.   You are trying to execute a SQL statement that  references a table or view that does not exist. 2. A synonym that is not allowed here was used. 3. You do not have access rights to that particular  object that you are referencing in your query. 4. The table or view belongs to another schema and you  did not reference the table by the sch...

Spool SqlPlus Output to Microsoft Excel Format SET PAGESIZE 50000 SET FEEDBACK OFF SET MARKUP HTML ON SPOOL ON SET NUM 24 SPOOL file_name.xls ---- Execute your query SPOOL OFF SET MARKUP HTML OFF SPOOL OFF Example: SET PAGESIZE 50000 SET FEED OFF MARKUP HTML ON SPOOL ON SET NUM 24 SPOOL EMP_DATA.xls Select EMPNO, ENAME, HIREDATE, SAL From Scott.EMP / [[ The output from above query will be displayed ..... ]] SPOOL OFF SET MARKUP HTML OFF SPOOL OFF NOTE: The file will contain the SQL as well. Save the file as Your_File_name.xlsx The file should be in the Current Working Directory.

ORA-01555 Snapshot Too Old Oracle Server has the ability to have multi-version read consistency  which is invaluable to you because it guarantees that you are  seeing a consistent view of the data (no 'dirty reads'). What it means is that when you are executing a query, Oracle server  will provide you a consistent view of the database as if someone  has taken a Snapshot of the database at the time your query begins.  Hence the name “ Snapshot Too Old”. How Oracle Server Provide Consistent View ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Oracle server has the ability to determine whether a database  block has been modified or not with respect to your  query/transaction and if it was modified then how to retrieve  the unmodified version of that database block for  your transaction.     Whenever Oracle changes a database block (index, table, etc,) it  stores a pointer in the header of the ...