Home
Search results “Sql delete from select oracle”
SQL Delete Statement with Example on Oracle 11g Database
 
03:41
SQL Lecturers for Beginners in Hindi and English SQL Delete Statement with Example on Oracle 11g Database
TUTORIAL-2 Select, Create, Alter, Insert, Update, Delete operations sql developer oracle 12c
 
07:25
This is SQL tutorial video for beginners. I have used Oracle 12c for its implementation. If you don't have oracle 12c downlad it from Oracle official website. It is open source, you don't need to pay for it. and Watch how to install Oracle 12c here:-https://www.youtube.com/watch?v=DXh-hmDb0xE&t=5s 1. create table tablename 2.insert into tablename values(); 3.Alter table add field datatype 4.Delete from tablename where conditions 5.UPDATE tablename SET values where condition If you have any doubt, Please comment below and share it because sharing is caring!! Have a great programming!!
Views: 3276 Let's Learn Pro
How to Delete the Duplicate Records in oracle
 
03:44
http://oracletemple.blogspot.in/ How to Delete the duplicate records How delete the duplicate rows ? Tips: - Always take extra caution while deleting records. 1. First identify the duplicates using select. 2. Double verify those are actual ‘duplicates’ or not 3. Take backup if necessary 4. Apply commit only if you are sure. -~-~~-~~~-~~-~- Please watch: "difference between delete and truncate" https://www.youtube.com/watch?v=7b6wQ3Qumgg -~-~~-~~~-~~-~- ------------------------------------------------------------------ Below is link for Useful Pl/SQL Books http://goo.gl/XMy0tt ---------------------------------------------------------- Watch More... What is Parameterized Cursor in Oracle https://www.youtube.com/watch?v=JMKwHlVi6-A What is autonomous transaction in Oracle. https://www.youtube.com/watch?v=gyvFajpfoWE What are Constraints available in Oracle. https://www.youtube.com/watch?v=WivhdLXQklQ What is Mutation Error and How to avoid mutation. https://www.youtube.com/watch?v=CbWNCyW18Bs 5 Effective way to delete Duplicate rows https://www.youtube.com/watch?v=1wtTtnc87Oc What is Difference between Delete and Truncate https://www.youtube.com/watch?v=7b6wQ3Qumgg
Views: 19984 Ram Gupta
SQL Tutorial : How To Delete Duplicate Records in SQL Oracle
 
07:43
SQL Tutorial : How To Delete Duplicate Records in SQL Oracle SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 1700 TechLake
How TO DELETE ROW, MODIFY, UPDATE COLUMN, DROP TABLE in Oracle SQL Using Cmd [Hindi/Urdu].
 
08:03
Hi Friends !!!!! In this Video we show the How to delete table, row, update etc. Oracle Databse- a) Open The Sqlplus. b) Connect The Workspace. c) Show Your Tables. Query : Select * from tab; d) Select the table where you want to delete row. Query : Delete From [Table Name] Where id=?; e) Show Your Tables. Query : Select * from tab; 1 row delete sucessfully. f) If You Modify Your Table to follow this Query : Alter table [Table Name] modify [Column Name] varchar2(10); Your table column is modified. g) If You Update row data follow this Query Update [Table Name] set [Column Name]='row data of column' where id=?; If you delete the table follow the Query : Drop Table [Table Name]; Your table is deleted sucessfully. Related video Links : How to Install Java Netbeans IDE in Windows 7, 8.1, 10 [Hindi/Urdu]: https://youtu.be/jOYMNognZXM How To Install Java On Window 10, 8.1, 7 64 bit Operating System [Hindi/Urdu] : https://youtu.be/y2-g09nY33A How to install Windows 7, 8.1,10 from a flash drive or Pandrive . [Hindi/Urdu] : https://youtu.be/s4kNcirxWrc How to Make Bootable Your Pandrive [Hindi/Urdu] : https://youtu.be/BPx_Ua_aCfY How to install Oracle 11G XE On Windows 10, 8.1, 7 Operating System in [Hindi/Urdu] : https://youtu.be/-2k4QCIpIOs How to Create Table Oracle Datbase Using Sqlplus [Hindi/Urdu] : https://youtu.be/EHnAebRP6Yw How To Insert Table Oracle Database Using Sqlplus [Hindi/Urdu]: https://youtu.be/Fu0tlCml8F8 How TO DELETE ROW, MODIFY, UPDATE COLUMN, DROP TABLE in Oracle SQL Using Cmd [Hindi/Urdu]: https://youtu.be/prz9Pr0PFEg How to recover format or delete Pandrive, Sdcard, Memory Card Or Harddisk Data [Hindi/Urdu] : https://youtu.be/0GGDHVTxDh0 How to install Oracle SQl Developer And How to Connect Your Database Sql Developer[Hindi/Urdu] : https://youtu.be/608nx3mT10c How to use SQL Distinct Keyword in Cmd Or Oracle SQL Developer [Hindi/Urdu] : https://youtu.be/ofLLZ9-EG_E How to use SQL AND Or OR operator [Hindi/Urdu] : https://youtu.be/zzqDp7U3rC8 How To Use SQL Where Operation using CMD [Hindi/Urdu] : https://youtu.be/EHmL0Wa14UY How To Use SQL ASC and DESC Operation using cmd [Hindi/Urdu] : https://youtu.be/UI0hat_RMX0 For Any Query Email Add : [email protected] Facebook Page link : https://www.facebook.com/Technical-Education-4-You-144220269545756/?ref=nf&hc_ref=ART3p2EX_iIdZHm96Uz36P99q7xfycGfo54RJafY-f0O4n1bdvWU_5xGHpPrOpLepi4
SQL: Data Manipulation Language INSERT / UPDATE / SELECT / DELETE
 
