Home
Search results “Oracle update fetch”
How to Fetch Latest record/row from the Table in Oracle Database
 
03:32
You will learn how to How to Fetch Latest record/row from the Table in Oracle Database. Realtime Scenario: This logic can be implemented to find whether the latest record should be inserted or updated to datawarehouse
PL/SQL tutorial 74: PL/SQL Bulk Collect Clause with FETCH-INTO statement of an explicit cursor
 
09:49
RebellionRider.com presents a PL/SQL tutorial on how to use PL/SQL Bulk Collect with Fetch-Into statement of an explicit cursor in Oracle Database. Watch and learn how to enhance query performance with Bulk Collect in Oracle Database by Manish Sharma. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/bulk-collect-3 Previous Tutorial ► Introduction to Bulk Collect: https://youtu.be/HPVzFBluM_Q ► Explicit Cursor: https://youtu.be/3q7dW_d2KVc ► Simple Loop: https://youtu.be/AFx6QYcY1CU ► The script on GIT: https://github.com/RebellionRider/pl-sql-tut-74.git ------------------------------------------------------------------------- ►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/ 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: 9523 Manish Sharma
Cursors in Oracle PLSQL
 
09:30
This Video Explains. 1. What is CURSOR in Oracle PLSQL 2. How to use cursor in Oracle PLSQL 3. How to declare,open and fetch values in CURSOR 4. CURSOR Attributes 5. Implicit cursor and explicit cursor 6. CURSOR TYPES
Views: 2790 yrrhelp
Fetch data from Oracle database to excel , using "APACHE POI".
 
