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		Click the icon to copy selected content from View Table Data window to clipboard. The shortcut key is Ctrl+C.
   Advanced Copy		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		Click the icon to display/hide the search text field. This is a toggle button.
   Encoding	-	Refer to Executing SQL Queries for information on encoding selection.

   Icons in Search field:

   Icon Name	Toolbar Icon	Description
   Search		Click the icon to search the table data displayed based on the criteria defined. The text is case-insensitive.
   Clear Search Text		Click the icon to clear the search texts entered in the search field.

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

   • Query Submit Time: Provides the query submitted time.
   • The number of rows obtained and the execution time are displayed, as well as the default number of rows. 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 obtain and display all rows.
     

     • 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.

     • A maximum of 1000 characters can be displayed in a cell of the table. The excess characters are displayed as ellipsis (...).
       • 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.
   

   • 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 space.
   • To copy part of a cell, select the desired part and press Ctrl+C or click .
   • The column size depends on the column with the longest text.
   • You can save preference to define:
     • Number of records to be obtained
     • Column width
     • Copy option from result set

       For details, see Query Results.