Command-line window

This topic introduces how to create a command-line window.

Background information

OceanBase Developer Center (ODC) integrates the CLI tool OceanBase Client (OBClient) in the form of a command-line window. OBClient is the recommended CLI client for OceanBase Database. ODC allows you to use OBClient without a need to download or install it. In the command-line window, you can directly execute SQL or PL statements and view the results in real time. You can also run files uploaded to the server by using the SOURCE command.

Create a command-line window

Assume that you want to insert data to the employee table in the odc_test database in the command-line window.

1. In the SQL development window, click the data source mysql410.

2. In the command-line window, edit the SQL statement to insert data into the employee table.

   INSERT INTO `odc_test`.`employee`(`emp_no`,`birthday`,`name`) VALUES (1001,'2023-07-16','xiaohong');
   

3. Edit the SQL statement to query the data inserted into the employee table.

   SELECT `emp_no`, `birthday`, `name` FROM `odc_test`.`employee`;
   

References

• Edit and execute SQL statements

• Compile and debug PL objects

• Edit and export results

• Analyze SQL statements

• Generate mock data

• Manage database changes

• Manage partitions

• Synchronize shadow tables

• Change lock-free structures