16:26
To fetch data from oracle to excel ,we need to download.... 1-netbeans(https://netbeans.org/downloads/) 2-jdk(https://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html) 3-oracle 11g(https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html) 4-Apache Poi jars(https://mvnrepository.com/artifact/commons-lang/commons-lang/2.6)...https://mvnrepository.com/artifact/org.apache.poi/poi/3.9 5-jar for oracle:-https://www.oracle.com/technetwork/apps-tech/jdbc-112010-090769.html CODE:- import java.io.File; import java.io.FileOutputStream; import java.sql.*; import org.apache.poi.xssf.usermodel.XSSFCell; import org.apache.poi.xssf.usermodel.XSSFRow; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; class ExcelDatabase { public static void main(String args[]) throws SQLException{ try{ //step1 load the driver class Class.forName("oracle.jdbc.driver.OracleDriver"); //step2 create the connection object Connection con=DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:xe","SYSTEM","SYSTEM"); //step3 create the statement object Statement stmt=con.createStatement(); //step4 execute query ResultSet resultSet=stmt.executeQuery("select * from EMPLOYE_TABLE"); XSSFWorkbook workbook = new XSSFWorkbook(); XSSFSheet spreadsheet = workbook.createSheet("employe db"); XSSFRow row = spreadsheet.createRow(1); XSSFCell cell; cell = row.createCell(1); cell.setCellValue("EMPLOYEE_ID"); cell = row.createCell(2); cell.setCellValue("EMPLOYEE_NAME"); cell = row.createCell(3); cell.setCellValue("EMPLOYEE_ADD"); cell = row.createCell(4); cell.setCellValue("EMPLOYEE_CONTACTNO"); cell = row.createCell(5); cell.setCellValue("EMPLOYEE_STATUS"); cell = row.createCell(6); cell.setCellValue("EMPLOYEE_SALARY"); int i = 2; while(resultSet.next()) { row = spreadsheet.createRow(i); cell = row.createCell(1); cell.setCellValue(resultSet.getInt("EMPLOYEE_ID")); cell = row.createCell(2); cell.setCellValue(resultSet.getString("EMPLOYEE_NAME")); cell = row.createCell(3); cell.setCellValue(resultSet.getString("EMPLOYEE_ADD")); cell = row.createCell(4); cell.setCellValue(resultSet.getString("EMPLOYEE_CONTACTNO")); cell = row.createCell(5); cell.setCellValue(resultSet.getString("EMPLOYEE_STATUS")); cell = row.createCell(6); cell.setCellValue(resultSet.getString("EMPLOYEE_SALARY")); i++; } FileOutputStream out = new FileOutputStream(new File("exceldatabase.xlsx")); workbook.write(out); out.close(); System.out.println("exceldatabase.xlsx written successfully"); //con.close(); }catch(Exception e){ System.out.println(e);} } }
Views: 718 TecHKmn
SELECT statement Processing in an Oracle Database - DBArch  Video 7
 
06:22
You will learn from this video how a SELECT statement is processed in an Oracle Database. You will learn about the a Parse, Execute and Fetch phases in a select statement. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 28729 Ramkumar Swaminathan
Oracle SQL PLSQL 12C Tutorial 8 - SELECT Command , Fetch Data from Table
 
09:41
This Video Tutorial Will Describe how to select or retrieve values or data into a 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. Then this part comes where you select the data from the table. Full Syntax will be given in this video tutorial about how to select records from oracle database table. Along with the live example to select records. All the keywords, format, mandatory clauses etc are described in this video.
#12. Intro to Oracle PL/SQL ( Explicit Cursor - fetch ) مقدمة لاوراكل
 
05:23
تفاصيل جلب الداتا باستخدام الكورسر Get the Source Code: https://gist.github.com/Ismail-AlJubbah/17c55492014b15489078 Help us caption & translate this video! http://amara.org/v/Fr7h/
Views: 339 Jubba Smail
How to Fetch Data By Using Cursor for loop In Oracle Form
 
06:55
How to Fetch Data By Using Cursor for loop In Oracle Form
Views: 120 Young India
PHP Ajax Crud - Insert Update Delete with Stored Procedure 1
 
14:38
In this video we will fetch or select data from database by using stored procedure in php script called by Ajax method with Jquery. We will use stored procedure for fetch data from database with PHP Script. We will use Ajax Jquery with Stored procedure in PHP code. Mysql data will be fetch on page load by using Stored procedure in PHP script with Ajax JQuery and Display data in html table format with update and delete button. Part 2 - https://www.youtube.com/watch?v=NBAbxh0KRyQ
Views: 33490 Webslesson
How to Fetch Data By Using Cursor for loop with where clause In Oracle Form
 
08:56
How to Fetch Data By Using Cursor for loop with where clause In Oracle Form
Views: 45 Young India
Oracle SQL PLSQL 12C Tutorial 8   SELECT Command , Fetch Data from Table
 
09:41
This Video Tutorial Will Describe how to select or retrieve values or data into a 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. Then this part comes where you select the data from the table. Full Syntax will be given in this video tutorial about how to select records from oracle database table. Along with the live example to select records. All the keywords, format, mandatory clauses etc are described in this video.
Views: 88 game hounds
Aula 06   FETCH FIRST oracle
 
05:43
Para se inscrever no nosso curso acesse --http://aprendaplsql.com/1z0-047-curso-oracle-sql-expert/ Esta aula faz parte do Curso Oracle SQL Expert e foi liberada para o público afim de distribuir conhecimentos do Oracle 12c. Queries utilizadas no vídeo: SELECT * FROM employees WHERE rownum = 5 ORDER BY salary desc; SELECT emp.* FROM (SELECT * FROM employees ORDER BY salary DESC) emp WHERE rownum = 5; SELECT * FROM employees ORDER BY salary DESC FETCH FIRST 5 ROWS ONLY; -- Clausula WITH TIES retorna as linhas repetidas na última posição SELECT * FROM employees ORDER BY salary DESC FETCH FIRST 5 ROWS WITH TIES; UPDATE employees SET salary = 13500 WHERE employee_id = 103; -- Comando OFFSET você pula linhas SELECT * FROM employees ORDER BY salary DESC OFFSET 3 ROWS; -- Você também pode retornar as próximas x linhas depois de uma certa quantidade -- de linhas SELECT * FROM employees ORDER BY salary DESC OFFSET 3 ROWS FETCH NEXT 2 ROWS ONLY; -- Você também consegue definir por porcentagem o retorno das linhas SELECT * FROM employees ORDER BY salary DESC FETCH FIRST 25 PERCENT ROWS ONLY;
Views: 1366 Aprenda PL/SQL
Connect Excel to Oracle Database
 
05:03
How to connect an Oracle Database to Microsoft Excel. https://www.elance.com/s/edtemb/
Views: 100965 i_marketing
Quickstart for Node.js and Oracle Database
 
08:39
This quickstart video shows the simple steps for installing and running a Node.js application that accesses Oracle Database using the node-oracledb add-on. Ask questions at https://github.com/oracle/node-oracledb/issues Useful Resources: npm repository: https://www.npmjs.com/package/oracledb Installation instructions: https://oracle.github.io/node-oracledb/INSTALL.html Documentation: https://oracle.github.io/node-oracledb/doc/api.html Examples: https://github.com/oracle/node-oracledb/tree/master/examples Blog: https://blogs.oracle.com/opal/ Twitter: https://twitter.com/ghrd
Hibernate Tutorial part 14 - save, get, update, delete database operations using Hibernate (CRUD)
 
06:59
http://www.gontu.org in this tutorial, I am gona talk about the basic database operations which we can perform using Hiberante provided functions like saving a record, retrieving a record, updating a record and deleting a record from the database table (simple CRUD operations). The tutorial (CRUD operations using Hibernate) is important as it forms the foundations for the rest of the tutorials like Hibernate Object states (Transient, Persistent, Detached)
Views: 40803 gontuseries
How to Update Record in table in oracle database .
 
01:00
How to Update Record in table in oracle database .
Views: 416 latest ITChannel
3.11 delete update data in ORACLE
 
12:37
use of update delete on udate on delete constraints
Views: 57 Sotiris zz
Insert Update Delete View and search data from database in C#.net
 
13:47
Need Help Or Need code? Feel Free To Contact Us Here http://www.noblecomputer.co.in/support.php using this tutorial you can easily understand that how you can do Insert Update Delete and View data from database in C#.net | insert update delete in c#.net | Insert Update Delete View and search data from database in C#.net,Legen Ansicht aktualisieren und Suchdaten aus der Datenbank in C # .net Löschen,Insérez Update Supprimer Afficher et recherche les données de base de données en C # .net, database connectivity in c#, c# connection to sql server.
Views: 363674 Amit Andipara
Fetch Data From Oracle 11g Database with Coding Only in Asp.Net C# | Hindi | Free Online Classes
 
13:00
Hi Friends, Students, Subscribers, In This Free Video Tutorial of Asp.Net Programming Using C#, You will Learn How to Fetch Data From Oracle 11g Database ( Table ) with The Help of Connection String, OracleConnection, OracleCommand, OracleDataAdapter, Dataset etc. ------------ Download Important Coding Used in This Example ( Google Drive Shared Link ) https://drive.google.com/open?id=0B1kvZ2xP-QXjNEFSTmRNTVVTTTg ------------------------------------------------------------------------------------ Subscribe Our YouTube Channel - Like, Comment & Share Our Videos https://www.youtube.com/haritistudyhubeasylearn -------------- Like & Share Our Facebook Page http://www.facebook.com/HaritiStudyHub -------------- if You Have Any Problem and Doubt in Programming Language Feel Free to Email Us BestStudyGuru @ Gmail.Com --------------
Oracle commands DML tutorial ( Insert, Select, Update, Delete) CRUD
 
01:03:30
Oracle commands DML tutorial ( Insert, Select, Update, Delete) CRUD. In this video can help you how to write sql code with DML like Insert, select, update, delete. and this tutorial can help to understand CRUD in SQL Server or Oracle and MySQL too.
Views: 245 Ly Kimchrea
how to fetch or populate data from database to jframe or jtable [SOLVED]- java tutorial #14
 
08:06
Bring the data from back end to front end in java netbeans.... or want to see or bring the database's data to your jframe in java or jtable here i will show you how to do that.... ============================================== IMPORTANT LINKS: -- rs2xml ( JAR FILE) https://drive.google.com/file/d/0BwUVtTEFk6GAVzItTzV1ZnlPVE0/view?usp=sharing -- SQLITE JDBC (JAR FILE) https://drive.google.com/file/d/0BwUVtTEFk6GAMmc0WmF0SUl2d3c/view?usp=sharing for any query drop your comments below this video please rate comment and subscribe for more videos..
Views: 71662 GSoft Knowledge
PL/SQL tutorial 35: Cursor Based Record Datatype Variable in Oracle Database By Manish Sharma
 
06:28
www.RebellionRider.com- Learn How To Create Cursor Based Record Datatype Variable in Oracle Database with easy Examples. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/cursor-records Previous Tutorial ►Table Based Record https://youtu.be/8WqpqKUj9l8 ► Simple Explicit Cursor https://youtu.be/3q7dW_d2KVc ------------------------------------------------------------------------- ►►►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/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ 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: 23569 Manish Sharma
#4.7 Flutter SQFLite tutorial: CRUD Operation. Perform Insert, Fetch, Update and Delete Operation
 
10:18
Access 7000+ courses for 60 days FREE: https://pluralsight.pxf.io/c/1291657/424552/7490 Learn how to create an SQLite database in Flutter using Raw SQL statement and perform Insert, Fetch, Update and Delete operation. Next Video: https://youtu.be/xke5_yGL0uk Previous Video: https://youtu.be/t39VV2XyqR0 Video Code: http://bit.ly/2GbmmfH Source code files: https://bit.ly/2NINczC Check out my website: ➤ https://bit.ly/smartherd Donate and support us [Only if you think our courses are better than Udemy or Udacity] ➤ Patreon: https://bit.ly/patreon-donate ➤ Paypal/Payoneer: [email protected] ➤ UPI (only for India): [email protected] Programming courses: ➤ Ruby Programming: https://bit.ly/smyt-r ➤ Dart Programming: https://bit.ly/smyt-d ➤ Kotlin Programming: https://bit.ly/smyt-k ➤ Java Programming: https://bit.ly/smyt-j Flutter course: ➤ Flutter App Development: https://bit.ly/2Rg7EFR Android courses: ➤ Android using Kotlin: https://bit.ly/smyt-ka ➤ Android using Java: https://bit.ly/smyt-ja ➤ Android Material Design: https://bit.ly/2SMJqU6 ➤ Android Jetpack Architecture: https://bit.ly/yt-j ➤ Android Multiple Screen Support: https://bit.ly/smyt-mss ➤ Android Retrofit: https://bit.ly/2Ee6GHn More programming courses: ➤ https://bit.ly/smy-list Follow us on Facebook: https://bit.ly/smartherd-facebook Twitter: https://bit.ly/smartherd-twitter Github: https://bit.ly/smartherd-github ---- Thank you for your love and support ----
Views: 3293 Smartherd
Part 2   SQL query to get organization hierarchy
 
10:14
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-2-sql-query-to-get-organization.html To get the best out of this video, the following concepts need to be understood first. These are already discussed in SQL Server Tutorial. 1. Self-Join - http://www.youtube.com/watch?v=qnYSN_7qwgg 2. CTE - http://www.youtube.com/watch?v=ZXB5b-7HJHk 3. Recursive CTE - http://www.youtube.com/watch?v=GGoV0wTMCg0 Here is the problem definition: 1. Employees table contains the following columns a) EmployeeId, b) EmployeeName c) ManagerId 2. If an EmployeeId is passed, the query should list down the entire organization hierarchy i.e who is the manager of the EmployeeId passed and who is managers manager and so on till full hierarchy is listed. For example, Scenario 1: If we pass David's EmployeeId to the query, then it should display the organization hierarchy starting from David. Scenario 2: If we pass Lara's EmployeeId to the query, then it should display the organization hierarchy starting from Lara. We will be Employees table for this demo. SQL to create and populate Employees table with test data Create table Employees ( EmployeeID int primary key identity, EmployeeName nvarchar(50), ManagerID int foreign key references Employees(EmployeeID) ) GO Insert into Employees values ('John', NULL) Insert into Employees values ('Mark', NULL) Insert into Employees values ('Steve', NULL) Insert into Employees values ('Tom', NULL) Insert into Employees values ('Lara', NULL) Insert into Employees values ('Simon', NULL) Insert into Employees values ('David', NULL) Insert into Employees values ('Ben', NULL) Insert into Employees values ('Stacy', NULL) Insert into Employees values ('Sam', NULL) GO Update Employees Set ManagerID = 8 Where EmployeeName IN ('Mark', 'Steve', 'Lara') Update Employees Set ManagerID = 2 Where EmployeeName IN ('Stacy', 'Simon') Update Employees Set ManagerID = 3 Where EmployeeName IN ('Tom') Update Employees Set ManagerID = 5 Where EmployeeName IN ('John', 'Sam') Update Employees Set ManagerID = 4 Where EmployeeName IN ('David') GO Here is the SQL that does the job Declare @ID int ; Set @ID = 7; WITH EmployeeCTE AS ( Select EmployeeId, EmployeeName, ManagerID From Employees Where EmployeeId = @ID UNION ALL Select Employees.EmployeeId , Employees.EmployeeName, Employees.ManagerID From Employees JOIN EmployeeCTE ON Employees.EmployeeId = EmployeeCTE.ManagerID ) Select E1.EmployeeName, ISNULL(E2.EmployeeName, 'No Boss') as ManagerName From EmployeeCTE E1 LEFT Join EmployeeCTE E2 ON E1.ManagerID = E2.EmployeeId
Views: 286214 kudvenkat
PL/SQL Tutorial | COALESCE Function in Oracle Database
 
05:31
Learn fetching all non-null expression using oracle Coalesce function with example. If all expressions evaluate to null, then the COALESCE function will return null. Coalesce function in Oracle, What is coalesce function, When to use coalesce function, How to use coalesce function in oracle, How to fetch non-null values in oracle using coalesce, Linkedin: https://www.linkedin.com/in/aditya-kumar-roy-b3673368/ Facebook: https://www.facebook.com/SpecializeAutomation/
jQuery datatables get data from database table
 
21:04
Link for all dot net and sql server video tutorial playlists https://www.youtube.com/user/kudvenkat/playlists?sort=dd&view=1 Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2015/08/jquery-datatables-get-data-from.html In this video we will discuss how to use database data with jQuery datatables plugin. There are many ways to get data into DataTables. If the data is small you can retrieve all the data at once and the processing (i.e paging, searching, ordering) is done on the client-side. On the other hand if the database data is large, server-side processing can be enabled. With server-side processing enabled, all paging, searching, ordering actions that DataTables performs are handed off to the server. In this video we will discuss retrieving all the data at once. The datatables plugin performs all the processing (i.e paging, searching, ordering etc) on the client-side. We want to retrieve data from the following database table tblEmployee. The database data should then be displayed using jQuery datatables plugin
Views: 150282 kudvenkat
PL/SQL tutorial 27: How To Create An Explicit Cursor In Oracle Database By Manish Sharma
 
05:03
Learn How To Create An Explicit Database Cursor In Oracle with easy to understand example by Manish Sharma RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/create-explicit-cursor Previous Tutorial ► Introduction To Database Cursor - https://youtu.be/_snAMqCBitg ► Simple Loop - https://youtu.be/AFx6QYcY1CU ------------------------------------------------------------------------- ►►►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/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ 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: 54971 Manish Sharma
Part 6   Transform rows into columns in sql server
 
08:53
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/06/part-6-transform-rows-into-columns-in.html This is another common sql server interview question. We will be using Countries table in this example. SQL to create the table Create Table Countries ( Country nvarchar(50), City nvarchar(50) ) GO Insert into Countries values ('USA','New York') Insert into Countries values ('USA','Houston') Insert into Countries values ('USA','Dallas') Insert into Countries values ('India','Hyderabad') Insert into Countries values ('India','Bangalore') Insert into Countries values ('India','New Delhi') Insert into Countries values ('UK','London') Insert into Countries values ('UK','Birmingham') Insert into Countries values ('UK','Manchester') Here is the interview question. Write a sql query to transpose rows to columns. Using PIVOT operator we can very easily transform rows to columns. Select Country, City1, City2, City3 From ( Select Country, City, 'City'+ cast(row_number() over(partition by Country order by Country) as varchar(10)) ColumnSequence from Countries ) Temp pivot ( max(City) for ColumnSequence in (City1, City2, City3) ) Piv
Views: 193964 kudvenkat
Insert And Extract/Fetch Data From Database using PHP Script
 
11:32
http://technotip.com/570/insert-extractfetch-data-from-database-php-script/ Using PHP script insert user entered data into database and extract/fetch data stored in database and display it on the browser. This video tutorial also teaches the MySQL queries.
Views: 83206 Satish B
Tutorial 71 : Bulk Collect in Pl Sql || FETCH INTO Statement with Bulk Collect
 
05:28
Hi Friends, Here we are learning about FETCH INTO Statement with Bulk Collect. Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box. YouTube Link (Explicit Cursor) : https://youtu.be/vUMX9AnAOt8 Blog (Explicit Cursor) : https://saurabhsagarsinha.blogspot.com/2018/07/explicit-cursor-in-pl-sql-declare-open.html YouTube Link (Simple Loop) : https://youtu.be/BJZf-RMwutM Blog (Simple Loop) : https://saurabhsagarsinha.blogspot.com/2018/07/loop-in-oracle-simple-loop-explained.html YouTube Link (For Loop) : https://youtu.be/Sz1Eub37Tao Blog (For Loop) : https://saurabhsagarsinha.blogspot.com/2018/07/for-loop-in-oracle.html Blog (SELECT INTO Statement with Bulk Collect) : https://saurabhsagarsinha.blogspot.com/2018/09/bulk-collect-in-pl-sql-select-into.html Thanks, Happy Coding.
Views: 52 YourSmartCode
Ubuntu Server apt-get update error SOLVED
 
04:34
In case you have problems with connecting to online repository for you Ubuntu Server, watch this video and see how easy is to fix errors that is generated because you can't connect to online repository of your Ubuntu Server Distro!
Views: 130748 bloger bobo
Using jQuery to Update a Page Without Refresh (Part 1 of 2)
 
14:47
In this video I show you how to update a page without refreshing using jQuery and JSON objects. Being able to do this is a key feature of single-page applications (SPA). As always, if you have any questions, please feel free to ask! Get the code here: https://prettyprinted.com/blog/577473/using-jquery-to-update-a-page-without-refresh
Views: 14147 Pretty Printed
Java Project For Beginners Step By Step Using NetBeans And MySQL Database In One Video [ With Code ]
 
02:30:28
Java Project Step By Step Using NetBeans With Source Code Project PlayList: https://www.youtube.com/playlist?list=PLFDH5bKmoNqwOYnwOmljGuivo4a9EeIvC ▶ Source Code: http://1bestcsharp.blogspot.com/2016/07/java-and-mysql-project-code-example.html ------------------ Check out more Java Projects! -------------------- ▶ Inventory Management System - http://bit.ly/Java_Inventory ▶ Students Information System - http://bit.ly/Students_System ▶ Contacts Management System - http://bit.ly/Java_Contacts ▶ All My Programming Projects Here - http://bit.ly/2HrU8hK ▶ My Source Code Store Here - http://bit.ly/2OsC0TU -------------------------- JAVA COURSE ----------------------------- ▶ Master Java core Development step-by-step - http://bit.ly/2HXSuAn -------------------------------------------------------------------- programming projects with source code: http://1bestcsharp.blogspot.com/p/programming-projects.html visit our blog https://1bestcsharp.blogspot.com/ subscribe: http://goo.gl/nRjPKk C# And Java Programming Books http://1bestcsharp.blogspot.com/2015/04/c-and-java-programming-books.html In this java Project Video we will see How To Create A Project For Beginners With MySQL Database Using NetBeans IDE With Source Code . Project Description: - swing controls used in this project : jtextfield, button, jtabel, jlabel, jdatechooser and some images - Insert Data To MySQL DataBase , - Connect Java To MySQL , - Update Data To MySQL , - Delete Data From DataBase , - Populate JTable From MySQL DataBase , - Browse And Display Image Into JLabel , - Navigation Buttons First, Next, Previous, Last , I Use In This Tutorial: - Java Programming Language . - NetBeans IDE . - XAMPP . - PhpMyAdmin . - MySQL Database . Java Tutorials: Insert Update Delete Data In MySQL Database Using Java https://www.youtube.com/watch?v=uKEgKETRCzE Add And Update A Row To JTable From JTextField + Delete Row In Java https://www.youtube.com/watch?v=22MBsRYuM4Q JAVA MySQL Database Rocords Navigation Buttons https://www.youtube.com/watch?v=WkPWPuGHTTI Search Values From MySQL Database And Set It Into JTextfield In Java https://www.youtube.com/watch?v=uuhEb0k3vVE bind jtable from mysql database in netbeans https://www.youtube.com/watch?v=G4JeKZ6nDUI insert Image in MySQL Database using Java https://www.youtube.com/watch?v=UusZGBkV6HI Java Login Form With MySQL Database Part 1 : https://www.youtube.com/watch?v=7sNYhlBz9xo Part 2 : https://www.youtube.com/watch?v=meGhTnlS9k4 Retrieve And Display Image From Mysql In Java https://www.youtube.com/watch?v=7QEgJnnEmnE How To Bind JTable From MySQL Using ArrayList In NetBeans https://www.youtube.com/watch?v=2d4i6BXQPFA How To Browse Image To Jlabel Using JFilechooser In NetBeans https://www.youtube.com/watch?v=VHd29F_Tk04 How To display Image From Database To JTable In Java https://www.youtube.com/watch?v=-ekqLViEvHg How To Get JTable Column Sum, Avarage, Max, Min Value In Java https://www.youtube.com/watch?v=ZCfk6S2BksA jtable click https://www.youtube.com/watch?v=91Rp2MA0i94 show jtable row data in another jframe https://www.youtube.com/watch?v=9Ot-cWh0Rhw insert update delete and display data in jtable https://www.youtube.com/watch?v=QKsfHqu4Pps https://www.youtube.com/watch?v=WIMojkwMTa0 see this project in serie : Part1 : https://www.youtube.com/watch?v=qGZMrRdE1Wc Part2 : https://www.youtube.com/watch?v=jnztpHqm5uI Part3 : https://www.youtube.com/watch?v=Jt62k0kyZDw Part4 : https://www.youtube.com/watch?v=mdPNwrQ8kxU Part5 : https://www.youtube.com/watch?v=DULRdveVIV8 Part6 : https://www.youtube.com/watch?v=e-hAIY9QtqA Part7 : https://www.youtube.com/watch?v=ZZIFJpd6jmk Part8 : https://www.youtube.com/watch?v=WX0Jk6OGL-Y Part9 : https://www.youtube.com/watch?v=k0QBcnI986I Part10 : https://www.youtube.com/watch?v=YLmNKoR2k_s Part11 : https://www.youtube.com/watch?v=xe1bZYkhSa0 check out "top programming courses on udemy" Post: http://1bestcsharp.blogspot.com/2016/11/top-udemy-programming-courses.html I created this video with the YouTube Video Editor (http://www.youtube.com/editor)
Views: 5301202 1BestCsharp blog
Java prog#6. How to link jcombobox with database in Netbeans  Java  and Sqlite (mysql)
 
08:29
------------------Online Courses to learn---------------------------- Java - https://bit.ly/2H6wqXk C++ - https://bit.ly/2q8VWl1 AngularJS - https://bit.ly/2qebsLu Python - https://bit.ly/2Eq0VSt C- https://bit.ly/2HfZ6L8 Android - https://bit.ly/2qaRSAS Linux - https://bit.ly/2IwOuqz AWS Certified Solutions Architect - https://bit.ly/2JrGoAF Modern React with Redux - https://bit.ly/2H6wDtA MySQL - https://bit.ly/2qcF63Z ----------------------Follow--------------------------------------------- My Website - http://www.codebind.com My Blog - https://goo.gl/Nd2pFn My Facebook Page - https://goo.gl/eLp2cQ Google+ - https://goo.gl/lvC5FX Twitter - https://twitter.com/ProgrammingKnow Pinterest - https://goo.gl/kCInUp Text Case Converter - https://goo.gl/pVpcwL -------------------------Stuff I use to make videos ------------------- Stuff I use to make videos Windows notebook – http://amzn.to/2zcXPyF Apple MacBook Pro – http://amzn.to/2BTJBZ7 Ubuntu notebook - https://amzn.to/2GE4giY Desktop - http://amzn.to/2zct252 Microphone – http://amzn.to/2zcYbW1 notebook mouse – http://amzn.to/2BVs4Q3 ------------------Facebook Links ---------------------------------------- http://fb.me/ProgrammingKnowledgeLearning/ http://fb.me/AndroidTutorialsForBeginners http://fb.me/Programmingknowledge http://fb.me/CppProgrammingLanguage http://fb.me/JavaTutorialsAndCode http://fb.me/SQLiteTutorial http://fb.me/UbuntuLinuxTutorials http://fb.me/EasyOnlineConverter Jave Netbeans and Sqlite (mysql) populate jcombobox In this video I have tried to show how to use jcombobox with database ComboBox for Java using NetBeans java netbeans and mysql populate combo box binding jComboBox to mysql database How to get the selected Text in JComboBox? populating combo box Fill JComboBox with MySQL data Netbeans Adding items to a jComboBox Populating Combo Box Selections With NetBeans - Java Fill JComboBox with MySQL data Java - JComboBox - Obtain Values How Use the Combo Box With Netbeans GUI Combo Box in Netbeans java - How do I populate jcombobox from a textfile? jComboBox demo Netbeans IDE Users - JCombo Box using Net Beans How To Add Jcombobox List From Database? link jcombobox with database Jcombobox with database help JAVA - How do I populate a jcombobox with information from a mySQL database? iit Learn java netbeans java tutorial netbeans
Views: 193131 ProgrammingKnowledge
Learn Oracle | PL SQL Cursor Types : Explicit Cursor, Implicit Cursor
 
14:02
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: 1189 Pebbles Tutorials
Import Excel Data to ASP.NET MVC
 
24:25
In this video, I will demo how to Import Excel Data to ASP.NET MVC. To download all sources code for this demo please pay for me $5 at my PayPal Account: [email protected] ====================================================== You can see and download source code demo from my Apps at https://play.google.com/store/apps/developer?id=PMK+Lab ====================================================== You also can buy my apps in http://codecanyon.net/user/octopuscodes/portfolio ====================================================== You also can read my blog in http://learningprogramming.net/ ====================================================== You also can learn Microsoft Office in https://www.youtube.com/channel/UCFrMOR6KF4cpa92OOPRyOng ====================================================== TODAY IS A GREAT DAY TO LEARN SOMETHING NEW! ====================================================== Finding Software videos help you watch reviews for Open Sources:Joomla, wordpress, drupal, magento, html template, free admin template, free bootstrap admin templates, SilverStripe, Cake PHP, CodeIgniter, Concrete5, Modx, ExpressionEngine, Alfresco,TYPOlight, laravel, magento, angularjs, node.js, html, css, javascript, jquery, java, .net, wamp server, xampp, php, mysql, sql server, oracle, open sources, android, hibernate, jpa, html5, jquery
Views: 49629 Learning Programming
From Oracle DB to RESTful Web Services
 
15:23
Via REST, you can create APIs that can be accessed and consumed by external applications. Each API provides access to a subset of data in your database. In this screencast, using an OracleDB, you are shown exactly how to do that.
Views: 25810 NetBeansVideos
Oracle Bulk Collect, Part I
 
04:09
Bulk collect is a good choice when you need to fetch large volumes of data and populate tables.
Views: 293 Blanca Keogh
how to: Fetch Data From DataBase to Table in Java
 
10:02
This video is about how to Fetch Data From DataBase to JTable in Java VISIT OUR BLOG: http://TECHWITHALI.COM TO READ AMAZING TECHNICAL ARTICLES.
Views: 30847 TECH WITH Ali
Part 1   How to find nth highest salary in sql
 
11:45
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-1-how-to-find-nth-highest-salary_17.html This is a very common SQL Server Interview Question. There are several ways of finding the nth highest salary. By the end of this video, we will be able to answer all the following questions as well. How to find nth highest salary in SQL Server using a Sub-Query How to find nth highest salary in SQL Server using a CTE How to find the 2nd, 3rd or 15th highest salary Let's use the following Employees table for this demo Use the following script to create Employees table Create table Employees ( ID int primary key identity, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) GO Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000) Insert into Employees values ('Mark', 'Hastings', 'Male', 60000) Insert into Employees values ('Steve', 'Pound', 'Male', 45000) Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000) Insert into Employees values ('Philip', 'Hastings', 'Male', 45000) Insert into Employees values ('Mary', 'Lambeth', 'Female', 30000) Insert into Employees values ('Valarie', 'Vikings', 'Female', 35000) Insert into Employees values ('John', 'Stanmore', 'Male', 80000) GO To find the highest salary it is straight forward. We can simply use the Max() function as shown below. Select Max(Salary) from Employees To get the second highest salary use a sub query along with Max() function as shown below. Select Max(Salary) from Employees where Salary [ (Select Max(Salary) from Employees) To find nth highest salary using Sub-Query SELECT TOP 1 SALARY FROM ( SELECT DISTINCT TOP N SALARY FROM EMPLOYEES ORDER BY SALARY DESC ) RESULT ORDER BY SALARY To find nth highest salary using CTE WITH RESULT AS ( SELECT SALARY, DENSE_RANK() OVER (ORDER BY SALARY DESC) AS DENSERANK FROM EMPLOYEES ) SELECT TOP 1 SALARY FROM RESULT WHERE DENSERANK = N To find 2nd highest salary we can use any of the above queries. Simple replace N with 2. Similarly, to find 3rd highest salary, simple replace N with 3. Please Note: On many of the websites, you may have seen that, the following query can be used to get the nth highest salary. The below query will only work if there are no duplicates. WITH RESULT AS ( SELECT SALARY, ROW_NUMBER() OVER (ORDER BY SALARY DESC) AS ROWNUMBER FROM EMPLOYEES ) SELECT SALARY FROM RESULT WHERE ROWNUMBER = 3
Views: 914732 kudvenkat
PL/SQL tutorial 12: PL/SQL WHILE Loop in Oracle Database
 
06:33
Iterative statements/loop series learn the concepts of While Loop in PL/SQL or In Oracle Database with Examples. also learn how to handle boolean expression in while loop ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/while-loop-in-pl-sql Previous Tutorial ► Simple Loop: https://youtu.be/AFx6QYcY1CU ------------------------------------------------------------------------- ►►►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: 57785 Manish Sharma
SQL Tutorial 12 Advanced Subqueries returning multiple columns
 
14:22
SQL Tutorial on Advanced Subqueries returning multiple columns Check out our website: http://www.telusko.com Follow Telusko on Twitter: https://twitter.com/navinreddy20 Follow on Facebook: Telusko : https://www.facebook.com/teluskolearnings Navin Reddy : https://www.facebook.com/navintelusko Follow Navin Reddy on Instagram: https://www.instagram.com/navinreddy20 Subscribe to our other channel: Navin Reddy : https://www.youtube.com/channel/UCxmkk8bMSOF-UBF43z-pdGQ?sub_confirmation=1 Telusko Hindi : https://www.youtube.com/channel/UCitzw4ROeTVGRRLnCPws-cw?sub_confirmation=1
Views: 60294 Telusko
Oracle Database PLSQL Cursor
 
54:18
Oracle Database PLSQL Cursor
Views: 215 Lead Technologies
Part 12   Can we join two tables without primary foreign key relation
 
10:38
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/09/part-12-can-we-join-two-tables-without.html Can we join two tables without primary foreign key relation Yes, we can join two tables without primary foreign key relation as long as the column values involved in the join can be converted to one type. ID column in Departments table is not the primary Key and DepartmentId column in Employees table is not the foreign key. But we can still join these tables using ID column from Departments table and DepartmentId column from Employees table, as both the columns involved in the join have same data type i.e int. Select Employees.Name as EmployeeName, Departments.Name as DepartmentName from Employees join Departments on Departments.ID = Employees.DepartmentId The obious next question is, if primary foreign key relation is not mandatory for 2 tables to be joined then what is the use of these keys? Primary key enforces uniqueness of values over one or more columns. Since ID is not a primary key in Departments table, 2 or more departments may end up having same ID value, which makes it impossible to distinguish between them based on the ID column value. Foreign key enforces referential integrity. Without foreign key constraint on DepartmentId column in Employees table, it is possible to insert a row into Employees table with a value for DepartmentId column that does not exist in Departments table. The following insert statement, successfully inserts a new Employee into Employees table whose DepartmentId is 100. But we don't have a department with ID = 100 in Departments table. This means this employee row is an orphan row, and the referential integrity is lost as result Insert into Employees values (8, 'Mary', 'Female', 80000, 100) If we have had a foreign key constraint on DepartmentId column in Employees table, the following insert statement would have failed with the following error. Msg 547, Level 16, State 0, Line 1 The INSERT statement conflicted with the FOREIGN KEY constraint. The conflict occurred in database "Sample", table "dbo.Departments", column 'ID'.
Views: 116893 kudvenkat
HOW TO USE UPDATE COMMAND IN ORACLE ...BY SANDEEP KUMAR MAURYA..9451818227
 
07:49
Hi Guys, This is Sandeep Kumar Maurya I have Always been asked to share my code which I use in my video. Answering people’s questions is great, and the feeling you get when you solve a problem always felt good. The only problem I have is making tutorials is a little bit time consuming. It requires planning the subjects that need to be covered, recording the tutorial, editing the video, rendering it and finally uploading it on YouTube. So I need your help in Collecting All the codes at one place. I made a website Codebind.com for sharing my code and other programming stuff. But I alone can not do this. So Ask you guys to become contributor to this site. Just Share the code Which you learn by watching Programming Knowledge or You can simply share your Programming Knowledge with others. What is your Benefit? 1 - Together we can collect all the codes of All my videos and share it with others. 2 - Sharing Knowledge is the biggest learning. By sharing You can understand the concepts better. Bindas Programming..........
Views: 48 Bindas Programming
oracle in select
 
13:49
oracle in select
Views: 454 Prakash Mishra
Part 19   Copying data from one table to another table using SqlBulkCopy
 
09:35
In this video we will discuss copying data from one table to another table. The source and destination tables may be in the same database or in different databases and these database can be on the same sql server or in different servers. In Part 18 we discussed, loading xml data into sql server table using sqlbulkcopy. We will be continuing with the example we worked with in Part 18. Step 1 : Create a new database. Name it SourceDB. Execute the following sql script to create Departments and Employees tables, and to populate with data. Create table Departments ( ID int primary key identity, Name nvarchar(50), Location nvarchar(50) ) GO Create table Employees ( ID int primary key identity, Name nvarchar(50), Gender nvarchar(50), DepartmentId int foreign key references Departments(Id) ) GO Insert into Departments values ('IT', 'New York') Insert into Departments values ('HR', 'London') Insert into Departments values ('Payroll', 'Muumbai') GO Insert into Employees values ('Mark', 'Male', 1) Insert into Employees values ('John', 'Male', 1) Insert into Employees values ('Mary', 'Female', 2) Insert into Employees values ('Steve', 'Male', 2) Insert into Employees values ('Ben', 'Male', 3) GO Step 2 : Create another new database. Name it DestinationDB. Execute the sql script to just create Departments and Employees tables. Here we have just the structre of the tables and no data. We will be moving data from SourceDB tables to DestinationDB tables. Step 3 : Include the following 2 connection strings for the Source and Destination databases in the web.config file of the Demo project we created in Part 18. [connectionStrings] [add name="SourceCS" connectionString="server=.;database=SourceDB;Integrated Security=True" providerName="System.Data.SqlClient" /] [add name="DestinationCS" connectionString="server=.;database=DestinationDB;Integrated Security=True" providerName="System.Data.SqlClient" /] [/connectionStrings] Step 4 : Copy and paste the following code in the button click event handler method in the code-behind file string sourceCS = ConfigurationManager.ConnectionStrings["SourceCS"].ConnectionString; string destinationCS = ConfigurationManager.ConnectionStrings["DestinationCS"].ConnectionString; using (SqlConnection sourceCon = new SqlConnection(sourceCS)) { SqlCommand cmd = new SqlCommand("Select * from Departments", sourceCon); sourceCon.Open(); using (SqlDataReader rdr = cmd.ExecuteReader()) { using (SqlConnection destinationCon = new SqlConnection(destinationCS)) { using (SqlBulkCopy bc = new SqlBulkCopy(destinationCon)) { bc.DestinationTableName = "Departments"; destinationCon.Open(); bc.WriteToServer(rdr); } } } cmd = new SqlCommand("Select * from Employees", sourceCon); using (SqlDataReader rdr = cmd.ExecuteReader()) { using (SqlConnection destinationCon = new SqlConnection(destinationCS)) { using (SqlBulkCopy bc = new SqlBulkCopy(destinationCon)) { bc.DestinationTableName = "Employees"; destinationCon.Open(); bc.WriteToServer(rdr); } } } } Note: Please make sure to include the following using declarations using System; using System.Configuration; using System.Data; using System.Data.SqlClient; As the column names in the source and destination tables are the same column mappings are not required. Text version of the video http://csharp-video-tutorials.blogspot.com/2014/09/part-19-copying-data-from-one-table-to.html Slides http://csharp-video-tutorials.blogspot.com/2014/09/part-19-copying-data-from-one-table-to_24.html All ADO .NET Text Articles http://csharp-video-tutorials.blogspot.com/p/free-adonet-video-tutorial.html All ADO .NET Slides http://csharp-video-tutorials.blogspot.com/p/adonet-slides.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 56792 kudvenkat