oracle database management 12c DBMS
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
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;
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 your changes
SQL> set autocommit on;
SQL> <<do whatever>>
Specify
CASCADE CONSTRAINTS to drop all referential integrity constraints that refer to primary and unique keys in the dropped table. If you omit this clause, and such referential integrity constraints exist, then the database returns an error and does not drop the table.
drop table tablename cascade constraints;
update to change data
and alter to add attributes or columns
Comments
Post a Comment