Home
Search results “Oracle select no data found”
Oracle tutorial : Exception Handling In Oracle PL SQL
 
13:21
Oracle tutorial : Exception Handling In Oracle PL SQL pl sql exception no data found pl sql select no data found oracle trigger exception pl sql exception handling best practice CREATE OR REPLACE PROCEDURE ORA_EXCE_HANDLING IS MYQUERY VARCHAR2(100); STR_ID VARCHAR2(10); BEGIN MYQUERY:='SELECT ID FROM MYDEV.EMPLOYEE111 WHERE ID=''1'''; DBMS_OUTPUT.PUT_LINE('QUERY '||MYQUERY); BEGIN EXECUTE IMMEDIATE MYQUERY INTO STR_ID; EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE('EXCEPTION CAPTURE.'); WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE('OTHER EXCEPTION IS CAPTURE HERE :'||SQLERRM); END; DBMS_OUTPUT.PUT_LINE('EMPLOYEE ID '||STR_ID); END; #techquerypond https://techquerypond.wordpress.com https://techquerypond.com https://twitter.com/techquerypond
Views: 891 Tech Query Pond
9. Send app-specific error message with RAISE_APPLICATION_ERROR.
 
02:26
If you execute a SELECT-INTO that does not identify any rows, the PL/SQL runtime engine raises: ORA-01403 and the error message (retrieved via SQLERRM or DBMS_UTILITY.FORMAT_ERROR_STACK) is simply "No data found". That may be exactly what you want your users to see. But there is a very good chance you'd like to offer something more informative, such as "An employee with that ID is not in the system." In this case, you can use RAISE_APPLICATION_ERROR, as in: CREATE OR REPLACE PACKAGE BODY employees_mgr IS FUNCTION onerow (employee_id_in IN hr.employees.employee_id%TYPE) RETURN hr.employees%ROWTYPE RESULT_CACHE IS l_employee hr.employees%ROWTYPE; BEGIN SELECT * INTO l_employee FROM hr.employees WHERE employee_id = employee_id_in; RETURN l_employee; EXCEPTION WHEN NO_DATA_FOUND THEN raise_application_error ( -20000, 'An employee with that ID is not in the system.'); END; END; Related blog post: http://stevenfeuersteinonplsql.blogspot.com/2016/03/nine-good-to-knows-about-plsql-error.html ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
PL/SQL:Exceptions
 
12:09
In this tutorial, you'll learn the difference between compile & run time error and how to handle the exceptions..
Views: 15245 radhikaravikumar
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: 119643 Manish Sharma
MVC  - Table -  Display No Data Found if empty table
 
01:11
More info with ready to copy/paste code http://howtodomssqlcsharpexcelaccess.blogspot.ca/2016/11/mvc-table-display-no-data-found-message.html
Views: 551 Vis Dotnet
Oracle Database11g tutorials 5:  how to retrieve Data Using SQL SELECT statement || SQL tutorials
 
05:13
This SQL tutorial and Oracle database 11g tutorial for beginners will show how to retrieve data using SQL SELECT statement. Tool used in this tutorial is SQL developer. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 You can download the Script which is used in this SQL tutorial from this link https://copy.com/yDQ46Tb64efm Contacts Email [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/RebellionRider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from The Code makers
Views: 194206 Manish Sharma
Create new connection with new user in Oracle SQL Developer
 
10:28
This video shows you how to create a new connection using a new user account (other than the system user account) in Oracle SQL Developer, so that you have a clean workspace without all the clutter of system tables. It is NOT a general introduction to using Oracle SQL Developer.
Views: 342426 Chitu Okoli
SQL Into - How to Copy Table Data with Select Into Statement - SQL Training Online
 
05:08
http://www.sqltrainingonline.com SQL Into - How to Copy Table Data with Select Into Statement - SQL Training Online In this video, I show you how to copy data using the SQL INTO statement. Including a trick to copy only a table schema in SQL Server. How do you copy a whole table in SQL Server? You often see the SQL INTO statement when you are using INSERT, but there is a special INTO statement in SQL Server that is used with the SELECT statement that allows you to make a copy of a table for development, testing, or whatever purpose you can think of. So, to start, let's take a look at the SQL Training Online Simple DB employee table. You can see that we have 14 records Now, all we have to do to make a copy of the table is to simply add the SQL INTO clause: SELECT * INTO EMPLOYEE_TEST FROM EMPLOYEE If we run that, you see that we made a copy of the table with all of the data. Now, I want to go ahead and empty the employee_test table and show you how to use the INSERT INTO. If you already have a copy of the table, (I will show you a shortcut in a minute on how to create a copy without data.) then you can use the following insert into statement: INSERT INTO EMPLOYEE_TEST SELECT * FROM EMPLOYEE After running that statement, you see that I have inserted data from the Employee table into the employee_test table. This is sometimes referred to as INSERT INTO SELECT. But, there is one trick that I have used throughout the years that is pretty cool. Sometimes, you want the table schema, but you don't want the data. Now, I know that you can use Management Studio to script out the table for you, but there is an easier way that is more flexible as far as I am concerned. That is to use the SELECT INTO FROM, but put the following in the WHERE clause: SELECT * INTO EMPLOYEE_TEST FROM EMPLOYEE WHERE 1=2 The 1=2 makes is so not data will come over, but you get the new table with the right column types. Is that pretty cool? I have found many uses for this over the years. Let me know what you think bellow. Let me know what you think by commenting or sharing on twitter, facebook, google+, etc. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 23014 Joey Blue
Formatting your Oracle Query Results Directly to CSV
 
03:02
How to get Oracle SQL Developer to automatically format your query results to CSV, HTML, JSON, Insert statements, and more.
Views: 42199 Jeff Smith
How to insert data into oracle database class No 3
 
25:05
How to insert data into oracle database in different types..select data..found data..quarry data and constant data with key.
Part 8   SQL Query to find department with highest number of employees
 
04:03
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-8-sql-query-to-find-department.html Scenario asked in the SQL Server Interview Based on the above two tables write a SQL Query to get the name of the Department that has got the maximum number of Employees. To answer this question it will be helpful if you the knowledge of JOINS & GROUP BY in SQL Server. We discusses these in Parts 11 & 12 of SQL Server Tutorial video series. SQL query that retrieves the department name with maximum number of employees SELECT TOP 1 DepartmentName FROM Employees JOIN Departments ON Employees.DepartmentID = Departments.DepartmentID GROUP BY DepartmentName ORDER BY COUNT(*) DESC Scenario asked in the SQL Server Interview Based on the above two tables write a SQL Query to get the name of the Department that has got the maximum number of Employees. To answer this question it will be helpful if you the knowledge of JOINS & GROUP BY in SQL Server. We discusses these in Parts 11 & 12 of SQL Server Tutorial video series. SQL query that retrieves the department name with maximum number of employees SELECT TOP 1 DepartmentName FROM Employees JOIN Departments ON Employees.DepartmentID = Departments.DepartmentID GROUP BY DepartmentName ORDER BY COUNT(*) DESC
Views: 118109 kudvenkat
Oracle Database tutorials 4:  database connectivity using SQL developer and command prompt
 
09:19
Blog Link: http://bit.ly/how-to-create-new-connection-in-sql-developer Wishlist: http://bit.ly/wishlist-amazon This SQL tutorial and Oracle database 11g tutorial for beginners will show how to connect to database either on a local machine or on a machine in your LAN using ip address. Tool used in this tutorial is SQL developer & command prompt. This tutorial series is part of SQL expert exam certification training. If you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts Email [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/RebellionRider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos The Code makers
Views: 275314 Manish Sharma
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
 
01:43
How to Fix java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified This method is applicable only to those situations where you make use of DSN method. If you are using the URL & Password method , it won't be useful for you. The solution to this problem is to simply create an system DSN instead of a user DSN. Code for login.java file: https://drive.google.com/file/d/0BzHL-CDt8cpYQUlPOUxQaXpIaGc/edit?usp=sharing Download Latest Tomcat Over Here: http://tomcat.apache.org/download-80.cgi Download MS SQL Management Studio: http://www.microsoft.com/en-in/download/details.aspx?id=7593 How to Run A Servelt Program Using Tomcat 7: https://www.youtube.com/watch?v=vT8YB5wzpqA Comment , Rate & Subscribe !
Views: 127772 64-bit Programmer
How to write post query trigger in Oracle Forms.
 
