Role of Consumer Involvement

Involvement too is an internal state of mind which a consumer experiences. It makes one analyze and rationalize his/her choice. Involvement of consumers can be induced by external sources and agencies. Involvement is the embodiment of time, effort, consideration given and the enjoyment that is derived by consumer while choosing a product or service.

The involvement theory holds that there are low and high involvement purchases. Consumers’ involvement depends on the degree of involvement of purchase to a consumer. For example, while buying a loaf of bread, the consumer does not feel very much involved. It is because the life of the product is very short. Once it is consumed, it gets exhausted. If the consumer is not satisfied with the particular bread brand, he will purchase some other brand next time.

It is an inner urge that creates within an individual an interest/desire to hold certain product/service offerings in greater relevance/importance.

Involvement possesses certain properties:

a) It has a level of strength and intensity that determines the degree of involvement that a consumer possesses. This could be high or low. A highly involved consumer would actively search for information and collect facts, compare the various brands against each other on the basis of the information, assess differences and similarities between the various alternatives and finally make a choice. In other words, they collect process and integrate information very intensely, and finally arrive at a decision regarding the brand choice. On the other hand, a consumer low on involvement would not make so much of effort in collecting and processing information about varying alternative brands and taking a decision.

b) The length of time that the consumer remains in this heightened state determines the level of persistence. It could be short term and situational interest in the product/service category; or it could be long term and enduring.

c) It is directed towards any or all of the elements of the marketing mix. A person may show involvement towards the product (its features/attributes and benefits), the price, the store or the dealer or even the promotional effort (advertisement/sales promotion etc).

A mechanism underlies the very process of involvement. As a process, involvement is impacted by certain “antecedents” that get restrained by “moderating factors,” and finally affect its degree of intensity and level of persistence.

Depending on whether the involvement is short term or long term, consumer involvement could be of two types, viz., situational and enduring.

Situational involvement: This is a state of arousal directed towards attaching relevance to a person/object/situation for a short term. As an affective state, it creates a level of involvement when a person thinks about a particular person/object/situation. It is specific to a situation and is thus temporary in nature. It could vary from low to high, depending upon the situational factors.

For example, a middle aged lady suddenly decides to gift a laptop to her son on his birthday. She is not techno savvy and has little interest with the product category. She goes to the electronics mall and visits the various stores that sell computers and laptops. She collects information on the product features, prices, etc and finally takes the help of her middle aged neighbor to reach a final decision. Her involvement with the purchase activity would be regarded as a situational involvement.

Enduring involvement: When the level of involvement towards the product/service category extends over a period of time across situations, it is referred to as enduring involvement. The person shows a high-level of interest in the product category and spends time collecting and processing information and integrating it within his memory.

For example, a person desires to buy a laptop for his son to be gifted to him when he goes to college, which would be three years later. The father plans well in advance, tries to collect information through advertisements, brochures, trade journals, visits to dealers, and word of mouth from peers and colleagues. Within this period he gets involved with the product category and after three years is in a position to take a decision based on the facts that he has collected. This is referred to as enduring involvement.

Enduring involvement with a product category often gives birth to an opinion leader. An opinion leader is a person who holds interest in a particular product/service category, and becomes a specialist; he makes efforts to gather all information about the category, the brand offering etc.; he talks about and spreads the information and the knowledge that he possesses. When a person wants to make a purchase, he seeks the advice and guidance of such an opinion leader who helps him make a decision. Opinion leaders are product specific. In the example above, if the lady approaches her neighbour and takes his advice/guidance because the neighbour is young, techno savvy and knows a lot about electronics and in particular laptops, she would actually be taking help of what is known as an “opinion leader”.

Types of consumer involvement in buying

Certain factors affect the degree of involvement of buyers in making purchase decisions. These include their level of knowledge, information, psychology, culture, lifestyle, social system, etc. Even for the same product or service the degree of involvement of an individual may vary depending upon the circumstances. There are five types of involvement.

Commitment: Commitment is another important form of involvement. When a member of the family falls sick, the other family members are committed to arrange medical treatment for the suffering members. Similarly, functions like marriages entail the commitment of the entire family.

Ego involvement: Ego involvement is intended to satisfy one’s ego. For example, all the members of the family involve themselves in purchasing a product for a single member belonging to that family. Wife involves herself in the purchase of garments for her husband and husband involves himself in the purchase of cosmetics for his wife. Sons and daughters of the family significantly influence the purchase of laptop, TV, car, household furniture, etc. The ego of each family member is satisfied by consulting him/her before the purchase.

Communication in involvement: Communication involvement signifies sharing the available information with others in the family or organization. If one member has some information on the subject matter of decision, he should communicate it with the other members before arriving at a decision.

Purchase importance: Involvement of individuals depends upon the degree of importance of purchase. Suppose e flat costing lakhs of rupees is purchased, then the purchase decision assumes a great deal of importance in respect of location and area of the flat. The title deeds should be free from encumbrance.

Extent of information: Once the consumer recognizes the need, he then engages in a search process. Search means acquisition of information from the environment. The extent of information search is part of purchase importance. When the purchase is important, information is sought from all possible sources. But in the case of routine purchase of products and services, information search will be rather minimum.

Situational Influences

Situational influences are temporary conditions that affect how buyers behave whether they actually buy your product, buy additional products, or buy nothing at all from you. They include things like physical factors, social factors, time factors, the reason for the buyer’s purchase, and the buyer’s mood. You have undoubtedly been affected by all these factors at one time or another. Because businesses very much want to try to control these factors, let’s now look at them in more detail.

The Consumer’s Physical Situation

Have you ever been in a department story and couldn’t find your way out? No, you aren’t necessarily directionally challenged. Marketing professionals take physical factors such as a store’s design and layout into account when they are designing their facilities. Presumably, the longer you wander around a facility, the more you will spend. Grocery stores frequently place bread and milk products on the opposite ends of the stores because people often need both types of products. To buy both, they have to walk around an entire store, which of course, is loaded with other items they might see and purchase.

Environmental Implications of Products

Environmental factors such as lighting, music, noise and aroma can either encourage or discourage the purchase of a product. A study by North, Hargreaves and McKendrick is a perfect example of how the choice of music affects purchase behavior. When French music was played in a store, the retailer saw a spike in the sale of French wine. Switching to German music saw sales increase for German wine. But atmospheric elements in the retail environment aren’t the only environmental influencers. Spatial factors also play a role. For example, the way in which a product is displayed can make it more desirable, while a crowded store or a long line at checkout can suddenly make that same product less compelling.

Purpose for Shopping Trip

The goal of a shopping trip is yet another theory involving situational influencers. A consumer searching for a birthday present, for instance, is in a store for a different purpose than someone casually shopping for a new outfit. The reason for shopping dictates the types of products customers are willing to interact with at that time and may cause them to bypass certain products they would normally interact with on another shopping trip. The same can be said for a trip to the grocery store. A customer out of milk will interact with different products than someone on her weekly shopping trip.

Social Aspects of Shopping

The social aspect of a purchase also involves situational influencers. Consumers unconsciously adjust their behavior to conform to the behavior of those in their company, and marketers have no way of changing this situation. A consumer is more apt stop to look at certain products when in the company of a friend as opposed to a parent, thereby influencing the potential of a purchase. Social aspects also can alter price point. A consumer may be persuaded to purchase a more expensive product when in the company of a colleague or potential partner than he would when with a friend or spouse.

Timing of Purchases

Much like the purpose of a purchase, timing also can influence consumer behavior. Someone in a rush will inevitably interact with fewer products than a consumer with hours to shop. Even if the two people are looking for the same type of product, the one in a hurry may end up with the most accessible product, while the leisurely shopper has time to interact with more products, giving her time to weigh the price and quality of the offerings.

State of Mind at Time of Interaction

Another situational factor known to influence behavior is state of mind. Someone feeling sad interacts differently with products than a shopper feeling happy. The interaction inevitably affects the opinion on a product and, in turn, the purchase behavior. But state of mind goes beyond mood or emotion and can entail personal conditions. Someone who’s sick interacts with different products than someone who’s healthy. The same can be said for someone who’s fatigued versus someone’s who’s full of energy.

There are two main correlations to remember here:

  • Situations can influence an individual’s personality.
  • An individual’s personality paired with the situation can help to predict behavior.

Companies can use these correlations to create stronger and more efficient teams. While unique circumstances may arise, understanding personality traits is the first step in developing a strong organization.

Consumer Behaviour Characteristics, Scope, Relevance, Need

A consumer behavior analysis helps you identify how your customers decide on a product or a service. To study their behavior you need a mix of qualitative and quantitative data from customer surveys, customer interviews, the information gathered from observation of their behavior in-store and online.

  • According to Engel, Blackwell, and Mansard

