Oracle iSQL*Plus/ Oracle 10g Express.

Disenchanterx

In Runtime
Messages
164
Anyone familiar with the differences between iSQL*Plus and Oracle 10g Express?

The statement terminators do not seem to work in Oracle 10g. I know that they work in iSQL*Plus The book I am using teaches iSQL*Plus and was made before 10g existed. I didn't think this was going to be a problem because I thought SQL statements in Oracle did not change.
 
Never used Oracle 10g Express, used 11g though, through university.

Never opted for 10g, although its free, I dont think theres a whole lot of info on it and know Oracle dont provide much support for it.

Are you using the newest release version? (just checked and its Release 2)

To be honest it should be ok though.

Mind giving me an example of what is not working, and what is?

Or is everything not working - what kind of errors?


Not promising anything, just trying to get a wider picture.
 
The main problem i'm having is the ";" does not terminate.

I could type in this statement and it will work.
insert into insure(PATIENT$id,INSURANCE$company)values
('11111','Prudential')

I use this statement it does not.
insert into insure(PATIENT$id,INSURANCE$company)values
('11111','Prudential');
insert into insure(PATIENT$id,INSURANCE$company)values
('22222','Prudential');

The error will be "Invalid Character"

I have tried to terminate with the colon, the foward slash, and no terminator at all. I know the answer to this is simple I just do not know what it is.
 
Hmmm

You can actually input a patient ID cant you??

(I.E. The patient ID isnt autoincremented, or the constraints on the field will allow a 'xxxxx' figure in)

^^ Just checking.

Im also fairly sure the forward slash wont end your command - forward slashes repeat the last statement, so make sure you havent left any of those in as it could cause an error.

This doesnt solve your problem though. Im guessing it doesnt run when you hit the 'Execute' button either.

You arent doing anything in MS DOS mode (or batch mode) are you?? sometimes character conversions can go wrong in there.. Have a look at the NLS_LANG character set value if so.

^^Thats probly a bit of a long shot. I like you think its something simpler.
 
Back
Top Bottom