Search & Filtering
Databases | SQL | Oracle | MS Access
Sample
DT AMT VNO VTYPE MPT
08/04/2011 11256 K0002 P M
08/04/2011 2818.75 K0002 P P
08/04/2011 2893 K0002 P P
08/04/2011 3047 K0002 P P
08/04/2011 2845.56 K0002 P P
08/04/2011 0.31 K0002 P T
08/04/2011 348 K0002 P T
We want to show the above data as per below format:
Sample
DT VNO AMT TERM PAMT
08/04/2011 K0002 11256 348.31 11604.31
DT AMT VNO VTYPE MPT
08/04/2011 11256 K0002 P M
08/04/2011 2818.75 K0002 P P
08/04/2011 2893 K0002 P P
08/04/2011 3047 K0002 P P
08/04/2011 2845.56 K0002 P P
08/04/2011 0.31 K0002 P T
08/04/2011 348 K0002 P T
We want to show the above data as per below format:
Sample
DT VNO AMT TERM PAMT
08/04/2011 K0002 11256 348.31 11604.31
Databases | SQL | Oracle | MS Access
Area of a rectangle with integer values for its sides, is 8 times its perimeter.
What are its sides ?
What are its sides ?
Databases | SQL | Oracle | MS Access
write a program which reads two numbers from user until one number is at least ten times bigger then the other.
A: print which number is bigger?
B: print the sum/difference/product of two numbers
C: print all integer numbers between the two numbers.
D: print all even numbers between these two numbers
E: print all odd numbers between these two numbers
Question number 2: create an array by the size of 10 integer numbers then print those elements that have greater value than 50.
A: list all the array elements to the console
B: search an element of an array
C: multiply the array elements to 2
A: print which number is bigger?
B: print the sum/difference/product of two numbers
C: print all integer numbers between the two numbers.
D: print all even numbers between these two numbers
E: print all odd numbers between these two numbers
Question number 2: create an array by the size of 10 integer numbers then print those elements that have greater value than 50.
A: list all the array elements to the console
B: search an element of an array
C: multiply the array elements to 2
Databases | SQL | Oracle | MS Access
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
Databases | SQL | Oracle | MS Access
Hi Sir/Madam
is it possible to get back data from mysql table after trucate table. please give me answer ASAP. its very urgent task.
is it possible to get back data from mysql table after trucate table. please give me answer ASAP. its very urgent task.
Databases | SQL | Oracle | MS Access
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>
</div>
Databases | SQL | Oracle | MS Access
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
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
Databases | SQL | Oracle | MS Access
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
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
Databases | SQL | Oracle | MS Access
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 ?
Area of a rectangle with integer values for its sides, is 8 times its perimeter.
What are its sides ?
Databases | SQL | Oracle | MS Access
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.
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.
