Select * from SPRIDEN
where DOCKET_IND like ‘C%’
order by OWNER;
I’ve tried to avoid using SQL because
I’m it’s such an obtuse language. But I guess I just can’t
get away from it.
As noted yesterday, I’m in a week long training on how to
access our new information system. The system is an Oracle
database and consists of hundreds of tables. To query the
database, you need to know how to use SQL, even if you are
using a front end such as Crystal Reports, which we will be
starting on today.
So, yesterday was spent going through the database tables
and doing a few simple SQL queries. Today we will try using
Crystal Reports to create queries similar to what we did
yesterday and look at some of the features that will enable us
to create the kind of reports we may need.