Edit¶

The Edit menu contains clipboard, Format, Find and Replace, and Search Objects operations to use in the PL/SQL Viewer and SQL Terminal tab. Press Alt+E to open the Edit menu.

Function	Shortcut Key	Description
Cut	Ctrl+X	Cuts the selected text
Copy	Ctrl+C	Copies the selected text or qualified object name
Paste	Ctrl+V	Pastes the selected text or qualified object name
Format	Ctrl+Shift+F	Formats all SQL statements and functions/procedures.
Select All	Ctrl+A	Selects all the text in SQL Terminal
Find and Replace	Ctrl+F	Finds and replaces text in SQL Terminal
Search Objects	Ctrl+Shift+S	Searches for objects within a connected database.
Undo	Ctrl+Z	Undoes the previous operation
Redo	Ctrl+Y	Redoes the previous operation
UPPERCASE	Ctrl+Shift+U	Changes the case of the selected text to uppercase
lowercase	Ctrl+Shift+L	Changes the case of the selected text to lowercase
Go To Line	Ctrl+G	Skips to a specific line in the Terminal or PL/SQL Viewer
Comment/Uncomment Lines	Ctrl+/	Comments/Uncomments each selected line
Comment/Uncomment Block	Ctrl+Shift+/	Comments/Uncomments all selected lines or a selected block

Copy¶

Copy can also be used to copy objects from Object Browser.

The format of copied object name is:

**Table 1**¶
Object Type	Copied Format
Functions/Procedures	schema.object name(parameter name parameter type,...)
Databases	object name
Schemas	object name
Columns	object name
Constraints	object name
Partition names	object name
All other object types	schema.object name

Search Objects¶

The Searching Objects option allows you to search for object(s) from the Object Browser based on the search criteria entered. The search operation can be executed either from Edit > Search Objects menu or by clicking from the Object Browser toolbar. The result of search displays tree structure similar to Object Browser. Right-click operations except for Refresh can be performed on the search result objects. Modified objects as a result of drop, set schema, rename, and so on can be viewed only from the main Object Browser after refresh. Right-click options on group names (tables, schema, views and so on) are not allowed on search result objects. Only objects to which you have access can be searched. Objects that you do not have access do not appear in the Search Scope.

Note

Newly added objects can be viewed in the Search window by clicking the refresh option at the end of the object type.

Supported Search Options:

Search Options	Search Behavior
Contains	A search text which contains the searched characters will be displayed.
Starts With	A search text which starts with the searched character will be displayed.
Exact Word	A search text which matches exactly with searched characters will be displayed.
Regular Expression	A search text with regular expression searches for similar pattern in Object Browser that fulfills the search condition. Select Regular Expression from Search Criteria drop-down to perform this search. For more information refer to POSIX Regular Expressions rules. Example: ^a, this displays all objects that start with the letter a. ^[^A-Za-z]+$, this displays all objects that do not have alphabets in them. ^[^0-9]+$, this displays all objects that do not have numbers in them. ^[a-t][^r-z]+$, this displays all objects whose name starts between a and t and excludes those that have characters between r and z in them. ^e.a$, this displays all objects that start with the letter e and end with letter a. ^[a-z]+$ and select Match Case, this displays all objects that contain only alphabets in lowercase. ^[A-Z]+$ and select Match Case, this displays all objects that contain only alphabets in uppercase. ^[A-Za-z]+$ and select Match Case, this displays all objects that contain only alphabets in lowercase and uppercase. ^[A-Za-z0-9]+$ and select Match Case, this displays all objects that contain only alphabets in lowercase, uppercase and numbers. ^"."$, this displays all objects that are within in quotes.

Underscore and % search:

Search Value	Search Behavior
_	A search text with _ (underscore) in it considers the underscore as a wildcard of single character. This does not apply to regular expression, starts with and exact word search. Example: _ed, this displays all objects that starts with any single character followed by "ed". D_t_e, this displays all objects that have character "d", followed by any single character, followed by character "t", followed by any single character, and followed by character "e".
%	A search text with % (percentage) in it considers the percentage as a wildcard of multiple characters. This does not apply to regular expression, starts with and exact word search. Example: %ed, this displays all objects that have "ed" pattern in it. D%t%e, this displays all objects that have character "d", followed by any number of characters, followed by character "t", followed by any number of characters, and followed by character "e".

Search Value

Search Behavior

A search text with _ (underscore) in it considers the underscore as a wildcard of single character. This does not apply to regular expression, starts with and exact word search.

Example:

_ed, this displays all objects that starts with any single character followed by "ed".
D_t_e, this displays all objects that have character "d", followed by any single character, followed by character "t", followed by any single character, and followed by character "e".

A search text with % (percentage) in it considers the percentage as a wildcard of multiple characters. This does not apply to regular expression, starts with and exact word search.

Example:

%ed, this displays all objects that have "ed" pattern in it.
D%t%e, this displays all objects that have character "d", followed by any number of characters, followed by character "t", followed by any number of characters, and followed by character "e".

Match case runs the search to match with the search text case.

last updated: 2024-11-13 15:46 UTC - commit: bdcb01d62e4f1de672b662d88ef6cb8eb3a27a29