Databases | SQL | Oracle | MS Access Answers

i need support for recovery data from innodb files , i lost the database folder and i have ony 3 files idbata1 id_log0 and id_log1

Well my question is about this. I dont know what it is saying. here is the link to the image.& <div>So if u can please help me or do it for me over teamviewer.</div><div><img src="https://www.assignmentexpert.com//assignments/uploaded_files/static/1c/fe/1cfe00391d23c9cbe6e234a839998881.bmp" title="" alt="">
</div>

I have to create a procedure for checking out movies and in this section of code i have to define three parameter and i am wondering if i did it right:
create or replace procedure movie_rental_sp(
mrs_movieid mm_movie.movie_id%TYPE,
mrs_memberid mm_member.member_id IN mm_member%TYPE,
mrs_paymenttype mm_pay_type.payment_method%TYPE,
mrs_movieqty mm_movie.movie_qty)
IS

I have to validate that these data exist
movie id = 13
member id = 10
payment method = 2

BEGIN
IF mrs_movieid = 13
then
ELSE IF
DBMS_OUTPUT.PUT_LINE('There is no movie with ID: '||movie_id||'Cannot proceed with rental.');
(IF mrs_memberid = 10
then
ELSE IF;
DBMS_OUTPUT.PUT_LINE('There is no member with ID: ||member_id||' Cannot proceed with rental.');
(IF mrs_paymentmethod = 2
then
ELSE IF
DBMS_OUTPUT.PUT_LINE('We don't have '||payment_method||' as a payment method.');
(IF mrs_movieqty => 0
then
ELSE IF
DBMS_OUTPUT.PUT_LINE('We don't have enough copies of said movie.' );
END IF;)
END IF;)
END IF;)
END IF;
i'm pretty sure i need more code but im not sure what to put

Write a PL/SQL program to solve the following

Area of a rectangle with integer values for its sides, is 8 times its perimeter.
What are its sides ?

I've got a table(kills) that contains every individual kill made on my game server (killer, killed_by, timeOfKill, killer_userID etc..)

I want to create a leaderboard from this information, I've had a look through some leaderboard threads/questions and they all seem to be created from already summed values (eg. Each user would already have their kills totaled) and that's fine but my dataset won't be that big for a while so I'm happy to calculate it on the fly.

Also there are records in the kills table that need to be excluded such as kills by environment and such but I believe that can be easily handled with a:

WHERE killed='playerType' AND killed_by NOT IN (<list of environment IDs>)

So basically I need to sum each separate user ID (which I'm not sure how to do) then order,limit and display them (which I'm fine with).

Note: There is no total of kills for each user, each kill is a separate entry in the kills table.

For each student count the number of courses he or she has taken: Got this one it is SELECT Name, COUNT(CourseNumber) AS Course_Count FROM STUDENTS LEFT JOIN COURSES ON STUDENTS.STudentID=COURSES.Student ID GROUP BY Name;
Having problems with: Modify the above query to only count CMIS Courses (a coursenumber is ex. CMIS345) Hint: You'll need to use the SUBSTR function on the COURSENUMBER column to extract the first four letters. then compare this to 'CMIS'

Researching the concepts and technology of data ETL (Extraction, Transformation&Loading) and document the process from start to finish using Microsoft SSIS (SQL Server Integration Services) as the basis of your study. could you tell me the indepth steps contained on Transforming Data.
also what example could i provide on this thanks

I need the SQL query for display the string after @ symbol
Ex: example@hh.com then I want only 'hh.com.'

Had have Sql Server 2005 installed on my sys?
Today morning when i started management studio
an error msg popuped saying cannot find sp_configure stored procedure.
so how can i add the missing sp_configure stored procedure back in master Database ?