‘Consumer behaviour is the actions and decision processes of people who purchase goods and services for personal consumption’.

  • According to Louden and Bitta

‘Consumer behaviour is the decision process and physical activity, which individuals engage in when evaluating, acquiring, using or disposing of goods and services’.

Consumer buying behavior is the sum total of a consumer’s attitudes, preferences, intentions, and decisions regarding the consumer’s behavior in the marketplace when purchasing a product or service. The study of consumer behavior draws upon social science disciplines of anthropology, psychology, sociology, and economics

Characteristics

  • Process

Consumer behaviour is a systematic process relating to buying decisions of the customers. The buying process consists of the following steps;

  • Need identification to buy the product.
  • Information search relating to the product.
  • Listing of alternative brands.
  • Evaluating the alternative (cost-benefit analysis)
  • Purchase decision.
  • Post-purchase evaluation by the marketer.

 

  • Influenced by Various Factors

Consumer behaviour is influenced by a number of factors.

The factors that influence consumers are: Marketing, Personal, Psychological, Situational, Social, Cultural etc.

  • Different for All Customer

All consumers do not behave in the same manner. Different consumers behave differently. The difference in consumer behaviour is due to individual factors such as nature of the consumer’s life style, culture, etc.

  • Different for Different Products

Consumer behaviour is different for different products. There are some consumers who may buy more quantity of certain items and very low/no quantity of some other items.

  • Region Bounded

The consumer behaviour varies across states, regions and countries. For instance, the behaviour of urban consumers is different from that of rural consumers.

Normally, rural consumers are conservative (traditional) in their buying behaviour.

  • Vital for Marketers

Marketers need to have a good knowledge of consumer behaviour. They need to study the various factors that influence consumer behaviour of their target customers. The knowledge of consumer behaviour enables marketers to take appropriate marketing decisions.

  • Reflects Status

Consumers buying behaviour is not only influenced by status of a consumer, but it also reflects it. Those consumers who own luxury cars, watches and other items are considered by others as persons of higher status.

  • Consumer behavior has a spread effect.

The buying behaviour of one person may influence the buying behavior of another person. For instance, a customer may always prefer to buy premium brands of clothing, watches and other items etc.

This may influence some of his friends, neighbours, colleagues. This is one of the reasons why marketers use celebrities like Shahrukh Khan , Sachin to endorse their brands.

  • Standard of Living

Consumer buying behaviour may lead to higher standard of living. The more a person buys the goods and services, the higher is the standard of living.

  • Keeps on Changing

The consumer’s behaviour undergoes a change over a period of time depending upon changes in age, education and income level. Etc, for instance, kids may prefer colorful dresses, but as they grow up as teenagers and young adults, they may prefer trendy clot

Scope

  • Marketing Management

Effective business managers know the importance of marketing towards the success of the business. Understanding consumer behaviour is essential for the long-run success of any marketing program. A better understanding of consumer needs and wants helps the business to plan and execute the marketing strategies accordingly.

  • Demand Forecasting

Consumer behaviour helps in the forecasting of the demands for the business. Every business identifies the needs and wants of the customers by understanding their behaviour. Forecasting helps them to find out the unfulfilled demands in the market easily. If the company knows what their consumer wants, they can design and produce the product accordingly.

  • Selecting the Target Market

Consumer behaviour helps in identifying target customers from the market. Study of customer behaviour identifies all customers segments with unique and distinct needs. It helps in segmentation of the overall market into different groups. Grouping of customers and identification of their needs will help business in serving them better. The business will be able to design their products in a better way as per the needs and wants of their customer. It makes clear to businesses who are their target customers and what they want.

  • Educating Customer

Consumer behaviour helps marketers to identify how customers spend on their buying decision. By understanding their behaviour marketers can easily guide their customers about how they can improve their buying decisions. They can suggest ways to save their money and guides them with better options available in the market. Customers get aware of different opportunities available to them as per their behaviour.

  • Market Mix.

Proper development and designing all-important elements like product, price, place, and promotion are essential for every business. It helps them to identify the likes and dislikes of the customers. This allows marketers to design optimum marketing mix plans and improve the effectiveness of marketing strategies. The proper implementation of a marketing mix helps organizations to attract more customers, thereby increasing profit.

  • Assists In Designing Product Portfolio

