AND condition / OR condition. Oracle / sqlserver we use AND / OR condition in below statement SELECT, INSERT, UPDATE, or DELETE statement. while any operation on the table both condition check the perform the actions. Syntax select * from <table_name> WHERE <condition 1> AND <condition 2> OR condition; For example of AND / OR condition - SELECT * FROM customer_master WHERE (Name = 'John' AND dept_id = '10') OR (customer_id < 10); we can user multiple or conditions as below , in sql we check the multiple conditions using "AND" "OR" SELECT Customer_id FROM customer_master WHERE (customer_id >= 10) OR (STATE = 'BIHAR' AND state = 'DELHI') OR (JOIN_DATE >= '10-JUN-2010' AND customer_name like 'John%'); when we insert some data using single or multiple table and condition and OR condition is very important. Example- INSERT INTO customer_master (customer_id, customer_name) SELECT cust_id, cust_na
Create table in Sql/plsql in this topic we covered create table , primary key,constraints,releations in table, datatype,not null constraint and basic course and advance course of create table topic.syntax, parameters, arguments, example
Create Table SQL CREATE TABLE statement with syntax, examples, and practice exercises. The SQL CREATE TABLE statement allows you to create and define a table. In this topic cover below sql basic knowledge. Create Table Create table with Primary key constraints Create table with Foreign key constraints Table Relation Add constraints in table Primary key Null and Not null Create table using select create table with multiple table joins. Statement of CREATE TABLE - Oracle / PLSQL: CREATE TABLE create table : Syntax CREATE TABLE table_name ( column1 datatype [ NULL | NOT NULL ], column2 datatype [ NULL | NOT NULL ], column_n datatype [ NULL | NOT NULL ] ); while the create table datatype is most important, we can also add null and not null in any column. null define you can allow a null values not null define you can not allow null value in specified column. Example Oracle CREATE TABLE example. CREATE TABLE customers ( customer_id number(10) NOT NULL, customer_name varchar2(50