Compute
Elastic Cloud Server
Huawei Cloud Flexus
Bare Metal Server
Auto Scaling
Image Management Service
Dedicated Host
FunctionGraph
Cloud Phone Host
Huawei Cloud EulerOS
Networking
Virtual Private Cloud
Elastic IP
Elastic Load Balance
NAT Gateway
Direct Connect
Virtual Private Network
VPC Endpoint
Cloud Connect
Enterprise Router
Enterprise Switch
Global Accelerator
Management & Governance
Cloud Eye
Identity and Access Management
Cloud Trace Service
Resource Formation Service
Tag Management Service
Log Tank Service
Config
OneAccess
Resource Access Manager
Simple Message Notification
Application Performance Management
Application Operations Management
Organizations
Optimization Advisor
IAM Identity Center
Cloud Operations Center
Resource Governance Center
Migration
Server Migration Service
Object Storage Migration Service
Cloud Data Migration
Migration Center
Cloud Ecosystem
KooGallery
Partner Center
User Support
My Account
Billing Center
Cost Center
Resource Center
Enterprise Management
Service Tickets
HUAWEI CLOUD (International) FAQs
ICP Filing
Support Plans
My Credentials
Customer Operation Capabilities
Partner Support Plans
Professional Services
Analytics
MapReduce Service
Data Lake Insight
CloudTable Service
Cloud Search Service
Data Lake Visualization
Data Ingestion Service
GaussDB(DWS)
DataArts Studio
Data Lake Factory
DataArts Lake Formation
IoT
IoT Device Access
Others
Product Pricing Details
System Permissions
Console Quick Start
Common FAQs
Instructions for Associating with a HUAWEI CLOUD Partner
Message Center
Security & Compliance
Security Technologies and Applications
Web Application Firewall
Host Security Service
Cloud Firewall
SecMaster
Anti-DDoS Service
Data Encryption Workshop
Database Security Service
Cloud Bastion Host
Data Security Center
Cloud Certificate Manager
Edge Security
Managed Threat Detection
Blockchain
Blockchain Service
Web3 Node Engine Service
Media Services
Media Processing Center
Video On Demand
Live
SparkRTC
MetaStudio
Storage
Object Storage Service
Elastic Volume Service
Cloud Backup and Recovery
Storage Disaster Recovery Service
Scalable File Service Turbo
Scalable File Service
Volume Backup Service
Cloud Server Backup Service
Data Express Service
Dedicated Distributed Storage Service
Containers
Cloud Container Engine
SoftWare Repository for Container
Application Service Mesh
Ubiquitous Cloud Native Service
Cloud Container Instance
Databases
Relational Database Service
Document Database Service
Data Admin Service
Data Replication Service
GeminiDB
GaussDB
Distributed Database Middleware
Database and Application Migration UGO
TaurusDB
Middleware
Distributed Cache Service
API Gateway
Distributed Message Service for Kafka
Distributed Message Service for RabbitMQ
Distributed Message Service for RocketMQ
Cloud Service Engine
Multi-Site High Availability Service
EventGrid
Dedicated Cloud
Dedicated Computing Cluster
Business Applications
Workspace
ROMA Connect
Message & SMS
Domain Name Service
Edge Data Center Management
Meeting
AI
Face Recognition Service
Graph Engine Service
Content Moderation
Image Recognition
Optical Character Recognition
ModelArts
ImageSearch
Conversational Bot Service
Speech Interaction Service
Huawei HiLens
Video Intelligent Analysis Service
Developer Tools
SDK Developer Guide
API Request Signing Guide
Terraform
Koo Command Line Interface
Content Delivery & Edge Computing
Content Delivery Network
Intelligent EdgeFabric
CloudPond
Intelligent EdgeCloud
Solutions
SAP Cloud
High Performance Computing
Developer Services
ServiceStage
CodeArts
CodeArts PerfTest
CodeArts Req
CodeArts Pipeline
CodeArts Build
CodeArts Deploy
CodeArts Artifact
CodeArts TestPlan
CodeArts Check
CodeArts Repo
Cloud Application Engine
MacroVerse aPaaS
KooMessage
KooPhone
KooDrive
On this page

Show all

Edit

Updated on 2022-08-16 GMT+08:00

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 object name.

Paste

Ctrl+V

Pastes the selected text or 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 for 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 selected text to uppercase.

Lowercase

Ctrl+Shift+L

Changes the selected text to lowercase.

Go to row

Ctrl+G

Redirects to a specific row in SQL Terminal or PL/SQL Viewer.

Comment/Uncomment lines

Ctrl+/

Comments or uncomments all selected rows.

Comment/Uncomment blocks

Ctrl+Shift+/

Comments or uncomments all selected rows or blocks.

Search Objects

You can choose Search Objects to search for objects from Object Browser based on the search criteria. Specifically, you can choose Edit > Search Objects or click in the Object Browser toolbar. The search result is displayed in a tree structure, similar to that in Object Browser. Operations in the right-click menu, except for Refresh, can be performed on objects in the search result. After the page is refreshed, objects that have been deleted or renamed or whose schemas have been set can be viewed only from the primary object browser. Right-click options on group names, such as tables, schemas, and views, cannot be performed on objects in the search result. Only objects that you have the permission to access will be displayed in Search Scope.

NOTE:

You can view newly added objects in the Search window by clicking Refresh at the end of the object type.

Supported search options

Search Option

Search Behavior

Contains

Text that contains the searched content will be displayed.

Starts With

Text that starts with the searched content will be displayed.

Exact Word

Text that matches exactly with the searched content will be displayed.

Regular Expression

When regular expression text is used, text that meets the search criteria is searched for in Object Browser. Select Regular Expression from the Search Criteria drop-down list. For more information, see POSIX Regular Expressions rules.

Examples are as follows:

  • Enter ^a to search for all objects that start with a.
  • Enter ^[^A-Za-z]+$ to search for objects that do not contain letters.
  • Enter ^[^0-9]+$ to search for objects that do not contain digits.
  • Enter ^[a-t][^r-z]+$ to search for objects that start with a letter from a to t and do not contain letters from r to z.
  • Enter ^e.*a$ to search for objects that start with e and end with a.
  • Enter ^[a-z]+$ and select Match Case to search for objects that contain only lowercase letters.
  • Enter ^[A-Z]+$ and select Match Case to search for objects that contain only uppercase letters.
  • Enter ^[A-Za-z]+$ and select Match Case to search for objects that contain uppercase and lowercase letters.
  • Enter ^[A-Za-z0-9]+$ and select Match Case to search for objects that contain uppercase and lowercase letters and digits.
  • Enter ^".*"$ to search for objects that are put in double quotation marks (").

Search with underscores (_) or percentage (%)

Search Value

Search Behavior

_

The underscore (_) in text is considered the wildcard of a single character. Search criteria such as Regular Expression, Starts With, and Exact Word are not applicable to text that contains underscores (_).

Examples are as follows:

  • Enter _ed to search for objects that start with a single character followed by ed.
  • Enter D_t_e to search for objects that contain d, followed by a single character, t, single character, and e.

%

The percentage (%) in text is considered the wildcard of multiple characters. Search criteria such as Regular Expression, Starts With, and Exact Word are not applicable to text that contains percentage (%).

Examples are as follows:

  • Enter _%ed to search for objects that contain ed.
  • Enter D%t%e to search for objects that contain d, followed by any number of characters, t, any number of characters, and e.

If you select Match Case and perform the search, the system searches for the content that matches the case of the search text.

We use cookies to improve our site and your experience. By continuing to browse our site you accept our cookie policy. Find out more

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback