Re: Views and Routines

[Jay Alverson]

1. Views generally are snapshots of existing tables and do maybe small amounts of processing. Routines are Stored Procedures or Functions or other pieces of code that generally only work with the data, although you can do almost anything with them. Views mostly show data in certain perspectives, Routines manipulate the data in some (often) extravagant way.

2. Sure.

3. Sure. Consult the documentation for exactly what's kosher inside a given Routine.

4. Just preference. There's also privileges and separate ones for Routines vs Views, so it may be preferential to give someone the ability to use a View versus giving them the ability to use Routines -- which potentially could screw-up data.

5. Find out the version and consult the documentation.

6. Ask your DBA. Potentially every database environment can be different in a variety of ways.

>

Thanks, Jay