Question

I have to write a script in sql

I have to write a script in sql

Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

A sql script is a combination of sql statement ( DDL or DML ) like create , insert , update , alter.

Mostly We write sql script using sql script editor .

Their use the following step -


1 - home page, click on SQL Workshop and then SQL Scripts.

2 - Click the Create button.


3 - Enter a name for the script in the Script Name field.

# note - Script name extensions are optional.

Now write any SQL statements, PL/SQL blocks and commands you want to execute using your script.

Click Save to save your script to the repository.

The SQL Scripts page appears listing your newly saved script.


and your sql script is ready to use.

If you have any query . Please mention in comment box.

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Save your select statements as a script. Place the semicolon at the end of each SQL...
Save your select statements as a script. Place the semicolon at the end of each SQL statement. Please number your select statements from 1 to 8 in your script and comment out each number. Include your name and student number as a comment at the top of your script. The name of the script has to be Assignment1_JohnSmith. Instead of JohnSmith use your First Name and Last Name. Upload your script trough Blackboard. Use SQL Developer to create the My...
MATLAB Programming Question How do I write a script to plot the diameter as a function...
MATLAB Programming Question How do I write a script to plot the diameter as a function of the length? I have the data imported and loaded, but not exactly sure how to write this portion.
Write a script to create the following tables with attributes as specified(SQL) Customer table with Customer’s...
Write a script to create the following tables with attributes as specified(SQL) Customer table with Customer’s id, name, address, city as varchar, customer’s date of birth as date type and zip code number where the customers id is the primary key in the table, name and date of birth are mandatory. Id has a 10-character limit, name, address and city have a 50-character limit, zip has a 5-character limit Product Table with Product id, description and finish as varchar, price...
How can I write a bash script that: Takes a series of filenames provided by the...
How can I write a bash script that: Takes a series of filenames provided by the user and moves them into their own new directory?
Write a Bash shell script highestTest.sh that will determine the highest value given to the script....
Write a Bash shell script highestTest.sh that will determine the highest value given to the script. It should take in as a command-line argument a series of numbers. This list could be of any length. Your script should start by finding the lowest value in the list of values. Then it should find how many times that value appears in total in the list. It should then output those results. In addition, I want you to detect if any fractional...
topic: oracle sql I have a database 'guitar'. I want to add a user to that...
topic: oracle sql I have a database 'guitar'. I want to add a user to that database. Please get me started at least with overview / tutorial.
For sqlite: Write a single SQL statement to list all the tracks that do not have...
For sqlite: Write a single SQL statement to list all the tracks that do not have the exact word 'time' (including both upper and lower cases) as part of the name in the Track table, but they have 'time' being part of a word in the name. For instance, it should include track names with words like 'wartime' or 'times' in the output I have to find a way to limit the exact word but the word should be part...
Purpose: The purpose of this assignment is to provide an opportunity for you to write SQL...
Purpose: The purpose of this assignment is to provide an opportunity for you to write SQL statements to create tables and insert data into tables. Skills: Learn and practice the techniques of writing SQL statements using SQL Server Management Studio(SSMS).   Knowledge: By doing this assignment you will learn to use SSMS and write SQL statements to create new tables and insert data into the tables. Tasks: Use the following figure for the tasks below: [15 points] Write SQL statements to...
1) Write SQL to return the first and last name of all actors with a first...
1) Write SQL to return the first and last name of all actors with a first name of "ADAM" (use the ACTOR table) who have: (a) an ID of 11, 16, or greater than or equal to 70 AND (b) a last name that starts with the letter H or higher (I, J, K, etc.) 2) Write SQL with the LIKE operator to return addresses that are in the "Dhaka" district and have street addresses that do not contain the...
Write the SQL queries that accomplish the tasks using the AP Database 1. Write a SQL...
Write the SQL queries that accomplish the tasks using the AP Database 1. Write a SQL statement to retrieve the InvoiceID, InvoiceDate, InvoiceTotal, BalanceDue, PaymentDate, and AgeofInvoices for the invoices that have more than 30 days of invoice age. Sort the result set by AgeofInvoice in a descending order. (Note: BalanceDue = InvoiceTotal-PaymentTotal-CreditTotal AgeofInvoice is the number of days difference between invoicedate and paymentdate.) 2. For each invoicedate that has more than one invoice, show the invoiceDate and calculate the...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT