Preview

praveen

Satisfactory Essays
Open Document
Open Document
335 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
praveen
CS457_J1_HW10_13259_PRAVEEN SINDOGI

01) Briefly describe what is the benefit to use SQL*Plus substitution variables?
Use SQL*plus substitution variables to:
Store values temporarily.
Single ampersand (&)
Double ampersand (&&)
DEFINE command
Pass variable values between SQL statements.
Dynamically alter headers and footers.

02) Briefly describe what is the benefit to use the ‘&’ substitution variable?

03) Briefly describe how to using character and date values with substitution variables in SQL?
04) Briefly describe where you can use substitution variables as supplement?

05) Briefly describe how you can define substitution variables in SQL*PLUS?
In SQL*Plus substitution variables can be used to customize reports and can be used instead of hard-coded text. Substitution variables can interact with bind and system variables. Substitution variables that have values stored are said to be defined. Substitution variables references have an "&" or "&&" prefix.
06) Briefly describe DEFINE and UNDEFINE commands in SQL*PLUS?
DEFINE COMMANDS: -
Use the DEFINE command to explicitly create substitution variables.
Using DEFINE with no arguments lists all defined substitution variables. Any variable that DEFINE lists is said to be defined.
The DEFINE command only ever creates variables with type CHAR.
UNDEFINE COMMANDS: -
Use UNDEFINE to remove a defined substitution variable.
Any variable not listed by DEFINE is said to be undefined.

07) Briefly describe when you want to use the ‘&&’ substitution variable in SQL*PLUS?
Use the double-ampersand (&&) if you want to reuse the variable value without promoting the user each time.
08) Briefly describe what the VERIFY command in SQL*PLUS use for?
Use the VERIFY command in SQL*Plus to toggle the display of the substitution variable before and after SQL*Plus replaces substitution variables with values.
09) Briefly describe how you can customize the SQL*Plus environment?
You can control the environment in which SQL*Plus