09:56
This screencast will demonstrate how to use the SQL DML statements to manipulate the data in your tables: INSERT / UPDATE / DELETE and SELECT. Watch this screencast and take the fearsome out of the "fearsome foursome"
Views: 24669 Michael Fudge
Find Duplicate Rows in SQL - Select Statement Tutorial
 
02:06
Find duplicate row values in a field or multiple fields in SQL Server table with this tutorial. Do this for one column, or multiple columns. Uses SQL Server Management Studio for the demonstration.
Views: 37369 Edward Kench
Oracle SQL Tutorial 19 - ON DELETE (SET NULL and CASCADE)
 
05:59
Welcome everyone! Something you need to consider when you are creating foreign keys is what happens if you delete the parent? As a reminder, the parent is the row that has the value you are referencing in the row that has a foreign key. Why is this something important to consider? It's important because foreign keys need to protect us from two primary things, unacceptable INSERT statements, and unacceptable DELETE statements. Let's see what happens when we try to insert incorrect data into the table with the foreign key: INSERT INTO projects VALUES (1, 'Update website homepage', 'CalebCurry') The response tells us plainly that there is no such user in the users table. So this works correctly. Deleting data on the other hand works a bit differently because the database does not know what you want to do with the child row when you delete the parent from the parent table. By default, we will get an error message that prevents the parent from being deleted, but there are some other options. How do we configure this? This is where the ON DELETE statement comes in. We add the keywords ON DELETE right after the foreign key and then we can give it the option of CASCADE or SET NULL. CASCADE means that if we delete the parent, we are also going to delete the child. In our situation what that means is that if somebody creates a project in our project table and then that persons account gets deleted, all of the projects he owns will also be deleted. CASCADE: CREATE TABLE projects( project_id NUMBER, Project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL, CONSTRAINT projects_pk PRIMARY KEY (project_id), CONSTRAINT projects_users_fk FOREIGN KEY (creator) REFERENCES users (username) ON DELETE CASCADE ) SET NULL will take the value in the child table and get rid of it. What you are left with is NULL. This means that we have an orphaned child. The first thought you might have is that it is a bad thing to have an orphaned child, but in databases that is not always so. In our application if we had it set to SET NULL, when a user account gets deleted the projects would remain in existence they would just lack a creator. This might be a good thing if you are concerned about the long term survival of a project, this might be the route you want to go. It ultimately depends on the application purpose. If you don't like CASCADE or SET NULL, you can leave the entire ON DELETE statement and just have Oracle throw an error when a parent is deleted. As for us, we are going to use ON DELETE CASCADE. We need to use this with extreme caution. If you are not careful, someday you will run a delete a row and that will cascade through you database deleting a bunch of stuff you didn't want to delete. Stuff happens, so make sure you back up your database every once in eternity. Now, in the last video we started with a database design that had three tables. We've only created two in this video. In the next video we are going to create the next one, which is a little special. Then we'll finish things up by adding some indexes. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me on Patreon! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://eepurl.com/-8qtH Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - https://www.dreamhost.com/r.cgi?1487063 (The best web hosting for a cheap price!)
Views: 10717 Caleb Curry
Merge Statement in Oracle SQL with Example (UPDATE/DELETE or INSERT)
 
15:04
This video demonstrates how to write a Merge Statement in oracle sql, how it is useful in doing a conditional update or delete or both of them when the condition between the target table and source table is evaluated to true, and how we can insert the record into the target table when condition is evaluated to false. The video also shows the use of UPDATE, DELETE and INSERT with Merge, and also the various possible ways to use a Merge statement!!!
Views: 6227 Kishan Mashru
Difference between Delete and Truncate and Drop in Oracle Sql
 
14:04
This is a free tutorial on understanding difference between drop, delete and truncate statements. I have tried to cover most of the major difference between all these three statements and have also shown the same with simple and easy to understand examples. Hope it will be helpful to all. If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below : union and union all : https://youtu.be/n9FqQOd8liY char and varchar2 : https://youtu.be/039qzwjWf4k replace and translate : https://youtu.be/HKYF77BGzOE procedure and function : https://youtu.be/q3LmOenL120 in and exists : https://youtu.be/REX4IjRYlFw rank and dense_rank : https://youtu.be/WGSX998hZ9M %type and %rowtype : https://youtu.be/MlLUFeZ_3eM
Views: 1383 Kishan Mashru
Delete duplicate records from a table in Oracle SQL.
 
07:27
How to search or delete duplicate records using SQL or PL SQL. Using select or delete clause to search or delete duplicate rows from tables in PL SQL.
Views: 1834 Subhroneel Ganguly
Oracle - SQL - Truncate Table
 
02:26
Oracle - SQL - Truncate Table Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
SQL with Oracle 10g XE - Using DELETE to Remove a Row from a Table
 
03:17
In this video I use the DELETE command to remove an entire row from a table. When using the DELETE command be sure to use the keywords FROM and WHERE to choose the table and record you wish to delete. The code I used is: DELETE FROM BOOKS WHERE BOOK_ID = '11'; This video is part of a series of videos with the purpose of learning the SQL language. For more information visit Lecture Snippets at http://lecturesnippets.com.
Views: 8433 Lecture Snippets
PL/SQL tutorial 16: Table Auditing using DML Triggers in Oracle PL/SQL
 
09:55
Learn Table Auditing using DML Triggers in Oracle Database and Increase the level of security by keep an eye on user tempering your table data. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/table-auditing Previous Tutorial ► DML Triggers with Examples https://youtu.be/-OR7zLzCh_I ► Select-Into Statement: https://youtu.be/F5eMJhwmCQs ►Sysdate Blog : http://bit.ly/sysdate-in-oracle-by-rebellionrider ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 59238 Manish Sharma
SQL Select Statement on Oracle 11g Database with Example
 
11:14
SQL tutorial for beginners in hindi and english SQL Select Statement on Oracle 11g Database with Example
ORACLE SQL INTERVIEW QUESTION : DIFFERENCE BETWEEN DELETE AND TRUNCATE
 
10:56
This video tutorial is on frequently asked interview question like the difference between delete and truncate statement in oracle sql, after watching this video you will understand more on the difference between both the statements and will be able to answer this interview question with a lot of confidence. Link to know more on HVM in oracle please refer to the link : https://youtu.be/uZ9BwzZx6lI
Views: 3485 Kishan Mashru
SQL Tutorial : Difference Between Delete  and Truncate in SQL Oracle
 
07:06
SQL Tutorial : Difference Between Delete and Truncate in SQL Oracle SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 130 TechLake
PL/SQL tutorial 15: DML Trigger With Before Insert, Update and Delete DML Examples
 
09:17
PL/SQL Tutorial 15 explaining DML Trigger with examples such as Before Insert, Update and Delete in Detail. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/dml-triggers Previous Tutorial ► Trigger Intro : https://youtu.be/R3fvX_xf5P4 ► SELECT-INTO : https://youtu.be/F5eMJhwmCQs ►IF-THEN-ELSIF: https://youtu.be/aW9XgUHSr0I ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 86463 Manish Sharma
Cours SQL ORACLE - 02 : Les requêtes DML (SELECT, INSERT, UPDATE et DELETE).
 
10:18
Cours SQL ORACLE - 02 : Les requêtes DML (SELECT, INSERT, UPDATE et DELETE). Dans cette vidéo nous allons voir les différentes requêtes qui manipulent les données. Ces requêtes s’appellent les DML (Data Manipulation Language). Abonnez-vous à la chaîne pour ne pas manquer mes prochaines vidéos. N'hésitez pas à me suivre sur: Site Web: http://www.courssql.com https://www.facebook.com/CoursSQL Twitter: https://twitter.com/Cours_SQL Google+: https://plus.google.com/108599494665250923662/posts
Views: 2493 Cours SQL
How to Delete Table in sql using oracle 10g or sql
 
02:05
This video gives information about How to Delete Table in sql using oracleXE 10g
Views: 2440 AvilTwo Beginer
ORACLE SQL AND PL/SQL INTERVIEW QUESTION : DELETE DUPLICATE RECORDS FROM  A TABLE(3 ways)
 
13:15
This video tutorial demonstrates about how we can delete duplicate records from a table, the video shows 3 different ways to delete duplicate record from a table, one using Group by, second one by using correlated joins and third on by using rownum analytical function You can get the code from our website http://oracleplsqlblog.com/FullBlog/FullBlog/21
Views: 2974 Kishan Mashru
PL/SQL tutorial 64: PL/SQL Collection Method Delete in Oracle Database by Manish Sharma
 
08:31
------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/delete-procedure Previous Tutorial ► Collection method Next & Prior https://youtu.be/5Ya35KboF1A ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 3814 Manish Sharma
ORACLE SQL AND PL/SQL INTERVIEW QUESTION : SUBQUERY WITH NULL / NOT IN / NOT EXISTS OR OUTER JOIN
 
08:36
This video demonstrates the oracle sql interview question where one need to use either not in, not exists or an outer join to get the desired result. For example if one is asked to fetch records from department table where department_id is not present in employee table
Views: 1542 Kishan Mashru
Learn Oracle | How to Delete Data from a Table using SQL
 
