Go Back   Computer Forums > General Computing > Programming
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 03-17-2010, 11:22 PM   #1
In Runtime
 
Disenchanterx's Avatar
 
Join Date: Mar 2010
Posts: 164
Default Oracle iSQL*Plus/ Oracle 10g Express.

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.
__________________

__________________
M.C.S.E.
Minesweeper Consultant / Solitaire Expert
Disenchanterx is offline   Reply With Quote
Old 03-18-2010, 06:27 AM   #2
In Runtime
 
Join Date: Jan 2010
Posts: 320
Default Re: Oracle iSQL*Plus/ Oracle 10g Express.

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.
__________________

Luke_Uk_Baggy is offline   Reply With Quote
Old 03-18-2010, 08:34 AM   #3
In Runtime
 
Disenchanterx's Avatar
 
Join Date: Mar 2010
Posts: 164
Default Re: Oracle iSQL*Plus/ Oracle 10g Express.

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.
__________________
M.C.S.E.
Minesweeper Consultant / Solitaire Expert
Disenchanterx is offline   Reply With Quote
Old 03-18-2010, 10:54 AM   #4
In Runtime
 
Join Date: Jan 2010
Posts: 320
Default Re: Oracle iSQL*Plus/ Oracle 10g Express.

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.
Luke_Uk_Baggy is offline   Reply With Quote
Old 03-19-2010, 02:04 PM   #5
In Runtime
 
Disenchanterx's Avatar
 
Join Date: Mar 2010
Posts: 164
Default Re: Oracle iSQL*Plus/ Oracle 10g Express.

Giving up on for the weekend I will try again later
__________________
M.C.S.E.
Minesweeper Consultant / Solitaire Expert
Disenchanterx is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 10:43 PM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0