Shulou(Shulou.com)05/31 Report--

How to set the separator color in the database, automatic submission, query function use, etc., many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail. People with this need can come and learn. I hope you can get something.

Tips in the database-how to set separator colors, auto-commit, query function usage, etc.

1. Adjust the separator color

When ① wrote the SQL statement, he found that the color of the delimiter was so light that it could not be seen clearly.

② can be set by selecting "window"-"options" in the menu bar.

③ select "query Analyzer-Syntax highlight-Delimiter" to set the color and font type, and you can see the color change in the preview.

two。 Set up auto-submit function

① finds "query Analyzer" in the "window" option and clicks OK by typing √ before "autosubmit" to set it successfully.

How to use ②: if autocommit is not set, the information in the table can be queried in the same window, but the data of insert cannot be queried in the new query. This is because the data has not been submitted, so we need manual commit. If autocommit is set, the writing data system will submit, and the result can be queried directly. The following example is the result when autocommit is not set.

3. SQL log function

In the "window-View-SQL Log", ① can see whether the executed SQL statement succeeded or failed, and it can also display the specific executed SQL statement, execution time and error information.

4. Line number display

It is troublesome for ① to find the correct location when an error occurs when the line number cannot be displayed in SQL query Editor.

② at this time we need to set the display line number, in the "window-options-query Analyzer-Editor" check the display line number, click "OK" to complete.

After ③ displays the line number, you can find the corresponding information clearly and accurately.

5. How to use the function

When ① uses SQL to query some things, we need to use some different types of functions. At this time, we can find the function in the DM management tool to find out the specific function usage and meaning.

After ② finds the function function, you can find it by category, and you can also use filtering, search through keywords, select the corresponding function, and the description of the usage rules of the function will appear below.

6. Check if there are invalid database objects

① focuses on indexes, triggers, stored procedures, functions, and so on. For example, look up the user_objects data dictionary to see if there are any objects with a status of invalid. Determine the cause of failure (for example, the cause of view failure may be due to the deletion of the base table that created the view, etc.) to find out the cause of reconstruction or repair.

SELECT OBJECT_NAME,OBJECT_TYPE FROM USER_OBJECTS WHERE OBJECT_TYPE='INVAID'

7. Query initialization parameter size

① in the Linux system, when the database initialization parameter information cannot be viewed using the graphical interface, you need to use SQL statement to query it, as shown below:

Select sf_get_page_size (), sf_get_extent_size (), sf_get_case_sensitive_flag ()

Sf_get_unicode_flag ()

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.