06:57
How to write post query trigger in Oracle Forms. Post query triggers at block level to retrieve data from other table. This is a small tutorial in Oracle forms to show you creating forms post query trigger, writing pl sql code into triggers.
Views: 8364 Subhroneel Ganguly
SQL tutorial 49: CASE - Simple Case Expression in Oracle Database (1/2)
 
06:34
Case expression let you perform IF-THEN-ELSE in oracle database. There are two type of case in oracle simple case expression and searched case expression. This SQL Tutorial 49 is about Simple Case Expression. ● What Is Case Expression ● Syntax of Simple Case Expression ● Query 1. Column name of a table as Search expression in CASE ● Query 2. String as Search expression in CASE Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/simple-case-expression ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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 [email protected] 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: 37157 Manish Sharma
Connect Excel to Oracle Database
 
05:03
How to connect an Oracle Database to Microsoft Excel. https://www.elance.com/s/edtemb/
Views: 99449 i_marketing
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: 355397 Amit Andipara
How to Display Selected Database Columns in JTable in Java Swing
 
03:27
Get Source Code/Read : http://intactabode.com/ For Developing support email your Details at : [email protected] Install Free Trail GST Ready Accounting Package Send your Contact information Name, Email, Contact Number to watch demo in English : https://www.youtube.com/watch?v=a4sFNtZuYzs&ab_channel=IntactAbode watch demo in Hindi : https://www.youtube.com/watch?v=I3eCieDpG3o&ab_channel=IntactAbode For Source Code Visit : http://corneey.com/wJ6X2K Subscribe to YouTube channel http://corneey.com/wJ6VoC Like us on Facebook http://corneey.com/wJ6C2l Follow us on Twitter http://corneey.com/wJ6C7x Follow me on Google+ http://corneey.com/wJ6Vhc linkedin http://corneey.com/wJ6V5g Watch More Java Swing(Windows Builder) GUI Tips ans FAQS Here: https://www.youtube.com/playlist?list=PLErD1cRL87W-NzXGuV1tAGO8kf2zrqU0k IN this video i shown How to Display Selected Column in JTable in Java Swing, How to fetch the data and add display them in your prefered jtable __________________________________________________________________ Also Watch More Java Swing Tutorials How to Display Time and Date In java Swing https://youtu.be/i-M08_hATzM How to Set Password Limit Attempts in Java Swing https://youtu.be/6SxzUHHRnsA How to Print JTable Without any Jar in Java Swing https://youtu.be/0Z9IfjIAMo8 How to Increase Font Size in Eclipse IDE https://youtu.be/dcevO7XNjB8 How to Generate Random Numbers in Java Swng https://youtu.be/qvaXkqt9OSU How to Fetch Database Selected Row in JTextField Java Swing https://youtu.be/xm1ovgF9FNA How to Fetch Database Selected Row in JTextField Java Swing https://youtu.be/1QiWXpqT28s How to Fetch Database Column in JComboBox Java Swing https://youtu.be/V_KkRr0DJ4c Java swing close window on button Clicked https://youtu.be/mblB8eG2mjA How to Display Selected Database Columns in JTable in Java Swing https://youtu.be/oz4iD_lidHg How to Delete Row From JTable in Java Swing https://youtu.be/accjKR4fxUM How to Convert String to Integer and Vice Versa https://youtu.be/MsfpBRZbkxA How to Close Current Frame When Clicked on Exit Java Swing https://youtu.be/PLrnvBIO-lA How to Calculate JTable Column Values in Java Swing https://youtu.be/zu57Gdg5TDY How to Add JTextField Values in Jtable DefaultTableModel in Java Swing https://youtu.be/Wl5guY77TUc How to Add Image to JButton in Java Swing https://youtu.be/jGYqtIWn5OY How to Print Jtable Data in Java Swing https://youtu.be/zaMhFY1-0eI How to Add or Remove Values in Database in Java Swing https://youtu.be/ARQ0UHukZzI How to Generate Random Numbers in Java https://youtu.be/p0psde93IBg How to Show Selected Colomn in JLable From Database in Java https://youtu.be/ydjouDv8tzQ How to Display Message in JLable in Java Swing https://youtu.be/L8xs35wX1QY Validations for JTextField in Java Swing Application https://youtu.be/MxEvihnQOD0 How to Open Two JFrames on One Button Click in Java https://youtu.be/zW9jn8e2lnc
Views: 12842 Intact Abode
How To Install MySQL on Windows 10
 
24:18
In this post we will learn how to How To Install MySQL on Windows 10. The same procedure can be used for installing MySQL on Windows 8 / Windows 7. But first let's see What is MySQL . MySQL is a very popular, open source database. Officially pronounced “my Ess Que Ell” (not my sequel). Handles very large databases; very fast performance. Why are we using MySQL? Free (much cheaper than Oracle!) Each student can install MySQL locally. Easy to use Shell for creating tables, querying tables, etc.Easy to use with Java JDBC. While installing MySQL, it will prompt you to create a root password . At this stage please select a safe and secure password . Make sure you remember the password, to use it later.MySQL tutorial for beginners and professionals with examples on CRUD, insert statement, select statement, update statement, delete statement, use database, keys, joins etc. -------------------Online Courses to learn---------------------------- Data Analytics with R Certification Training- http://bit.ly/2rSKHNP DevOps Certification Training - http://bit.ly/2T5P6bQ AWS Architect Certification Training - http://bit.ly/2PRHDeF Python Certification Training for Data Science - http://bit.ly/2BB3PV8 Java, J2EE & SOA Certification Training - http://bit.ly/2EKbwMK AI & Deep Learning with TensorFlow - http://bit.ly/2AeIHUR Big Data Hadoop Certification Training- http://bit.ly/2ReOl31 AWS Architect Certification Training - http://bit.ly/2EJhXjk Selenium Certification Training - http://bit.ly/2BFrfZs Tableau Training & Certification - http://bit.ly/2rODzSK Linux Administration Certification Training-http://bit.ly/2Gy9GQH ----------------------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 ------------------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
Views: 509844 ProgrammingKnowledge
Php : How To Search And Filter Data In Html Table Using Php And MySQL Database [ with source code ]
 
08:32
How To Find Data In MySQL Database And Display It In Html Table Using Php Source Code: http://1bestcsharp.blogspot.com/2015/10/php-html-table-search-filter-data-mysql-database.html PHP Programming Tutorials ➜ http://bit.ly/2Lh7zPM PHP And MySQL Tutorials ➜ http://bit.ly/2kdXWot PHP Course For Beginners ➜ http://bit.ly/2GxRodb Web Development Course ➜ http://bit.ly/2ITRQrj visit our blog https://1bestcsharp.blogspot.com/ facebook: https://www.facebook.com/1BestCsharp twitter: https://www.twitter.com/1BestCsharp_ subscribe: http://goo.gl/nRjPKk Share This Video: https://youtu.be/2XuxFi85GTw In this Php Tutorial You will see How You Can Make Search Input Text And Show Data With Input Text Value In Html Table Using MySQL Database And Php . I Use In This Tutorial: - NetBeans IDE . - XAMPP . - PhpMyAdmin . Others Tutorials : Get Select Option Value From MySQL Database Using Php https://www.youtube.com/watch?v=V8sIWh_sdvs How To Populate Html Table From MySQL Database Using Php https://www.youtube.com/watch?v=6goqMwURH9Q How To Use Mysqli Num Rows In Php https://www.youtube.com/watch?v=12L6Sckk8cc How To Use Pdo Row Count In Php https://www.youtube.com/watch?v=F3tqnbDTP3k Insert Update Delete Search Data In MySQL Database Using Php Part1 https://www.youtube.com/watch?v=f85jvD_Y8Ck Check Out This: Top Programming Courses On Udemy http://1bestcsharp.blogspot.com/2016/11/top-udemy-programming-courses.html
Views: 265953 1BestCsharp blog
VB.NET And SQL - Datagridview Search Data Using Visual  Basic .Net [ with source code ]
 
