DataGrid (Grid view) Question: Download Questions PDF
How can I see TIMESTAMP and INTERVAL data?
Answer:
TOAD 7.5 and up can show TIMESTAMP and INTERVAL data in its data grids if you are using a 9.0.1 or higher Oracle client. TOAD 9.0.1 supports TIMESTAMP and INTERVAL data in its "run as script" function. TOAD versions 7.4 and previous do not support TIMESTAMP and INTERVAL data due to a limitation in their data layer.
To see timestamp/intervals in the "datatype" drop down in the Create/Alter Table window, and in the "Add Column" window, go to options → datatypes, and make sure "Include Timestamp/Interval Types" is checked.
To see timestamp/intervals in the "datatype" drop down in the Create/Alter Table window, and in the "Add Column" window, go to options → datatypes, and make sure "Include Timestamp/Interval Types" is checked.
Download DataGrid (Grid view) Interview Questions And Answers
PDF
Previous Question | Next Question |
How can I see nested object data? | Why can not I set a style in my XLS SaveAs exports of DataGrid data? |