02:13
Pebbles present, Learn Oracle 10g with Step By Step Video Tutorials. Learn Oracle 10g Tutorial series contains the following videos : Learn Oracle - History of Oracle Learn Oracle - What is Oracle - Why do we need Oracle Learn Oracle - What is a Database Learn Oracle - What is Grid Computing Learn Oracle - What is Normalization Learn Oracle - What is ORDBMS Learn Oracle - What is RDBMS Learn Oracle - Alias Names, Concatenation, Distinct Keyword Learn Oracle - Controlling and Managing User Access (Data Control Language) Learn Oracle - Introduction to SQL Learn Oracle - Oracle 10g New Data Types Learn Oracle - How to Alter a Table using SQL Learn Oracle - How to Create a Package in PL SQL Learn Oracle - How to Create a Report in SQL Plus Learn Oracle - How to Create a Table using SQL - Not Null, Unique Key, Primary Key Learn Oracle - How to Create a Table using SQL Learn Oracle - How to Create a Trigger in PL SQL Learn Oracle - How to Delete Data from a Table using SQL Learn Oracle - How to Drop and Truncate a Table using SQL Learn Oracle - How to Insert Data in a Table using SQL Learn Oracle - How to open ISQL Plus for the first time Learn Oracle - How to Open SQL Plus for the First Time Learn Oracle - How to Update a Table using SQL Learn Oracle - How to use Aggregate Functions in SQL Learn Oracle - How to use Functions in PL SQL Learn Oracle - How to use Group By, Having Clause in SQL Learn Oracle - How to Use Joins, Cross Join, Cartesian Product in SQL Learn Oracle - How to use Outer Joins (Left, Right, Full) in SQL Learn Oracle - How to use the Character Functions, Date Functions in SQL Learn Oracle - How to use the Merge Statement in SQL Learn Oracle - How to use the ORDER BY Clause with the Select Statement Learn Oracle - How to use the SELECT Statement Learn Oracle - How to use the Transactional Control Statements in SQL Learn Oracle - How to use PL SQL Learn Oracle - Data Types in PL SQL Learn Oracle - Exception Handling in PL SQL Learn Oracle - PL SQL Conditional Logics Learn Oracle - PL SQL Cursor Types - Explicit Cursor, Implicit Cursor Learn Oracle - PL SQL Loops Learn Oracle - Procedure Creation in PL SQL Learn Oracle - Select Statement with WHERE Cause Learn Oracle - SQL Operators and their Precedence Learn Oracle - Using Case Function, Decode Function in SQL Learn Oracle - Using Logical Operators in the WHERE Clause of the Select Statement Learn Oracle - Using Rollup Function, Cube Function Learn Oracle - Using Set Operators in SQL Learn Oracle - What are the Different SQL Data Types Learn Oracle - What are the different types of Databases Visit Pebbles Official Website - http://www.pebbles.in Subscribe to our Channel – https://www.youtube.com/channel/UCNNjWVsQqaMYccY044vtHJw?sub_confirmation=1 Engage with us on Facebook at https://www.facebook.com/PebblesChennai Please Like, Share, Comment & Subscribe
Views: 291 Pebbles Tutorials
Oracle - Final Revision on All Basic SQL statements.
 
46:28
مراجعة شاملة على كل الأوامر الأساسية فى الــ SQL by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج Final Revision. مراجعة شاملة لكل ما تم دراسته بالسلسلة Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W oracle create table statement oracle drop table statement oracle constraints database constraints primary key constraint foreign key constraint check constraint null not null constraint unique constraint insert into statement update statement delete statement select statement basic query where clause select where Like '%' Like '_' select where Like aggregate functions summary functions group by group by with aggregate functions
Oracle SQL PLSQL 12C Tutorial 13 - DELETE Statement
 
03:27
This Video Tutorial Will Describe how to delete a row or delete data which is already inserted into the table in oracle 12C version. This command will also work on other versions of database like Oracle 11g Database, Oracle 10g Database, Oracle 9i Database, Oracle 8i Database, Oracle 8 Database and so on. Sometimes you delete to delete some unwanted rows or data from the table. Delete command is used to do that. But it does not permanently delete rows, you can restore or rollback the deleted rows before commit. Full Syntax will be given in this video tutorial about how to insert records in oracle database table. Along with the live example to delete rows from the table. All the keywords, format, mandatory clauses etc are described in this video.
How to delete table in Oracle SQL
 
05:46
How to delete table in Oracle SQL
Views: 633 Tanmun
ORACLE SQL INTERVIEW QUESTION : HOW TO SELECT ODD OR EVEN ROWS FROM A TABLE IN ORACLE
 
03:52
This video tutorial answers the frequently asked interview question, how to select only odd or even records in oracle sql, after watching this video you will understand more on the topic and will be able to answer this interview question with a lot of confidence.
Views: 2948 Kishan Mashru
SQL with Oracle 10g XE - Using SELECT to View the Entire Table
 
02:36
In this video I use the SELECT command to view the data of a table. When viewing the entire table be sure to choose the appropriate number of records to display from the drop-down menu and then enter the command. To view the Books table I used the following: SELECT * FROM BOOKS; This video is part of a series of videos with the purpose of learning the SQL language. For more information visit Lecture Snippets at http://lecturesnippets.com.
Views: 15426 Lecture Snippets
Oracle - SQL - Select Statement
 
11:47
Oracle - SQL - Select Statement Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
ORACLE SQL AND PL/SQL INTERVIEW QUESTION : SUBQUERY WITH IN / EXISTS OR SELF JOIN
 
09:31
This video demonstrates the solution of the oracle sql interview question like, find the employees where there manager's salary is more than 15000. This is a classic example of using a subquery or a self join to get the result.
Views: 1920 Kishan Mashru
PL/SQL tutorial 3: SELECT INTO statement in PL/SQL by Manish Sharma RebellionRider
 
05:22
How to initialize the variable by fetching values from the table of the database or by using SELECT INTO statement in PL/SQL by Manish Sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/select-into-statement-pl-sql Previous Tutorial ► Variables: https://youtu.be/2MNmodawvnE ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 102161 Manish Sharma
Oracle Sql tutorial connect, select,insert,delete,commit ,desc bangla part-2
 
09:28
The tutorials I like to share how to work in oracle sql command line from basic level. In this tutorials I show how to connect with database, insert data into table, select all data from table, save data , show table structure etc. I think that the tutorials to be helpful for all beginner. Installing Oracle 11g in Windows bangla tuorial https://www.youtube.com/edit?o=U&video_id=Wv-Vj9GYbYs
Oracle SQL Tutorial 21 - How to Create / Drop Indexes
 
03:58
In the last video, we wrote up the SQL to create three tables: CREATE TABLE users( user_id NUMBER, username VARCHAR2(50 CHAR) UNIQUE, CONSTRAINT users_pk PRIMARY KEY (user_id) ); CREATE TABLE projects( project_id NUMBER, Project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL, CONSTRAINT projects_pk PRIMARY KEY (project_id), CONSTRAINT projects_users_fk FOREIGN KEY (creator) REFERENCES users (username) ON DELETE CASCADE ); CREATE TABLE project_users( project_id NUMBER NOT NULL REFERENCES projects (project_id) ON DELETE CASCADE, user_id NUMBER NOT NULL REFERENCES users (user_id) ON DELETE CASCADE, CONSTRAINT project_users_pk PRIMARY KEY (project_id, user_id) ); I'm going to increase the size of the users table a bit by adding a first and last name column. CREATE TABLE users( user_id NUMBER, username VARCHAR2(50 CHAR) UNIQUE, first_name VARCHAR2(50 CHAR), last_name VARCHAR2 (50 CHAR), CONSTRAINT users_pk PRIMARY KEY (user_id) ); But before we finish this design, we should consider indexing certain columns. What columns should we index? Well, as a reminder, the columns that are indexed by default are columns with the UNIQUE constraint, and those that are labeled as primary keys. Columns that are not indexed but often should be are those labeled as a foreign key. The column that jumps out the most to me is the creator column of the project table. It's the only foreign key that is not part of some index. Let's fix this by creating our first index. The way we do that is with the CREATE INDEX command. CREATE INDEX projects_creator_ix ON projects (creator) What naming convention are we following for the index? We are naming it by the table name, followed by an underscore, followed by the column, followed by an underscore, followed by an ix (for index). In this situation it does not apply, but if our foreign key column is labeled as UNIQUE, we can add the UNIQUE keyword like this: CREATE UNIQUE INDEX projects_creator_ix ON projects (creator) Now if you want to get rid of an INDEX, you can use this command: DROP INDEX projects_creator_ix Now, if we want to select data from the user table and the project table we can do that much faster. That's because the foreign key and column it references are both indexed and those are the columns we would do the join on. We will discuss how to do joins in a future video. So what are some potential problems with this database design? Overall, it is pretty good. With this design though we need to make sure there is no way for someone to update a user's username. In the next video we are going to discuss why. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me on Patreon! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://eepurl.com/-8qtH Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - https://www.dreamhost.com/r.cgi?1487063 (The best web hosting for a cheap price!)
Views: 6307 Caleb Curry
Oracle tutorial : Recover deleted rows in Oracle PL SQL using flashback
 
10:59
Oracle tutorial : Recover deleted rows in Oracle using flashback oracle tutorial for beginners oracle recover deleted rows In this video, we have used as of timestamp concept of oracle. Example : select * from table as of timestamp(systimestamp-interval '1'minute ) Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond
Views: 1372 Tech Query Pond
SelectTec | Aula Nº 5 | Select Table - Oracle SQL Developer
 
03:39
select syntax: select * from tabela;
Views: 4898 SelectTec
GLOBAL TEMPORARY TABLE (GTT) IN ORACLE SQL WITH EXAMPLES
 
13:33
This video demonstrates the usage and working of GTT in oracle SQL. The video shows how internally oracle works with GTT, and also explains the working of ON COMMIT DELETE ROWS and ON COMMIT PRESERVER ROWS in oracle with easy examples.
Views: 6615 Kishan Mashru
Connecting C# with Oracle 11g  use SQL  insert - select  Tutorial  2
 
