Database Script

In: Computers and Technology

Submitted By icthacker
Words 302
Pages 2
SQL> connect system/db
Connected.
SQL> create user section3 identify by section3; create user section3 identify by section3 *
ERROR at line 1:
ORA-00922: missing or invalid option

SQL> create user section3 identified by section3;

User created.

SQL> grant connect, resource, , create view to section3; grant connect, resource, , create view to section3 *
ERROR at line 1:
ORA-00990: missing or invalid privilege

SQL> grant connect,resource,create view to section3;

Grant succeeded.

SQL> disconnect
Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Produ ction SQL> connect section3/section3
Connected.
SQL> select * from tab;

no rows selected

SQL> help index

Enter Help [topic] for help.

@ COPY PAUSE SHUTDOWN @@ DEFINE PRINT SPOOL / DEL PROMPT SQLPLUS ACCEPT DESCRIBE QUIT START APPEND DISCONNECT RECOVER STARTUP ARCHIVE LOG EDIT REMARK STORE ATTRIBUTE EXECUTE REPFOOTER TIMING BREAK EXIT REPHEADER TTITLE BTITLE GET RESERVED WORDS (SQL) UNDEFINE CHANGE HELP RESERVED WORDS (PL/SQL) VARIABLE CLEAR HOST RUN WHENEVER OSERROR COLUMN INPUT SAVE WHENEVER SQLERROR COMPUTE LIST SET XQUERY CONNECT PASSWORD SHOW

SQL> help describe

DESCRIBE --------

Lists the column definitions for a table, view, or synonym, or the specifications for a function or procedure.

DESC[RIBE] {[schema.]object[@connect_identifier]}

SQL> help clear…...

Similar Documents

Database

...Client/Server is a system. It is not just hardware or software. It is not necessarily a program that comes in a box to be installed onto your computer’s hard drive. Client/Server is a conglomeration of computer equipment, infrastructure, and software programs working together to accomplish computing tasks which enable their users to be more efficient and productive. Client/Server applications can be distinguished by the nature of the service or type of solutions they provide. Client/Server Computing is new technology that yields solutions to many data management problems faced by modern organizations. Client/Server Computing: An Introduction, features objective evaluations and details of Client/Server development tools, used operating system, database management system and its mechanism in respect of Client/Server computing and network components used in order to build effective Client/Server applications. vi Preface Last but not the least, this work is primarily a joint work with a number of fellow teacher who have worked with us. My parents, wife Meera, and our children, Akanksha and Harsh. I am particularly grateful to Dr. A. P. Singh, Principal, Udai Pratap Inter College, Varanasi; Dr. D. S. Yadav, Sr. Lecturer, Department of Computer Science and Engineering, IET, Lucknow; Dr. A. K. Naiyak, Director IIBM, Patna, former President of IT and Computer Science Section of Indian Science Congress Association; Prof. A. K. Agrawal, Professor and Ex-Head of Department,......

Words: 79055 - Pages: 317

Database

...FROM   employees;     5. Modify the query in lab_04_04.sql to display the minimum, maximum, sum, and average salary for each job type. Resave lab_04_04.sql as lab_04_05.sql. Run the statement in lab_04_05.sql. SELECT job_id, ROUND(MAX(salary),0) "Maximum",                 ROUND(MIN(salary),0) "Minimum",                 ROUND(SUM(salary),0) "Sum",                 ROUND(AVG(salary),0) "Average"  FROM   employees         GROUP BY job_id;  6. Write a query to display the number of people with the same job. SELECT job_id, COUNT(*)  FROM   employees   GROUP BY job_id;  Generalize the query so that the user in the HR department is prompted for a job title. Save the script to a file named lab_04_06.sql.� SELECT job_id, COUNT(*)  FROM   employees  WHERE  job_id = '&job_title'  GROUP BY job_id;  Oracle Database 10g: SQL Fundamentals I A - 12 Practice 4: Solutions (continued) 7. Determine the number of managers without listing them. Label the column Number of  Managers. Hint: Use the MANAGER_ID column to determine the number of managers. SELECT COUNT(DISTINCT manager_id) "Number of Managers"  FROM   employees;   8. Find the difference between the highest and lowest salaries. Label the column DIFFERENCE.� SELECT   MAX(salary) - MIN(salary) DIFFERENCE  FROM     employees;  If you have time, complete the following exercises:� 9. Create a report to display the manager number and the salary of the lowest-paid employee for that manager. Exclude anyone whose manager......

