Oracle sql developer filter syntax5/21/2023 Syntax:- SELECT l1, l2, l1,… FROM table1 LEFT JOIN table2 ON condition ģ.) RIGHT OUTER JOIN - The RIGHT OUTER JOIN returns all the rows of the table on the right side of the join and matching rows for the table on the left side of join. Syntax:- SELECT col_1.col_n from table_1 INNER JOIN ON table_1.col = lĢ.) LEFT OUTER JOIN - The LEFT OUTER JOIN returns all the rows of the table on the left side of the join and matching rows for the table on the right side of join. Join statement is used to combine data or rows from two or more tables based on a common field between them.Different types of Joins are:ġ.) INNER JOIN - The INNER JOIN returns all rows from multiple tables where the join condition is met. Syntax:- SELECT exp_1.exp_n FROM table_1 WHERE condition INTERSECT SELECT exp_1.exp_n FROM table_2 WHERE condition Note:-Each SELECT statement within the UNION operator must have the same number of fields in the result sets with similar data typesġ4.) INTERSECT - The INTERSECT operator is used to pick the common records from compound SELECT queries. Syntax:- SELECT exp_1.exp_n FROM table_1 WHERE condition UNION SELECT exp_1.exp_n FROM table_2 WHERE condition Syntax:- CREATE VIEW view_name AS SELECT col_1,col_2.col_n FROM table_name WHERE ġ3.) UNION - The UNION operator is used to combine the result sets of two or more Oracle SELECT statements. Syntax:- SELECT * FROM table_name WHERE condition ORDER BY expression ġ2.) VIEW - It is basically a virtual table which is stored in Oracle data dictionary. Syntax:- SELECT col_name FROM table_name WHERE condition GROUP BY col_name(s) ġ1.) ORDER BY - The Order By clause is used to sort the records in result set Syntax:- SELECT DISTINCT expression FROM table_name WHERE ġ0.) GROUP BY - The Group By clause is used with SELECT statement to collect data from multiple records and group the results by one or more columns. Syntax:- DELETE FROM table_name WHERE col_name=value ħ.) TRUNCATE - The truncate statement is used to remove records of a table.Ĩ.) DROP - The truncate statement is used to drop a table.ĩ.) DISTINCT - The Distinct clause is used to remove the duplicate records from the result set. Syntax:- SELECT * FROM table_name where col_name=value Ħ.) DELETE - The delete statement is used to delete the records of a table from database. Syntax:- UPDATE table_name set col1_name="exp1", col2_name="exp2" WHERE ĥ.) WHERE - The where statement is used to filter the records of a table. Syntax:- INSERT into table_name values(value1, value2., valuen) Ĥ.) UPDATE - The update statement is used to update records of a table. Syntax:- CREATE TABLE table_name(col1_name data_type,col2_name data_type.,colN_name data_type) Ģ.) SELECT - The select statement is used to fetch records from database.ģ.) INSERT - The insert statement is used to insert records into table. ![]() To know more about Oracle database Click Hereġ.) CREATE TABLE - The create table statement is used to create a new table in the database. It is a relational database in which data is accessed by users through query language called SQL.Oracle database has several structural features like Logical data structure, Memory caching, Backup and recovery, Clustering, etc. It has its networking stack that allows applications from different platforms to communicate. ![]() ![]() It is cross-platform i.e it can run on various hardware across operating systems. It is a relational database system developed by Oracle Corporation in 1980. Oracle Database allows you to quickly and safely create, maintain and retrieve data. Hello everyone! In this blog, we will learn the most common-used commands of the Oracle database.
0 Comments
Leave a Reply. |