You May Also Find These Documents Helpful

  • Good Essays

    The SELECT statement is the primary means of extracting data from database tables, and allows you to determine exactly which data you want to extract by means of different comparison operators used in the WHERE clause. This includes the use of specific "wild card" characters which allow you to search for character or number patterns within the data. You can also perform mathematical expressions within the SELECT statement to create derived output. The ORDER BY clause allows you to sort the output data in either ascending (the default) or descending order. Lab #5 will explore all of these applications of the SELECT statement.…

    • 1559 Words
    • 7 Pages
    Good Essays
  • Good Essays

    SEQUEL or SQL is a data language that provides benefits for all types of users. SQL’s purpose is to provide an interface to a relational database such as Oracle Database. Dr. Edgar Frank “Ted” Codd introduced the first commercially available implementation of SQL. Today, SQL is accepted as the standard RDBMS language. The features of SQL include processing sets of data as groups rather than as individual units and providing automatic navigation to the data. It uses statements that are complex and powerful individually, and that therefore stand alone. Flow-control statements were not part of SQL originally, but they are found in the recently accepted optional part of SQL. Flow-control statements are commonly known as "persistent stored modules" (PSM), and the PL/SQL extension to Oracle SQL is similar to PSM.…

    • 452 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    a guide to mysql ch 7

    • 1287 Words
    • 9 Pages

    Except where indicated, use MySQL Query Browser to perform each operation and print the results.…

    • 1287 Words
    • 9 Pages
    Powerful Essays
  • Satisfactory Essays

    unit 6

    • 360 Words
    • 2 Pages

    6) The * in SELECT * clause of an SQL statement is a wildcard for returning all columns in a table.…

    • 360 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    1.) There have been several versions of SQL created in the last 26 years. In 1986, SQL-86 (SQL-87) was first published. In 1989, SQL-89 was a minor revision made to the original SQL. In 1992, SQL-92 (SQL2) was a major revision to its previous version. In 1999, SQL-99 (SQL3) added regular expression matching, recursive queries, triggers, non scalar types and some object oriented features. In 2003, SQL-2003 introduced XML related features, standardized sequences, and columns with auto generated values. In 2006, SQL-2006 defined ways in which SQL can be used in conjunction with XML and it defined ways of importing and storing XML data in an SQL database, manipulating it within the database and publishing both XML and conventional SQL-data in XML form. It also enables applications to integrate into their SQL code the use of XQuery. In 2008, SQL-2008 Legalized ORDER BY outside cursor definitions, added INSTEAD OF triggers, and added the TRUNCATE statement. As of March 2012, the newest SQL was released its new features include AlwaysOn SQL Server Failover Cluster Instances and Availability Groups which provides a set of options to improve database availability, Contained Databases which simplify the moving of databases between instances, new and modified Dynamic Management Views and Functions, programmability enhancements including new Spatial features, Metadata discovery, Sequence objects and the THROW statement, performance enhancements such as ColumnStore Indexes as well as improvements to OnLine and Partition level operations and security enhancements including Provisioning During Setup, new permissions, improved role management and default schema assignment for groups…

    • 701 Words
    • 3 Pages
    Good Essays
  • Good Essays

    prpopaganda

    • 673 Words
    • 3 Pages

    The term propaganda is sometimes brought up in casual conversation, however, many do not realize the potential power that propaganda can have. Can be defined propaganda as the spreading of ideas, information, or rumor for the purpose of helping or injuring an institution, a cause, or a person. In the novel Animal Farm by George Orwell, propaganda is shown to indeed cause harm. A various sections of the book will be conducted in order to demonstrate three aspects of propaganda: how it is used by Snowball to positively obtain the control of Animal Farm; how Napoleon uses it in a sinister way to exile Snowball and his paradigm and to show Napoleon's propaganda as a scapegoat for his own problems. Again, Merriam-Webster states propaganda as the spreading of ideas, information, or rumor for the purpose of helping or injuring an institution, a cause, or a person. First, it can be seen how Snowball uses propaganda to effectively assume leadership of Animal Farm. After the rebellion, Snowball took control and broadcast his ideas upon desperate ears. Vote for Snowball and the three day week... (p.34) Snowball spread propaganda that would promote Animalism by building a windmill. This windmill was to be used for luxuries that would make life better for everyone on Animal Farm. Snowball also said that although the construction would be difficult all animals would benefit in the long run. His positive attitude, ideas and propaganda excited the animals so much that they wanted to build it, until the demise of Snowball and his crimes of treason. Napoleon decided to use propaganda in a negative manner to destroy the reputation of Snowball's righteousness. During a vote when the animals of Animal Farm were to decide the fate of the windmill, the animals seemed to be siding with Snowball. That is when Napoleon implemented his wicked plot to rule Animal Farm. Napoleon exiled Snowball from the farm by means of…

    • 673 Words
    • 3 Pages
    Good Essays
  • Good Essays

    rietveld

    • 954 Words
    • 3 Pages

    The Red and Blue Chair is a chair designed in 1917 by Gerrit Rietveld. It represents one of the first explorations by the De Stijl art movement in three dimensions. In the Red Blue Chair, Rietveld manipulated rectilinear volumes and examined the interaction of vertical and horizontal planes, much as he did in his architecture. Although the chair was originally designed in 1918, its color scheme of primary colors (red, yellow, blue) plus black—so closely associated with the de Stijl group and its most famous theorist and practitioner Piet Mondrian—was applied to it around 1923. Hoping that much of his furniture would eventually be mass-produced rather than handcrafted, Rietveld aimed for simplicity in construction. The pieces of wood that comprise the Red Blue Chair are in the standard lumber sizes readily available at the time…

    • 954 Words
    • 3 Pages
    Good Essays
  • Good Essays

    prueba

    • 20599 Words
    • 88 Pages

    Companies have realized they need to hire data scientists, academic institutions are scrambling to put together…

    • 20599 Words
    • 88 Pages
    Good Essays
  • Good Essays

    pranav

    • 999 Words
    • 4 Pages

    - Pranav New York has the first-mover advantage being the first-ever “one-stop shop” on spa and grooming services catered to the male market…

    • 999 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Pran

    • 4164 Words
    • 17 Pages

    PRAN -RFL Group is the largest food and nutrition company of Bangladesh founded in 1980 and started its operation in 1981. It has obtained prestigious ISO 9001:2000, and being the largest exporter of processed agro products with compliance of HALAL & HACCP to more than 70 countries from Bangladesh. Also a popular company for juice in Bangladesh.…

    • 4164 Words
    • 17 Pages
    Powerful Essays
  • Satisfactory Essays

    Prabhas

    • 495 Words
    • 2 Pages

    Prabhas Raju Uppalapati (born 23 October 1979),[1] popularly known as Prabhas, is an Indian film actor, who is referred to as Young Rebel star in Telugu cinema.[2][3] He made his debut with Eeshwar. After playing the role of a lover boy in the 2004 blockbuster film Varsham, Prabhas continued in this vein, gaining mass appeal for his subsequent films. He appeared in the blockbuster hit Chatrapathi and continued enthralling masses with commercial entertainers like Munna, Ek Niranjan, Bujjigadu, Billa, and Mirchi, proving his box office stamina.[4] After gaining success, he started experimenting with youthful family entertainers like Darling and Mr. Perfect which were successful at the box office. His release, Mirchi, was also highly successful.…

    • 495 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    reniassance

    • 855 Words
    • 4 Pages

    The recordings you can listen to on this page are featured throughout the Museum's Medieval & Renaissance galleries and complement significant objects in the collection. The recordings were made by the Royal College of Music especially for the Medieval & Renaissance Galleries thanks to an award from the Arts and Humanities Research Council.…

    • 855 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Visual Basic Terms

    • 1691 Words
    • 7 Pages

    PROCEDURE CALL STATEMENT: THE LEFT AND RIGHT PARENTHESES IMMEDIATELY FOLLOWING THE NAME OF THE PROCEDURE IDENTIFIES THE VISUAL BASIC STATEMENT AS THE PROCEDURE CALL STATEMENT.…

    • 1691 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

    implicit and explicit

    • 393 Words
    • 2 Pages

    "implicitly assign", I'm not sure exactly without more context, but the implication here is that the assignment is not explicit, it happens somewhere else, or by default....…

    • 393 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Pradeep's

    • 402 Words
    • 2 Pages

    I agree with the statement that beauty contests are degrading. They degrade women to mere objects. The sponsors exploit women by requiring them to parade in swimsuits or even lingerie. They are judged mainly on their physical appearance rather than on any other qualities they may possess.When the women parade themselves on stage, the judges will look at a number of things, but the most important criteria will probably be poise. To achieve proper poise, a woman's body should be well proportioned - having a neck proportionate to her height, lanky legs and so on. This process of evaluating poise can be compared to dog shows where golden retrievers of the wrong bodily proportions are kicked out of the competition. I feel judging women primarily on their looks degrade womanhood.Moreover, beauty contests project an unrealistically thin image of the ideal woman in the eyes of the public. As it is, we are already bombarded with such silly standards by the mass media. Do we really need a beauty pageant to further aggravate the situation? A John Hopkins study has shown that more than half of the Miss America pageant winners are underweight, with a Body Mass Index of about 18.5, well below the normal BMI of 20 -- 25. Insecure women who watch the pageants are bound to develop a false body image and may even become anorexic or even bulimic just to look like beauty queens.Being a Muslim, I feel beauty contests violate some religious or cultural practices. I consider western style beauty contests as immoral, because the female participants are typically not dressed modestly. This really degrades women in the eyes of a conservative society. Lastly, when the winner wears a crown and reigns for a year, she is actually being exploited to do cheap promotions for the sponsors who make use of her to promote their products until they see it fit to replace her with some other beauties. This is cold and mercenary.For all the reasons given, I find…

    • 402 Words
    • 2 Pages
    Good Essays

Related Topics