14:10
To Download Full project + code + file Library Oracle.ManagedDataAccess.dll https://www.4shared.com/rar/SGPri5qpfi/oracle_win_project.html thank you mohamed fayed egypt - Giza My Facebook : https://www.facebook.com/shams.ezzat.73
SQL Developer INSERT UPDATE DELETE SELECT : 오라클 강좌 2016 SQL & PL/SQL 잠자리채널 jamjalee oracle tutorial
 
09:14
잠자리 오라클 SQL & PL/SQL 2016에 대한 강좌입니다. 데이터 입력 수정 삭제 조회 INSERT INTO UPDATE DELETE SELECT ● 재생목록 바로가기 ▶ https://goo.gl/NmQBOL ▶ 자세히 보기 ▶ ※ 유튜브 잠자리채널 youtube jamjalee channel ▶ http://goo.gl/YluPrC ※ 잠자리채널 구독 jamjalee channel subscribe ▶ https://goo.gl/qx2Jbp ※ 홈페이지 jamjalee homepage ▶ http://goo.gl/nRYDti ※ 동영상 재생목록 youtube jamjalee channel playlist ● 잠자리 소프트웨어 아키텍처 2016 ▶ https://goo.gl/WYeEUD ● 잠자리 오라클 SQL & PL/SQL 2016 ▶ https://goo.gl/NmQBOL ● 잠자리 자바 8 프로그래밍 java programming tutorial ▶ https://goo.gl/YlHDcy ● 잠자리 워드프레스 사용법 wordpress tutorial ▶ https://goo.gl/PXCD91 ● 잠자리 마인크래프트 2016 사용법 minecraft 1.8.3 tutorial ▶ https://goo.gl/pHTs3d ● 잠자리 더 위쳐 와일드 헌트 The Witcher 3 Wild Hunt tutorial ▶ https://goo.gl/AHkSgK
Views: 1958 잠자리코딩
79. UPDATE and DELETE using Cursor in PL/SQL Oracle
 
08:18
In this video you will learn about UPDATE and DELETE using Cursor in PL/SQL Oracle. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 2968 ITORIAN
UPDATE STATEMENT WITH JOIN IN ORACLE SQL
 
07:18
This video demonstrates how user can update data of a particular table(t1), based on the join condition with other table(t2). So it would be a easy way to ditch the for-loop, and check for the condition every time. What was to be achieved from the for-loop can be achieved with a single simple update statement. A simple trick to update data in table based on some conditional data in some another table, would help you to increase the performance of your code massively. For ex : UPDATE TABLE1 t1 SET COL1 = (SELECT COL FROM TABLE2 t2 where t1.col = t2.col);
Views: 2105 Kishan Mashru
PL/SQL tutorial 73: Bulk Collect with SELECT-INTO statement in Oracle Database
 
07:26
RebellionRider.com presents a PL/SQL tutorial on how to use the BULK COLLECT clause with SELECT INTO statement in Oracle Database by Manish Sharma. In this tutorial, you will also learn how to overcome the overhead caused by context switch and improve the query performance. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/bulk-collect-2 Previous Tutorial ►Introduction to Bulk Collect: https://youtu.be/CrJSlf_m3yA ►PL/SQL Tutorial 51-Nested Table: https://youtu.be/EUYyiFCzU0I ►Collection Method Count:https://youtu.be/NNq80CcC5K8 ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 6771 Manish Sharma
Oracle SQL The Update Statement تعليم أوراكل
 
10:54
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج How to update and modify existing data in a table. كيف تحدث بيانات موجودة فى الجدول Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W oracle create table statement oracle drop table statement oracle constraints database constraints primary key constraint foreign key constraint check constraint null not null constraint unique constraint insert into statement update statement delete statement
Oracle 11G SQL Session 1 Introduction to Oracle SQL
 
28:02
Oracle 11G SQL Session 1 Introduction to Oracle SQL. To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers. Oracle 11G SQL: Session 1 Introduction Oracle Database 11g: Focus Areas Relational and Object Relational Database Management Systems Data Storage on Different Media Definition of a Relational Database Data Models Relating Multiple Tables Each row of data in a table is uniquely identified by a primary key. You can logically relate data from multiple tables using foreign keys. Relational Database Terminology Using SQL to Query Your Database SQL Statements SELECT INSERT UPDATE DELETE MERGE CREATE ALTER DROP RENAME TRUNCATE COMMENT GRANT REVOKE COMMIT ROLLBACK SAVEPOINT Development Environments for SQL There are two development environments for this course: The primary tool is Oracle SQL Developer. SQL*Plus command-line interface can also be used. Human Resources (HR) Schema Tables Used in the Course Thank You Visit www.theskillpedia.com to Learn or Teach a Skill
Views: 1278 TheSkillPedia
GridView insert update delete in asp.net - Part 23
 
