(SQL Coding) Run the command to Query the data dictionary USER_VIEWS, showing only the view name...

Question

Question

(SQL Coding) Run the command to Query the data dictionary USER_VIEWS, showing only the view name...

(SQL Coding)

Run the command to Query the data dictionary USER_VIEWS, showing only the view name and the text column.

engineering Computer-Science

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

Hi,

Execute the following commands one after other you will get the output.

COLUMN view_name FORMAT A30
COLUMN text FORMAT A50
SELECT view_name, text2 FROM USER_VIEWS;

Add a comment

Answer 2

Similar Homework Help Questions

Create sql query command for the following. Modify your query and produce the following results. Customer...

Create sql query command for the following. Modify your query and produce the following results. Customer #000000001 1 1428873.61 9 Customer #000000002 2 1156504.92 10 Customer #000000004 4 4134567.39 31 Customer#000000005 5 1084042.74 9 Customer #000000007 7 3922020.98 24 Column 1 is the customer Name, Column 2, is the customer key, column 3 is the total of the customer orders ($$) and column 4 is the number of orders.
(SQL Coding) Create a read only view called: VIEW_EMPS_NO_SAL Have the view show all of the...

(SQL Coding) Create a read only view called: VIEW_EMPS_NO_SAL Have the view show all of the data from the employee table and the department id and department name from the departments table. Do not show the salary and commission percent from the o_employees table.
I need to write an SQL statement to run this query: SALES has the following column...

I need to write an SQL statement to run this query: SALES has the following column names: vendorid, name, upc, move, price, qty, year, store the table name is SALES... the sales is not a column in the SALES so it needs to be created in the query with the formula as well. QUESTION BELOW: Query 4: Return the vendor id, vendor name, product UPC code, move, and sales (price * move/qty) for each product sold by store 100 in...

Please access to TUN SQL/Assistant using the default database = db_pvfc12_std 1.- Run a query to...

Please access to TUN SQL/Assistant using the default database = db_pvfc12_std 1.- Run a query to retrieve all the data field from db_pvfc12_std in table CUSTOMER_T 2.- Run a query to retrieve record --> CustomerID = 11, How many records did you get and why? 3.- Run a query to retrieve all the data field from table Order_T Once retrieved: 3.1.- Please name the fields showing: Primary Key, Foreign Key and other fields 3.2.- What type of...
SQL Question: 1：The SCRIPT...AS command in the SSMS will A. Execute a command to create the...

SQL Question: 1：The SCRIPT...AS command in the SSMS will A. Execute a command to create the object. B. Retrieve the properties of the object. C. Retrieve a data result-set. D. Create a query script of the object. 2：As queries are written, if the IntelliSense is enabled in the SSMS, there will be A. Indents added to the second line. B. Comments automatically added. C. Table and column options. D. New query windows available.
For this hands-on project, you will use the SQL Server named instance SQLSERVERHOA, and the HandsOnOne...

For this hands-on project, you will use the SQL Server named instance SQLSERVERHOA, and the HandsOnOne database and tables you created in previous chapters. The objective of this activity is to practice generating keys and encrypting/decrypting data. Document each step by taking a screen shot of the Query Editor window after successfully executing each SQL query. 1.In SQL Server Management Studio, open a new Query Editor window, which you will use for completing all steps in this activity. 2.Create a...

WRITE A SQL QUERY SQL SERVER Write a SELECT statement that returns one column from the...

WRITE A SQL QUERY SQL SERVER Write a SELECT statement that returns one column from the Customers table named FullName that joins the LastName and FirstName columns. -- Format this column with the last name, a comma, a space, and the first name like this: -- Doe, John -- Sort the result set by last name in ascending sequence. -- Return only the contacts whose last name begins with a letter from M to Z. -- ...
SQL query: Write an SQL query that will output the last name, employee id, hire date and department from the employee table. Pick only those employees whose department ID is specified in the employee...

SQL query: Write an SQL query that will output the last name, employee id, hire date and department from the employee table. Pick only those employees whose department ID is specified in the employee table. If the employee id is 777, name is ABC and hire date is 01-JAN-2016, the output should look as follows - 'Stephen (Employee ID - 777) was hired on the 1st of January, 2016 – Department: 90'. Note - The date should not have preceding...
QUESTION 1 Match the following: an SQL command that retrieves data A. Communicate B. RETRIEVE C....

QUESTION 1 Match the following: an SQL command that retrieves data A. Communicate B. RETRIEVE C. exception D. ReadFile E. STORE F. array G. try - catch block H. Connection I. Disconnect0) J. StreamReader K. Respond L. SQL M. Fork N. Query O. BlowUp P. SELECT Q. Close0 R. StreamWriter S. WriteFile T. UPDATE an SQL command that changes data ., class that can be used to read data from a file , establishing communication with a database a method...

1. Given the table above, write an SQL Query that will select only those individuals that...

1. Given the table above, write an SQL Query that will select only those individuals that scored 800 or higher, sorted by last name in ascending order. 2. Given the table above, write an SQL Query that will add a new entry for John Smith with a score of 834. The field id is auto incrementing. 3. Given the data below, write an SQL Query that will delete any values where the score is below 740. id Fname Lname Score...

(SQL Coding) Run the command to Query the data dictionary USER_VIEWS, showing only the view name...

Homework Answers

Add Answer to:
(SQL Coding) Run the command to Query the data dictionary USER_VIEWS, showing only the view name...

Post as a guest

Earn Coins

Create sql query command for the following. Modify your query and produce the following results. Customer...

(SQL Coding) Create a read only view called: VIEW_EMPS_NO_SAL Have the view show all of the...

I need to write an SQL statement to run this query: SALES has the following column...

Please access to TUN SQL/Assistant using the default database = db_pvfc12_std 1.- Run a query to...

SQL Question: 1：The SCRIPT...AS command in the SSMS will A. Execute a command to create the...

For this hands-on project, you will use the SQL Server named instance SQLSERVERHOA, and the HandsOnOne...

WRITE A SQL QUERY SQL SERVER Write a SELECT statement that returns one column from the...

SQL query: Write an SQL query that will output the last name, employee id, hire date and department from the employee table. Pick only those employees whose department ID is specified in the employee...

QUESTION 1 Match the following: an SQL command that retrieves data A. Communicate B. RETRIEVE C....

1. Given the table above, write an SQL Query that will select only those individuals that...

(SQL Coding) Run the command to Query the data dictionary USER_VIEWS, showing only the view name...

Homework Answers

Add Answer to: (SQL Coding) Run the command to Query the data dictionary USER_VIEWS, showing only the view name...

Post as a guest

Earn Coins

Add Answer to:
(SQL Coding) Run the command to Query the data dictionary USER_VIEWS, showing only the view name...