10:33
Search Data In SQL And Display On DataGridView In VB Net Source Code: http://1bestcsharp.blogspot.com/2016/09/vb.net-sql-search-data-and-display-datagridview.html ------------------ Check out my VB.Net Projects! -------------------- ▶ Inventory Management System - http://bit.ly/Vbnet_Inventory_System ▶ Students Information System - http://bit.ly/VbnetStudent_System ▶ Contacts Management System - http://bit.ly/Vbnet_Contacts ▶ All My Programming Projects Here - http://bit.ly/2HrU8hK ▶ My Source Code Store Here - http://bit.ly/2OsC0TU -------------------------- VB.NET COURSE ----------------------------- ▶ Learning Visual Basic .NET - http://bit.ly/2wnNiVt -------------------------------------------------------------------- Programming Projects: http://1bestcsharp.blogspot.com/p/programming-projects.html visit our blog https://1bestcsharp.blogspot.com/ facebook: https://www.facebook.com/1BestCsharp twitter: https://www.twitter.com/1BestCsharp_ subscribe: http://goo.gl/nRjPKk C# And Java Programming Books http://1bestcsharp.blogspot.com/2015/04/c-and-java-programming-books.html In This VB.NET Tutorial We Will See How To Search Records From SqlServer Database On Button Click Event And Text Changed Event With Microsoft SQL DataBase Using Visual Basic .NET Programming Language. subscribe for more tutorials VB.NET And SQL Server Database Tutorials: Connect SqlServer Database With Vb.net https://www.youtube.com/watch?v=098akejVsG8 Select And Display Data From SQL Server Database Using Vbnet https://www.youtube.com/watch?v=z3NpONNl2Qk Insert Data Into SQLServer Database Using VB NET https://www.youtube.com/watch?v=MWP8geR76kI Update Data In Database Using Vbnet https://www.youtube.com/watch?v=VC2XRfxmNBM Delete Data From SQL Server Database Using Visual Basic .NET https://www.youtube.com/watch?v=NSRDbI4Jra0 Search Values From SQL Server Database And Set It Into TextBox In Visual Basic .NET https://www.youtube.com/watch?v=CarCQoqDCGM Populate ComboBox From SQL Values In VbNet https://www.youtube.com/watch?v=3LIOcTLPh80 SQL Server Records Navigation Using Visual Basic.Net https://www.youtube.com/watch?v=DnAYjApOEtI Datagridview Search Data Using VB.Net https://www.youtube.com/watch?v=zn4zgBeUwnA Insert Update Delete https://www.youtube.com/watch?v=u9DqI0oAzmk Login Form With SQL Database https://www.youtube.com/watch?v=a9wloibYVNI VB NET Using SQL Stored Procedures https://www.youtube.com/watch?v=O_olT5FnqOg Insert Image Into SQL DataBase Part 1: https://www.youtube.com/watch?v=3ZjsimNLdLY Part 2: https://www.youtube.com/watch?v=u1vpYKkPquI Retrieve Image From SQL DataBase In Visual Basic.net https://www.youtube.com/watch?v=GUNZ1hfCsHc Retrieve Images From SQL DataBase Into DataGridView In VB.net https://www.youtube.com/watch?v=F72XSYlOwxk
Views: 104865 1BestCsharp blog
Oracle Database Tutorial 70: IO ERROR: The network adapter could not establish the connection
 
03:34
IO ERROR: The network adapter could not establish the connection Learn how to solve this Oracle Database / SQL Developer Error with in 4 minutes ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-developer-error-the-network-adapter-could-not-establish-the-connection Previous Tutorial ► Intersect and Minus SQL set operators https://youtu.be/sDZFpwEw1k8 ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►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 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: 147868 Manish Sharma
Using Database Connection Strings in App.Config-Windows Application .NET.mp4
 
13:54
In this video I have shown how to use database connection strings in the app.config file,in a Windows Application .NET project... I have used Visual Studio 2010 for this purpose... Hope u like it...
Views: 67029 Piyush Agarwal
How to Reset Root Password On Ubuntu 18.04 / 16.04 / 17.10 LTS
 
05:23
1 Reboot your computer. 2 Hold Shift during boot to start GRUB menu. 3 Select advanced options for ubuntu 4 Select the option with recovery mode 5 Select root and press enter 6 Give command - mount -n -o remount,rw / 7 Press Enter 8 Give command - passwd your_username 9 Give new password 10 reboot ------------------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 Searches related to How to Reset Root Password In Ubuntu how to set root password in ubuntu how to reset root password in ubuntu using grub forgot ubuntu password how to change root password in ubuntu create root password ubuntu ubuntu change password terminal start ubuntu in recovery mode linux root password
Views: 210153 ProgrammingKnowledge
Learning PL/SQL programming
 
29:21
Download the session ppts @ https://drive.google.com/file/d/0B_2D199JLIIpLXp5cm9QMFpVS00/view?usp=sharing 3:05 - Procedures 6:48 - Cursors 15:13 - Functions 16:36 - Triggers 21:35 - Package 23:59 - Exceptions
Views: 134210 BBarters
How to Use Google Forms to Collect Data
 
19:24
Learn to use Google Forms to collect data from specific people by sharing the link on email or on social media. It is a 3 step process that starts with creation of form and then next step is to distribute it to the audience and third step is to collect the data. All the three steps to use Google form have been explained in this tutorial. Share this video:http://youtu.be/s94fL4g0riI common use of various question types in Google forms is given below - Text — Respondents provide short answers Paragraph text — Use this for long answers Multiple choice — Respondents select one option from among several Checkboxes — select as many options from checkboxes. Choose from a list — respondents select one option from a dropdown menu Scale — rank something along a scale of numbers (e.g., from 1 to 5) Grid — respondents select a point from a two-dimensional grid Date — People filling the form can use a calendar picker to enter a date Time — respondents select a time (either a time of day or a duration of time) You can plan events, make a survey, give quiz to students or simply collect any data on Google Forms. It can save you from lot of physical effort as the collected data automatically gets saved in the linked spreadsheet.You can insert an image or video on Google forms and also set a customize theme for your form. Google forms is a gem in the Google docs, that's free to use and has a powerful tools like regular expressions that help to validate the data.Currently, only Text, Paragraph text, Check boxes, and Grid questions have support for validation. This video tutorial also covers certain Frequently asked questions given below- Can I capture respondents email address automatically? Can I receive notification on email every time a form is submitted? Can i send a personal thank you message to the respondents? Can i use Capcha on Google Form? Harish Bali is the creator of this video, he is a social media expert and an SEO. ............................................................................................... Learn to use Regular expressions in Google forms: https://support.google.com/docs/answer/3378864?hl=en Learn useful regular expressions for data validation by Labnol.org: http://www.labnol.org/internet/regular-expressions-forms/28380/ You can watch my other video on: How to use mail merge in gmail: https://www.youtube.com/watch?v=skrGMoq_TRA How to use Google drive to share files: https://www.youtube.com/watch?v=Itn3WIhQ6NQ Follow us: Blog on Tech Guide: http://www.technofare.com/ Google Plus Technofare : https://plus.google.com/+Technofareblog/posts Google Plus Harish Bali: https://plus.google.com/+harishBali/posts Facebook: https://www.facebook.com/technofare?ref=bookmarks Subscribe to Channel: https://www.youtube.com/user/Technofare Hope you found the detailed tutorial on how to use Google forms to collect data useful. Do share it with your friends on social media.
Views: 222852 Technofare
Java JDBC Tutorial - Part 1: Connect to MySQL database with Java
 
