For those who don't have GUI tools like SQL developer or Enterprise Manager, you can still get an explain plan for a statement in SQL*Plus.… Read More »SQL Developer Explain Plan
SP2-0618 and SP2-0611 An user reported errors SP2-0618 and SP2-0611 when he tried to enable AUTOTRACE at his session-time. SQL> show user USER is "HR"… Read More »How to Resolve SP2-0618 and SP2-0611
Let's see how we enable an user other than the owner of Oracle product to run SQL*Plus. Windows In Windows platform, once oracle database has… Read More »Enable Non-Oracle User Run SQL*Plus
Partitioned Index To align with the partitioned table we created by SQL developer previously, we can add a partitioned index for it to improve data… Read More »SQL Developer Create Index Partition
At the first time startup of SQL developer, you may want to new a connection to start to use the tool. But sometimes, you might… Read More »tnsnames.ora in SQL Developer
EM_EXPRESS_ALL Whereas EM_EXPRESS_BASIC provides some basic privileges to monitor properties through EM, EM_EXPRESS_ALL, also an Oracle predefined role, has some more advanced privileges which enable… Read More »EM_EXPRESS_ALL, How and Why
Enterprise Manager (EM) Enterprise Manager (EM) is a graphical management tool that provides centralized capabilities of managing Oracle databases and servers. In recent releases, EM… Read More »EM_EXPRESS_BASIC, How and Why
How to create a table in Oracle step by step? To create a new table, we can choose to compose a hand-writing PL/SQL statement which… Read More »Toad Create Table Example