23:47
Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for text version of this video http://csharp-video-tutorials.blogspot.com/2013/03/gridview-insert-update-delete-in-aspnet.html In this video we will discuss about performing an insert, update and delete on asp.net gridview control using sqldatasource. We will be using tblEmployee table for this demo. SQL script to create and populate this table with sample data is available in Part 13 of asp.net gridview tutorial. Create an asp.net web application. Drag and drop a gridview and a sqldatasource control on WebForm1.aspx. Configure "SqlDataSource1" control 1. Right click on "SqlDataSource1" control and select "Show Smart Tag" 2. Now click on "Configure Data Source" link 3. Select connection string, from the dropdownlist on "Choose your data connection" screen. You need to have a connection string specified in web.config file. 4. Click Next 5. On "Configure the Select Statement" screen, select "tblEmployee" table from dropdownlist. 6. Click on "Advanced" button 7. Select "Generate INSERT, UPDATE and DELETE statements" checkbox and click OK 8. Click Next and Finish Drag and drop gridview control on WebForm1.aspx. Now let us associate "SqlDataSource1" control with "GridView1" control 1. Right click on "GridView1" control and select "Show Smart Tag" 2. Select "SqlDataSource1" from "Choose Data Source" dropdownlist 3. Select "Enable Deleting" and "Enable Editing" checkboxes. At this point "Delete" and "Edit" buttons should appear on the gridview control. We will be using gridview control's footer for inserting a new record. Set "ShowFooter" property of the GridView1 control to "true". This can be done from the properties window, or in the HTML. By default GridView control has generated bound fields to display EmployeeId, Name, Gender and City columns. We need to convert these bound fields into template fields. This can be done very easily using the designer. 1. On the "GridView Tasks" pane click on "Edit Columns" link button. 2. Select "EmployeeId" from "Selected Fields" section and click on "Convert this field into a template field" link 3. Do the same for Name, Gender and City Now modify the template fields in the HTML. Please note 1. In every TemplateField, along with EditItemTemplate and ItemTemplate, we also need FooterTemplate. 2. A dropdownlist is used in EditItemTemplate and FooterTemplate of "Gender" template field, instead of a textbox control. 3. To validate data during edit and insert operations, notice that, we are using validation controls, in EditItemTemplate and FooterTemplate. 4. A linkbutton is used in the footer template of "EmployeeId" template field, to enable the user to insert a new employee row 5. We have used ValidationGroup="Insert" for all the validation controls in FooterTemplates. LinkButton's ValidationGroup is aslo set to "Insert", so that all the validation controls in in FooterTemplates are fired only on Insert LinkButton click. 6. We have set LinkButton's OnClick="lbInsert_Click". 7. After the closing tag of GridView, notice that we are using 2 validationsummary controls, to display all the validation messages in one place. ValidationSummary1 control's ValidationGroup is set to "Insert". ValidationSummary1 control displays all insert related validation errors, and edit related validation errors are displayed using ValidationSummary2 control. Finally copy and paste the following event handler method in WebForm1.aspx.cs protected void lbInsert_Click(object sender, EventArgs e) { SqlDataSource1.InsertParameters["Name"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("txtName")).Text; SqlDataSource1.InsertParameters["Gender"].DefaultValue = ((DropDownList)GridView1.FooterRow.FindControl("ddlGender")).SelectedValue; SqlDataSource1.InsertParameters["City"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("txtCity")).Text; SqlDataSource1.Insert(); }
Views: 369198 kudvenkat
Learn Oracle | How to Create a Package in PL SQL
 
07:54
Pebbles present, Learn Oracle 10g with Step By Step Video Tutorials. Learn Oracle 10g Tutorial series contains the following videos : Learn Oracle - History of Oracle Learn Oracle - What is Oracle - Why do we need Oracle Learn Oracle - What is a Database Learn Oracle - What is Grid Computing Learn Oracle - What is Normalization Learn Oracle - What is ORDBMS Learn Oracle - What is RDBMS Learn Oracle - Alias Names, Concatenation, Distinct Keyword Learn Oracle - Controlling and Managing User Access (Data Control Language) Learn Oracle - Introduction to SQL Learn Oracle - Oracle 10g New Data Types Learn Oracle - How to Alter a Table using SQL Learn Oracle - How to Create a Package in PL SQL Learn Oracle - How to Create a Report in SQL Plus Learn Oracle - How to Create a Table using SQL - Not Null, Unique Key, Primary Key Learn Oracle - How to Create a Table using SQL Learn Oracle - How to Create a Trigger in PL SQL Learn Oracle - How to Delete Data from a Table using SQL Learn Oracle - How to Drop and Truncate a Table using SQL Learn Oracle - How to Insert Data in a Table using SQL Learn Oracle - How to open ISQL Plus for the first time Learn Oracle - How to Open SQL Plus for the First Time Learn Oracle - How to Update a Table using SQL Learn Oracle - How to use Aggregate Functions in SQL Learn Oracle - How to use Functions in PL SQL Learn Oracle - How to use Group By, Having Clause in SQL Learn Oracle - How to Use Joins, Cross Join, Cartesian Product in SQL Learn Oracle - How to use Outer Joins (Left, Right, Full) in SQL Learn Oracle - How to use the Character Functions, Date Functions in SQL Learn Oracle - How to use the Merge Statement in SQL Learn Oracle - How to use the ORDER BY Clause with the Select Statement Learn Oracle - How to use the SELECT Statement Learn Oracle - How to use the Transactional Control Statements in SQL Learn Oracle - How to use PL SQL Learn Oracle - Data Types in PL SQL Learn Oracle - Exception Handling in PL SQL Learn Oracle - PL SQL Conditional Logics Learn Oracle - PL SQL Cursor Types - Explicit Cursor, Implicit Cursor Learn Oracle - PL SQL Loops Learn Oracle - Procedure Creation in PL SQL Learn Oracle - Select Statement with WHERE Cause Learn Oracle - SQL Operators and their Precedence Learn Oracle - Using Case Function, Decode Function in SQL Learn Oracle - Using Logical Operators in the WHERE Clause of the Select Statement Learn Oracle - Using Rollup Function, Cube Function Learn Oracle - Using Set Operators in SQL Learn Oracle - What are the Different SQL Data Types Learn Oracle - What are the different types of Databases Visit Pebbles Official Website - http://www.pebbles.in Subscribe to our Channel – https://www.youtube.com/channel/UCNNjWVsQqaMYccY044vtHJw?sub_confirmation=1 Engage with us on Facebook at https://www.facebook.com/PebblesChennai Please Like, Share, Comment & Subscribe
Views: 2005 Pebbles Tutorials
Oracle SQL PLSQL 12C Tutorial 7 - How to Insert Record or Data in Table
 
