Toad Create Table Example
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
Toad
Toad Alter Session set NLS_DATE_FORMAT
NLS_DATE_FORMAT in Toad for Oracle Just like we said previously, NLS_DATE_FORMAT can be set at session, database or OS level. It depends on what you… Read More »Toad Alter Session set NLS_DATE_FORMAT
How to Flip Vertical into Horizontal Layout in Toad
After your Toad for Oracle installed in a new computer, you may see a strange layout in Session Browser like mine. It's a vertical layout… Read More »How to Flip Vertical into Horizontal Layout in Toad
How to Resolve Toad Error: Unable to find RAC connection information for INST_ID
Unable to find RAC connection information for INST_ID A developer tried to run a procedure with debug mode in Toad for Oracle, a database tool… Read More »How to Resolve Toad Error: Unable to find RAC connection information for INST_ID
How to Resolve Toad Error ORA-00904: "REF": invalid identifier
Tried to display "Script" (DDL) of a table in Toad for Oracle, we saw ORA-00904: "REF": invalid identifier. Typically, ORA-00904 is an unmatched column issue,… Read More »How to Resolve Toad Error ORA-00904: "REF": invalid identifier
How to Resolve ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated
JDBC ORA-12850 Some developers report ORA-12850 error in their JDBC log. ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated There… Read More »How to Resolve ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated
How Toad Import Excel File
Toad Import Excel After exporting table data to Excel files in Toad, we can do some import test. In this post, I'll show you how… Read More »How Toad Import Excel File
How Toad Export to Excel
Toad Export Excel Exporting table data to an Excel file in Toad for Oracle is pretty easy. Here are the steps: 1. Select Export Function… Read More »How Toad Export to Excel