Viewing Table Data

Follow the steps to view table data:

  1. Right-click the selected table and select View Table Data.

    The View Table Data tab is displayed where you can view the table data information.

    Toolbar menu in the View Table Data window:

    Toolbar Name

    Toolbar Icon

    Description

    Copy

    image4

    Click the icon to copy selected content from View Table Data window to clipboard. Shortcut key - Ctrl+C.

    Advanced Copy

    image5

    Click the icon to copy content from result window to the clipboard. Results can be copied to include the row number and/or column header. Refer to Query Results to set this preference. The shortcut key is Ctrl+Shift+C.

    Show/Hide Search Bar

    image6

    Click the icon to display/hide the search text field. This is a toggle button.

    Encoding

    -

    Refer to Execute SQL Queries for information on encoding selection.

    Icons in Search field:

    Icon Name

    Icon

    Description

    Search

    image9

    Click the icon to search the table data displayed based on the criteria defined. The text is case-insensitive.

    Clear Search Text

    image10

    Click the icon to clear the search texts entered in the search field.

    Refer to Execute SQL Queries for column reordering and sorting options.

    • Query Submit Time: Provides the query submitted time.

    • Number of rows fetched with execution time is displayed. The default number of rows is displayed. If there are additional rows to be fetched, then it will be denoted with the word "more". You can scroll to the bottom of the table to fetch and display all rows.

      Important

      • When you view table data, Data Studio automatically adjusts the column widths for an optimal table view. Users can resize the columns as needed. If the text content of a cell exceeds the total available display area, then resizing the cell column may cause DS to become unresponsive.

      • When the data in a table cell is more than 1000 characters, it will be trimmed to 1000 characters with "..." at the end.

        • If the user copies the data from a cell in a table or the Result tab and pastes it on any editor (such as SQL terminal/PLSQL source editor, notepad or any other external editor application), the entire data is pasted.

        • If the user copies the data from a cell in a table or the Result tab and pastes it on an editable cell (same or different), the cell shows only the first 1000 characters with "..." in the end.

        • When the table/Result tab data is exported, the exported file contains the whole data.

    Note

    • Individual table data window is displayed for each table.

    • If the data of the table that is already opened is modified, then refresh and open the table data again to view the updated information on the same opened window.

    • While the data is loading a message displays at the bottom stating "fetching".

    • If the text of a column contains spaces, word wrapping is applied to fit the column width. Word wrapping is not applied to columns without spaces.

    • Select part of cell content and press Ctrl+C or click image11 to copy selected text from a cell.

    • The size of the column is determined by the maximum content length column.

    • You can save preference to define:

      • Number of records to be fetched

      • Column width

      • Copy option from result set

        For details, see Query Results.