Find out how to use the Library catalogue, LibrarySearch, for finding books and eBooks available from Unitec Library.
LibrarySearch is used to find print books, eBooks and other materials you will need for your studies and research.
Click on the ‘LibrarySearch’ button on the Unitec Library homepage. Start your searching by entering appropriate keywords.
Filter your results by choosing from the options listed under the ‘Refine My Results’ menu on the left-hand side of the page.
To find out if the resources are available, click the ‘Find in Library’ button. This will also tell you the shelf location and number for print books.
To access eBooks, click ‘View Online’ and click the link.
The ‘Article-Express’ tab in the main menu allows you to search a range of journals. For more comprehensive information, you can search individual library databases.
Click the ‘Course Reading’ tab to search for course materials by tutor name or course code. Past exam papers are available under the ‘Exams’ tab.
Login using your username and password for the following features:
To request a print book, click ‘Find in Library’ and use the drop down menus to enter details.
Click the ‘Request’ button to get the book sent to your nearest Unitec library branch.
You can save items to ‘My Favourites’ by ticking the box next to each book.
My account shows the items you have checked out and when they are due back.
If you are a Distance Student, you will need to contact Distance Services to get items sent to you. Note that you will need to allow extra time to receive them as they are posted by standard mail.
Thanks for watching and remember the Library staff are here to help. Please contact us if there is anything else we can do for you. Check out our other online tutorials for more tips on how to get the most from your library.
Ka kite anō.
A trigger is a named PL/SQL unit that is stored in the database and executed ( fired ) in response to a specified event that occurs in the database.
Overview of Triggers.
A trigger is a named program unit that is stored in the database and fired (executed) in response to a specified event. The specified event is associated with either a table, a view, a schema, or the database, and it is one of the following:
A database manipulation (DML) statement ( DELETE , INSERT , or UPDATE )
A database definition (DDL) statement ( CREATE , ALTER , or DROP )
A database operation ( SERVERERROR , LOGON , LOGOFF , STARTUP , or SHUTDOWN )
The trigger is said to be defined on the table, view, schema, or database.
A DML trigger is fired by a DML statement, a DDL trigger is fired by a DDL statement, a DELETE trigger is fired by a DELETE statement, and so on.
An INSTEAD OF trigger is a DML trigger that is defined on a view (not a table). The database fires the INSTEAD OF trigger instead of executing the triggering DML statement. For more information, see Modifying Complex Views (INSTEAD OF Triggers).
A system trigger is defined on a schema or the database. A trigger defined on a schema fires for each event associated with the owner of the schema (the current user). A trigger defined on a database fires for each event associated with all users.
A simple trigger can fire at exactly one of the following timing points :
Before the triggering statement executes.
After the triggering statement executes.
Before each row that the triggering statement affects.
After each row that the triggering statement affects.
A compound trigger can fire at more than one timing point. Compound triggers make it easier to program an approach where you want the actions you implement for the various timing points to share common data. For more information, see Compound Triggers.