Oracle version 8.1.7
Ok I am very new to this and am currently following O'Reilly's guide to 'Mastering Oracle SQL' which is actually for oracle9... (not my fault, I didnt buy the thing!)
anyway, here is where I am..
Code:CHRIS:CHRIS>> select * from tblfirst; NAME AGE ------------------------------ ---------- Chris 26 Simon 62Is the use of _ (which can match any single character) not available in my version of oracle, or have I got something wrong here?Code:CHRIS:CHRIS>> select * from tblfirst where name like '_hris'; no rows selected
Cheers![]()


LinkBack URL
About LinkBacks
Reply With Quote

