Tutorial#12 How to Insert data into a table using SQL developer

In this video, I am explaining How to insert data into tables using the INSERT INTO statement into two ways, with the columns names, and without the columns name

Oracle SQL Practice question :

In this series we cover the following topics:
SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator.

follow me on:
Facebook Page:

Contacts Email:

Instagram:

Twitter:

#SQLPracticeQuestion #equalConnectCoach #OracleSQL

[sagarpatil]

#include<stdio.h>
void main()
{
printf("THANK YOU SIR")
};

[sagarpatil]

insert into respected_sir values('RAKESH_SIR', 'SQL');

[anouarseljouki]

there is one point that is not included in this Video that I ran into. I tried updating the Employees database that was provided by Oracle by using insert statement, I typed NULL in some to not fill up all columns and I got the following error :

SQL Error: ORA-00984: column not allowed here
00984. - "column not allowed here"

apparently toy have to fill up each of the columns, I tried the same in different tables That I created myself and it worked

Thank you

[budhahemalatha]

Can we insert multiple records in a single insert command in oracle sql Sir?

[swarakulkarni]

How can one insert multiple rows at the same time?

[SC-zpmx]

All your videos are great but to me what irritates the most is the sound when you swallow your spit while talking .... idk about others but That's so annoying to me. Please, on your next videos, try not to do that. Thank you.