TechPro

                                          PL / SQL   Pl/SQL    state Loops in PL/SQL   Built in Function     Cursor Management     Exception INTRODUCTION   PL/SQL stands for Procedural Language/SQL. PL/SQL extends SQL by adding constructs found in procedural languages,  resulting in a structural language that is more powerful than  SQL.PL/SQL is not case sensitive. ‘C’ style comments (/* ……… */)  may be used in PL/SQL programs whenever required.   All PL/SQL programs are made up of blocks, each block performs  a logical action in the program. A PL/SQL block consists of three parts  1. Declaration section   2. Executable section   3. Exception handling section  Only the executable section is required. The other sections are  optional.  A PL/SQL block h...

                            TRIGGER OBJECTIVES  After reading this  you will able to -     how to Create Trigger     how to Modify Trigger   State Enable / Disable trigger    State Delete Trigger  INTRODUCTION   A trigger is PL/SQL code block which is executed by an event  which occurs to a database table. Triggers are implicitly invoked when  INSERT, UPDATE or DELETE command is executed. A trigger is  associated to a table or a view. When a view is used, the base table  triggers are normally enabled.   Triggers are stored as text and compiled at execute time, because  of this it is wise not to include much code in them. You may not use  COMMIT, ROLLBACK and SAVEPOINT statements within trigger  blocks.   The advantages of using trigger are :   1. It creates consistency and access r...

  ORACLE 9I DATABASE TYPES   An upgraded Oracle 9i consists of three different types :  i) Relational : The traditional ORACLE relational database  (RDBMS).  ii) Object-relational : The traditional ORACLE relational database,  extended to include object-oriented concepts and structures such  as abstract datatype, nested tables and varying arrays.  iii) Object-oriented : An object-oriented database whose design is  based only on Object-Oriented Analysis and Design principles.   Oracle provides full support to all the three types. Whatever  method we choose, we must be familiar with the functions and  features of the core ORACLE relational database. Even if OO  capabilities are used, the functions and datatypes available in Oracle  and its programming languages i.e. SQL and PL/SQL should be  known. USES OF OBECTS   Objects reduce complexity of representing complex data and its  relations. O...

   Email Client Configuration - Introduction to Email • Email is abbreviated as electronic mail • Email is used to exchange (i.e. send and receive) mails across Internet. • More plainly, e-mail is a message that may contain text, files, images, or other attachments sent through a network to a specified individual or group of individuals. • From year 2000 onwards, electronic mail was a preferred medium over postal mail. • Productivity tools : Email is usually packaged with a calendar, address book, IM (instant messaging) and more for convenience and productivity. • A valid Email is required to Access to web services from shopping sites like Amazon, Flipkart. Email is also required for social networking sites like Facebook. • Easy mail management : Email service providers have tools that allow you to file, label, prioritize, find, group, and filter your emails for easy management. You can even easily control spam, or junk email. • Privacy : Your email is delivered to your own pe...

   Maintaining Outlook User Interface for Outlook 2016 • Title Bar – shows the Email address of the user and the folder access by the user. • Ribbon – The ribbon is a user interface element created by Microsoft, and introduced since Microsoft Office 2007. The purpose of the ribbon is to provide quick access to commonly used tasks within each program. • Mail Folders consists of various related folders like Inbox, Drafts, Sent Items etc. • Navigation Bar provides access to Mails, Calendar, People (that is Contacts), and To-Do Lists. • To-Do Bar is a ready reckoner for activities planned for a specific day, Status Bar provides information about ZoomIn. Zoom-Out and Connection and Message Status of the Outlook client. Home Ribbon in Outlook 2016  • New option is used to draft a new email • Other Email based operation are Delete the message • Reply to Sender or Reply the message to all the recipients • Forward the email to all the recipients • Move the corresponding email to ...

   Troubleshooting Outlook • Email is important platform for personal and business communications. Microsoft Outlook is most common and preferred email client. • As a user, if you fail to send or receive email, it becomes a worst situation, since due to this you are virtually disconnected or unproductive (in case if most of your work is allocated on emails). • This chapter helps you to, understand the common errors in Outlook and Troubleshoot the errors that have occurred in Outlook client. Common errors in Outlook • The first error is illustrated as “Object not found” error message. This error is triggered when you trying to send an email from Outlook. • The possible causes and Solutions are, Error Cause - Your Outlook profile is corrupt Solution - Create a new Outlook profile. Add your email in this profile. And try sending the email message again by using the new Outlook profile created by you. Error Cause - Automatic SMTP account settings are incorrect Solution - Manually ...

  Collaboration with Office 365 What is Modern Workplace? • A Modern Workplace is a complete, intelligent solution that empowers everyone to be creative and work together, securely Unlock creativity Built for teamwork. • Modern Workplace provides integrated simplicity and intelligent security for Microsoft Office 365 + Windows 10 + Enterprise Mobility + Security (i.e. EMS). • The image shows the illustrated benefit of Modern Workplace. • There are some corporate facts recognized by Microsoft „ Fact1 : When employees feel enabled to do their best work, they are engaged and satisfied. „ Fact2 : Providing employees a digital, flexible workplace (like remote working/ work from home), results in higher productivity. „ Microsoft Core Services Engineering works to provide seamless communication and multi-device experiences to help bring teams together, enable productivity, and help drive digital transformation. The goal of Modern Workplace is to create an environment in which employees ca...