Oracle

投稿者incognitプレイ回数00
難易度(4.2) 300秒 英語 英字タグoracle データベース
ORACLEステートメントを完璧に入力できるようになろう!
ORACLEデータベースユーザ用
順位 名前 スコア 称号 打鍵/秒 正誤率 時間(秒) 打鍵数 ミス 問題 日付
1 ニック 3653 ぼちぼち 3.7 97.3% 300.0 1127 31 34 2020/12/25

問題文

ふりがな非表示 ふりがな表示

(lsnrctl start)

lsnrctl start

リスナー開始

(lsnrctl status)

lsnrctl status

リスナーの状態確認

(lsnrctl stop)

lsnrctl stop

リスナー停止

(lsnrctl reload)

lsnrctl reload

リスナーをリロードする

(sqlplus / as sysdba)

sqlplus / as sysdba

システムユーザーでデータベースへログイン

(sqlplus hr/hr@//localhost:1521/orclpdb)

sqlplus hr/hr@//localhost:1521/orclpdb

HRユーザーでデータベースにログイン

(sqlplus hr/hr@orclpdb)

sqlplus hr/hr@orclpdb

HRユーザーでデータベースにログイン

(spool c:\mydata.html@c:\myscript.sql)

spool c:\mydata.html@c:\myscript.sql

sqlファイルを実行

(select sysdate from dual;)

select sysdate from dual;

(select * from all_tables;)

select * from all_tables;

(select * from all_users;)

select * from all_users;

(select * from countries;)

select * from countries;

(select * from depertments;)

select * from depertments;

(select * from employees;)

select * from employees;

(select employee_id,first_name,last_name from employees;)

select employee_id,first_name,last_name from employees;

(select * from locations;)

select * from locations;

(select * from regions where rownum < 5 order by user_id like 'all%' and table_type = 'VIEW';)

select * from regions where rownum < 5 order by user_id like 'all%' and table_type = 'VIEW';

(select * from all_tables where owner sys;)

select * from all_tables where owner sys;

(select /*csv*/* from all_users;)

select /*csv*/* from all_users;

/*ここにはコメントとして扱われるため実行されない*/

(select /*insert*/* from all_users;)

select /*insert*/* from all_users;

/*ここにはコメントとして扱われるため実行されない*/

など

(select /*html*/* from all_users;)

select /*html*/* from all_users;

/*ここにはコメントとして扱われるため実行されない*/

(select * from [(table)] where [(conditions)];)

select * from [(table)] where [(conditions)];

(alter session set container = orclpdb)

alter session set container = orclpdb

(show con_name)

show con_name

接続コンテナを確認

(cl scr)

cl scr

スクリーンをクリアする

(column name format a20;)

column name format a20;

列幅を20バイトにする

(select name,con_id from v$pdbs;)

select name,con_id from v$pdbs;

(select name as "Service Name" from v$active_services where con_id = 3;)

select name as "Service Name" from v$active_services where con_id = 3;

(alter session set container = orclpdb)

alter session set container = orclpdb

セッションをORCLPDへ変更する

(select name,open_mode from v$pdbs;)

select name,open_mode from v$pdbs;

(alter pluggable database open;)

alter pluggable database open;

(select name,open_mode from v$pdbs;)

select name,open_mode from v$pdbs;

(alter user HR identified by hr account unlock;)

alter user HR identified by hr account unlock;

(create view EmpVu50 as select Employee_id,First_Name || ' ' || Last_Name as EmpName,Email,Salary,)

create view EmpVu50 as select Employee_id,First_Name || ' ' || Last_Name as EmpName,Email,Salary,

ビュー作成

(Department_id from Employees where Department_id = 50;)

Department_id from Employees where Department_id = 50;

(select text from user_views;)

select text from user_views;

(delete from EmpVu50 where Employee_id = 185;)

delete from EmpVu50 where Employee_id = 185;

(update EmpVu50 set salary = 2800 where Employee_id = 199;)

update EmpVu50 set salary = 2800 where Employee_id = 199;

(alter table employees add constraint Emp_Dept_Ref Foreign Key(DeptId) references Departments(DeptId) )

alter table employees add constraint Emp_Dept_Ref Foreign Key(DeptId) references Departments(DeptId)

(on delete cascade;)

on delete cascade;

(on delete set null;)

on delete set null;

(alter table employees add constraint Employees_Email_un unique(EmailID);)

alter table employees add constraint Employees_Email_un unique(EmailID);

(select constraint_name,constraint_type,table_name,status from user_constraints;)

select constraint_name,constraint_type,table_name,status from user_constraints;

(select to_char(sysdate,'HH:MI:SS AM') from dual;)

select to_char(sysdate,'HH:MI:SS AM') from dual;

(select to_char(sysdate,'HH24:MI:SS AM') from dual;)

select to_char(sysdate,'HH24:MI:SS AM') from dual;

システム日付を指定フォーマットで表示

(select to_number(to_char(sysdate,'dd')) + 20 from dual;)

select to_number(to_char(sysdate,'dd')) + 20 from dual;

システム日付の日にちに20を追加

(select rpad(substr(phone_number,1,3),7,'*') from employees;)

select rpad(substr(phone_number,1,3),7,'*') from employees;

(select tablespace_name,contents from dba_tablespaces;)

select tablespace_name,contents from dba_tablespaces;

(select emp_name,dept_name from dept right outer join emp on (emp.emp_id = dept.emp_id);)

select emp_name,dept_name from dept right outer join emp on (emp.emp_id = dept.emp_id);

on clause

(select emp_name,dept_name from dept right outer join emp using(emp_id);)

select emp_name,dept_name from dept right outer join emp using(emp_id);

using clause

問題文を全て表示 一部のみ表示 誤字・脱字等の報告

◆コメントを投稿

※他者を中傷したり、公序良俗に反するコメント、宣伝行為はしないでください。

※このゲームにコメントするにはログインが必要です。