Select D.Department_name(Select Count(E.Department_name) From Employee E Where E.Department_no=D.Department_no (Select Department_Name from Employee where Department_Name=’OBIEE’)) (Select Department_no From Department D where E.Employee_id=D.Employee_ID) (Select Department_Name from Employee where Department_name in (‘OBIEE’,Oracle’)) Where Salary=(Select max(Salary) from Employee) Įxample 2 : Multiple Row Sub-query example Select Employee_No,Employee_Name from Employee In this section i would like to give you some important examples of subqueries. These are some most important basic SQL Queries. The above command will add new column in Teacher table. The above statement will delete the data from Teacher table.Įxample 5 : Alter table and add new column The above query will update the Teacher table where Employee_No is 101.
#Oracle sql developer tutorial examples how to#
How to Create table in SQL | Basic SQL CommandsĮxample 3 :What is query to update data in table. The above query will give you information about the specific users on database SELECT Username FROM All_Users ORDER BY Username The above query will give you the information about all the tables on the database.Įxample 2 : How do you fetch different users on database. Select table_name,Owner from All_tables order by table_name,owner In this section i would like to give you some most important Oracle SQL commands which are based on system tables.Įxample 1 : How to Find table information about specific table.
In previous articles i have explained about different examples of SQL queries.I explained the SQL server queries examples as well.In this article i would like to give you different important Oracle SQL Commands with real life examples.Oracle SQL Commands not only contains different SQL Statements but also PL SQL statements.I would like to start with simple system table commands to complex sql and pl sql codes which are used in real world industry.There are following important Oracle SQL commands which are really very useful : Part 1 : Oracle System Table Commands :
0 kommentar(er)
