My house mates and me are database development students, we started studying Oracle Database Express Edition. We both used same pen drive to install oracle and to transfer the tutorial sql table to C:\oraclexe\app\oracle\product\11.2.0\server\bin . When I use the command "select * from table;" im getting "no rows selected" .
With the same file and same command, the table is displayed on my housemate`s computer. Why it doesnt work on me ? The only difference is that im on XP, he is on win7.
table in this case is one of your tutorial tables.
SELECT * FROM table;
965164 wrote:What tables?
to transfer the tutorial sql table
With the same file and same command,What file and format? What command? How was the file loaded and to what database schema?
What are you trying to put instead of table? What's the real table name?
SELECT * from table;
965164 wrote:Before start command, type in show user.
What do you mean by what user runs the sql?
Before I type SET TERMOUT OFF in the sql, it looks like that :Before that, did you open the demobld.sql file in a text editor and comment out the line with set termout off? It is probably the line directly after "PROMPT Building demonstration tables. Please wait.".
SQL> start demobld.sql;
965164 wrote:Script posted is missing insert statements for emp.
CREATE TABLE DEPT (
INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK');
CREATE TABLE EMP (