New answers tagged sqlplus
I found out the solution: If the machine has a hostname defined in /etc/sysconfig/network, this name also needs to be defined in /etc/hosts, period. This is what I had: host2> cat /etc/sysconfig/network NETWORKING=yes HOSTNAME=host2 host2> cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 ...
At first make sure the database host is available ping host1. Then you have to install a client and configure service name. To install the oracle client correctly and be able to use it you have to: Choose the "Administrator" type of the oracle client installation, not instant client, it provides you database administrator tools. After your client ...
In Oracle BEGIN starts a PL/SQL block. In other words, after BEGIN you ought to provide a text of a program that is written in a procedural language that is somewhat different than SQL (although it bears some similarities). Your sqlplus had read everything but it was not yet parsing or executing anything, it was waiting for an END and a line containing only ...
Oracle's transactions are implicit in sqlplus you're already in one and don't have to start it. This means you can just do select ... update .. rollback ... select... if you do an exit without doing exit rollback it will commit on exit. begin is not necessary here.
Top 50 recent answers are included