ポンコツプログラマーのリスキリング記、第5回です！ 今回のテーマは、Oracleを扱うために欠かせない2つのツール―― SQL*PlusとSQL Developer です。 SQLそのものはどのツールでも同じですが、操作感や用途がまったく違うので、まずは特徴を理解して、自分に ...

Read this chapter while sitting at your computer and try out the examples shown. Before beginning, make sure you have access to the sample tables described. To begin using SQL*Plus, you must first ...

Oracle9i offers some great tools to make it easy to view the execution plan and trace information for a SQL statement. Prior to Oracle8i, you had to create a plan table and execute special syntax to ...