Words: 569 - Pages: 3

Database

...IT203 Database Development GRADED ASSIGNMENTS ------------------------------------------------- Graded Assignment Requirements This document includes all of the assignment requirements for the graded assignments in this course. Your instructor will provide the details about when each assignment is due. Unit 1 Assignment 1: Homework Learning Objectives and Outcomes Describe the role of software for computers. Identify the hardware associated with a computer. Describe how computers store data. Explain how programs work. Differentiate among machine language, assembly language, and high-level languages. Differentiate between compilers and interpreters. Identify the different types of software. Assignment Requirements Answer the following true-or-false questions. Required Resources * Textbook Submission Requirements Submit your answers on the answer sheet provided to your instructor at the beginning of Unit 2. Unit 1 True/False Questions Indicate whether the following statements are true or false on the student answer sheet. 1) At its simplest, a database can be seen as a collection of related data. 2) A delimited file is a file where the length of the file is limited. 3) A delimited file is one in which the data is separated by a character such as a comma. 4) All fixed length files are of the same length. 5) In relational databases, logical design is kept separate from physical design. 6) A......

Words: 7907 - Pages: 32

Script

...Group 6: Script in English- August 29, 2013 Present Tense and Present Perfect Tense of the Verb Interview: Pork Barrel-To Inspire or To Expire? Members: G-10 Precious Ann R. Carandang-Interviewer G-15 Alyssa Nicole M. Dipasupil-Interviewer G-16 Jem Krizelle L. Garing- Pro-Pork Barrel B-07 Marc Aaron R. Gonzales- Pro-Pork Barrel G-19 Jaira Claire P. Jacinto- Anti-Pork Barrel B-02 John Paulo C. Buela- Anti-Pork Barrel Script: (play video clip) Precious: Pork barrel is a slang term used when politicians or governments "unofficially" undertake projects that benefit a group of citizens in return for that group's support or campaign donations. This spending mostly benefits the needs of a small select group despite the fact that the entire community's funds are being used. Alyssa: One possible derivation for the phrase comes from the practice of country stores keeping a barrel of salted pork open and available to the public. Certain high-ranking citizens would come by daily to dip into this common fund. Precious and Alyssa: Good morning everyone! I am Precious and I am Alyssa, (P)and today we will talk hear two different sides, (A)explaining why they are favor or against of this benefit.(B)This is Pork Barrel- To inspire or to expire? Precious: This morning we have two pairs of respected politicians in our country. Alyssa: You are right. Let us all welcome, Ms. Jem Krizelle Garing and Mr. Marc Aaron Gonzales for the pro-team… Precious: And Ms. Jaira Claire......

Words: 446 - Pages: 2

Database

... FUNDAMENTALS OF Database Systems SIXTH EDITION This page intentionally left blank FUNDAMENTALS OF Database Systems SIXTH EDITION Ramez Elmasri Department of Computer Science and Engineering The University of Texas at Arlington Shamkant B. Navathe College of Computing Georgia Institute of Technology Addison-Wesley Boston Columbus Indianapolis New York San Francisco Upper Saddle River Amsterdam Cape Town Dubai London Madrid Milan Munich Paris Montreal Toronto Delhi Mexico City Sao Paulo Sydney Hong Kong Seoul Singapore Taipei Tokyo Editor in Chief: Acquisitions Editor: Editorial Assistant: Managing Editor: Senior Production Project Manager: Media Producer: Director of Marketing: Marketing Coordinator: Senior Manufacturing Buyer: Senior Media Buyer: Text Designer: Cover Designer: Cover Image: Full Service Vendor: Copyeditor: Proofreader: Indexer: Printer/Binder: Cover Printer: Michael Hirsch Matt Goldstein Chelsea Bell Jeffrey Holcomb Marilyn Lloyd Katelyn Boller Margaret Waples Kathryn Ferranti Alan Fischer Ginny Michaud Sandra Rigney and Gillian Hall Elena Sidorova Lou Gibbs/Getty Images Gillian Hall, The Aardvark Group Rebecca Greenberg Holly McLean-Aldis Jack Lewis Courier, Westford Lehigh-Phoenix Color/Hagerstown Credits and acknowledgments borrowed from other sources and reproduced with permission in this textbook appear on appropriate page within text. The interior of this book was set in Minion and Akzidenz Grotesk. Copyright © 2011,......