09:06
5 FREE JAVA VIDEO COURSES - CLICK HERE - https://goo.gl/7i95F8 --- View more videos on my "Java JDBC Tutorial" Playlist: http://goo.gl/crT4nS Closed-Captioning and English subtitles available. In this tutorial, you will learn how to connect to a MySQL database with Java. Download source code from - http://www.luv2code.com/2014/03/21/connect-to-mysql-database-with-java-jdbc/ Please subscribe to my channel. http://goo.gl/EV6Kwv ---- Follow luv2code: Website: http://www.luv2code.com YouTube: http://goo.gl/EV6Kwv Twitter: http://goo.gl/ALMzLG Facebook: http://goo.gl/8pDRdA --- Join my mailing list: Get advance notice on new tutorials. Emails about 1 per week. - http://www.luv2code.com/joinlist --- Questions or problems? Post them in the comments section below. --- Want to suggest a video? Leave a comment below. I'm always looking for new video ideas. Let me know what video you'd like for me to create. --- Video Transcript Time - 00:00 Hello. In this tutorial, you will learn how to connect to a MySQL database with Java. In this session we’re going to learn how to connect a MySQL database with Java. Before we get started there are some prep work that needs to take place. One is that you need to have a MySQL database already installed. If not, you can download one from the site listed here on the slide. Time - 00:20 Next, we’ll need to download and install a MySQL JDBC driver. This driver will allow the Java program to connect to the database. You can download it from this URL, and I’ll do that now. I’ll just take this URL, drop it into my favorite browser and here I am at the page. I’m on this page, this is for downloading the Connector/J browser. I’ll select the platform, platform independent. Now move down and I’ll select download and it will download a zip archive. Make sure you download the most recent version. In this case it’s 5.1.29. Make sure you download something at that version or later. Time - 01:04 Download, scroll down, select, “No thanks, just start my download.” This will start downloading the file for you. Now what we can do is show it in the finder. I’ll double click it to extract it. At this point I have the driver extracted. There’s a file in here called MySQL connector.jar that we’ll use later. Time - 01:34 Next, what I need to do is create a Java project in Eclipse. Let’s do that. On Eclipse I’ll say I’ll save file, new, Java project. This will be JDBC demo and I will select finish. What I’ll do is I will add a new class. New, class, this will be my driver and it will have a public static void main region. At this point we have a shell for our project created. Time - 02:28 Next, what we’ll do is we will talk to the actual development process and I really like this slide because it outlines exactly what we need to do. The first thing we’ll do is add the database driver to the classpath. Next, we’ll get a connection, we’ll submit a SQL query and then we’ll process the result set. Time - 02:48 Let’s start with step one, adding a MySQL database driver to the classpath. In our Eclipse project I’m going to add a new folder called lib, lib for library. In this lib folder I’m going to add the driver that I downloaded earlier. What I’ll do is I’ll just grab this driver. It’s the MySQL connector bin.jar and I’ll just drag and drop it to this lib folder. It will prompt me and I’ll say go ahead and copy the file. Time - 03:25 Next, I need to add the jar file, the driver to the classpath. I’ve set this up with properties, choose Java build path and then I’ll choose add jars. Expand this folder, that lib, I’ll grab that jar file and I’ll have it setup. Great. Time - 03:51 Now we can start coding. We need to get a connection, submit a SQL query and process a result set. Let me just sketch this out on a slide over here. The first thing I’ll do up top is I’ll just do an import on java.sql.* because all of the classes and interfaces that we need are in this package. Time - 04:17 I’ll also just setup a try catch block just to handle for any exception that may occur. Small typo there. Time - 04:40 Inside of this section I’m going to first get a connection to database. Then next I will create a statement. Then from here I will execute a SQL query and then I will process the result set. Time - 05:16 That’s my basic game plan, let’s fill it in with some real code. Here I’ll say connection, myConn = DriverManager.getConnection. I’ll give the jdbc:mysql://localhost:3306/demo student, student. Student is the user ID and student is also the password. [snip] Click the Transcripts tab for full transcript.
Views: 633852 luv2code
How to INSERT data into table in MySQL?
 
02:44
MySQL INSERT MySQL INSERT statement is used to insert data in MySQL table within the database. We can insert single or multiple records using a single query in MySQL. Syntax: The SQL INSERT INTO command is used to insert data in MySQL table. Following is a generic syntax: INSERTINTO table_name ( field1, field2,...fieldN ) VALUES ( value1, value2,...valueN ); Field name is optional. If you want to specify partial values, field name is mandatory.Syntax for all fields: INSERTINTO table_name VALUES ( value1, value2,...valueN ); Example 1: for all fields If you have to store all the field values, either specify all field name or don't specify any field. Example: INSERTINTO emp Subscribe channel on YouTube:- https://www.youtube.com/c/ipctrd/videos Read this post on Blogger:- http://ipctrd.blogspot.in/ Like page on Facebook:- https://www.facebook.com/ipctrd/ Tweet about video on twitter:- https://twitter.com/ipctrd Let's chat on whatsapp:- https://chat.whatsapp.com/BrHbRDvbfs64CulIoLfbjf See you at Instagram :- https://www.instagram.com/ipctrd/ Google+ :- https://plus.google.com/u/0/101013097390807587448
Views: 605 Ipctrd
Oracle SQL Tutorial 16 - Parent Child Relationships
 
06:09
So far in this series we have discussed database design, creating tables, and constraints. We've brought up the concept of foreign keys, but we have not explained how to create them. That is the goal of this video and the upcoming videos. We want to study those foreign keys! Let's make them not so foreign. Let's learn the proper way to define a foreign key. As a reminder, a foreign key is a column that references a column of another table. The column it references must either be a primary key, or have the UNIQUE constraint. This means that every value inside of the column that is labeled as a foreign key, there must be that value in some row of the referenced column. As an example, imagine that we have the users table, and we have a table service_requests. We could have a column in the service_request that references a column in the users table. Usually this would be the primary key that is referenced, but there is nothing stopping you from referencing a unique column. Just for fun, let's go through an example using the username column. If we have a service_requests table, every single row within the table is going to be what some would consider an instance of a service_request. This means that the table columns are like the blueprint for what a service request looks like and then each row is an individual service request. If we have one of the columns labeled as a foreign key to the username of the users table, what does that mean practically? It means that for a single row, the value for that column must be a value that exists in the users table. We could have a service_request submitted by a user with the username of Yoloswagman. This means that there must be a row inside of the users table that has the value Yoloswagman for the username column. This brings up the concept of parent and child relationships. Yoloswagman in this situation is the parent, and his service request is the child. When we draw it out, it makes sense why a primary key must be UNIQUE. If we had two Yoloswagmans, the child would not know which column is the parent. The same applies if we were using IDs and we had So remember, always reference a primary key or a column with the UNIQUE constraint. Now, I have a question for you. Do foreign keys automatically have the UNIQUE constraint, just like primary keys? The answer is no. A parent row can have many child rows. It makes sense because the user could submit multiple service requests. Can we force the column to be unique? Absolutely. If that was the case, the user could only make one service request. Another question. Do foreign keys automatically have the NOT NULL constraint, just like primary keys? The answer is no. Essentially what this means is that a child could be created with no parent. Can we force the column to be NOT NULL? Absolutely. It is ok in some situations to allow the row to be null, but in this situation it makes no sense. It would be wise for us to add that constraint ourselves. So now that you understand some more differences between primary and foreign keys and parent child relationships, take all of these questions into consideration when you are creating foreign keys. In the next video, we are going to start a small project that is going to require multiple tables. We'll take a video to design our structure and then we'll get to creating those foreign keys in Oracle SQL Developer. Stick around and if you like these videos please be a serious supporter and subscribe to my channel. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter 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 - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 12143 Caleb Curry
How to Install Java JDK on Windows 10 ( with JAVA_HOME )
 
