praveen

Satisfactory Essays
Topics: 1918, SQL, 1920, 1916, 1922
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

  • Satisfactory Essays

    praveen

    • 507 Words
    • 3 Pages

    The Advantages and Disadvantages of Internet Nowadays, internet plays an important role in our daily life. Now we can use computer, laptop, 3G phone or else to connect on the internet. Human are addicted seriously by internet in this century. Human will like to spend lots of time for surfing on the internet. It seems like it had already become an essential things in our life. By contrast, we should know the advantages and disadvantages that the internet brings. First, for the advantage we…

    • 507 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Praveen Resume

    • 325 Words
    • 2 Pages

    RESUME Name: R.PRAVEEN KUMAR E-mail: Praveen.acquarious@gmail.com Address: H-No:8-129/1/103, Mobile: +91-7893548595 20-72/4(17),flatno:402, Rohit Apartments,Gautham Nagar Malkajgiri. Career Objective: Aspiring for a challenging position in a growing organization where I can find ample opportunities to improve and prove my potential in realizing the goals of the organization. Educational Credentials:…

    • 325 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    Compare how the poets present workmanship and their journey of life and composing ‘to a friend ‘Praveen shakir and ‘on top’ Gary Snyder. Introduction: ‘All you have to do then is wait and watch. New life will sprout’. I will explore the major theme relating it to liberation and the journey of life and demonstrate this by comparing style, language and the importance in both poems by Praveen shakir and Gary Snyder and determine if this was expected or intended. ‘On top’ by Gary Snyder is…

    • 1205 Words
    • 5 Pages
    Better Essays
  • Powerful Essays

    potentially violated by outage, threatening suit * Flow of crisis * Praveen D. got call from HSH, pages on-call after-hours US manager 3x, MISTAKE: used weekday number not weekend (still weekend in Cali, not India) * Did not call Nick E. directly: insulted by earlier Nick comment “India team incompetent” * Possible mistake: Nick E. had cell phone off, assumed others would call his home * Praveen D. tries to fix problem with Indian team, couldn’t find HS Holdings contact…

    • 750 Words
    • 3 Pages
    Powerful Essays
  • Good Essays

    jyothi sampat

    • 492 Words
    • 2 Pages

    life. Maybe people have limited knowledge about other people’s background. Based upon Jyothi Sampat’s descriptions of her courting and married life, how do you think she defines a good marriage and married love? What about Praveen? How do you define a good marriage and/or married love? Explain.…

    • 492 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Welcome Address

    • 409 Words
    • 2 Pages

    Welcome address by Dr. B.Vidyasagar, Honorary Director, Coaching cell for Prelims(civils) College of Agriculture, Rajendranagar. Respected chief guest, Dr. R.S. Praveen Kumar, Secretary, APSWREIS, Dr. K.V.S . Meena Kumari, Registrar, Controller of Examination, Coordinator for SC,ST,Cell, ANGRAU, Dr. K. Veeranjaneyulu, University Librarin, ANGRAU, Associate Dean, College of Agriculture, learned Colleagues, students press and Media. It is my Privilege to welcome to “Orientation…

    • 409 Words
    • 2 Pages
    Good Essays
  • Best Essays

    Greg James

    • 4227 Words
    • 17 Pages

    jame Table of Content Introduction 3 Question 1: How well had James managed his global teams? 3 Question 2: Compare and contrast how the various teams see as the cause of the crisis? In your view, who is responsible for the HS Holding Crisis? 4 Question 3: What role did open work environment and diversity play in the case? How? 7 Question 4: What should James do in the short and long term? 9 Conclusion 11 Reference List 12 Team Distribution of Tasks: 12…

    • 4227 Words
    • 17 Pages
    Best Essays
  • Powerful Essays

    Team and James

    • 1161 Words
    • 5 Pages

    | Managing a Global Team-Greg James at Sun Microsystems, Inc | Case Analysis | | Long Cui | Hawaii Pacific UniversityDr. Kenneth Gerard RossiApril 30, 2013 | | Brief Summary Greg James, a global manager at Sun Microsystems, Inc., led a customer implementation team of 45 members spread across India, France, the United Arab Emirates (UAE), and the United States (US). It was the second time that the team…

    • 1161 Words
    • 5 Pages
    Powerful Essays
  • Powerful Essays

    Culture

    • 2562 Words
    • 8 Pages

    between themselves and a person in a position of power. Vietnamese culture is high power distance. It means that organization use management systems and processes that reflect a strong concern with hierarchy (Strategic International Management, K. Praveen Parboteeah, John B. Cullen). Subordinates always maintain a distance from their superiors with a sense of respect, sometimes they even awe their boss and the children are expected to be obedient to parents and elders. So that when the children are…

    • 2562 Words
    • 8 Pages
    Powerful Essays
  • Good Essays

    Greg James

    • 6094 Words
    • 25 Pages

    Holdings James scanned his inbox, reliving the events that had plunged him into this predicament. Six days earlier, he had received a string of e-mails, forwarded to him by his team. Rahul Ashok, service manager for the Mumbai team, was in touch with Praveen Devilal (one of Ashok’s team members in Mumbai) and Nick Elliott and Robert Chan in Santa Clara to trace the source of the breakdown: To: Greg James (Global Manager, Santa Clara)
Fw: FYI in re: HS Holdings
Date: Mon, 26 May 2008 06:58:40 PST
From:…

    • 6094 Words
    • 25 Pages
    Good Essays