Words: 181574 - Pages: 727

Database

... FUNDAMENTALS OF Database Systems SIXTH EDITION This page intentionally left blank FUNDAMENTALS OF Database Systems SIXTH EDITION Ramez Elmasri Department of Computer Science and Engineering The University of Texas at Arlington Shamkant B. Navathe College of Computing Georgia Institute of Technology Addison-Wesley Boston Columbus Indianapolis New York San Francisco Upper Saddle River Amsterdam Cape Town Dubai London Madrid Milan Munich Paris Montreal Toronto Delhi Mexico City Sao Paulo Sydney Hong Kong Seoul Singapore Taipei Tokyo Editor in Chief: Acquisitions Editor: Editorial Assistant: Managing Editor: Senior Production Project Manager: Media Producer: Director of Marketing: Marketing Coordinator: Senior Manufacturing Buyer: Senior Media Buyer: Text Designer: Cover Designer: Cover Image: Full Service Vendor: Copyeditor: Proofreader: Indexer: Printer/Binder: Cover Printer: Michael Hirsch Matt Goldstein Chelsea Bell Jeffrey Holcomb Marilyn Lloyd Katelyn Boller Margaret Waples Kathryn Ferranti Alan Fischer Ginny Michaud Sandra Rigney and Gillian Hall Elena Sidorova Lou Gibbs/Getty Images Gillian Hall, The Aardvark Group Rebecca Greenberg Holly McLean-Aldis Jack Lewis Courier, Westford Lehigh-Phoenix Color/Hagerstown Credits and acknowledgments borrowed from other sources and reproduced with permission in this textbook appear on appropriate page within text. The interior of this book was set in Minion and Akzidenz Grotesk. Copyright © 2011,......

Words: 181574 - Pages: 727

Script

...Script of Lovers' Path : A Tale of Cupid and Psyche Note: credits to Edith Hamilton, author of Greek Mythology Book, other writers on net which is my source of conceptualizing the details, composers and artist of all the music and sound effects for the soundtracks. Prelude : Story Teller: (Forever In Love: Sax Instrumental) Cupid and Psyche is a story about love. It is also about beauty, truth, and goodness, for these are three aspects of love: and it is about death, the hereafter, and rebirth. Its simplicity touches our hearts, and at the same time tantalizes our minds with hints of teachings that youth experienced during the higher degrees of initiation. It deals about human consciousness, with its fall from on high, its captivity in realms of material illusion, its ages-long wanderings, and its metamorphosis as it awakens and recollects with increasing clarity its divine origin and nature. Hence love endeavours to rise, as a butterfly freed from its chrysalis, into higher dimensions where it lives among the immortals.  Cupid and Psyche is indeed a story of love, a love with transcendent power to raise the soul to divine awareness. As such, this is a love story to be cherished during those dark and silent moments that sanctify our lives. : My friends……the beautiful story of Cupid and Psyche…. Music : harp and lyre instrumental ( 30 seconds) SCENE I. (open curtain – stage 1) Narration : (background music : prayer to the goddess)Olympus was the residence of the......

Words: 12812 - Pages: 52

Script

............................................................................................................................25 Notes about variables.................................................................................................................................................................26 Changing a variable’s value ...............................................................................................................................................26 Using variables to refer to existing objects ..................................................................................................................27 Making script files readable......................................................................................................................................................27 Commenting the script........................................................................................................................................................27 Continuing long lines in AppleScript and VBScript...................................................................................................29 Using Arrays ...................................................................................................................................................................................29 Creating objects...........................................................................................................................................

Words: 14237 - Pages: 57

Database