08:56
In this video I am going to show you How to install Java JDK on Windows 10 ( with JAVA_HOME ). Java installer .msi file comes with JRE and JDK. Java JDK Installation for Microsoft Windows (64-bit). JDK stands for Java SE Development Kit. JRE stands for Java Runtime Environment. 1. Download Java Open your web browser Type URL: http://www.oracle.com/technetwork/java/javase/downloads/index.html to go to Oracle download page Click on button “ JDK download ” for Java SE update 4. This will lead you JDK download page http://www.oracle.com/technetwork/java/javase/downloads/jdk-7u4-downloads-1591156.html Accept oracle license agreement Find and click on the correct jdk download link right for your operating system to download Save the file to disk 2. Install Java Double click to run the download file Just follow the prompt in Installer window #Javatutorialforbeginners #Javatutorial #Javaprogramming #Javaprogrammingtutorial #Javabasicsforbeginners -------------------Online Courses to learn---------------------------- Data Analytics with R Certification Training- http://bit.ly/2rSKHNP DevOps Certification Training - http://bit.ly/2T5P6bQ AWS Architect Certification Training - http://bit.ly/2PRHDeF Python Certification Training for Data Science - http://bit.ly/2BB3PV8 Java, J2EE & SOA Certification Training - http://bit.ly/2EKbwMK AI & Deep Learning with TensorFlow - http://bit.ly/2AeIHUR Big Data Hadoop Certification Training- http://bit.ly/2ReOl31 AWS Architect Certification Training - http://bit.ly/2EJhXjk Selenium Certification Training - http://bit.ly/2BFrfZs Tableau Training & Certification - http://bit.ly/2rODzSK Linux Administration Certification Training-http://bit.ly/2Gy9GQH ----------------------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 ------------------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
Views: 1189200 ProgrammingKnowledge
Part 4   Delete duplicate rows in sql
 
03:26
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-4-delete-duplicate-rows-in-sql.html In this video, we will discuss deleting all duplicate rows except one from a sql server table. SQL Script to create Employees table Create table Employees ( ID int, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) GO Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000) Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000) Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000) The delete query should delete all duplicate rows except one. Here is the SQL query that does the job. PARTITION BY divides the query result set into partitions. WITH EmployeesCTE AS ( SELECT *, ROW_NUMBER()OVER(PARTITION BY ID ORDER BY ID) AS RowNumber FROM Employees ) DELETE FROM EmployeesCTE WHERE RowNumber ] 1
Views: 329355 kudvenkat
FreeNAS 11.1 Storage Installation + Configuration + Overview on Oracle VirtualBox [2017]
 
16:12
This video tutorial shows FreeNAS 11.1 Storage Installation, Configuration and Overview on Oracle VirtualBox step by step. We also create and configure Storage Volume and setup NFS and Samba/SMB/CIFS shares on FreeNAS storage. This tutorial is also helpful to installing FreeNAS 11.1 on physical computer hardware or bare-metal server. Steps: 1- Create Virtual Machine on Oracle VirtualBox 2- Start FreeNAS 11.1 Storage Installation 3- FreeNAS Storage Initial Configuration 4- Create New User and Group on FreeNAS 5- Create Storage Volume 6- Create, Configure and Test NFS and CIFS/SMB Shares 7- FreeNAS 11.1 Storage Overview FreeNAS 11.1 New Features and Improvements FreeNAS is a tiny FreeBSD-based operating system which provides free Network-Attached Storage (NAS) services (CIFS, FTP and NFS). FreeNAS can be installed on virtually any hardware platform to share data over a network. FreeNAS is the simplest way to create a centralized and easily accessible place for your data. Use FreeNAS with ZFS to protect, store, backup, all of your data. FreeNAS is used everywhere, for the home, small business, and the enterprise. FreeNAS 11.1 adds cloud integration, OpenZFS performance improvements, including the ability to prioritize resilvering operations, and preliminary Docker support to the world’s most popular software-defined storage operating system. This release includes an updated preview of the beta version of the new administrator graphical user interface, including the ability to select display themes. FreeNAS Website: http://www.freenas.org/ Download FreeNAS 11.1 ISO: http://www.freenas.org/download-freenas-release/ FreeNAS 11.1 Minimum System Hardware Requirements These specifications will suffice to get a small FreeNAS install running reliably with moderate performance for a few users. - Multicore 64-bit processor (Intel strongly recommended) - 8GB Boot Drive (USB Flash Drive suffices) - 8GB RAM - At least 1 direct attached disk (Hardware RAID strongly discouraged) - One physical network port FreeNAS no longer supports 32-bit hardware. The last FreeNAS Release with 32-bit hardware support was FreeNAS 9.2.1.9. This release also supported the UFS filesystem. Deployments on 32-bit hardware using UFS had lower hardware requirements of a 4GB boot device and 4GB of RAM. PLEASE NOTE that further security and stability updates to the 9.2.1.x branch are not guaranteed. Hope you found it informative and useful. Any questions or comments are welcomed. PLEASE SUBSCRIBE TO THE CHANNEL ---------------------------------------------------------------------------- Website: http://www.SysAdminsHowto.com/ Facebook Page: https://www.facebook.com/SysAdminsHowto/ Twitter: https://twitter.com/SysAdmHowto Linux Video Tutorials: https://linux-video-tutorials.blogspot.com/ FreeNAS 11.1 Storage Installation on VirtualBox Video: https://youtu.be/TQaTz6HhlEc
Views: 41634 Linux Video Tutorials
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: 42757 Edward Kench
@Windows 7 #IIS 7 -  Provider cannot be found  It may not be properly installed
 
02:31
In order to be able to run Access database's within your Web Development pages, such as ASP, and ASP.NET, which include VB.NET, and C#.NET through Windows Vista, Windows 7, Windows 8, windows 8.1, Windows 10, and within the Windows Server above Windows 2003, you will have to perform this action, as demonstrated in this video. Thank You Wayne Barron Dark Effects Production https://www.facebook.com/darkeffectstv ( Like Us On Facebook ) Spotlight on Dark Effects http://www.youtube.com/DESpotlight Follow us on Twitter https://twitter.com/DarkEffectsTV http://www.darkeffects.net http://www.darkeffects.com http://www.enterview.org/Dark_Effects_Production
Views: 7851 Dark Effects Studios
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
 
03:28
How to resolve java.lang.ClassNotFoundException: com.mysql.jdbc.Driver error? In this video tutorial I have explained you the reason of the java.lang.ClassNotFoundException: com.mysql.jdbc.Driver error and also explained you how to resolve the error? The error java.lang.ClassNotFoundException: com.mysql.jdbc.Driver comes in a Java application when there is no MySQL JDBC driver present in the application. View the complete details of the tutorial at http://www.roseindia.net/jdbc/javalang-ClassNotFoundException-com-mysql-jdbc-Driver.shtml
Views: 93113 Deepak Kumar
Solved: This site can’t be reached [ Fix with various DNS server ]
 
