oracle sql practice exercises

"annual Salary"From EMP ORDER by 3 DESC;SELECT ename,job,sal from emp ORDER by Job,sal DESC;SELECT ename,job,sal from emp ORDER by Empno;Modify Default display widthSET line[size] {80|n}SET Line 100L display the SQL statement in the buffer you just enteredN Text modified section of error'/' (run) commandSAVEGET@ or Start command when the specified script file contents are loaded into the SQL buffer to runS

, AVG (degree) as average from score where Cno like ' 3% ' GROUP by Cno have Count (Cno) >5; 13, the query score is greater than 70, less than 90 of the SNO column. SELECT * from score where degree between and 90; 14. Sname, CNO and degree columns for all students are queried. Select S.sname,c.cno,c.degree from student S, score C where S.sno=c.sno; 15. Check the SNO, CNAME and degree columns of all students. Select C.sno,q.cname,c.degree from student S, score c,course Q where S.sno=c.sno and q.c

/volnet/plsqldev.ico) 7.3.2 to eliminate the black command-line window, you can also write the following bat file directly: set nls_lang=simplified Chinese_china. Zhs16gbkStart plsqldev.exe This will not show a black command-line window. The same way to modify the icon. I'm also in the study of how applications that you write can be deployed in a free-to-install manner, and this link is worth referencing: http://www.oracle.com/technetwork/issue-archive/2008/08-nov/o68odpnet-101744.html For the

, Add_months (hiredate,12*10) as service life date from EMP;--Show employee details, sorted by nameSELECT * from emp order by ename;-Show the employee's name, according to their service life, the oldest employees in the frontSelect ename from emp order BY hiredate Desc;--Displays the names, jobs, and salaries of all employees, sorted in descending order of work, sorted in ascending order by salarySelect Ename,job,sal from emp order by job desc,sal ASC;--Displays the names of all employees and th

operation:Back Time-Front timeDate subtraction The default result is the difference in daysMonths_between (Back Time-front time)Months_between default return result is the number of months differenceB. Value of date takenExtract functionExtract (year from Sysdate)3. Paging QueryRownum:oracle-specific keywords for pagingA. Nested implementation paging QueryPaged queries are nested with two queries, internal queries are used to specify upper bounds, and result sets return rownum, and external que

application requires transactional integrity. ==================================== Save Point If necessary, You can also use the savepoint (savepoint) in a transaction to create a tag at a key point in the current transaction, and in the future you can roll back to the specified token (savepoint) to implement a partial rollback of the transaction. For example: INSERT into Dept VALUES (' Adv ', ' Beijing '); INSERT into Dept VALUES (, ' Sec ', ' Shanghai '); SavePoint p1; INSERT into De

20-feb-81 1600 300 307521 WARD salesman 7698 22-feb-81 1250 500 307654 MARTIN salesman 7698 28-sep-81 1250 1400 307698 BLAKE MANAGER 7839 01-may-81 2850 307844 TURNER salesman 7698 08-sep-81 1500 0 307900 JAMES Clerk 7698 03-dec-81 950 306 rows selected.Define and UndefineSql> Define Name=enameSql> select name,sal from emp;Ename SAL---------- -----SMITH 800ALLEN 1600WARD 1250JONES 2975MARTIN 1250BLAKE 2850CLARK 2450SCOTT 3000KING 5000TURNER 1500ADAMS 1100JAMES 950FORD 3000MILLER 1300Rows select

A code block for the basic introduction to PL/SQLPL/sql: Process language (Procedure Language) and structured language (structured Query Language) A combined programming language is an extension to SQL that supports a variety of data types such as large objects and collection types, using control statements such as conditions and loops, creating stored procedures, packages, triggers, and so on, to

The Oracle tutorial you are looking at is the Oracle Pl/sql introductory case practice. We have already learned the basics of pl/sql programming, and this article will combine a case to deepen understanding of these knowledge points. A Case Introduction A database has two