...transformation processes. In actual sense, relational database offers a solution to this menace. Data organization, keeping, storage, and retrieval among other essentials can easily be realized by adopting relational data management model. In this kind of model, tables are made use of in such a way that data items are formally described and organized according to their level of relations. The data item contained in a given table represents a relation. I am convinced beyond reasonable doubt that through the use of relational database model, an organization can be able to effectively manage their wide range of information encountered on a daily basis. Relational database model offers a more efficient means of managing data. Some of the huge benefits are discussed as follows. A relational database is a collection of relations or tables. The rows of a table in a relational database are known as tuples and each column of a table is called an attribute. By definition, a relation becomes a set of tuples having the same attributes. Operations, which can be performed on the relations are select, project and join. The join operation combines relations, the select queries are used for data retrieval and the project operation identifies attributes. The information oif the organization can be captured, manipulated, managed, and shared, and the value the database brings to the organization is immense. The advantages of a relational database are that they contribute to sound logical......

Words: 554 - Pages: 3

Script

...RIAHD 73 BES 2100 ! ! Voicing Our Values Script Case Study - BES2100 ! Ahmed Rishwan RIAHD73 ! ! ! ! Submitted to: Ms. Ayami Tennekoon
 SCRIPT CASE STUDY !1 RIAHD 73 BES 2100 Introduc)on   ! This   script   presents   a   dialogue   that   takes   place   between   a   young   man   named   Ma8hew  and  his  friend  Brad.  Ma8hew  recently  joined  a  computer  shop  where  both   Brad  was  his  superior  and  they  both  worked  the  night  shi=.     ! One  month  into  the  job,  Ma8hew  started  to  no@ce  that  Brad  was  involved  in  some   unusual   ac@vi@es   at   work.   When   asked   about   this,   Brad   explained   what   was   going   on.     ! Ma8hew  was  shocked  to  learn  that  Brad  was  involved  in  some  fraudulent  ac@vi@es.   But  he  was  unsure  of  how  to  confront  this  situa@on.  There  are  two  scenes  that  cover   this  script.  The  four  quadrant  model  in  Table  1  explains  the  characters  in  the  script   providing  a  descrip@on  of  what  they  have  at  stake  with  regard  to  the ......

Words: 1362 - Pages: 6

Script

...!The script is solid overall and succeeds in presenting a clear, interesting story. The characters are memorable and distinct. I only have a few recommendations for improving the script. !1. The relationship between Jake and Polly !I think it would be nice to have some more background on their relationship together. At some point the reason they are together should be made clear. It would raise the stakes once Antonio becomes involved and allow us to see a more complete character arc for both of them. Without it, some of the dialogue, tension, and conflicts sometimes feel a little bit forced or unrealistic, particularly on page 58, 68, and 77. Particularly on page 77, instead of saying “So I’m selfish now,” maybe Polly can say something acknowledging she made a mistake. That way, Jake will seem more in the wrong once he says something hurtful and it will make even more sense as to why Polly almost hooks up with Antonio. !2. Polly’s Transformation !Much of Polly’s transformation throughout the middle of the script seems a bit shallowly presented—merely through outfit changes and her growing acceptance of Antonio’s taboo behavior and ideas. She mentions that Jake wants to change her, but it seems more that he just wants to bring the old her back. It would be nice to have clarification on that change and why it is so hurtful to her that Jake doesn’t seem to like it. This relates to the tension I addressed in #1. I think there needs to be a moment where Polly fully recognizes...

Words: 287 - Pages: 2

Express Scripts

...Express Scripts Sharda Taylor American Intercontinental University July 25, 2015 Dr. Miller Abstract In this paper, you will read about Express Scripts and what types of services they provide and they type of business they perform. Also in this paper, you will read about their payer mix. In this paper, also you will read an analysis of their financials. Express Scripts The company Express Scripts is known for their leading home delivery, specialty pharmacy services and for having the best-known pharmacy benefit management service (Express Scripts, 2015). They manage the prescription benefits for millions of clients, health plans and plan sponsors (Express Scripts, 2015). Across the country employers, unions, and government organization tend to use one or more of Express Scripts services. According to Express Scripts (2015), their brand helps people to use prescription drugs safely and offer it to them at a more affordable price. This works out great since the country has billions of dollars in prescription drug waste due to costly drugs, pharmacies and health choices (Express Scripts, 2015). History and/or Background Express Scripts Holding was founded on July 15, 1986 and is headquartered in Saint Louis, Missouri (Forbes, 2015). In 2013, Express Scripts became a Fortune100 company and is the 20th largest company in the United States (Express Scripts, 2015). The CEO of the company is George Paz and employs more than 29,000 people....