03:51
Fix : This site can’t be reached on Chrome or any other browser. www. example ’s server DNS address could not be found. Try: Checking the connection Checking the proxy, firewall, and DNS configuration Running Windows Network Diagnostics easy fix DNS 1: Open Network Sharing 2: Connection proprieties 3: Select Internet protocol Version and open properties 4: Select - use the following DNS server address type this : preferred DNS 208-67-222-222 Alternate DNS 208-67-220-220 or preferred DNS 8-8-8-8 Alternate DNS 8-8-4-4 or preferred DNS 208-67-222-220 Alternate DNS 208-67-220-220 or preferred DNS 156-154-70--1 Alternate DNS 156-154-71-1 OR preferred DNS 82.200.69.80 Alternate DNS 84.200.70.40 OR preferred DNS 209.244.0.3 Alternate DNS 209.244.0.4 OR preferred DNS 4.2.2.1 Alternate DNS 4.2.2.2 OR preferred DNS 4.2.2.3 Alternate DNS 4.2.2.4 OR preferred DNS 8.26.56.26 Alternate DNS 8.20.247.20 5: Validate settings If it doesn't work you can reset the host file from C:\Windows\System32\drivers\etc folder. First step : Copy and paste the host file to anywhere on the drive (eg: Desktop) (don't edit original host file) . Then open duplicate host file with notepad and clear the complete text , after that copy and paste below details in to notepad and Save it. Next step : Copy the saved host file to C:\Windows\System32\drivers\etc folder and replace the file. The default Host file details are below: ( copy from # Copyright (c) 1993-2009 Microsoft Corp. to # ::1 localhost ) .................................................................... # Copyright (c) 1993-2009 Microsoft Corp. # # This is a sample HOSTS file used by Microsoft TCP/IP for Windows. # # This file contains the mappings of IP addresses to host names. Each # entry should be kept on an individual line. The IP address should # be placed in the first column followed by the corresponding host name. # The IP address and the host name should be separated by at least one # space. # # Additionally, comments (such as these) may be inserted on individual # lines or following the machine name denoted by a '#' symbol. # # For example: # # 102.54.94.97 rhino.acme.com # source server # 38.25.63.10 x.acme.com # x client host # localhost name resolution is handle within DNS itself. # 127.0.0.1 localhost # ::1 localhost .................................................................... copyright Reserved © - 2016-17 All rights to this video is owned DEEZ : www.deezzone.com The video obeys the YouTube Community Guidelines and NO copyright content is present in this video. For Educational Purpose Only. Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for -fair use- for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favour of fair use Copyright Reserved © - 2016-17
Views: 500193 DEE Z
Internet Explorer cannot display the webpage WINDOWS 7
 
03:33
"Internet Explorer cannot display the webpage" error Hi If you're successfully connected to the Internet but cannot view any webpages in Internet Explorer, use one of the following troubleshooting procedures, as appropriate for your operating system Windows 7 Delete your browser history 1. Start Internet Explorer. 2. Press Alt to show the menu bar. 3. On the Tools menu, click Internet options. 4. Under Browsing history, click Delete. 5. Select all the check boxes, and then tap or click Delete. 6. Tap or click Exit, and then restart Internet Explorer. Disable add-ons in Internet Explorer Click the Start button, and then click All Programs. 1. Click Accessories, click System Tools, and then click Internet Explorer (No Add-ons). To disable add-ons in Add-on Manager 1. Open Internet Explorer. 2. Click the Tools button, and then click Manage add-ons. 3. Under Show, click All Add-ons. 4. Click the add-on you want to disable, and then click Disable. 5. click Close. Reset Internet Explorer 1. Start Internet Explorer, click Tools, and then click Internet Options. 2. Click the Advanced tab, and then click Reset. 3. In the Internet Explorer Default Settings dialog box, click Reset. 1. In the Reset Internet Explorer Settings dialog box, click Reset. Click Close and then click OK two times. 2. Exit and then restart Internet Explorer. The changes take effect the next time that you open Internet Explorer. Check whether a third-party service or program is conflicting with Internet Explorer 1. Click Start, type msconfig in the search box, and then click the displayed System Configuration icon. 2. Click the Services tab and check the box beside hide all Microsoft services, and then click Disable all. 3. Next, click the Startup tab. 4. Click Disable all in the bottom right and then click OK. You will be prompted to reboot your computer. Restore your PC to an earlier point in time If you think an app or driver that you recently installed caused problems with your PC, you can restore it back to an earlier point in time, called a restore point. System Restore doesn't change your personal files, but it might remove recently installed apps and drivers. To restore your PC using System Restore Open System Restore by clicking the Start button . In the search box, type System Restore, and then, in the list of results, click System Restore. Thank you for watching fawzi academy TUBE please subscribe share this video Favorite and like
Views: 342248 Fawzi Academy
Part 5   SQL query to find employees hired in last n months
 
04: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/05/part-5-sql-query-to-find-employees.html This question is asked is many sql server interviews. If you have used DATEDIFF() sql server function then you already know the answer. -- Replace N with number of months Select * FROM Employees Where DATEDIFF(MONTH, HireDate, GETDATE()) Between 1 and N
Views: 169410 kudvenkat
Advance Java | JDBC Appilication to excute non select Sql query with execute() byNagoorBabu
 
07:27
This video explains Advance Java - JDBC Application to execute non select Sql query by using execute method. Training Tutorial delivered by our Trainer Nagoor Babu. For more details visit : http://bit.ly/2cJvkOd DURGASOFT is INDIA's No.1 Software Training Center Trainer Name : Mr.Nagoor Babu Course : Advance Java Topic : JDBC Application to execute non select Sql query Methods of Training : Inclass, Online, Video based training Location : 2nd Floor, Canara Bank Building, S.R Nagar, Hyderabad-500032 Contact Phone : +91-8885252627,+91-7207212428,+91-7207212427, (US)+1-(443) 332-6786 Email : [email protected], [email protected] Other Courses We Offered : JAVA, OCJP/SCJP, .NET , ANDROID, HADOOP, TESTING TOOLS , ADF, INFORMATICA, TABLEAU, IPHONE, OBIEE, ANJULAR JS, SAP,etc. Enjoy and stay connected with us!! ►Subscribe us on Youtube: https://goo.gl/drpxPQ ►Like us: http://www.facebook.com/DurgaSoftOnline ►Follow us: http://www.twitter.com/durgasoftonline ►Circle us: https://plus.google.com/+DurgaSoftwareSolutions © 2016 Durga Software Solutions Pvt Ltd.
Java NetBeans Tutorial:  Connecting to a MySQL Database with Java, JDBC and NetBeans
 
05:23
Download Java Source Code: http://www.luv2code.com/?p=992 In this video you will learn how to connect to MySQL with Java and NetBeans. Please subscribe to this channel :-) - https://www.youtube.com/user/luv2codetv?sub_confirmation=1 Video Transcript Time - 00:00 Hi, this is Chad (shod) with luv2code.com. In this video, you will learn how to connect to MySQL with Java and NetBeans. Time - 00:10 Let's go over the development process. The first thing we'll do is review the database tables, then we'll download and add MySQL database driver to NetBeans, then we'll actually create the Java code. Time - 00:25 Let's look at our database and see what data we have. We'll move to the MySQL workbench tool. See that we have a table called Employees and then we'll do a select star from that table and we'll see that we have three employees currently in our database. Time - 00:46 Now I'll create a simple NetBeans project. I'll go to the File menu, I'll select new Project. Make sure the Java application is selected and click next. For the project name, I'll give it jdbcdemo, I'll click Finish. Now what I'll do is I'll add a new Java Class. I'll select the project, I'll right click, I'll select New Java Class. For the name of the class I'll enter demo and hit finish. Now I have a basic Java Class ready to go. Time - 01:26 I will show you how to download the MySQL database driver and add it to your NetBeans project. First thing we have to do is visit the MySQL website at dev.mysql.com. On this page, we'll choose the dropdown and we'll select the platform independent. We'll choose the second entry here, the ZIP Archive and we'll click the download button. On the next page right near the bottom, we'll say no thanks, just start my download. Then we'll save it to our local system. Time - 02:07 Now let's move over to our Finder window on our file system and find the actual file that we just downloaded and I want to uncompressed it because right now it's a ZIP. I'll double click it, this will expand it or extract it. I'll look at it through list view. Now I have this new directory with the artifacts and there's a MySQL connector Java bin.jar, that's the actual JDBC driver that we'll use. Time - 02:35 Now we need to copy this file to the NetBeans project directory. I'll right click, I'll select copy then I'll switch over to NetBeans, I'll click the files tab and I'll select my project and I'll right click and I'll say paste. Even though the file is copied over, we still need to tell NetBeans that this a JAR library that we'll use on our project. What I'll do know is I'll click on the projects tab, I'll go to libraries and I'll choose add library and now I'll navigate to that NetBeans project directory where I actually have the file stored. Jbdcdemo and MySQL connector Java bin and I'll select choose. Then I'll expand this library's folder and we'll see that now this MySQL Java driver is part of this NetBeans project. Time - 03:37 Now let's start with the coding. The first thing I need to do is import Java to SQL package and then I'll drop in code for this main map it and then I'll walk through the code and show you how it works. This is our main map it, the main routine for the application. Then we have variables for the connection statement and result set. We also have the user id and password that we'll use. Time - 04:03 Then the first step is getting a connection to a database. We'll use the URL, the user id and the password. Then we go through and we create a statement object. Then we use this statement object to execute SQL query, select star from employees, then we'll process the result set and we'll simply print out the last name of the employee along with the first name. We have our accession handler and then we also clean up our resources at the end once we're done. Time - 04:42 Then to actually run the application, we will right click, select run file and at the bottom we have our output. We have our three employees that were listed in the database and our Java program was able to access it successfully. Great. Time - 04:59 Okay so this wraps up our video. You learned how to use NetBeans to connect to a MySQL database. Please subscribe to our channel to view more videos on Java, click thumbs up to like our video. Also visit our website luv2code.com to download the Java source code used in this video.
Views: 100210 luv2code
Oracle 12c PL/SQL Security Enhancements - Session 2 of 8- Tutorial Agenda
 
04:11
What's in the SkillBuilders Oracle 12c PL/SQL Security New Features tutorial. John Watson: What I want to talk about today is some security issues with 11g PL/SQL and then moving on to Oracle Database 12c. [see how they've been addressed] In general previous releases of the database have had real problems with security particularly with PL/SQL. This does cause a bit of confusion out there when you read third party assessments contrasting Oracle security with say SQL server and so on. Some people will say that Oracle security is rubbish. Other people will say it's fantastic. What causes that paradox? It's because you can secure your database, but you have to do it. Out of the box the database is stuffed full of marvelous facilities - the developer's marvelous facilities for users - but many of them are potentially highly dangerous. So make no mistake. Oracle database can and should be totally secure, but if your DBAs and your programmers don't make it secure it may be wide open to abuse, wide open to hackers. This has always been a problem. With later releases 11 and now 12, the situation is improving. There are more and more things that one can do declaratively, more techniques for tightening up those wonderfully powerful facilities that can be open to abuse. So what I'm going to go through is spend some time with 11g. We have to. We have to understand what some of the problems are that are being addressed. Also, of course, 11g will be available to be useful for several years to come. I'll spend some time in 11g environment looking at some of the major issues in the PL/SQL environment. Then we will move on to 12c and see some of the new facilities and see how they tighten up the security issues that we see with 11g. If possible - I don't know if this will come true or not - I'll maybe have quick look at network access control list I completely re-implemented in 12c and maybe talk a bit about the advanced security option as well as that has changed somewhat too. That's the agenda I intend to follow. Beginning with 11g, we'll go through what are the definer's rights, what are invoker's rights for code, the relationship between roles and PL/SQL. These issues, definer's rights, invoker's rights and roles is potentially very useful but cause a lot of confusion. I remember when I installed PL/SQL, it first came when it was first introduced in version 7 many, many years ago I found this mind bogglingly confusing. Invoker's rights came in a couple of releases later and then died. That added to the confusion because invoker's rights attempted to fix the problem caused by definer's rights. Roles have always been confusing in the PL/SQL 11g environment. We then move on to the 12c techniques. It's a whole new privilege - inherit privileges or inherit any privileges. That tightens up some of the problems with both views and with PL/SQL. They're very nice facility indeed. We can now grow up roles to procedures, so the confusion of roles in PL/SQL, that is not removed, but we can use roles in a much more [03:31 inaudible] fashion with PL/SQL in 12c. Also, closer [03:35 inaudible], that's the concept of the bequeath view. Just as PL/SQL stored procedures they execute definer's rights to invoker's rights with the privileges of the person who owns the PL/SQL or with the privileges of the person who invokes the PL/SQL. It's the same with views. Historically views are always executed with the privileges of the owner. Now, to a certain extent we can have what I might always call an invoker's rights view. Then if we have time, a couple of other things as well.
Views: 1144 SkillBuilders
[2 Fixes] USB Windows 10 Clean Install - A Media Driver Your Computer Needs is Missing (2018)
 