Designing the right product portfolio is a challenging task for every business. Every business should design such a portfolio consisting of all class of products. Consumer behaviour helps in identifying the class and requirements of peoples. This helps in designing products as per people’s needs and include in the product portfolio of the company. This way business is able to design the optimum product portfolio and able to serve its customers in a better way.

Relevance

  • Know the effect of price on buying

Consumer behavior can help to understanding the effect of price on buying. Whenever the price is moderate on cheap more and more customers will buy the product.

After the time of production, there comes a time in which the company has to decide what the price of our product will be because it helps to divide the categories of the customer and also helps to attain more sales.

  • Innovate new Products

Continuous strive for improvement in success rate largely depends on the innovation in the offered product or services line. To accurately predict and ace innovation, the need for study of Consumer behaviour is a must. Researching the same not only enables to make new products/services satisfying the needs and wants of consumers but also to tweak the present line of offerings to fulfil the consumer’s needs and demands.

  • To design production policies

All of the production policies have designed taking into consideration the consumer preference so that product can be successful in the market.

In every business, the main motive is to enhance the production and as well as sales of the company and to do all these, any company or business has to win the trust of its customers and studying about their tastes, likings, and preferences.

Need for Consumer Behaviour

Consumer behavior is a crucial aspect of marketing and business strategy. Understanding why and how consumers make decisions about what to buy or not to buy is essential for businesses to thrive.

  • Product Development and Innovation:

Knowledge of consumer preferences and needs helps businesses create products and services that align with customer expectations. Understanding consumer behavior can drive innovation by identifying gaps in the market and areas where improvements or new solutions are needed.

  • Marketing Strategy:

Marketers can tailor their messaging and promotional strategies based on an understanding of consumer behavior. This includes selecting the right advertising channels, creating compelling content, and using effective communication techniques. The study of consumer behavior helps in market segmentation, allowing businesses to target specific consumer groups with customized marketing approaches.

  • Brand Building:

Consumer perceptions and attitudes toward a brand are influenced by their experiences and interactions. By understanding consumer behavior, businesses can build and maintain a positive brand image. Recognizing the emotional and psychological factors that influence consumer choices can contribute to the development of brand loyalty.

  • Price and Value Perception:

Consumers don’t just evaluate products based on their price; they also consider the value they receive in return. Understanding how consumers perceive value helps businesses set appropriate pricing strategies. Consumer behavior studies can reveal insights into the pricing sensitivity of different market segments.

  • Customer Satisfaction and Retention:

Knowing what satisfies or dissatisfies customers enables businesses to improve their products and services continuously. Building strong relationships with customers and understanding their post-purchase behavior can contribute to customer retention and repeat business.

  • Market Trends and Forecasting:

Analyzing consumer behavior provides insights into current market trends and helps businesses anticipate future changes. Predicting consumer preferences allows businesses to adapt their strategies proactively, staying ahead of competitors and market shifts.

  • E-commerce and Technology Impact:

In the digital age, where online shopping and e-commerce are prevalent, understanding consumer behavior is crucial for online retailers. This includes optimizing website design, streamlining the purchase process, and utilizing data analytics for personalized recommendations.

  • Policy and Regulation Compliance:

Consumer behavior studies help businesses comply with relevant laws and regulations, ensuring that their products and services meet consumer expectations and legal requirements.

Basic understanding in Dashboard and Storyboard

A business intelligence dashboard is a data visualization technique that displays the current status and/or historical trends of metrics and key performance indicators (KPIs) for an enterprise. Dashboards consolidate and arrange numbers, metricsand sometimes performance scorecards on a single screen. They may be tailored for a specific role and display metrics targeted for a single point of view or department. The essential features of a BI dashboard product include a customizable interface and the ability to pull real-time data from multiple sources. The latter is important since lots of people think dashboards are only on summarized data which is absolutely not the case.

A Dashboard

