Write syntax to create view.

Write syntax to create view.
by

1 Answer

Answer :

Create view <view name> as select <query> OR

CREATE VIEW name ASSELECT column1, column2.....FROM table_nameWHERE [condition];
by

Related questions

Write Syntax for create table.

Description : Write Syntax for create table.

Last Answer : Syntax of Create table: CREATE TABLE table_name(  column1 datatype (size),  column2 datatype(size),  column3 datatype(size),  ..... columnNdatatype(size)  );

Describe the use of primary key and unique key constraints with example?

Description : Describe the use of primary key and unique key constraints with example?

Last Answer : There are two Entity constraints: 1.Primary Key constraint 2. Unique Constraint 1. Primary Key constraint: It is use to avoid redundant/duplicate value entry within the row of specified column in ... TABLE PERSONS (P_ID NUM CONSTRAINT P_UK UNIQUE , FIRSTNAME VARCHAR(20), CITY VARCHAR(20) );

State the use of sequence.

Description : State the use of sequence.

Last Answer : A sequence refers to a database object that is capable of generating unique and sequential integer values. Syntax: Create sequence [increment by num][start with num] [maxvaluenum] [ ... can be used for multiple tables. * Sequence numbers are stored and generated independently of tables

State the properties of Transaction

Description : State the properties of Transaction

Last Answer : The ACID properties of transaction. 1. Atomicity. 2. Consistency. 3. Isolation.  4. Durability

Enlist different types of database users.

Description : Enlist different types of database users.

Last Answer : Database users are the one who really use and take the benefits of database. There will be different types of users depending on their need and way of accessing the database. 1. Application Programmers 2. Sophisticated Users 3. Specialized Users 4. Native Users/ Naïve Users

List the types of Cursor.

Description : List the types of Cursor.

Last Answer : Cursor: A cursor is a temporary work area created in the system memory when a SQL statement is executed. Types of Cursor: 1.Implicit Cursor 2.Explicit Cursor

State the use of ‘Like’ Operator.

Description : State the use of ‘Like’ Operator.

Last Answer : The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. There are two operator often used in conjunction with the LIKE operator:  %:The percent sign represents zero, one, or multiple characters  _: The underscore represents a single character.

Choose the correct syntax to create an E_mail link. (a) <a href = “[emailprotected]”> -Technology

Description : Choose the correct syntax to create an E_mail link. (a) -Technology

Last Answer : (b)

An Assertion is a predicate expressing a condition we wish database to always satisfy. The correct syntax for Assertion is : (A) CREATE ASSERTION ‘ASSERTION Name’ CHECK ‘Predicate’ (B) CREATE ASSERTION ‘ASSERTION NAME’ (C) CREATE ASSERTION, CHECK Predicate (D) SELECT ASSERTION

Description : An Assertion is a predicate expressing a condition we wish database to always satisfy. The correct syntax for Assertion is : (A) CREATE ASSERTION ‘ASSERTION Name’ CHECK ‘Predicate’ (B) CREATE ASSERTION ‘ASSERTION NAME’ (C) CREATE ASSERTION, CHECK Predicate (D) SELECT ASSERTION

Last Answer : (A) CREATE ASSERTION ‘ASSERTION Name’ CHECK ‘Predicate’ 

What is function definition? (OR) what is user defined function? (OR) Write syntax of user defined function?

Description : What is function definition? (OR) what is user defined function? (OR) Write syntax of user defined function?

Last Answer : Function Definition : The program module that is written to achieve a specific task is called function definition. Syntax : type function-name(parameter list) // function header. { declaration of variables; body of function; // ... and b ); scanf( %d%d ,&a,&b); c=a+b; printf( %d ,c); }

Write syntax to define a derived class

Description : Write syntax to define a derived class

Last Answer : Syntax: class derived_class_name : visibility_mode/access_specifier base_class_name { class body };

Write the syntax of switch case statement.

Description : Write the syntax of switch case statement. 

Last Answer : switch(variable) { case value1: statements break; case value2: statements; break; . . . default: statements; break; }

Define pointer. Write syntax for pointer declaration.

Description : Define pointer. Write syntax for pointer declaration.

Last Answer : Definition: A pointer is a variable that stores memory address of another variable which is of similar data type.  Declaration: datatype *pointer_variable_name; 

Write syntax and use of pow ()function of <math.h> header file.

Description : Write syntax and use of pow ()function of header file.

Last Answer : pow()- compute the power of a input value Syntax: double pow (double x, double y);

Write syntax and example of : 1) drawRect() 2)drawOval()

Description : Write syntax and example of : 1) drawRect() 2)drawOval()

Last Answer : 1)drawRect() : drawRect () method display an outlined rectangle. Syntax: void drawRect(int top,int left, int width,int height) The upper-left corner of the Rectangle is at top and left. The ... and height the following program draws several ellipses and circle. Example: g.drawOval(10,10,50,50);

Write the syntax of try-catch-finally blocks.

Description : Write the syntax of try-catch-finally blocks.

Last Answer : try{ //Statements to be monitored for any exception } catch(ThrowableInstance1 obj) { //Statements to execute if this type of exception occurs } catch(ThrowableInstance2 obj2) { //Statements }finally{ //Statements which should be executed even if any exception happens }

Write syntax for following commands: i)Sleep ii)Kill

Description : Write syntax for following commands: i)Sleep ii)Kill

Last Answer : i)sleep Syntax: sleep NUMBER[SUFFIX]… sleep OPTION ii) kill Syntax: kill pid

Write the syntax of entity and architecture used in VHDL and explain it.

Description : Write the syntax of entity and architecture used in VHDL and explain it.

Last Answer : Entity declaration: It defines the names. Input output signals and modes of a hardware module. Also it provides the external interface of an entity. It is a black box view. Syntax ... _name of entity_ name  Architecture_ declaration_ name;  begin  Statement;  end architecture_ name;

A room with no view. How do you create a view or simply detract from this issue?

Description : A room with no view. How do you create a view or simply detract from this issue?

Last Answer : answer:A picture of the room would help a lot here. What do you want the room to be? Do you want a garden room, a music room or a reading room etc. You could go the route of taking the ... herbs will better grow, give a focal point to the room and give you privacy while keeping light. Product Here

In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction? A. CREATE PACKAGE B. CREATE SCHEMAC.CREATE CLUSTERD.All of theaboveE.None of the above;

Description : In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction? A. CREATE PACKAGE B. CREATE SCHEMA C. CREATE CLUSTER D. All of theabove E. None of the above;

Last Answer : CREATE SCHEMA

A solid created by rotating a planar-shape about an axis is called a “Surface of Revolution”. The figure below shows a shape and the axis of revolution which is used to create such a solid. Which of the options would be the correct top view of this solid?

Description : A solid created by rotating a planar-shape about an axis is called a “Surface of Revolution”. The figure below shows a shape and the axis of revolution which is used to create such a solid. Which of the options would be the correct top view of this solid? 

Last Answer : B

Is there a syntax or word construction plug-in for Microsoft Office Mac?

Description : Is there a syntax or word construction plug-in for Microsoft Office Mac?

Last Answer : answer:Have you tried the grammar checker included with Word? Microsoft Office for Mac 2011 – Check spelling and grammar in a different language link

Any web references for correct syntax use?

Description : Any web references for correct syntax use?

Last Answer : It’s unclear whether you want this in English or Italian, but I think what you’re looking for is a reference for idioms. If you google the word, you’ll find many out there. Here’s one that has lots of examples: The Idiom Connection .

What's the correct syntax for linking to an HTML page on your local C: drive from an <A HREF=> tag in a HTML page on your desktop?

Description : What's the correct syntax for linking to an HTML page on your local C: drive from an tag in a HTML page on your desktop?

Last Answer : try using \ instead of / for starters…

What is the right access 2007 sql syntax for adding the last record of another table?

Description : What is the right access 2007 sql syntax for adding the last record of another table?

Last Answer : INSERT INTO samples (id_sample) SELECT Last(project.Id) AS LastOfId FROM project I tested this and it works. One nice thing about Access is you can use the graphical query designer to test your syntax. The ... View if you prefer text over the GUI. It will not run or save your query if errors exist

Syntax for a Linux task, please. I am not familiar with the OS.

Description : Syntax for a Linux task, please. I am not familiar with the OS.

Last Answer : Did you get a chance to read over something like this?

My calculator keeps saying syntax error over 10.2x10^12 why?

Description : My calculator keeps saying syntax error over 10.2x10^12 why?

Last Answer : ok it works if I type in x10^12 but if I use the button x10^x it gives a syntax error.

Changing syntax highlighting in Emacs?

Description : Changing syntax highlighting in Emacs?

Last Answer : Yes, it is, but it’s a complicated process that requires you to know how your major-mode parses whatever language you’re working in. Syntax highlighting annoys me, so I turn it off and can’t give you much more info than that.

Can someone please explain the origins and syntax of using "something fierce" at the end of a phrase?

Description : Can someone please explain the origins and syntax of using "something fierce" at the end of a phrase?

Last Answer : To want something very badly.

Why do many gay men speak with similar inflections and syntax, regardless of place of origin, ethnicity, or age?

Description : Why do many gay men speak with similar inflections and syntax, regardless of place of origin, ethnicity, or age?

Last Answer : Because it's a learned cultural affectation. My understanding is that as the gay rights movement became more visible in the late 60s in urban centers like NY and San Francisco, the very vocal/visible ... affluent kids in the suburbs, emulating kids in the inner city. It's all just learned behavior.

The general syntax for inline image is <img src = “file name” >. -Technology

Description : The general syntax for inline image is . -Technology

Last Answer : True At the place of the file name, the path of the image is specified. If the image is in the same folder as HTML file, it is not needed to specify the full path of an image.

Which one of these is correct syntax of the declaration, that defines the XML version? -Technology

Description : Which one of these is correct syntax of the declaration, that defines the XML version? -Technology

Last Answer : (a) is a correct syntax of the declaration.

An XML document that follows the XML syntax is called a -Technology

Description : An XML document that follows the XML syntax is called a -Technology

Last Answer : (b) well-formed XML document

What is Syntax in coding? -Web-Development

Description : What is Syntax in coding? -Web-Development

Last Answer : In easy terms, syntax can be called "Grammar in Programming". Like Grammar in English, The grammar and spelling in Coding languages is Syntax In other words, it means using character structures ... proper syntax, it generates syntax error, usually causing the program to fail.See the Python Syntax

What's wrong with syntax ?

Description : What's wrong with syntax ?

Last Answer : Grammatical errors in program language are usually called syntax errors. For example: misspellings , commas , no brackets, etc.

What does Syntax mean ?

Description : What does Syntax mean ?

Last Answer : Syntax means syntax.

Who wrote the syntax ?

Last Answer : Written by Humayun Azad.

GDScript vs ActionScript, syntax differences?

Description : GDScript vs ActionScript, syntax differences?

Last Answer : GDScript has been the official language of Godot for a long time and it is more stable, C# on the other hand gives you the ability to use all features available in . Net framework / Mono But since C# is new to Godot, it has a Lot of issues and bugs.

A _____ contains specific rules and words that express the logical steps of an algorithm. 1) Syntax 2) Programming structure 3) Programming language 4) Logic chart 5) None of these

Description : A _____ contains specific rules and words that express the logical steps of an algorithm. 1) Syntax 2) Programming structure 3) Programming language 4) Logic chart 5) None of these

Last Answer : Answer :3

What are the stages in the compilation process? A) Feasibility study, system design and testing B) Implementation and documentation C) Lexical Analysis, syntax analysis, and code generation D) None of the above

Description : What are the stages in the compilation process? A) Feasibility study, system design and testing B) Implementation and documentation C) Lexical Analysis, syntax analysis, and code generation D) None of the above

Last Answer : Answer : C

When an algorithm is written in the form of a programming language, it becomes a _________ a) Flowchart b) Program c) Pseudo code d) Syntax

Description : When an algorithm is written in the form of a programming language, it becomes a _________ a) Flowchart b) Program c) Pseudo code d) Syntax

Last Answer : Answer: b Explanation: An algorithm becomes a program when it is written in the form of a programming language. Thus, any program is an algorithm

Which of the following is incorrect? Algorithms can be represented: a) as pseudo codes b) as syntax c) as programs d) as flowcharts

Description : Which of the following is incorrect? Algorithms can be represented: a) as pseudo codes b) as syntax c) as programs d) as flowcharts

Last Answer : Answer: b Explanation: Representation of algorithms: -As programs -As flowcharts -As pseudo codes

The word ____________comes from the name of a Persian mathematician Abu Ja’far Mohammed ibn-i Musa al Khowarizmi. a) Flowchart b) Flow c) Algorithm d) Syntax

Description : The word ____________comes from the name of a Persian mathematician Abu Ja’far Mohammed ibn-i Musa al Khowarizmi. a) Flowchart b) Flow c) Algorithm d) Syntax

Last Answer : Answer: c Explanation: The word algorithm comes from the name of a Persian mathematician Abu Ja’far Mohammed ibn-i Musa al Khowarizmi

The rules that give meaning to the instructions. a) Semantics b) Syntax c) Code d) Cases

Description : The rules that give meaning to the instructions. a) Semantics b) Syntax c) Code d) Cases

Last Answer : Answer: a Explanation: The answer is semantics. They are the rules that give meaning to the instructions. Syntax is the formal rules that ensure validation of code

The formal grammar rules governing the construction of valid instruction. a) test case b) syntax c) program d) semantics

Description : The formal grammar rules governing the construction of valid instruction. a) test case b) syntax c) program d) semantics

Last Answer : Answer: b Explanation: Syntax determines the grammatical rules in a code. Semantics give meaning to the instructions

What is syntax for dropping a procedure and a function .Are these operations possible?

Description : What is syntax for dropping a procedure and a function .Are these operations possible?

Last Answer : Drop Procedure procedure_name Drop Function function_name

What are logical errors and how does it differ from syntax errors?

Description : What are logical errors and how does it differ from syntax errors?

Last Answer : Program that contains logical errors tend to pass the compilation process, but the resulting output may not be the expected one. This happens when a wrong formula was inserted into the code, or ... the other hand, deal with incorrect commands that are misspelled or not recognized by the compiler.

What is syntax error?

Description : What is syntax error?

Last Answer : Syntax errors are associated with mistakes in the use of a programming language. It maybe a command that was misspelled or a command that must was entered in lowercase mode but was instead entered with an ... symbol, or lack of symbol, somewhere within a line of code can also lead to syntax error.

What is the syntax to inherit from a class in C#?

Description : What is the syntax to inherit from a class in C#? 

Last Answer : Place a colon and then the name of the base class. Example: class MyNewClass : MyBaseClass

What’s the C# syntax to catch any possible exception?

Description : What’s the C# syntax to catch any possible exception?

Last Answer : A catch block that catches the exception of type System.Exception. You can also omit the parameter data type in this case and just write catch {}.