07:08
In this tutorial, I will be showing you two possible ways to fix the problem of missing media driver during Windows 10 installation. This is a common error when you try to install Windows 10 from a USB storage device. The full error message is “A media driver your computer needs is missing. This could be a DVD, USB or Hard Disk driver. If you have a CD, DVD or USB flash drive with the driver on it Please insert it now. Note: if the installation media is in the windows DVD drive or on a USB drive, you can safely remove it from this step”. The solutions discussed in this video are: 1. Changing to another USB port. Preferably from a USB 3.0 port to a 2.0 port or vice versa. 2. Install Intel Rapid Storage technology User Interface and Driver during the installation process: https://downloadcenter.intel.com/download/27681/Intel-Rapid-Storage-Technology-Intel-RST-User-Interface-and-Driver?product=55005 LINKS Subscribe to EasyTechs: https://goo.gl/dDSBNL If you would like to support us at EasyTechs, please feel free to donate to our patreon page on this link: https://www.patreon.com/easytechs Your donations are very much appreciated and would go a long way in growing the channel. Equipment I Use For Making Videos Canon EOS 70D : https://goo.gl/Wd6W9d Rode VMGO Video Mic GO Lightweight On-Camera Microphone Super-Cardioid: https://goo.gl/onGmCp Canon EF-S 24mm f/2.8 STM Lens: https://goo.gl/8y6Bk7 Canon EF 50mm f/1.8 STM Lens: https://goo.gl/ZtxZSg SLIK U-8000 Photo/Video Mid-Size Tripod: https://goo.gl/CjPKTU
Views: 96152 EasyTechs
How to install Java JDK on Mac OS X ( with JAVA_HOME )
 
15:33
How to install Java JDK Java Development Kit on mac. In Mac OSX 10.5 or later, Apple recommends to set the $JAVA_HOME variable to /usr/libexec/java_home, just export $JAVA_HOME in file ~/. bash_profile or ~/.profile. $ vim .bash_profile export JAVA_HOME=$(/usr/libexec/java_home) $ echo $JAVA_HOME /Library/Java/JavaVirtualMachines/1.7.0.jdk/Contents/Home JRE Installation for Mac OS X (64-bit). How to Set $JAVA_HOME environment variable on Mac OS X -------------------Online Courses to learn---------------------------- Data Analytics with R Certification Training- http://bit.ly/2rSKHNP DevOps Certification Training - http://bit.ly/2T5P6bQ AWS Architect Certification Training - http://bit.ly/2PRHDeF Python Certification Training for Data Science - http://bit.ly/2BB3PV8 Java, J2EE & SOA Certification Training - http://bit.ly/2EKbwMK AI & Deep Learning with TensorFlow - http://bit.ly/2AeIHUR Big Data Hadoop Certification Training- http://bit.ly/2ReOl31 AWS Architect Certification Training - http://bit.ly/2EJhXjk Selenium Certification Training - http://bit.ly/2BFrfZs Tableau Training & Certification - http://bit.ly/2rODzSK Linux Administration Certification Training-http://bit.ly/2Gy9GQH ----------------------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 ------------------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
Views: 236687 ProgrammingKnowledge
Oracle BI Customer Success Forum: Agilysys
 
37:26
Presentation Sections (audio only) - ERP & BI Story - Implementation Partner: KPI Partners - Oracle BI Applications Implemented - Lessons Learned: Use out-of-the-box structure as the starting point for customization - Lessons Learned: Educate users on data definitions - Lessons Learned: Develop for efficiency and scalability - create dashboards for standardized reporting - Lessons Learned: Deploy functionality in small phases - Lessons Learned: pre-built analytics will get you approx 90% to your goal - Lessons Learned: BI Team should be involved in the ERP system implementation - Lessons Learned: Obtain executive sponsorship - Lessons Learned: Take the time to understand your audience - Lessons Learned: Requirements gathering and sign-off processes for BI projects can differ from traditional IT projects - Lessons Learned: Works against a stable ERP system - Lessons Learned: Test as much as possible - Lessons Learned: Create a training plan for end-users - Question: Was this an OBIEE 11g or 10g implementation? - Question: Was Oracle E-Business Suite the ERP source system? - Question: How much customization was necessary for the reports and dashboards? ETL? - Question: Where is the data model located for the business intelligence reporting? - Question: Have you integrated with any other systems besides Oracle EBS? - Question: Do you use sub-ledger accounting? - Question: Hardware architecture? - Question: What is your data volume? - Question: Do you connect to any transactional data through OBIEE? - Question: Are you utilizing iBots, Delivers, or OLAP Cubes? - Question: How much customization was necessary for ETL? - Question: How was your BI team constructed? - Question: Did you extract data directly from ERP? - Question: Did you have additional hierarchies developed? - Question: Do out-of-the-box account groupings satisfy your requirements? - Question: Are you using any out-of-the-box dashboards for financial analytics? - Question: What type of security model have you adopted? - Question: How often does the data refresh? - Question: What is the composition of your support team? - Question: How is the offshore model working for you? Agilysys is a leading provider of innovative IT solutions to corporate and public-sector customers, with special expertise in select markets, including retail and hospitality. Headquartered in Cleveland, Agilysys operates extensively throughout North America, with additional sales offices in the United Kingdom, Singapore and Hong Kong. After replacing a legacy ERP system with Oracle EBS, Agilysys found out-of-the-box reports provided substantial amount of data, but not sufficient information or knowledge. Management reports were built by analysts from each business unit which resulted in several issues: Lack of data consistency equaling no single point of truth; No operational or financial visibility on a daily basis; and Limited visibility with only certain metrics are available. Previously a Brio customer, Agilysys sought a new, robust BI platform that easily integrated with Oracle EBS, required minimal development time and delivered a platform for future growth. Agilysys selected Oracle BI Applications and engaged KPI Partners to deployed Oracle BI Financial Analytics within three months. The first phase was rolled out to upper and mid-level management, and financial analysts. The solution delivered financial sales analysis: Financial and Operational point of view ; Sales, Cost, Profit (actual and budget); By Business Unit, Sales Group, Sales Rep, Manufacturer, Customer, Supplier; and Tax data. Among the benefits achieved, Agilysy eliminated several legacy reports, made gre! at strides toward its goal of a single point of truth, and delivered timely and accurate information to business users daily. Attend this call to learn more about how Agilysys is leveraging Oracle BI Applications and KPI Partners to drive enterprise performance. http://www.kpipartners.com
Views: 2168 kpipartners
Install CentOS 7 in UEFI Mode (Dual Boot Windows 8)
 