A business intelligence dashboard is a data visualization technique that displays the current status and/or historical trends of metrics and key performance indicators (KPIs) for an enterprise. Dashboards consolidate and arrange numbers, metrics and sometimes performance scorecards on a single screen. They may be tailored for a specific role and display metrics targeted for a single point of view or department. The essential features of a BI dashboard product include a customizable interface and the ability to pull real-time data from multiple sources. The latter is important since lots of people think dashboards are only on summarized data which is absolutely not the case; dashboards consolidate data which may be of the lowest grain available! Key properties of a dashboard are:

  • Simple and communicates easily and straight
  • Minimum distractions, since these could cause confusion
  • Supports organized business with meaning, insights and useful data or information
  • Applies human visual perception to visual presentation of information: colors play a significant role here
  • Limited interactivity: filtering, sorting, what-if scenarios, drill down capabilities and sometimes some self-service features
  • They are often “managed” in a sense that the dashboards are centrally developed by ICT, key users or a competence center, and they are consumed by the end-users
  • Offer connectivity capabilities to other BI components for providing more detail. Often these are reports with are connected via query-parsing to the dashboards

A Storyboard

Is there a big difference between a storyboard and a dashboard? Mwah, not too much: they both focus on communicating key – consolidated – information in a highly visualized and way which ultimately leaves little room for misinterpretation. For both the same key words apply: simple, visual, minimum distraction.

The main difference between a dashboard and a storyboard is that the latter is fully interactive for the end user. The interactivity of the storyboard is reflected through capabilities for the end user to:

  • Sort
  • Filter data: include and exclude data
  • Change chart or graph types on the fly
  • Add new visualizations on the fly; store and share them
  • Drill down
  • Add or adjust calculated measures and dimensions
  • Add new data via wrangling, blending or joining
  • Adjust the full layout of the board
  • Create custom hierarchies or custom groupings
  • Allow for basic data quality improvements (rename, concatenate, upper and lower case etc)

Another big difference between dashboards and storyboards is that storyboards are self-service enabled boards meaning the end user creates them him/herself. Opposite to dashboards that are typically “managed” and as such are created centrally by ICT, key users or a BICC, and are consumed by the end user.

Aggregate Functions, Relational Algebra

Aggregate functions are functions that define an operation which consumes values from multiple records to a produce a single output. Aggregate functions in SQL are typically used in GROUP BY functions. Aggregate functions are similar to scalar functions and function signatures with a small set of different properties.

Aggregate function signatures contain all the properties defined for scalar functions. Additionally, they contain the properties below:

In database management an aggregate function is a function where the values of multiple rows are grouped together as input on certain criteria to form a single value of more significant meaning.

Various Aggregate Functions

1) Count()

2) Sum()

3) Avg()

4) Min()

5) Max()

Id     Name     Salary

———————–

1       A        80

2       B        40

3       C        60

4       D        70

5       E        60

6       F        Null

Count():

Count(*): Returns total number of records .i.e 6.

Count(salary): Return number of Non Null values over the column salary. i.e 5.

Count(Distinct Salary):  Return number of distinct Non Null values over the column salary .i.e 4

Sum():

sum(salary):  Sum all Non Null values of Column salary i.e., 310

sum(Distinct salary): Sum of all distinct Non-Null values i.e., 250.

Avg():

Avg(salary) = Sum(salary) / count(salary) = 310/5

Avg(Distinct salary) = sum(Distinct salary) / Count(Distinct Salary) = 250/4

Min():

Min(salary): Minimum value in the salary column except NULL i.e., 40.

Max(salary): Maximum value in the salary i.e., 80.

Relational Algebra

Relational algebra is a procedural query language, which takes instances of relations as input and yields instances of relations as output. It uses operators to perform queries. An operator can be either unary or binary. They accept relations as their input and yield relations as their output. Relational algebra is performed recursively on a relation and intermediate results are also considered relations.

The fundamental operations of relational algebra are as follows:

  • Select
  • Project
  • Union
  • Set different
  • Cartesian product
  • Rename

Data Query Language: Where clause, Order by, Group by

Where clause

The WHERE clause is used to filter records.

It is used to extract only those records that fulfill a specified condition.

WHERE Syntax

  • SELECT column1, column2, …

  • FROM table_name

  • WHERE condition;

Order by

Syntax of Order By in SQL:

  • SELECT column1, column2….
  • FROM table_name
  • ORDER BY column1 ASC/DESC, column2 ASC/DESC;

Example:

Sort all the students in ascending order in SQL by the “marks” column.

  • SELECT Name

  • FROM Student_details

  • ORDER BY Roll_no ASC;

Group by

It is used to arrange similar data into the group. The GROUP BY clause follows the WHERE clause and comes before the ORDER BY clause.

  • SELECT Name, Sum(marks)
  • FROM Student_details
  • GROUP BY Name;

