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: 925 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.
How to Resolve Oracle SQL Parent Key Not Found (ORA-02291)
 
05:49
In this video, we’ll explain what the ORA-02291 “parent key not found” error is, see an example, and look at how to resolve it. This error usually happens when we try to insert data into a table. It looks like this: Error is: ORA-02291: integrity constraint (constraint_name) violated - parent key not found So what does this error mean? It means we’re trying to insert data into a child table, and there is no related record in the parent table. If a foreign key has been set up to enforce this relationship, there needs to be a parent to insert a child that refers to it. Watch the video to see an example of this error as well as how to resolve it. For more information on Oracle SQL, refer to the Database Star website here: https://www.databasestar.com/
Views: 3579 Database Star
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: 361138 Chitu Okoli
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: 127426 Manish Sharma
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: 24393 Joey Blue
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: 157957 Manish Sharma
How to install a JDBC driver in Oracle SQL Developer
 
02:38
To connect to a third party database in SQL Developer, you will need to install a jdbc driver. The drivers are free downloads. Review the supported jdbc driver versions at http://www.oracle.com/technetwork/products/migration/jdbc-migration-1923524.html. Copyright © 2013 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. 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 of merchantability, fitness for a particular purpose, and non-infringement.
Views: 155555 Oracle Learning Library
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: 45954 Jeff Smith
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: 5693 Manish Sharma
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: 179127 kudvenkat
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: 229133 Technofare
[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: 132235 64-bit Programmer
Oracle Integration with Visual Studio 2012
 
04:45
This is a demonstration of the Oracle Developer Tools for Visual Studio, a Visual Studio "add-in" which is free and available for download from Oracle at http://otn.oracle.com/dotnet Visual Studio 2012, 2010 and 2008 are all supported. Featured demoed here include: * Server Explorer Integration * Table Designer * Entity Designer integration * PL/SQL editor and debugger * SQL Script Generation * SQL Script Editor * Source control integration * SQL Tuning Advisor * Oracle Performance Analyzer To try these features out, download ODAC 11.2 Release 5 or later. As with earlier releases of Visual Studio, Oracle has partnered closely with Microsoft as part of the Visual Studio Industry Partner Program to make the simultaneous release of this product with Visual Studio 2012 possible. More Oracle .NET videos can be found at https://www.youtube.com/user/OracleDOTNETTeam/
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.
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: 282669 Manish Sharma
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: 283233 1BestCsharp blog
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 | Exception Handling in Oracle Database
 
08:58
Learn exception handling in oracle, understanding different types of exceptions and trapping exception with SQLERRM and SQLCODE. How to handle exception in oracle database, How to handle user defined exception in oracle database, What is Pragma in Exception Handling, What is Pragma Exception_INIT in oracle, Difference between named and unnamed exception in oracle, Types of exception available in oracle, How to use Raise_application_error in oracle, How to use custom exception in oracle, Details of System Exception: DUP_VAL_ON_INDEX ORA-00001 You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index. TIMEOUT_ON_RESOURCE ORA-00051 You were waiting for a resource and you timed out. TRANSACTION_BACKED_OUT ORA-00061 The remote portion of a transaction has rolled back. INVALID_CURSOR ORA-01001 You tried to reference a cursor that does not yet exist. This may have happened because you've executed a FETCH cursor or CLOSE cursor before OPENing the cursor. NOT_LOGGED_ON ORA-01012 You tried to execute a call to Oracle before logging in. LOGIN_DENIED ORA-01017 You tried to log into Oracle with an invalid username/password combination. NO_DATA_FOUND ORA-01403 You tried one of the following: You executed a SELECT INTO statement and no rows were returned. You referenced an uninitialized row in a table. You read past the end of file with the UTL_FILE package. TOO_MANY_ROWS ORA-01422 You tried to execute a SELECT INTO statement and more than one row was returned. ZERO_DIVIDE ORA-01476 You tried to divide a number by zero. INVALID_NUMBER ORA-01722 You tried to execute a SQL statement that tried to convert a string to a number, but it was unsuccessful. STORAGE_ERROR ORA-06500 You ran out of memory or memory was corrupted. PROGRAM_ERROR ORA-06501 This is a generic "Contact Oracle support" message because an internal problem was encountered. VALUE_ERROR ORA-06502 You tried to perform an operation and there was a error on a conversion, truncation, or invalid constraining of numeric or character data. CURSOR_ALREADY_OPEN ORA-06511 You tried to open a cursor that is already open. Linkedin: https://www.linkedin.com/in/aditya-kumar-roy-b3673368/ Facebook: https://www.facebook.com/SpecializeAutomation/
Views: 1145 Specialize Automation
How to Install Oracle Database 11g on Windows 10 By Manish Sharma
 
08:24
Detail tutorial on How to install Oracle database 11g enterprise edition on Windows 10 Professional 64 bit. Full installation under 9 mins. You can follow the steps for installing Oracle 11g on Windows 10 32 bit home or any other version. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Previous Tutorial ► Download Link http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html ►Create Database using DBCA https://youtu.be/enFFezPYhCg ►How To Unlock User using ALTER USER https://youtu.be/sMqq9MSVmQo ------------------------------------------------------------------------- ►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/TheRebellionRider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ 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: 355355 Manish Sharma
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: 614878 ProgrammingKnowledge
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: 105418 luv2code
Microsoft Access Driver (*.mdb, *.accdb) ODBC Driver could not be found.
 
02:15
Error Solved : The Setup routines for the Microsoft Access Driver (*.mdb, *.accdb) ODBC Driver could not be found. Please reinstall the driver Errors Found: The specified DSN Contains an architecture mismatch between the Driver and Application
Views: 131011 Ready4 Education
This Site Can't Be Reached ERR_CONNECTION_REFUSED in Google chrome- Fixed easily
 
11:06
Most of Google chrome users must have faced the issue ‘This site can’t be reached error‘. Don’t worry devicemanager is at your disposal to fix this issue easily. The cause of this error is that DNS lookup failed so the webpage is not available. In this video I have given five methods to solve the problem. Watch the video fully. ---------------------------------------------------------------------------------------------- Method 1: Restart DNS client Method 2: Change IPv4 DNS Address.Type the following address in the Preferred DNS server and Alternate DNS server: 8.8.8.8 8.8.4.4 Method 3: Try resetting TCP/IP (a) ipconfig /release (b) ipconfig /all (c) ipconfig /flushdns (d) ipconfig /renew (e) netsh int ip set dns (f) netsh winsock reset Method 4: Reset Gooogle Chrome settings Method 5: Reinstall Chrome ----------------------------------------------------------------------------------------------- The fix shown in the video works even for the issues like Fix This site can't be reached|ERR_CONNECTION_REFUSED in Google chrome-I got the error message while surfing the internet. This site can’t be reached-this site cannot be reached this website refused to connect. Try: Reload the page Check the connection Check the proxy and the firewall ERR_CONNECTION_REFUSED. Check your Internet connection Check any cables and reboot any routers, modems or other network devices you may be using. Allow Chrome to access the network in your firewall or antivirus settings. If it is already listed as a program allowed to access the network, try removing it from the list and adding it again. If you use a proxy server. Check your proxy settings or contact your network administrator to make sure that the proxy server is working. If you don't believe you should be using a proxy server: Go to the Chrome menu - Settings - - Show advanced settings - Change proxy settings... - LAN Settings and deselect "Use a proxy server for your LAN". Then try to troubleshoot the error by using windows troubleshooter,finally it shows the following error. "The remote device or resource won't accept the connection"-ERR_CONNECTION_REFUSED,this method is working in windows 7,windows 8/windows 8.1/windows 10 too. Solution:1 Go to settings-show advanced settings-network-change proxy settings select connections tab-Lan settings tick automatically detect settings option. Solution:2 go to network and sharing center then select your network adapter and then click properties. select internet protocol version 4 then tick automatically detect settings option. finally the error is fixed. --------------------------------------------------------------------------------------------------- Check this Url : https://youtu.be/HznL6MXcGJ8 for the following issues. 1.how to fix this site cannot be reached google chrome 2.site cannot be reached chrome 3.site cannot be reached fix 4.site cannot be reached windows 10 5.site cannot be reached problem 6.site cannot be reached fix windows 10 7.This site can’t be reached [FIX] [Google Chrome] 8.FIX "THIS SITE CAN'T BE REACHED" - CHROME - (2016) 9.ERR CONNECTION REFUSED 10.this site cannot be reached google chrome 11.this site can’t be reached 12.this site cannot be reached 13.the site cannot be reached 14.ERR CONNECTION RESET 15.chrome error connection reset 16.chrome this site can't be reached 17.can't be reached 18.ERR CONNECTION TIMED OUT --------------------------------------------------------------------------- Please share the video https://youtu.be/HznL6MXcGJ8
Views: 839681 DEVICE MANAGER
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: 1308551 ProgrammingKnowledge
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: 373857 Amit Andipara
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: 98252 Deepak Kumar
[SOLVED] USB Windows 7 Installation | A Required CD-DVD Drive Device Driver is Missing
 
08:23
Stellar Data Recovery – A Leading Data Recovery Software (Watch Full Review: https://goo.gl/2TzW1L) 10% Discount Coupon (Limited): 4A9E9B4451 ► Data Recovery Windows Standard: https://goo.gl/jKh2dp ► Data Recovery Windows Professional: https://goo.gl/HTWZ7j ► Data Recovery Windows Technician: https://goo.gl/aVq54b ► Photo Recovery Windows Standard: https://goo.gl/smqir6 ► Data Recovery Mac Professional: https://goo.gl/n6a56r ֎ Top VPN Services - CyberGhost VPN https://goo.gl/yD9cb1 - NordVPN https://goo.gl/8Uuhft - Express VPN https://goo.gl/oaWpU7 ֎ MY Top Cool Tech Deals - Smart Wireless Charging Mouse Pad https://goo.gl/8gG1cM - i10 TWS Bluetooth 5.0 Wireless Earbuds https://goo.gl/a9rptg - Wireless Charger https://goo.gl/Pmf4Nk - Android Alfawise A5X TV Box https://goo.gl/XSMDFr - Flash Sales https://goo.gl/tKg8eV UPDATE: Here is a NEW link to download Gigabyte's Windows 7 USB Installation Tool: https://drive.google.com/file/d/1NHsqjK7CZky9tnq0a0L7avPZxt5EX9e-/view?usp=sharing Download and extract, then follow the same procedure shown in the video. ֎ Subscribe to EasyTechs: https://goo.gl/dDSBNL ֎ Follow us on Twitter:https://twitter.com/easy_techs?lang=en ֎ Follow us on Facebook:https://www.facebook.com/OfficialEasyTechs/ ֎ Support us on Patreon: https://www.patreon.com/easytechs In this video I we will see how to fix the problem of missing USB 3.0 driver during windows 7 installation. This problem is shown by the message “A required CD/DVD drive device driver is missing. If you have a driver floppy disk, CD, DVD, or USB flash drive, please insert it now”. The primary reason for this error is that the USB controller chip on the laptop is not recognized by Windows 7, so Windows 7 is unable to reach or access the computer hard disk because the USB lacks the required driver which is the USB 3.0 driver. This problem is actually unique to Windows 7, if you try a similar installation process on the same PC with Windows 10 from a USB stick, you won’t encounter this error. Also if you have the option of installing using a Windows 7 DVD, then you should get past this error. The idea of this solution is to install the required USB driver in order to enable Windows 7 gain access to the PC hard drive and proceed with the installation. Here I’ve simplified the driver installation process into two basic steps; Step 1: Download the Gigabyte's Windows 7 USB Installation Tool from here: https://drive.google.com/file/d/1NHsqjK7CZky9tnq0a0L7avPZxt5EX9e-/view For different chipset models check download from this link: https://www.gigabyte.com/Support/Utility?kw=Windows+USB+installation+tool&p=1 Step 2: Installing the USB driver. To do that you insert your bootable USB with the Windows 7 installation, then go to the folder where we saved the downloaded file and extract the zipped folder. After the extraction you should have a folder named “WindowsImage Tool”. Open the folder, you should see this WindowsImageTool application, run the application (you don’t have to worry about the files you have saved on your USB device, the Windows image tool will not override or delete your files). Leave the source path as “None-Add USB Drivers” then in the destination path, select the USB that contains your Windows 7 installation files. Here the “Add USB drivers to an offline Windows 7 image” is selected by default, now select the Add NVMe drivers option to an offline Windows 7 image as well, automatically the “Add packages to an offline Windows 7” is also selected. So you should have all three options checked. Then click on start to begin the installation process. An alternative solution is to try to change the USB port where you attached your bootable Windows USB stick, certain computers come with the required USB driver installed in only one of the USB ports, so you might try changing your USB port to see if it works for you. Another alternative is to visit your manufacturer support page and download the USB 3.0 driver, and install it during the Windows 7 installation.
Views: 432845 EasyTechs
Java trouble shooting - JDBC - Parameter index out of range
 
03:35
This video shows the cause and solution to the error Parameter index out of range when dealing with JDBC.
Views: 3989 Jaret Wright
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: 349603 kudvenkat
How Install VirtualBox Guest Additions on Ubuntu 18.04 Guest / virtual machine
 
03:38
Best Linux Tutorial - https://bit.ly/2IwOuqz The new Ubuntu 18.04 LTS is out now. But VirtualBox Guest Additions software is not working properly after installation. So this post shows the step by step procedure on how to install it properly. Step 1. Install required packages. Before installing VirtualBox Guest Additions on Ubuntu 18.04 we need to install some required packages. So open the terminal and run the following command. sudo apt install linux-headers-$(uname -r) build-essential dkms Step 2. Install Guest Additions using virtual box. In order To install VirtualBox Guest Additions on Ubuntu virtual machine, Got to VirtualBox - select the Devices from VirtualBox host application menu - click Insert Guest Additions CD image. Step 3. This will open a pop up window and it will ask you to run it. Press Run button (see the picture below) After pressing Run button it will install VirtualBox Guest Additions on Ubuntu 18.04. Press enter to close the window. Step 4. Shut down your Ubuntu 18.04 Guest. Step 5. Start Ubuntu 18.04 virtual machine and check if copy and paste works. Finish -------------------Online Courses to learn---------------------------- Blockchain Course - http://bit.ly/2Mmzcv0 Big Data Hadoop Course - http://bit.ly/2MV97PL 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
Views: 58010 ProgrammingKnowledge
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: 120137 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: 43631 Linux Video Tutorials
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: 2171 kpipartners
QlikView - Connect and Query Data
 
03:28
Video 2 in multi-part series that will help you become more familiar with QlikView. This video covers connecting to a Microsoft SQL Server database and accessing its tables and columns to get data needed for analysis. Video 1 (Download and Install) can be found here: https://www.youtube.com/watch?v=aKQMhtQnaz0 and video 3 can be found here: http://www.youtube.com/watch?v=xwHNM18D9fE
Views: 78367 Qlik
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: 154894 kudvenkat
ODBC DSN Setup
 
00:54
In this video, I will show you how to configure an ODBC Data Source Name for a MS-Access 2003 database file. I am using the Northwind.mdb, that is shipped with MS-Office 2003. You can select any database in your computer. If you want to download the PDF version of the steps involved, visit http://javatrainer.org and follow the link "How do I...?" in the home page. Here are some of my other videos: Using HyperSQL database http://www.youtube.com/watch?v=aHzhYvJpy8c Stock Quote WS Client using Apache AXIS 1.4 http://www.youtube.com/watch?v=4RPCb-KCKs4 Windows Services List Using Java http://www.youtube.com/watch?v=GU4GKkFaKO0 ODBC DSN Setup http://www.youtube.com/watch?v=_kUYPqauyyo AWTDemo Part 1 http://www.youtube.com/watch?v=eCUxVDbtE78 AWTDemo Part 2 http://www.youtube.com/watch?v=FyEOqCE_88E AWTDemo Part 3 http://www.youtube.com/watch?v=vfGpfV32StE Connecting to JDBC from CRXI http://www.youtube.com/watch?v=vZU5pW_JxyM Servlet development using Eclipse and Tomcat http://www.youtube.com/watch?v=EOkN5IPoJVs Transforming XML,XSL to HTML using saxon9 http://www.youtube.com/watch?v=he8KiRFmM6o
Views: 25600 Vinod Kumar
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: 78514 Nehal J Wani
PLSQL 6 (%TYPE, %ROWTYPE, CURSORS)
 
59:18
ORACLE PL/SQL %TYPE , %ROWTYPE ATTRIBUTES AND CURSORS
1Z0-588 Exam Dumps | Hyperion Data Relationship Management 1Z0-588 Dumps PDF
 
02:04
Get Now: https://www.justcerts.com/oracle/1Z0-588-practice-questions.html 1Z0-588 Why are Oracle Hyperion Data Relationship Management Essentials exams important? Oracle Hyperion Data Relationship Management Essentials 1Z0-588 exams although not thought of as easy to accomplish, carry amazing importance. The Oracle Hyperion Data Relationship Management Essentials 1Z0-588 exams serve as an assistance tool for certification holders as far as the attainment of a good, satisfactory job is concerned. Preparation The Oracle 1Z0-588 exam requires candidates to be mindful of the syllabus of the Oracle 1Z0-588 exam. Preparation via practice will help clearing the Hyperion Data Relationship Management Essentials 1Z0-588 exam in the first go. Pertinent preparation material for Oracle 1Z0-588 exam can be found via internet research as well. Select the Justcerts Justcerts selection involves vigilance on the part of candidates who must select the brand that has the best content and set of questions to offer for Oracle 1Z0-588 exam preparation. The content of the Justcerts content is ample in all respects. The candidates can easily understand the information provided. The preparation material provided by the Justcerts to the candidates, for the preparation of the Oracle Hyperion Data Relationship Management Essentials 1Z0-588 exam, is truly germane. The reproduction of the Oracle Hyperion Data Relationship Management Essentials 1Z0-588 exam, provides an opportunity to the candidates to become conscious of their own abilities as well as slip-ups. Practice prospects are offered to the candidates, so that they can practice as thoroughly as possible before appearing for the real exam. The design of the Justcert’s layout by the Oracle is such that it makes it effortless for the candidates to operate it. Some critical features are as follows; Any Oracle Hyperion Data Relationship Management Essentials 1Z0-588 exam can be searched on the Justcerts. The Justcert’s content is updated recurrently. Therefore, candidates can acquaint themselves with the most recent updates. The Oracle antivirus is used as a safety device to protect the bio-data of the Justcert’s customers. The comments that have already been posted by customers who have experienced the Product offered by the Justcerts, can be viewed by new customers. Candidates who are first-timers can also become members and comment apropos their own experience with the Justcert’s product. Feedback from customers is not only welcomed by the Justcerts but it is also used to make useful modifications in the product. The customers are given a specimen of the Oracle Hyperion Data Relationship Management Essentials 1Z0-588 exam. The purpose is to ensure that the final product that the customer is sold and the brand that was advertised to the customer, are perfectly identical. The Justcerts is valuable The Justcerts offers valuable the following incentives to its customers: The Justcerts reimburses the Oracle Hyperion Data Relationship Management Essentials 1Z0-588 exam fee to the candidates who have been ineffective in clearing their Oracle Hyperion Data Relationship Management Essentials 1Z0-588 exam, if the candidates inform the Justcerts of such happening, within sixty days. We offer the Oracle Hyperion Data Relationship Management Essentials 1Z0-588 examination plus, professional help and guidance to the candidates. The Justcerts offers to its regular customers, valuable price cuts and discounts of up to 30%.
Views: 118 ammy lee
How to Select and Display Clob Data in Codeigniter
 
01:09
This is how to select and display clob data in codeigniter. If you face error "Object of Class OCI-Lob could not be converted to string", this is the way to solve it.
Views: 640 Tanya Kenapa?
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: 8112 Curbal
PL/SQL tutorial 26: Introduction to PL/SQL Cursor in Oracle Database By Manish Sharma
 
05:10
Learn What are cursors, what are types(Explicit and implicit), and steps of cursor's creation in oracle database by Manish Sharma From RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/introduction-to-database-cursors Previous Tutorial ► Pl/SQL 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/ ___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: 101550 Manish Sharma
Xubuntu 16.04.3 LTS (Xenial Xerus) Installation + Guest Additions on Oracle VirtualBox [2017]
 
08:09
This video tutorial shows Xubuntu 16.04.3 LTS (Xenial Xerus) installation on Oracle VirtualBox step by step. This tutorial is also helpful to install Xubuntu 16.04.3 LTS on physical computer or laptop hardware. We also install Guest Additions on Xubuntu 16.04 LTS for better performance and usability features: Automatic Resizing Guest Display, Shared Folder, Seamless Mode and Shared Clipboard, Improved Performance and Drag and Drop. Steps: 1- Create Virtual Machine on Oracle VirtualBox 2- Start Xubuntu 16.04.3 LTS (Xenial Xerus) Installation 3- Install VirtualBox Guest Additions 4- Test Guest Additions Features: Automatic Resizing Guest Display and Shared Clipboard Xubuntu 16.04.3 LTS (Xenial Xerus) New Features and Improvements Like previous LTS series, Xubuntu 16.04.3 includes hardware enablement stacks for use on newer hardware. This support is offered on all architectures except for 32-bit powerpc, and is installed by default when using one of the desktop images. Ubuntu Server defaults to installing the GA kernel, however you may select the HWE kernel from the installer bootloader. As usual, this point release includes many updates. Xubuntu Website: https://xubuntu.org/ Download Xubuntu 16.04.3 LTS ISO: http://cdimage.ubuntu.com/xubuntu/releases/16.04.3/release/ Xubuntu 16.04.3 LTS Desktop Minimum System Requirements To install and use Xubuntu, you need at least 512 MB of memory. You can also try Xubuntu within the Desktop DVD with the same amount of memory. Keep in mind that running the system from a DVD will be slower than an installed system. When you install Xubuntu from the Desktop DVD, you need about 7.5 GB of free space on your hard disk. Your processor needs to support PAE in order to run Xubuntu. Xubuntu 16.04.3 LTS Desktop Recommended System Resources To get a smooth experience when running multiple applications parallel on the desktop, it is recommended to have at least 1 GB of memory. It is recommended to have at least 20 GB of free space on your hard disk. This allows new application installations as well as saving your personal data on the hard disk in addition to the core system. 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/ Xubuntu 16.04.3 LTS Installation on VirtualBox Video: https://youtu.be/-p_C8m8dIE0
Conditional display of a column based on its data
 
07:17
This video how-to shows basic concepts around conditional display of a column in a Table object, based on its data. This example is based on Jaspersoft Studio 6.0.1 but it should work (possibly with little editing) on recent releases, such as 5.x. See: http://community.jaspersoft.com/wiki/conditional-display-column-based-its-data
Views: 16393 Jaspersoft Embedded BI
Basics of jdbc programming Tutorial-11(Retrieving a text file from oracle database)
 
09:46
this video deals with the overall idea of how the jdbc program is connected to the database to retrieve a text file from the database. //Retrieving a text file from the oracle database import java.sql.*; import java.io.*; class Jdbc { public static void main(String[] args) throws Exception { Connection con=null; PreparedStatement pst=null; ResultSet rs=null; try { Class.forName("oracle.jdbc.driver.OracleDriver"); con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "student","shubham123"); if(con!=null) { System.out.println("connection established"); pst=con.prepareStatement("select * from myfile"); } if(pst!=null) { System.out.println("preparedstatement object created"); rs=pst.executeQuery(); rs.next(); Clob c=rs.getClob(1); System.out.println("File Size="+c.length()); Reader r=c.getCharacterStream(); int ch; FileWriter fw=new FileWriter("f://text.txt"); while((ch=r.read())!=-1) fw.write((char)ch); fw.close(); } } catch(SQLException e) { e.printStackTrace(); } catch(ClassNotFoundException e) { e.printStackTrace(); } catch(Exception e) { e.printStackTrace(); } finally { pst.close(); con.close(); } } }
Views: 66 Learn it by Fun
What's New in SQL Monitor 5
 
05:41
Colin Millerchip, Product Manager at Redgate, talks you through the major new features in SQL Monitor 5, including: Active Directory integration (00:39) AlwaysOn Availability Group support (03:12) To find out more about SQL Monitor, visit http://www.red-gate.com/sql-monitor Hi, my name is Colin Millerchip, and I work at Redgate Software as part of the team developing SQL Monitor. In this short video, I’m going to introduce you to SQL Monitor version 5, which we released in October 2015. If you’re not already familiar with SQL Monitor, it’s a performance monitoring tool that helps you manage your SQL Servers, keeping an eye on them 24-7, alerting you to problems or potential problems, helping you diagnose the root cause and keep your system up and running. Version 5 has two new key features: Active Directory integration, and improved support for AlwaysOn Availability groups. First let’s look at active directory integration. You can now use your Windows credentials to log into SQL Monitor, and SQL Monitor administrators have granular control over which monitored servers you’re allowed to see. This improves collaboration, for example, giving developers performance insights into production servers without having to grant them direct access, or allowing your BI team to only see the servers relevant to them. It also allows you to share administration duties across the team of people who are looking after your servers. • To enable Active Directory integration, go to the configuration tab, and select Authentication settings • By default, SQL Monitor uses built-in credentials. To switch to using Active Directory, select this as your authentication type • Now configure the domain information, and select a service account used to query Active Directory. • Save the settings… • … and SQL Monitor will ask you to set up a user as administrator. • Now, log on as this admin user • … and you’ll be taken to the configuration screen where you can add in any users who you want to give access to SQL Monitor. You can add individual users, as well as groups of users. • For standard users... • … not only do you restrict their access to some of the more administrative features of SQL Monitor (such as license management), but you can restrict the set of servers that they can manage. All the authorization data is stored internally within SQL Monitor, so this feature requires no modification of your Active Directory domain.   Now let’s look at Availability Group support. Prior to version 5, SQL Monitor would monitor the host machines running an AlwaysOn Availability Group, but had no Availability Group-specific features. With the introduction of version 5, SQL Monitor now has Availability Group overviews, alerts, metrics, and wait types. The overview gives you an at-a-glance view of the status of an Availability Group. You can see information about Availability Group specific alerts, … the state and failover information for availability replicas and databases, … and key availability database metrics Further details on the meaning of these fields and their values can be found in the product documentation. As for any other overview in SQL Monitor, you can drill through to see details of alerts or metrics. SQL Monitor version 5 ships with 7 pre-configured Availability Group alerts, covering areas including the health of Availability Group databases and replicas, whether replication is falling behind, and whether replication is slowing down query execution on your primary replica. Of course, these metrics can be extended using SQL Monitor’s custom metrics and alerting features. Time series data collected from Availability Groups is available within the Analysis tab. Again, you can drill through from the overviews to get this. If you are already monitoring host machines running Availability Groups, then upgrading to version 5 will automatically provide you with these Availability Group features. As to other changes in version 5: If you’re already familiar with SQL Monitor version 4, you’ll have noticed that we’ve refreshed the user interface, both to make it easier to use, and to make the UI faster and more responsive. Other changes include improving the stability of the monitoring service; and SQL Monitor version 5 has been fully tested against community technology previews of SQL Server 2016, If you want to find out more about SQL Monitor, visit the product homepage, and better still give us a call to arrange a demo or get help with your evaluation.
Views: 1460 Redgate Videos
Traces of stolen paintings found in ashes
 
01:15
Forensic scientists say they may have found the remnants of some priceless paintings stolen from a museum in the Netherlands last year. They found traces of paint in piles of ash recovered from the home of the main suspect's mother in Romania. The stolen works include pieces by Matisse, Picasso and Gauguin. Al Jazeera's Catherine Stancl reports.
Views: 1313 Al Jazeera English
When does JDBC No suitable driver error occurs?
| javapedia.net
 
00:29
Follow the link for discussions and other questions and answers at: https://www.javapedia.net/module/Java/JDBC/1906. Visit the playlist to watch other videos at the same category: https://www.youtube.com/playlist?list=PLYxPfcj1dUYtkulaso-jkYYpUJmKGzLaR Subscribe to the youtube channel to receive the updates. Thank you for visiting javapedia.net!
Views: 606 javapedia.net