Help Center> Data Warehouse Service (DWS)> Tool Guide (Paris Region)> Data Studio - Integrated Database Development Tool> Working with Functions/Procedures> Viewing Object Properties in the PL/SQL Viewer

Updated on 2022-07-29 GMT+08:00

View PDF

Viewing Object Properties in the PL/SQL Viewer

Data Studio allows you to view table properties, procedures/functions and SQL functions.

Follow the steps below to view table properties:

Press Ctrl and point to the table name.
Click the highlighted table name.

The properties of the selected table is displayed.

The table properties are read-only.

Follow the steps below to view functions/procedures or SQL functions:

Press Ctrl and point to the procedure/function name or SQL function name.
Click the highlighted function/procedure name or SQL function name. The function/procedure or SQL function is displayed in a new PL/SQL Viewer tab based on your selection.

Follow the steps below to view object DDL:

Press Ctrl and point to the name of an object DDL to be viewed.
Click the highlighted Object DDL name. A new tab page for viewing the object DDL is displayed based on your selection.

Parent topic: Working with Functions/Procedures

Previous topic: Exporting the DDL of a Function or Procedure

Next topic: Dropping a Function/Procedure

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.