Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
12 Cards in this Set
- Front
- Back
|
Set pause on
|
display one page and hit enter to display next page of result;
|
|
|
To start a session as sysdba:
|
sqlplus sys@tnsname as sysdba;
|
|
|
To list all tables in current schema
|
SELECT table_name FROM user_tables
|
|
|
all tables current user has access to
|
SELECT table_name FROM all_tables
|
|
|
To list all schemas
|
SELECT username FROM all_users ORDER BY username;
|
|
|
To turn pause on
|
SET PAUSE ON;
|
|
|
To list top n rows of a table in order
|
SELECT * FROM (SELECT * FROM t ORDER BY c) WHERE ROWNUM <= n;
|
|
|
Show current database
|
SELECT * FROM global_name;
|
|
|
Use database
|
CONNECT schema/password@tnsname;
|
|
|
Show who I am
|
SHOW USER;
|
|
|
Set display rows
|
SET PAGESIZE 66;
|
|
|
Read field constraints
|
SELECT constraint_name,search_condition FROM user_constraints WHERE table_name='tablename';
|