DCL commands: Grant, Revoke

Data Controlling Language (DCL) helps users to retrieve and modify the data stored in the database with some specified queries. Grant and Revoke belong to these types of commands of the Data controlling Language. DCL is a component of SQL commands.

Grant:

SQL Grant command is specifically used to provide privileges to database objects for a user. This command also allows users to grant permissions to other users too.

Syntax:

grant privilege_name on object_name

to {user_name | public | role_name}

Here privilege_name is which permission has to be granted, object_name is the name of the database object, user_name is the user to which access should be provided, the public is used to permit access to all the users.

Revoke

Revoke command withdraw user privileges on database objects if any granted. It does operations opposite to the Grant command. When a privilege is revoked from a particular user U, then the privileges granted to all other users by user U will be revoked.

Syntax:

revoke privilege_name on object_name

from {user_name | public | role_name}

DDL commands: Create, Add, Drop

The Structure of Create Table Command

Table name is Student

Column name Data type  Size
 Reg_no  varchar2  10
 Name  char  30
 DOB      date  
 Address  varchar2  50

Insert

The ALTER Table Command

By The use of ALTER TABLE Command we can modify our exiting table.

Adding New Columns

Syntax:

ALTER TABLE <table_name>

         ADD (<NewColumnName> <Data_Type>(<size>),……n)

Example:

ALTER TABLE Student ADD (Age number(2), Marks number(3));

The Student table is already exist and then we added two more columns Age and Marks respectively, by the use of above command.

Delete

Syntax:

DROP TABLE <table_name>

Example:

DROP TABLE Student;

It will destroy the table and all data which will be recorded in it.

Update

UPDATE Syntax

UPDATE table_name

SET column1 = value1, column2 = value2, …

WHERE condition;

DML Commands: Insert, Delete, Update

Insert

The INSERT INTO statement of SQL is used to insert a new row in a table. There are two ways of using INSERT INTO statement for inserting rows:

  1. Only values: First method is to specify only the value of data to be inserted without the column names.

INSERT INTO table_name VALUES (value1, value2, value3,…);

table_name: name of the table.

value1, value2,.. : value of first column, second column,… for the new record

  1. Column names and values both: In the second method we will specify both the columns which we want to fill and their corresponding values as shown below:

INSERT INTO table_name (column1, column2, column3,..) VALUES ( value1, value2, value3,..);

table_name: name of the table.

column1: name of first column, second column …

value1, value2, value3 : value of first column, second column,… for the new record

Delete

The DELETE Statement in SQL is used to delete existing records from a table. We can delete a single record or multiple records depending on the condition we specify in the WHERE clause.

Syntax: Basic

DELETE FROM table_name WHERE some_condition;

table_name: name of the table

some_condition: condition to choose particular record.

Update

The UPDATE statement in SQL is used to update the data of an existing table in database. We can update single columns as well as multiple columns using UPDATE statement as per our requirement.

Basic Syntax

UPDATE table_name SET column1 = value1, column2 = value2,…

WHERE condition;

table_name: name of the table

column1: name of first , second, third column….

value1: new value for first, second, third column….

condition: condition to select the rows for which the values of columns needs to be updated.

TCL Commands: Commit, Roll Back, Save point

COMMIT command in SQL is used to save all the transaction-related changes permanently to the disk. Whenever DDL commands such as INSERT, UPDATE and DELETE are used, the changes made by these commands are permanent only after closing the current session. So before closing the session, one can easily roll back the changes made by the DDL commands. Hence, if we want the changes to be saved permanently to the disk without closing the session, we will use the commit command.

Syntax:

COMMIT; 

Example:

We will select an existing database, i.e., school.

mysql> USE school;

Rollback command

This command restores the database to last commited state. It is also used with SAVEPOINT command to jump to a savepoint in an ongoing transaction.

If we have used the UPDATE command to make some changes into the database, and realise that those changes were not required, then we can use the ROLLBACK command to rollback those changes, if they were not commited using the COMMIT command.

Following is rollback command’s syntax,

ROLLBACK TO savepoint_name;

SAVEPOINT command

SAVEPOINT command is used to temporarily save a transaction so that you can rollback to that point whenever required.

Following is savepoint command’s syntax,

SAVEPOINT savepoint_name;

In short, using this command we can name the different states of our data in any table and then rollback to that state using the ROLLBACK command whenever required.

error: Content is protected !!