SYS@orcl>startupORACLE instance started. Total System Global Area 849530880 bytesFixed Size 1339824 bytesVariable Size 557846096 bytesDatabase Buffers 285212672 bytesRedo Buffers 5132288 bytesDatabase mounted.Database opened.SYS@orcl>conn hr/jrERROR:ORA-01017: invalid username/password; logon denied Warning: You are no longer connected to ORACLE.@>conn hr/hrConnected.HR@orcl>!clear HR@orcl>selec..
HR@orcl>select salary from employees where rownum select salary from employees where rownum=5 order by desc;select last_name, salary from employees where rownum >=5 order by desc *ERROR at line 1:ORA-00936: missing expression HR@orcl>edWrote file afiedt.buf 1* select rownum, last_name, salary from employees where rownum /select rownum, last_name, salary from employees where rownum edWrote file a..
HR@orcl>desc user_constraints Name Null? Type ----------------------------------------- -------- ---------------------------- OWNER VARCHAR2(30) CONSTRAINT_NAME NOT NULL VARCHAR2(30) CONSTRAINT_TYPE VARCHAR2(1) TABLE_NAME NOT NULL VARCHAR2(30) SEARCH_CONDITION LONG R_OWNER VARCHAR2(30) R_CONSTRAINT_NAME VARCHAR2(30) DELETE_RULE VARCHAR2(9) STATUS VARCHAR2(8) DEFERRABLE VARCHAR2(14) DEFERRED VARC..
[oracle@localhost ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 9 11:57:39 2018 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SYS@orcl>startupORACLE instance started. Total System Global Area 849530880 bytesFixed Size 1339824 bytesVariable Size 557846096 bytesDatabase Buffers 285212672 bytesRedo Buffers 5132288 bytesDatabase mo..