Promis.e Help

To Submit a SQL Statement

  1. In the SQL Window, type the SQL statement. The statement can be typed as a continuous string with automatic word wrap or you can press <Enter> at the end of each line.

    Literal expressions used in assignments and comparisons can be of character (char), numeric (number). Character strings are single quote delimited.

  2. Click the Submit button.

    Retrieved database information is presented one row at a time. You can use the scroll bar if the data exceeds the window size.

  3. (Optional) To advance between retrieved rows, click the Next button.
    Note: The user can also enter SQL commands preceded by the pipe symbol "|" in the Promis.e key-in window.