3/20/2023 0 Comments Dbvisualizer tutorial![]() In DBVisualizer, a similar feature is called Bookmarks. In EXAplus, frequently used SQL Statements are stored in the Favorite tab. Select Keep Case As is in the Case drop-down.Īdditionally, see Executing Complex Statements.Go to Tool Properties > Tools > SQL Formatting.So if you open an existing LUA script, keywords are automatically transformed to uppercase and they won't work. For example:ĬREATE LUA SCRIPT MY_CAT RETURNS TABLE ASīy default, the keywords in DbVisualizer are displayed in uppercase. The start of the SQL Block is -/ and the end of the block is defined with /. In DBVisualizer, LUA scripts / UDFs should be created as an SQL block. You can also customize the behavior of the auto-completion from Tools > Tool Properties > SQL Commander > Auto Completion. To know more about the feature, see Auto Completion in DbVisualizer documentation. In DBVisualizer, if you are in the context of a schema, only the tables of that schema are shown in the auto completion. In DbVisualizer, you can directly access the table or column name without the need to fully qualify the object. In EXAplus, to use the auto completion of table/column names you need to first type the schema name. ![]() If you want to configure the shortcuts, see Changing Keyboard Shortcuts in DbVisualizer documentation. In EXAplus, the keyboard shortcuts for the statements start with CTRL+Enter. Here are some best practices if you are moving from the old EXAplus client to DbVisualizer: Keyboard Shortcuts To remove issues with -/, click Tool Properties > General > SQL Commander > Statement Delimiters and select Allow SQL Dialects.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |