i amm trying to do some work in sql developer   insert data from nametest to names  i want only to insert year ,name and gender ,then create a id for each data in the databse . what commend shouldi  use ?  i try "INSERT INTO names (Year, Name, gender), SELECT (Year_, name_, genderA) FROM namestest; it shows  Error starting at line : 1 in command - INSERT INTO names (Year, Name, gender), SELECT (Year_, name_, genderA) FROM namestest Error at Command Line : 2 Column : 21 Error report - SQL Error: ORA-00926: missing VALUES keyword 00926. 00000 -  "missing VALUES keyword" *Cause:     how to make it corrrect ?and make a "id "for each data ?

Q: Display the list of students who are involved in the IT club Display the details of all the…

A: First get the studid from Club table and then get those Student details This can be done using inner…

Q: BOOK_NUM Times Checked Out BOOK_NUM TIMES Checked Out 5236 12 5236 12 No under score line 5235 5235…

A: SELECT  BOOK_NUM, COUNT(check_out_DATE) AS "Times Checked Out " FROM  CHECKOUT GROUP BY BOOK_NUM…

Q: The given SQL creates a Song table and inserts some songs. The SELECT statement selects all songs.…

A: SQL stands for Structured Query Language.

Q: Return how many artists are currently in the band, how many artists have ever been in the band (be…

A: To work with relational databases, you must use SQL. Records in databases can be added, searched…

Q: My SQL: The Car Maintenance team wants to add new maintenance tasks into the system. The team has…

A: This query selects all cars from the CARS table with a model year of 2021 and a manufacturer of…

Q: what commend can i use to delete all the nulls ?

A: To find which command use to delete all the nulls.

Q: Write a SQL code that returns the Name of ALL Customers (based on CUS_FNAME and CUS_LNAME in…

A: The question is solved in step2

Q: We have employee table contains (emp-no, emp-name, emp-age, emp-salary, emp-department) write a…

A: Given Employee table contains the attributes: emp_no, emp_name, emp_age, emp_salary, emp_department

Q: Please written by computer source 1. For this project, you need to create the company database and…

A: Step 1: Create the Company Database Open the Oracle SQL PLUS environment and create a new database…

Q: the HR department needs the department name, manager first name, manager last name, and job title.…

A: SQL: SQL stands for Structuref Query Language. It is used to access and manipulate the database…

Q: obtain the name and credit limit of the customer whose number currently is stored in I_CUSTOMER_NUM.…

A: I have answered this question in step 2.

Q: What is the query used to see if the date format is same and find values other than dates in the…

A: I am giving some examples along with queries to explain this. Suppose:…

Q: Create a PL/SQL function to increment the salary of all employees of an organization by 15%, and for…

A: Creating a PL/SQL function to increment the salary of all employees of an organization by 15%, and…

Q: Write PL/SQL or T-SQL procedures to accomplish the following tasks: A: obtain the name and credit…

A: Actually, SQL stands for Structured Query Language.

Q: Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows: A) FUNCTION:…

A: A) : create function Return_region_name { @region_id num, } returns varchar as begin  (select name…

Q: Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows: a) Group all…

A: Process To display the all the data we use select * from tablename and condition what we want to get…

Q: Students Table : • List of all Students, just FirstName, LastName and gpa, with a C avg(2.0 to…

A: ANSWER: Student Table: Syntax of SQL Table Statement

Q: In the preceding PL/SQL block, determine the values and data types for each of the following cases.…

A: PL/SQL block, the values and data types for each of the following cases are:   a) The value of…

Q: UPDATE NONCAT SET Category =NULL WHERE ITEM_ID = UF39; Task 7: In the NONCAT table, change the…

A: Solution: UPDATE NONCAT SET Category =NULL WHERE ITEM_ID = 'UF39';

Q: For each band that currently has a female member: Return the name of the band and each artist's…

A: The question has asked us to join three tables, namely, p_artist, p_band, and p_member, based upon…

Q: Write and execute a SQL query to list all patient numbers and encounter ids which do not have any…

A: Actually, SQL stands for Structured Query Language.

Q: Write a function and a call program in PL/SQL to sum the even integers between 1 and any number that…

A: given to write pl/sqlprocedure function for sum of 1 to n even numbers: Below is the procedure of…

Q: Translate the following SQL query to a pandas statement in Python so that it can be executed on the…

A: count(*)-count number of rows satisfying the condition sqldta-table name conditions;- case>1000…

Q: The given SQL creates a Song table and inserts three songs. Write three UPDATE statements to make…

A: Solution - (Note:   all data used in this solution is dummy.) Song table at starting -     Task 1:…

Q: Obtain the name and credit limit of the customer whose number currently is stored in I_CUSTOMER_NUM.…

A: Answer:-

Q: They need all the service requests with the category of Plumbing (category number 1) and Heating…

A: The given requirement is to be solved in the form of SQL command where the only service requests are…