Words: 1162 - Pages: 5

Database

...1.1 Define the following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, and transaction-processing application. • Data merupakan satu satuan informasi yang akan diolah dimana sebelum diolah dikumpulkan di dalam suatu file database. Pengumpulan data dilakukan secara sistematis menurut struktur file database. • Database merupakan kumpulan data yang terkait satu sama lain. Atau sekumpulan data yang terintegrasi yang diorganisasi untuk memenuhi kebutuhan pemakai untuk keperluan organisasi. • Dalam database pastinya mengenal istilah DBMS (Databse Management System) yang mana merupakan suatu koleksi dari program yang mana pengguna bisa mengcreate dan memaintain suatu database. Dalam DBMS terdiri atas proses-proses yang harus dilakuka nyaitu defining, constructing, manipulating dan sharing. Komponen-komponen DBMS yaitu terdiri atas hardware, software, data, prosedur, people. Fungsi dari defining yaitu DBMS harus dapat mengolah pendefinisian data. Fungsi dari manipulating DBMS harus dapat menangani permintaan-permintaan dari pemakai untuk mengakses data. Fungsi dari constructing yaitu DBMS harus mengontrol proses pengiriman data ke penyimpanan medium. Fungsi dari sharing yaitu database memperbolehkan banyak orang dan program untuk mengakses database. • Meta data: informasi terstruktur yang bertujuan untuk mendeskripsikan,......

Words: 1618 - Pages: 7

Database

...Student Database Management System Ajay Shankar Bidyarthy , Abhishek Kumar b.ajay@iitg.ernet.in kumar.ak@iitg.ernet.in November 13, 2012 Abstract: An organized and systematic office solution is essential for all universities and organizations. There are many departments of administration for the maintenance of college information and student databases in any institution. All these departments provide various records regarding students. Most of these track records need to maintain information about the students. This information could be the general details like student name, address, performance, attendance etc or specific information related to departments like collection of data. All the modules in college administration are interdependent. They are maintained manually. So they need to be automated and centralized as, Information from one module will be needed by other modules. For example when a student needs his course completion certificate it needs to check many details about the student like his name, reg number, year of study, exams he attended and many other details. So it needs to contact all the modules that are office, department and examination and result of students. With that in mind, we overhauled the existing Student Database Management System and made necessary improvement to streamline the processes. Administrators using the system will find that the process of recording and retrieving students information and managing their classes,......

Words: 4780 - Pages: 20

Database

...2 RELATIONAL MODEL: CONCEPTS, CONSTRAINTS, LANGUAGES, DESIGN, AND PROGRAMMING 5 The Relational Data Model and Relational Database Constraints This chapter opens Part II of the book on relational databases. The relational model was first introduced by Ted Codd of IBM Research in 1970 in a classic research publication "System R4 Relational." (Codd 1970), and attracted immediate attention due to its simplicity, practicality, and mathematical foundation. The model uses the concept of a mathematical relation—which looks somewhat like a table of values—as its basic building block, and has its theoretical basis in set theory and first-order predicate logic. This is a classic example where sound theoretical principles are effectively applied for strong practical advantages. In this chapter we discuss the basic characteristics of the relational model and its constraints. The first commercial implementations of the relational model became available in the early 1980s, such as the Oracle DBMS and the SQL/DS system on the MVS operating system by IBM. Since then, the model has been implemented in a large number of commercial systems. Current popular relational DBMSs (RDBMSs) include DB2 and Informix Dynamic Server (from IBM), Oracle and Rdb (from Oracle), and SQL Server and Access (from Microsoft). Some other commercial relational DBMSs used are Sybase (also known as Sybase SQL Server), Paradox, and Foxbase. Recently, some open source relational DBMSs, such as MySQL...

Words: 6699 - Pages: 27