oracle数据库基础命令

网站编辑2023-05-12 11:18:26416

以下是一些常用的SQL查询命令:

1. SELECT * FROM tables 2. SELECT * FROM customers ORDER BY product_name INDEX AUTO_INCREMENT 3. SELECT * FROM table_name, product_name ORDER BY product_name ASC; 4. SELECT * FROM table_name, production_name AND product_name DESC 5. SELECT * FROM table_name; AND production_name DESC ASC; 6. SELECT * FROM table_name AND production_name ORDER BY product_name ASC; 7. SELECT * FROM table_name AND product_name ORDER BY product_name DESC; 8. SELECT * FROM table_name AND product_name DESC ASC; 9. SELECT * FROM table_name ASC AND product_name ORDER BY product_name DESC; 10. SELECT * FROM table_name; ORDER BY product_name ASC;

以上命令都可以用来查询和修改表的数据。