How Do I Translate Sybase to Oracle

Submitted by jtreadwell on Mon, 08/04/2008 - 6:22pm

A running list of differences between Sybase and Oracle, specifically how PowerSchool handles Sybase or Oracle.

0
Your rating: None

Comments

setting alias to blank

by ndoughty - 08/15/2008 - 12:18pm

Hi Jason,

MAX(CASE WHEN f.Name='allergies' THEN to_char(cvc.Value) ELSE '' END) AS allergies,

In the above statement, do you think the "ELSE '' END" work or do I need the word null "ELSE null END"?

THANKS for ALL you HELP!

Naomi Doughty
MSAD#9

re: setting alias to blank

by jtreadwell - 08/15/2008 - 2:24pm

I'd use the word null. Also, Oracle doesn't like AS so remove that.

It appears you are looking up a custom field. May I also suggest...

(SELECT string_value FROM pvsis_custom_students WHERE studentid = [whatever you called students].id AND field_name = 'allergies') allergies

This method will allow you to remove your left outer join and removes the need to do the grouping just to get the one field to look right. Just a thought.

Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org

Thanks so much for all the ORACLE info!

by ndoughty - 08/05/2008 - 12:46pm

Naomi Doughty
MSAD#9

Syndicate content Syndicate content