, Add_months (hiredate,12*10) as service life date from EMP;--Show employee details, sorted by nameSELECT * from emp order by ename;-Show the employee's name, according to their service life, the oldest employees in the frontSelect ename from emp order BY hiredate Desc;--Displays the names, jobs, and salaries of all employees, sorted in descending order of work, sorted in ascending order by salarySelect Ename,job,sal from emp order by job desc,sal ASC;--Displays the names of all employees and th

optimizer is the core of SQL execution, it makes the execution plan is good or bad, directly determines the efficiency of SQL execution. There are two types of Oracle optimizer: RBO (rule-based Optimization): rule-based Optimizer CBO (cost-based Optimization): Cost-based Optimizer Starting with Oracle 10g, RBO has bee

Learned the simplest kinds of statements, but also installed a few times the database, was looking at that high-level programming, but there is a primer did not see, and then read the first to say,More practice, familiar with the most basic operation. I used to log in before using Conn carriage return, and then enter the password, this document is the first one to introduce another method of login. Conn Scott/xxThis will be directly logg

and code snippets that contain the vulnerability cannot be compiled. Many of the patches for the GCC compiler provide these features, such as Stackguard, and so on.4. Database injection Attack tool bSQL Hacker?? bSQL Hacker was developed by Portcullis Labs, and bSQL Hacker is a SQL auto-injection tool (which supports SQL blinds) designed to allow SQL overflow in

is not NULLORDER by Score DESC --second, the polymerization function exercises--1, statistics SELECT COUNT (SNO)From A_studentinfo;--2, statistics SELECT COUNT (Sno) from A_studentinfo WHERE 2016-yearofbirth > 30;--3, statistics SELECT COUNT (SNO)From A_studentinfoWHERE enrollment between to_date (' + ', ' yyyy ') andTo_date (' n ', ' yyyy ');--4, Statistics SELECT Sno, AVG (Score)From A_studentcourseGROUP by SnoHaving sno = ' S001 ';--5, Statistics

Tags:--SQL database Password control hack search type inject log ali sig the 1th section studies the principle of buffer overflow, at least for two kinds of database differential study 1.1 principle Inside the computer, the input data is usually stored in a temporary space, the temporary storage space is called a buffer, the length of the buffer has been pre-defined by the program or the operating system. Fill the buffer with data, if the l

cursor defined with the cursor...is command that can handle multiple records returned by a SELECT statement.Implicit cursors: When you perform an INSERT, delete, UPDATE, and a query that returns a single record, the SELECT INTO statement is automatically defined by PL/SQL, and an implicit cursor is also called a SQL cursor. (2)Oracle explicit cursors are divid

Oracle Notes (11) Build table, update, query comprehensive exercisesThere is a database of information about a student sports meeting, and the following tables are saved: Athlete Sporter (athlete number Sporterid, athlete name name, athlete sex sex, Affiliation department number Department) Item Item (Project number itemid, project name ItemName, Project match location) Score Grade (athlete ID, item number itemid, points mark) Us

to small.41. Query "male" teachers and their courses.42. Check the SNO, CNO and degree columns of the students with the highest score.43, inquiries and "Li June" with the gender of all students sname.44, inquiries and "Li June" with the same sex and classmates sname.45. Check the scores of all "male" students who took the "Introduction to Computer" course SQL Statement Exercises Reference answers1, select

, CNO and degree columns of the students with the highest score.43, inquiries and "Li June" with the gender of all students sname.44, inquiries and "Li June" with the same sex and classmates sname.45. Check the scores of all "male" students who took the "Introduction to Computer" course SQL Statement Exercises Reference answers1, select Sname,ssex,class from Student;2, select distinct depart from teacher;3,

Tags: PL/SQL structure exercisesPL/SQL Blocks:1 anonymous blocks----cannot be stored, cannot be shared2 stored procedure function The trigger package----a block with a name that can be stored on an Oracle server and can be shared and called multiple times.1 Anonymous BlocksBeginSqlSqlEndAnonymous block Example:SQL >beginFor I in 1..1000 loopINSERT into T1 values