1.4 About Home

The Home page contains widgets that provide a general overview of the activity and status in SQL Developer Web.

  • Recently Modified Objects: Displays a timeline of the created, modified, and dropped objects in the database. You can zoom in and out using the + and icons. You can also move horizontally by dragging the cursor to the right or left.

  • Invalid Objects: Displays the invalid objects in the database.

  • Table Stats Freshness: Displays the time period since the tables were last analyzed.

  • My Worksheets: Displays the worksheets that have been created or modified. You can click the name of the worksheet to open it in the Worksheet page.

  • My Diagrams: Displays the Data Modeler diagrams that have been created or modified. You can click the name of the diagram to open it in the Data Modeler page.

You can right-click the header in Invalid Objects, Table Stats Freshness, My Worksheets, or My Diagrams to manage or sort columns:

  • Columns: Enables you to select columns to show or hide.

  • Sort: Displays a dialog box for selecting columns to sort by. For each column, you can specify ascending or descending order, and you can specify that null values be displayed first.

Right-click the body of the display table to count rows or to view records:

  • Count Rows: Displays the number of rows in the table.

  • Single Record View: Enables you to view data for a table or view, one record at a time.