The SQL cheat sheet is designed to provide a quick reference for the most common SQL statements you use. It is one-page A4 printable document in both PDF and JPEG format. You can print it out and stick it to your desk.
To list all users and profile, run the following command: SQL SELECT USERNAME, ACCOUNTSTATUS, PROFILE FROM DBAUSERS; To list all roles, run the following command: SQL SELECT. FROM DBAROLES; To create a user profile, run the following command: SQL CREATE PROFILE MYPROFILE LIMIT; To list all user profiles, run the following command. CREATE TABLE tablename ( column1 datatype, column2 datatype, column3 datatype); It is used to. Connecting to an Oracle Database Using SQL.Plus; Show the Connected User; Show All Schema’s; Show All Tables/Views in a Particular Schema; Describe a Table; Show DDL of a Table; Show the Privileges of Your User; Get More Decent Output From a Command; Get and Alter Database Timezones; Select DATE Rows in the Last Hour; Working Around Oracle Not Having a LIMIT.
SQL Statements Cheat Sheet
SQL statements cheat sheet gives you the most common SQL queries to help you get familiar with SQL quickly. You can find the most basic SQL statements in the cheat sheet. In addition, you can find the SQL statements for creating database objects such as tables, views and indexes.
Download
We offer the SQL Cheat Sheets in PDF, JPEG and ZIP format:
Link to SQL Cheat Sheet
If you want to link to these SQL Cheat Sheets, please copy the link below and paste it to your web page instead of linking directly to the files. Thanks!
Oracle Sql Query Cheat Sheet
- Was this tutorial helpful ?