05:40
This is a sample video showing how to install CentOS 7 in UEFI Mode and Dual Boot with Windows 8 Step1: Make some space for installing CentOS 7 in Windows Step2: Boot CentOS 7 Live Disc in UEFI mode Step3: Start Installation Step4: Make some partitions in the free space Step5: Continue with the installation Step6: Boot into newly installed CentOS 7 Here is what I do from 1:46 to 2:21 I click on "I will configure partitioning". I click on Done. I select standard partition as the partitioning scheme. I click on "Click here to create them automatically" I delete the partition /boot/efi I select the EFI partition already created by Windows 8 (which was installed in UEFI mode) Then I set it's mount point to /boot/efi (Since there is no need to have more than one EFI partitions, I deleted the previous one) I click on update settings. Then, since my RAM is 4GB, I intend to have only 2GB of Swap Space. Hence I decrease the amount of swap space to 2GB. I click on update settings. Since I had opted not to create a new EFI partition, some space was free, which I intend to allot to the partition mounted on / Since I don't know the exact amount of space remaining, I enter 177GB and then click update settings, installer is intelligent enough to allocate the maximum remaining amount it can. Then I click Done. Then I click Accept Changes. Wanna support me? Visit: https://www.patreon.com/nehaljwani
Views: 77722 Nehal J Wani
LAB8 Mo
 
24:02
--declare --v_emp_email varchar2(10); --begin --select email --into v_emp_email --from employees --where employee_id = 207; --dbms_output.put_line('the email is '||v_emp_email); --exception --when no_data_found then --dbms_output.put_line (' no data found.'); --end; --declare --v_emp_email varchar2(10); --e_select_excep exception; --pragma exception_init(e_select_excep, -01402); --begin select email --into v_emp_email --from employees --where employee_id = 207; --exception --when e_select_excep then --dbms_output.put_line('select failed'); --when others then --dbms_output.put_line(sqlerrm); --end; --declare --v_reg_id number := 5; --e_invalid_region exception; --begin --delete from regions --where region_id = v_reg_id; --if sql % notfound then --raise e_invalid_region; --end if; --exception --dbms_output.put_line('NO delete region id.'); --end; declare e_integrity exception; pragma exception_init (e_integrity, -2292); v_name varchar2(4) := 'four' ; v_regid integer := 5; cursor reg_cursor is select region_id from regions; begin for c_record in reg_cursor loop declare e_no_rows exception; begin dbms_output.put_line(c_record.region_id); update regions set region_name = v_name where region_id = v_regid; if sql%notfound then raise e_no_rows; end if; exception when e_no_rows then dbms_output.put_line('ERROR Sir'); end; end loop; exception when e_integrity then null; end;
Views: 20 Noonim Zuza
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: 5087 Manish Sharma
Show rows with no data - Power BI Tips & Tricks #33
 
03:19
By default, column headings are only displayed in your reports if they contain data. For example, if you were displaying revenue by country and had no sales in Norway, then Norway would not appear anywhere in your visualization. In this video we will show you how to display empty categories or show items with no data. Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1 Our PLAYLISTS: - Join our DAX Fridays! Series: https://goo.gl/FtUWUX - Power BI dashboards for beginners: https://goo.gl/9YzyDP - Power BI Tips & Tricks: https://goo.gl/H6kUbP - Power Bi and Google Analytics: https://goo.gl/ZNsY8l ABOUT CURBAL: Website: http://www.curbal.com Contact us: http://www.curbal.com/contact ▼▼▼▼▼▼▼▼▼▼ If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running: https://curbal.com/product/sponsor-me Many thanks in advance! ▲▲▲▲▲▲▲▲▲▲ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: ► Twitter: @curbalen, @ruthpozuelo ► Google +: https://goo.gl/rvIBDP ► Facebook: https://goo.gl/bME2sB #POWERBITIPS #CURBAL #POWERBI #MVP ► Linkedin: https://goo.gl/3VW6Ky
Views: 6260 Curbal
HOW TO GENERATE E WAY BILL(DETAILED)
 
15:44
Here is a step by step Guide to Generate E-Way Bill (EWB-01) online: Step 1: Login to e-way bill system. Enter the Username, password and Captcha code, Click on ‘Login’ E-way bills Step 2: Click on ‘Generate new’ under ‘E-waybill’ option appearing on the left-hand side of the dashboard. 1) Transaction Type: Select ‘Outward’ if you are a supplier of consignment Select ‘Inward’ if you are a recipient of consignment. 2) Sub-type: Select the relevant sub-type applicable to you: If transaction type selected is Outward, following subtypes appear: f transaction type selected is Inward, following subtypes appear: ote: SKD/CKD- Semi knocked down condition/ Complete knocked down condition 3) Document type: Select either of Invoice / Bill/ challan/ credit note/ Bill of entry or others if not Listed 4) Document No. : Enter the document/invoice number 5) Document Date: Select the date of Invoice or challan or Document. Note: The system will not allow the user to enter the future date. 6) From/ To: Depending on whether you are a supplier or a recipient, enter the To / From section details. Note: If the supplier/client is unregistered, then mention ‘URP’ in the field GSTIN, indicating that the supplier/client is an ‘Unregistered Person’. 7) Item Details: Add the details of the consignment (HSN code-wise) in this section: Product name Description HSN Code Quantity, Unit, Value/Taxable value Tax rates of CGST and SGST or IGST (in %) Tax rate of Cess, if any charged (in %) Note: On the implementation of E-way bills, Based on the details entered here, corresponding entries can also be auto-populated in the respective GST Return while filing on GST portal. 8) Transporter details: The mode of transport(Road/rail/ship/air) and the approximate distance covered (in KM) needs to be compulsorily mentioned in this part. Apart from above, Either of the details can be mentioned: Transporter name, transporter ID, transporter Doc. No. & Date. OR Vehicle number in which consignment is being transported. Format: AB12AB1234 or AB12A1234 or AB121234 or ABC1234
Views: 838364 TAX MITRA
Machine Learning with Oracle
 
35:47
Introduction - 0:00 Overview Machine Learning in Oracle - 1:31 Machine Learning theory - 6:04 Demonstration: preparation and building the model - 11:52 Demonstration: run the prediction and adapt the application - 26:24 How to get started - 33:33 Without a doubt Machine Learning / Artificial Intelligence is an incredibly powerful technology with a huge potential. It brings benefits across many industries and business functions: From better targeting in the marketing/sales domain to predictive maintenance in manufacturing. This video-webinar is a kickstart to Machine Learning. You will learn the required theoretical knowledge and then we'll go through a real-life example: intelligent sales with ML. We'll create our very first ML model, and use it to make an existing application intelligent with sales recommendations. After this webinar you will have the basic ingredients to apply ML to your own business cases! Note that you don't require any previous knowledge of ML to be able to understand this session. Powerpoint and background material can be found here: https://ptdrv.linkedin.com/cmaj4xt
Views: 5416 Jeroen