Posts

Showing posts with the label oracle database 12c rc2

oracle database management 12c DBMS

Image
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html ORACLE SQL DEVELOPER status:Failure -Test failed:IO Error:The Network Adapter could not establish the connection open command prompt in admin mode then lsnrctl status lsnrctl start Global database name is SID and  host and port can be find from C:\app\admin\product\12.2.0\dbhome_1\network\admin\sample set ORACLE_SID=orcl sqlplus /nolog username :sys as sysdba or system  password you have entered during installation of oracle How to view properly in sql plus open sql plus and type set line 350; you can increase the value from 350 to as per your requirement. To view a table desc tablename; To view data inside a table select * from tablename; How to Delete a table drop table tablename; SQL Plus- no rows selected error;though the data has been inserted without any error solution you can tell SQL*Plus to autocommit you...