04:23
This Video Tutorial Will Describe how to insert values or data into the table in oracle 12C version. This command will also work on other versions of database like Oracle 11g Database, Oracle 10g Database, Oracle 9i Database, Oracle 8i Database, Oracle 8 Database and so on. Whenever you create a new table in oracle, you need to insert some data into that table otherwise that table is not usable. Example to select data, to update data and delete data, you first need to insert some data. Full Syntax will be given in this video tutorial about how to insert records in oracle database table. Along with the live example to insert records. All the keywords, format, mandatory clauses etc are described in this video. In this video, I use the INSERT command to add an entire record into a table. When using the command you must also use the keyword VALUES. If you want to enter a null value (one that has no value) for a field you can use the keyword NULL. Be sure to put single quotes around data types that are not numbers. Values need to be entered in the order the fields appear in the table.
Oracle sql Interview Question : How to change rows to column
 
09:18
This video tutorial talks about the frequently asked oracle sql interview question of changing rows to the column. Based on the given scenario, we are asked to change the presentation of data in a table with 3 rows and 2 column to 3 columns and 2 rows. Decode Function in oracle https://youtu.be/YUAjPMjqMws Pivot and unpivot in oracle https://youtu.be/6s0DI1YcWIM
Views: 9395 Kishan Mashru
Oracle SQL Tutorial 11 - CREATE TABLE
 
05:04
The way you create a table is to use the CREATE TABLE command. CREATE TABLE users() So in this situation, the name comes right after the TABLE keyword. The next thing we do is put all of the columns on a line that we want to put in our table. CREATE TABLE users( user_id, username, first_name, last_name ) Notice the naming conventions here. For this series we are going to make columns with what is known as snake casing. This is where each individual word is separated by an underscore. if you have more than one column, all of them have to have commas except the last one. The comma is a way to say that another column is coming, so you don't need to do it on the last one. Now you would think we were done, but we also have to say what data type each column is. Later we will extensively discuss data types so we can focus on them exclusively. For now, here are the data types we are going to use: CREATE TABLE users( user_id NUMBER, username VARCHAR2(50), first_name VARCHAR2(50), last_name VARCHAR2(50) ) Now, inside of the parenthesis for varchar2, we pass in a number... This is the max length of the string. But the question is, what is it measured in? The default is actually in bytes, not characters. For example if we have the string hello, it is 5 characters, but it might take up a total of 10 bytes of storage. So I would recommend adding the keyword char right after the number so it defaults to 50 characters, not bytes. CREATE TABLE users( user_id NUMBER, username VARCHAR(50 CHAR), first_name VARCHAR2(50 CHAR), last_name VARCHAR2(50 CHAR) ) This will work to create a table, but it's really missing a lot of information… which column is the primary key? Are we adding any indexes? Is there any thing else we need to say about these columns? So as you can tell, we are making progress, but there is still so much to learn. The biggest gotcha to remember from this video is that the data type VARCHAR ends in a 2, stupid, right? who would end the name of something with a 2? Once again, this is Caleb from CalebTheVideoMaker2, and we will catch you in the next one! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://eepurl.com/-8qtH Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - https://www.dreamhost.com/r.cgi?1487063 (The best web hosting for a cheap price!)
Views: 22041 Caleb Curry
ON DELETE CLAUSE OF FOREIGN KEY CONSTRAINT IN ORACLE SQL WITH EXAMPLE (CASCADE/SET NULL/NO ACTION)
 
15:31
This is a free video tutorial explaining about the nonmandatory on delete clause in the foreign key constraint in Oracle SQL database, the video explains about how the on delete set null and on delete cascade works, how it can be implemented with easy to understand examples. We have also shown practical demonstration on creating the foreign key constraint, and then deleting the data from the parent table and observing the changes that take place in the child table.
Views: 1130 Kishan Mashru