Home
Search results “Oracle guid generate”
How to generate UUIDs as primary keys with Hibernate
 
05:59
Most developers prefer numerical primary keys because they are efficient to use and easy to generate. But that doesn’t mean that a primary key has to be a number. UUIDs, for example, have gained some popularity over the recent years If you like this video, please give me your thumbs up and share it with your friends and co-workers. Like my channel? Subscribe! ➜ http://bit.ly/2cUsid8 Join the free Member Library: https://goo.gl/dtyIIC Read the accompanying post: https://www.thoughts-on-java.org/generate-uuids-primary-keys-hibernate/ Want to connect with me? Blog: http://www.thoughts-on-java.org/ Twitter: https://twitter.com/thjanssen123 Facebook: https://www.facebook.com/thoughtsonjava
Views: 2583 Thoughts On Java
NIH Global Unique Identifier (GUID)
 
03:36
Overview of the GUID tool and the GUID creation process, including elements required to generate a GUID.
Views: 1027 NCATS NIH
Working with Orchestrated Integrations in Oracle Integration Cloud Service
 
04:38
When should you use an Orchestration integration? How do you create an Orchestration integration? This video shows you how. Learn more about Orchestration: https://docs.oracle.com/cloud/latest/intcs_gs/ICSUG/GUID-F66ABE41-0A69-4A73-BC3D-0CE36FA78C4D.htm#ICSUG-GUID-36A90FF0-F0D4-4F81-9028-41971C7D100B ================================= For more information, see http://www.oracle.com/goto/oll Copyright © 2016 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.
Oracle DV: How to build viz plugins using SDK
 
05:05
Oracle Data Visualization SDK Reference https://docs.oracle.com/middleware/bidv1221/desktop/BIDVD/GUID-6CCA6D3D-1877-4F7E-B337-73DC68D84797.htm Oracle Data Visualization SDK JavaScript Reference https://docs.oracle.com/middleware/bidv1221/desktop/DVDJS/index.html
Views: 1359 ORACLE ANALYTICS
guid generator in hibernate
 
06:10
Working of guid generator in hbiernate
Views: 144 Gopi krishna
Data Generator 2 - Defining tables
 
15:47
This video shows how to implement the plan devised in the previous video. Here, you will see how to select appropriate data types for the random data as well as how to handle foreign keys. The site being used is www.freedatagenerator.com
Views: 221 Andy Wicks
How To Create A Customer in Oracle ERP Cloud Accounts Receivable
 
03:07
How To Create A Customer in Oracle ERP Cloud Accounts Receivable
Views: 4129 Inoapps Limited
Virtual Box - How to set a new UUID to a Virtual Machine
 
02:47
How to set a new UUID on a VM in Oracle VM Virtual Box, this error can happen if circumstances surrounding the VDI file change such as name, location etc. This is done using the vboxmanage command line tool Steps: 1 - Right click "Command Prompt" and then click "Run as Administrator" 2 - Then use CD and DIR to browse to: C:\Program files\Oracle\Virtual Box 3 - Then type: vboxmanage internalcommands sethduuid "VDI filepath and filename" For example: vboxmanage internalcommands sethduuid "D:\vm\Windows7virtualmachine.vdi" Song name: DM Galaxy - Etiquette - Free Background Music Link to song: https://youtu.be/ZD_Urg9fOs0 Song created by: DM Galaxy: YouTube - http://goo.gl/5Tezt7 Facebook - https://www.facebook.com/DmGalaxy SoundCloud - https://soundcloud.com/dmgalaxy
Views: 3013 WitherTech
Java Prepopulate Adapter to Autogenerate User ID - OIM 11.1.2.3
 
08:29
Utilize a Java OIM Prepoulate Adapter to auto-generate a User ID by concatenating the first letter of the First Name attribute with the Last Name attribute then convert the result to upper case. This video tutorial is based on the OIM development environment deployed in previous tutorials. It also assumes knowledge of Linux and the Oracle modules involved in the build. For detailed information please visit http://idmgo.com To see the video playlist for the OIM 11.1.2.3 Development Environment build tutorials: https://www.youtube.com/playlist?list=PLkPO_JYGX0Yj2qz4eIU6v3Qek4IbQkXh_ For more information, refer to the guide for Developing and Customizing Applications for Oracle Identity Manager 11.1.2.3: https://docs.oracle.com/cd/E52734_01/oim/OMDEV/toc.htm
Views: 3226 IDMgo
Oracle Enterprise Manager: Metric Extensions
 
19:49
ic extensions provide you with the ability to extend Oracle's monitoring capabilities to monitor conditions specific to your IT environment. This provides you with a comprehensive view of your environment. Furthermore, metric extensions allow you to simplify your IT organization's operational processes by leveraging Enterprise Manager as the single central monitoring tool for your entire datacenter instead of relying on other monitoring tools to provide this supplementary monitoring. See Enterprise manager online documentation for more information: http://docs.oracle.com/cd/E73210_01/EMADM/GUID-4FCB90EC-5335-4F92-BFA7-CB1442000353.htm#EMADM10032 ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll Copyright © 2016 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.
Hierarchical Queries: Databases for Developers #16
 
09:38
Often data contains a parent-child relationship between rows in the same table. For example, company org charts and family trees. You can use the power of SQL to traverse these hierarchical relationships. There are two ways to do this in Oracle Database: - Connect By - Recursive With Watch this video to learn about data trees and find out how these work! Further reading: Hierarchical queries in the docs: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Hierarchical-Queries.html#GUID-0118DF1D-B9A9-41EB-8556-C6E7D6A5A84E Recursive subquery factoring in 11.2: https://oracle-base.com/articles/11g/recursive-subquery-factoring-11gr2 Take the course! https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-next-level.html Need help with SQL? Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ ============================ The Magic of SQL with Chris Saxon 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.
Views: 1264 The Magic of SQL
Hibernate 5 Tutorial - UUID and Custom Id Generation
 
12:57
In this video, I will demo how to makeUUID and Custom Id Generation. ====================================================== You can see programming languages book reviews and buy Books Online at http://learningprogramming.net/ ====================================================== You also can buy my apps in http://codecanyon.net/user/octopuscodes/portfolio ====================================================== TODAY IS A GREAT DAY TO LEARN SOMETHING NEW! ====================================================== Learning Programming videos help teach you about programming languages:Joomla, wordpress, drupal, magento, html template, free admin template, free bootstrap admin templates, SilverStripe, Cake PHP, CodeIgniter, Concrete5, Modx, ExpressionEngine, Alfresco,TYPOlight, laravel, magento, angularjs, node.js, html, css, javascript, jquery, java, .net, wamp server, xampp, php, mysql, sql server, oracle, open sources, android, hibernate, jpa, html5, jquery
Views: 1107 Learning Programming
How to Generate Random Alphanumeric in Java
 
01:45
Generate Random Alphanumeric in Java. http://www.tutorialesje.com/
Views: 800 JE Tutoriales
Set Up and Log In to Your First Oracle Container Cloud Service Instance
 
02:52
Find out how to get from your Oracle Cloud welcome mail to a working instance of Oracle Container Cloud Service, where you can manage your Docker environment. For more information, see the documentation at http://www.oracle.com/pls/topic/lookup?ctx=cloud&id=CONTU-GUID-CA18910C-AFC9-432E-AB1D-ADE87EAB5E63 ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll Copyright © 2017 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.
Virtualbox error - Failed to create the hard disk storage, with UUID already exists
 
01:44
When trying to create a virtualbox (ubuntu), i get an error : -- Failed to create the hard disk storage /home/user/VirtualBox VMs/Ubuntu64bit.vdi Cannot register the hard disk '/home/duaz/VirtualBox VMs/Ubuntu64bit/Ubuntu64bit.vdi' {fb7edfb4-d1c7-41de-9e1d-e483f4663fed} because a hard disk '/home/duaz/VirtualBox VMs/Ubuntu64bit/Ubuntu64bit.vdi' with UUID {1ac61938-0ee5-428b-a29e-1c252dcdcbd4} already exists. -- See this video how to fix that.
Views: 5581 Ambar Hasbiyatmoko
How to Use VirtualBox (Beginners Guide)
 
13:52
In a recent video in the “Free Software” series, I showed you VirtualBox, which is a free and open source solution to be able to run other operating systems virtually on your PC. In this beginner’s guide, I will show you how to set-up and use VirtualBox. In addition, I’ll also show you how to install and run Ubuntu, which is one of the most popular of the Linux distributions. If you're new, Subscribe! ▶ https://www.youtube.com/techgumbo Share This Video ▶ https://youtu.be/sB_5fqiysi4 0:30 What is VirtualBox. 1:16 Download. 1:46 Install. 2:29 Launch VirtualBox. 2:42 Download ISO for Ubuntu. 3:35 Create Guest OS. 6:41 Settings to complete the Guest OS process. 8:54 Install Ubuntu. 11:07 Tips for using Ubuntu. 13:15 Shut down Ubuntu. “Free Software” Playlist https://www.youtube.com/watch?v=gM8plsUfkTA&list=PLunpbmfrhFAWJA4lSDmRYJdcsEpjAuRdz VirtualBox https://www.virtualbox.org/wiki/Downloads Ubuntu https://www.ubuntu.com/desktop TechGumbo is a leading source for the technology that we use each day. Whether it’s discussing computer operating system tricks, the latest tips for your mobile phone, finding out about the newest gadgets, or beginners guides that show you how to use popular software, TechGumbo has boundless topics on technology for the astute YouTube viewer.
Views: 231924 TechGumbo
Omnichannel Services - Use UUID Keys to Your Data
 
03:46
Today I'm going to talk to you about why it's important to use universally unique identifiers (UUID) as keys to your data, and I will show you some of the problems that they can solve. In the distributed computing world of mobile devices and an internet of things it becomes almost impossible to have one source for key generation, so each device need to be able to create their own keys, while still making sure that those keys are unique. The answer is to use UUIDs, which is a standard by the Open Software Foundation, and there's an industry wide support for them (http://en.wikipedia.org/wiki/Universally_unique_identifier). For example, PHP, Java, .NET, Oracle, and MySQL all have ways to generate them, and SQL Server and ProgresSQL even has native UUID data types. Let talk about the benefits of using UUIDs, and I will start by pointing out some of the problems they can solve. When doing our data models, we have been taught to normalize our databases so that we find primary keys as one of the columns or a combination of columns. If not found, we usually add a generated id, such as an automatically incremented integer. One problem with using a multi-column key is that the queries become more complex as each column needs to be included in each join, and more complex means a lower performance and also larger indices. Another problem is that it's harder for the consumer of the data to know which columns are included in the key. With auto-generated keys, we get a simpler join, but a problem is that each consumer need to ask the generator for a valid key, and another problem is that there will be "holes" in the sequence when rows are deleted. Yet another problem is that any data type used has a fixed limit (even if huge), so it will eventually run out. Also, it becomes tricky for a client to find out which id was generated during an insert. With UUIDs, we get the same benefit of the simpler join as we got with the auto-generated keys, but now each user of the data can generate new keys and rows, without access to any central key generator -- it can even happen while disconnected. So any device or thing can generate a key and the maximum 3.4 x 10^38 combinations both ensure that each key is unique and that there's no practical limit of keys. But even UUIDs have drawbacks, and the most obvious is that they are hard to remember. Therefore, it's a good practice to provide ways of accessing data using attributes that are easier to remember. For example, provide a service that can get an order by providing an order number in addition to getting it using the primary key, the UUID. So make sure that you use UUIDs as keys to your data to allow distributed key generation, simplified joins, and get better performance. Follow me on Twitter https://twitter.com/chrisforsberg Visit my site http://cforsberg.com
Views: 4812 Chris Forsberg
Oracle Enterprise Manager: Integration with 3rd Party Systems
 
18:26
Enterprise Manager has a number of management connectors to integrate with popular 3rd party management systems. The management connectors leverage EM’s connector framework in order to forward event and incident details to 3rd party systems. Besides the management connectors, Enterprise Manager also has a number of Advanced Notification Methods when the use case is more complicated or when there is no management connector available. Enterprise Manager is highly extensible and provides a Connector Framework API which leverages web service calls to create and update events or tickets in 3rd party systems. We provide a Connectors Integration Guide with instructions and examples to build your own connector. See Enterprise manager online documentation for more information: http://docs.oracle.com/cd/E73210_01/nav/connectors.htm http://docs.oracle.com/cd/E73210_01/EMADM/GUID-B48F6A84-EE89-498D-94E0-5DE1E7A0CFBC.htm#EMADM9066 http://docs.oracle.com/cd/E73210_01/EMCIG/GUID-FBA700A1-B2F0-4A7B-980C-E4816A21FAD4.htm#EMCIG169 Copyright © 2017 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.
DataGrip Introduction
 
11:01
IMPORTANT! If you're looking for DataGrip Quick Start Guide, please, read: https://www.jetbrains.com/datagrip/quick-start/ DataGrip is an IDE from JetBrains built for database developers. It allows you to quickly migrate and refactor relational databases, construct efficient, statically checked SQL queries and much more. In this video, we highlight some of DataGrip's most powerful features. It is also relevant to the database plugin of IntelliJ IDEA, PhpStorm, PyCharm and RubyMine. For more details visit https://www.jetbrains.com/datagrip.
Views: 36407 JetBrainsTV
CTE in sql server   Part 49
 
12:57
In this video we will learn about creating and referencing CTE's in SQL server. We will also learn how to create multiple CTE's using a single WITH clause. Text version of the video http://csharp-video-tutorials.blogspot.com/2012/09/common-table-expressions-part-49.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-49-cte.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 169236 kudvenkat
Oracle Enterprise Manager: Intelligent Incident Compression
 
12:55
Beginning with Enterprise Manager 13c, Intelligent Incident Compression allows multiple events to be automatically grouped into a single incident. This recording consists of a product overview (8 min), followed by a demo (5 min). See Enterprise manager online documentation for more information: http://docs.oracle.com/cd/E73210_01/EMADM/GUID-D0428ED9-FCA8-44D6-AB5B-B8FF4139BF0D.htm#EMADM15277 ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll and http://docs.oracle.com Copyright © 2017 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.
10 - web services. Генерация классов
 
16:48
Лектор: Тимур Батыршинов (http://javabegin.ru). Ссылки из урока: Пример использования xjc: http://www.xyzws.com/scdjws/studyguide/jaxb_samples2.0.html http://docs.oracle.com/javase/6/docs/technotes/tools/share/xjc.html Домашнее задание: Сравнить реализации Java классов из прошлого урока Просмотреть документацию для ручного создания Java классов на основе XSD Создать Java классы на основе xml Добавить тег UUID к каждому person Почитать про класс UUID http://docs.oracle.com/javase/7/docs/api/java/util/UUID.html Сохранить новый xml
Views: 2059 Roman Brovko
Oracle Enterprise Manager: Always-On Monitoring
 
25:23
The Enterprise Manager Always-On Monitoring application provides the ability to monitor critical target status and metric alerts when the Oracle Management Service is unavailable. The service continuously monitors critical targets through the Enterprise Manager Agent and can be easily configured to send email notifications for these events to administrators. See Enterprise manager online documentation for more information: http://docs.oracle.com/cd/E73210_01/EMADM/GUID-3152AD33-8118-4478-B888-A332CFAB3453.htm#EMADM15489 ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll Copyright © 2016 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.
LINUX: Mount USB drives to permanent locations with UUID, fstab and udev
 
06:28
More videos like this on http://www.theurbanpenguin.com : In this tutorial we mount a USB dive to a fixed location using the file-system's UUID mounted in /etc/fstab. To make sure that the fstab is read for new hardware being detected, ie the usb drive being inserted, we create a udev rule to cater for this.
Views: 14392 theurbanpenguin
SQL Plus 18c rocks!
 
01:45
It's only March, but Christmas just came (very) early for SQL Plus users blog: https://connor-mcdonald.com music: Kevin McLeod, incomptech.com New features for SQL Plus 18c here: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqprn/index.html#SQPRN-GUID-B336CE0F-EC31-4993-A34C-733E335046BC
Views: 726 Connor McDonald
Hibernate GenerationType.SEQUENCE primary key generation strategy
 
06:23
In this video you will learn how GenerationType.SEQUENCE primary key generation strategy works. Below is the GitHub link to download source: https://github.com/kishanjavatrainer/HibernatePrimaryKeyGenExample3.git
Views: 1549 KK JavaTutorials
Select and Where: Databases for Developers #4
 
05:03
You query a database table with a select statement. But unless you provide a where clause, this will return you all the rows! That's a lot for you to sift through if your table has millions, billions or trillions of rows. In this episode Chris discusses common conditions for filtering rows so the database only returns what you need. Further reading: Oracle Database 12.2 select syntax: http://docs.oracle.com/database/122/SQLRF/SELECT.htm#SQLRF01702 Oracle Database Concepts Guide on Select: http://docs.oracle.com/database/122/CNCPT/sql.htm#GUID-702909E1-B214-4D30-A0F9-5A4335C2BA4A Take the Databases for Developers FREE SQL course at https://devgym.oracle.com/devgym/database-for-developers.html Daily SQL tips on Twitter: https://twitter.com/SQLDaily Chris on Twitter: https://twitter.com/ChrisRSaxon All Things SQL Blog: https://blogs.oracle.com/sql ============================ The Magic of SQL with Chris Saxon 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.
Views: 5290 The Magic of SQL
How to Create an Oracle VirtualBox Virtual Machine and Recover Data from a VDI Disk 💻📦⚕️
 
08:02
👍 Watch how to create an Oracle VirtualBox virtual machine, and how to recover data from a virtual disk of such machine after a failure or when the virtual machine can’t start. Recovering Data of Oracle VM VirtualBox Virtual Machine (*.vdi, *.vmdk, *.vhd, *.hdd, *.qed, *.qcow) - https://hetmanrecovery.com/recovery_news/recovering-data-of-oracle-vm-virtualbox-virtual-machine.htm. VirtualBox official webpage: https://www.virtualbox.org/. Watch another video on our channel to see how to create a bootable USB drive to install Windows: https://www.youtube.com/watch?v=YUOLPBSgwI4. Watch another video by our channel to see how to make a clean installation of Windows: https://www.youtube.com/watch?v=lb7P2iATJwc. In this video, I want to show you one trick, just in case if for some reason your virtual machine is no longer working, and there are important files on its disks. I will show you how to recover them. Though Oracle VirtualBox is a virtual machine, real data can be saved there. As we have already said, all files stored in virtual machine disks are located in .vdi files of the virtual disk (in our case). Hetman Partition Recovery, the program for hard disk data recovery, has the function of mounting virtual disks and recovering data from such disks. You can download Hetman Partition Recovery here: https://hetmanrecovery.com/hard_drive_recovery/software.htm In order to get access to virtual machine files: 1. Run Hetman Partition Recovery and mount the virtual machine disk. If there are several of them, you can mount them all at once or one by one.  To mount a virtual disk with the help of Hetman Partition Recovery, click on Mount Disk in the quick access menu of the program. As a result, the window of choosing a virtual disk will open.  Go to the folder containing the virtual machine and choose the necessary virtual disk file.  Open 2. As you do that, the section “Mounted Disks” containing the list of mounted virtual disks will appear in the window, where all disks found by the application are shown. If you mount several disks, you will see the entire disk list there. 3. Scan the disk with the application by clicking on the disk in the disk manager 4. After the analysis, the application will show the directory tree of the scanned disk. 5. Find and recover the necessary files to a convenient location in your main operating system. By the way, you can use this method to move files from a virtual machine disk to the main operating system. The methods we have described for recovering data of an Oracle VM VirtualBox virtual machine are good for virtual machine regardless of their virtual disk format: *.vdi, *.vmdk, *.vhd, *.vhdx, *.hdd, *.qed, *.qcow and they will be absolutely similar for all of these virtual disk formats. In this video, we have used the *.vdi virtual disk format as an example. I also recommend watching our previous videos on VMWare Workstation and Microsoft Hyper-V virtual machines; you can find the links in the description of this video. How to create a VMWare virtual machine and recover data from a VMDK disk with VMFS https://www.youtube.com/watch?v=7IOkVnQfN0E. How to create a Microsoft Hyper V virtual machine and recover data from a VHDX disk https://www.youtube.com/watch?v=2FcU_3JGReI. That is all for now. If you liked this video, click the Like button below and subscribe to our channel to see more. We’ll be glad to answer any questions in comments. Thank you for watching and good luck! Playlist: Recovering Data Deleted From The Hard Disk of a Windows Computer or Laptop - https://www.youtube.com/playlist?list=PLWfvrWYvsWiJz-xwWNm8AnZSzoAzDq-Zp. Other videos: #OracleVirtualBox, #VirtualMachine, #VMDK, #DataRecovery, #vhd, #vdi.
Views: 1780 Hetman Recovery
Java - How to Generate Unique Serial Number in Database using Java
 
15:59
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 email : [email protected] 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 Website : http://relybill.com/ 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
Views: 10024 Intact Abode
Oracle Enterprise Manager: Advanced Threshold Management
 
16:34
Advanced Thresholds allow you to define and manage alert thresholds that are either adaptive (self-adjusting) or time-based (static). There are monitoring situations in which different workloads for a target occur at regular (expected) intervals. Under these conditions, a static alert threshold would prove to be inaccurate. For example, the accurate alert thresholds for a database performing Online Transaction Process (OLTP) during the day and batch processing at night would be different. Similarly, database workloads can change based purely on different time periods, such as weekday versus weekend. In both these situations, fixed, static values for thresholds might result in false alert reporting. See Enterprise manager online documentation for more information: http://docs.oracle.com/cd/E73210_01/EMADM/GUID-02356AB5-4B03-46AE-8354-2E9517A8F439.htm#EMADM15123 ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll Copyright © 2016 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 Fix VirtualBox “UUID already exists”
 
04:10
It is a simple solution for some of you big problem. Just do as I and no error anymore ################## Buy my course: IOT based Raspberry Temperature monitoring with Email Alert on udemy https://www.udemy.com/course/481118 ##################
Views: 2003 Mix tutor
Oracle Database tutorials 1: How to install Oracle Database 11g on windows 7
 
08:54
How To install Oracle Database 11g enterprise edition On windows 7 64 bit. Full installation in Single video. Enjoy SQL and Oracle Database Download Oracle Database 11g from here http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Related Tutorial ► Tut 16 How To Uninstall Oracle 11g http://youtu.be/pk-E-QxWe38 ► Tut 25 How To Install Oracle 11g XE r2 http://youtu.be/-13SbeDavwk ► Oracle 12c Tut 1 How To Install Oracle 12c http://youtu.be/T-rCbe1MMG4 ►Oracle 12c Tut 5 How To Uninstall Oracle 12c http://youtu.be/lyN9aJfMlzQ ------------------------------------------------------------------------- ►►►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 -------------------------------------------------------------------------- ►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 [email protected] You can help me in getting a good job by connecting with me on my LinkedIn and Endorsing my Skills. 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: 1366811 Manish Sharma
Dynamic SQL in SQL Server
 
12:12
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/03/dynamic-sql-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2017/03/dynamic-sql-in-sql-server_27.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All SQL Server Tutorial Videos https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss 1. What is Dynamic SQL 2. Simple example of using Dynamic SQL What is Dynamic SQL Dynamic SQL is a SQL built from strings at runtime. Simple example of using Dynamic SQL Here is the SQL Script to create Employees table and populate it with data Create table Employees ( ID int primary key identity, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) Go Insert into Employees values ('Mark', 'Hastings', 'Male', 60000) Insert into Employees values ('Steve', 'Pound', 'Male', 45000) Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000) Insert into Employees values ('Philip', 'Hastings', 'Male', 45000) Insert into Employees values ('Mary', 'Lambeth', 'Female', 30000) Insert into Employees values ('Valarie', 'Vikings', 'Female', 35000) Insert into Employees values ('John', 'Stanmore', 'Male', 80000) Go One way to achieve this is by implementing a stored procedure as shown below that this page would call. Create Procedure spSearchEmployees @FirstName nvarchar(100), @LastName nvarchar(100), @Gender nvarchar(50), @Salary int As Begin Select * from Employees where (FirstName = @FirstName OR @FirstName IS NULL) AND (LastName = @LastName OR @LastName IS NULL) AND (Gender = @Gender OR @Gender IS NULL) AND (Salary = @Salary OR @Salary IS NULL) End Go The stored procedure in this case is not very complicated as we have only 4 search filters. What if there are 20 or more such filters. This stored procedure can get complex. To make things worse what if we want to specify conditions like AND, OR etc between these search filters. The stored procedure can get extremely large, complicated and difficult to maintain. One way to reduce the complexity is by using dynamic SQL as show below. Depending on for which search filters the user has provided the values on the "Search Page", we build the WHERE clause dynamically at runtime, which can reduce complexity. However, you might hear arguments that dynamic sql is bad both in-terms of security and performance. This is true if the dynamic sql is not properly implemented. From a security standpoint, it may open doors for SQL injection attack and from a performance standpoint, the cached query plans may not be reused. If properly implemented, we will not have these problems with dynamic sql. In our upcoming videos, we will discuss good and bad dynamic sql implementations. For now let's implement a simple example that makes use of dynamic sql. In the example below we are assuming the user has supplied values only for FirstName and LastName search fields. To execute the dynamicl sql we are using system stored procedure sp_executesql. sp_executesql takes two pre-defined parameters and any number of user-defined parameters. @statement - The is the first parameter which is mandatory, and contains the SQL statements to execute @params - This is the second parameter and is optional. This is used to declare parameters specified in @statement The rest of the parameters are the parameters that you declared in @params, and you pass them as you pass parameters to a stored procedure Declare @sql nvarchar(1000) Declare @params nvarchar(1000) Set @sql = 'Select * from Employees where [email protected] and [email protected]' Set @params = '@FirstName nvarchar(100), @LastName nvarchar(100)' Execute sp_executesql @sql, @params, @FirstName='Ben',@LastName='Hoskins' This is just the introduction to dynamic SQL. If a few things are unclear at the moment, don't worry. In our upcoming videos we will discuss the following 1. Implementing a real world "Search Web Page" with and without dynamic SQL 2. Performance and Security implications of dynamic sql. Along the way we will also discuss good and bad dynamic sql implementations. 3. Different options available for executing dynamic sql and their implications 4. Using dynamic sql in stored procedures and it's implications Once we discuss all the above, you will understand 1. The flexibility dynamic sql provides 2. Advantages and disadvantages of dynamic sql 3. When and when not to use dynamic sql
Views: 34221 kudvenkat
2 Node Oracle 11gR2 RAC on laptop using Oracle VirtualBox
 
01:34:19
2 Node Oracle 11gR2 Real Application Cluster on laptop/desktop using Oracle VirtualBox and Linux as the Guest OS This is just a fast forward of a full configuration. You must be familiar with the installation process of Oracle Grid Infrastructure and the RAC concepts. This video is for those who want to practice Oracle RAC on laptop or desktop
Views: 13918 Satish Lodam
Changing the UUID of a Virtualbox Hard Drive (VDI) using VBoxManage Sethduuid
 
02:42
In this video I change the Universal Unique Identifier (UUID) of a copied Virtualbox hard drive (vdi) using the VboxManage command line utility tool. In order to reuse an existing hard drive in Virtualbox you will need to have a different UUID for every hard drive associated with VirtualBox. If you simply make a copy of a hard drive without using the CloneHD utility of Virtualbox you will need to change the UUID of your copied VDI. The command is in the format VBoxManage internalcommands sethduuid harddrive.vdi. For more information visit http://lecturesnippets.com
Views: 18593 Lecture Snippets
Monitoring  Oracle Java Cloud Service -  SaaS Extension
 
04:54
(This video is describes how to use JCS-SaaS Extension Control, the Java console for JCS-SaaS Extension, to monitor activity running on that application. For additional information, see "Using Oracle Java Cloud Service - SaaS Extension Control" at https://docs.oracle.com/cloud/latest/javacs_gs/CSJSU/GUID-DB8FC210-671F-470C-94A9-C472814C8E66.htm#CSJSU7074 NOTE: To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. ================================= For more information, see http://www.oracle.com/goto/oll Copyright © 2016 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.
Difference between rows and range
 
05:52
range vs rows in sql server difference between rows clause and range clause in sql server range clause vs rows clause in sql server sql server running total query running total example in sql server In this video we will discuss the difference between rows and range in SQL Server. This is continuation to Part 116. Please watch Part 116 from SQL Server tutorial before proceeding. Let us understand the difference with an example. We will use the following Employees table in this demo. SQL Script to create the Employees table Create Table Employees ( Id int primary key, Name nvarchar(50), Salary int ) Go Insert Into Employees Values (1, 'Mark', 1000) Insert Into Employees Values (2, 'John', 2000) Insert Into Employees Values (3, 'Pam', 3000) Insert Into Employees Values (4, 'Sara', 4000) Insert Into Employees Values (5, 'Todd', 5000) Go Calculate the running total of Salary and display it against every employee row The following query calculates the running total. We have not specified an explicit value for ROWS or RANGE clause. SELECT Name, Salary, SUM(Salary) OVER(ORDER BY Salary) AS RunningTotal FROM Employees So the above query is using the default value which is RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW This means the above query can be re-written using an explicit value for ROWS or RANGE clause as shown below. SELECT Name, Salary, SUM(Salary) OVER(ORDER BY Salary RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RunningTotal FROM Employees We can also achieve the same result, by replacing RANGE with ROWS SELECT Name, Salary, SUM(Salary) OVER(ORDER BY Salary ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RunningTotal FROM Employees What is the difference between ROWS and RANGE To understand the difference we need some duplicate values for the Salary column in the Employees table. Execute the following UPDATE script to introduce duplicate values in the Salary column Update Employees set Salary = 1000 where Id = 2 Update Employees set Salary = 3000 where Id = 4 Go Now execute the following query. Notice that we get the running total as expected. SELECT Name, Salary, SUM(Salary) OVER(ORDER BY Salary ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RunningTotal FROM Employees The following query uses RANGE instead of ROWS SELECT Name, Salary, SUM(Salary) OVER(ORDER BY Salary RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RunningTotal FROM Employees Notice we don't get the running total as expected. So, the main difference between ROWS and RANGE is in the way duplicate rows are treated. ROWS treat duplicates as distinct values, where as RANGE treats them as a single entity. All together side by side. The following query shows how running total changes 1. When no value is specified for ROWS or RANGE clause 2. When RANGE clause is used explicitly with it's default value 3. When ROWS clause is used instead of RANGE clause SELECT Name, Salary, SUM(Salary) OVER(ORDER BY Salary) AS [Default], SUM(Salary) OVER(ORDER BY Salary RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS [Range], SUM(Salary) OVER(ORDER BY Salary ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS [Rows] FROM Employees Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/difference-between-rows-and-range.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/difference-between-rows-and-range_8.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 31475 kudvenkat
How To Integrate Oracle Weblogic Server With Oracle Enterprise Manager (OEM) Cloud Control
 
19:02
In this video demo I will show you how to integrate Oracle Weblogic Server with Oracle Enterprise Manager Cloud Control (OEM) Have a look at my blog for step by step instructions and screenshots I used in this video. Blog Link : http://prasaddomala.com/how-to-integrate-oracle-weblogic-server-with-oracle-enterprise-manager-cloud-control-oem Oracle Enterprise Manager Cloud Control (OEM) Installation & Configuration https://www.youtube.com/watch?v=EKd_Mr_c1XU http://prasaddomala.com/oracle-enterprise-manager-cloud-control-13c-installation-configuration/ Weblogic Server OEM Metric Reference Guide http://docs.oracle.com/cd/E73210_01/EMASM/GUID-3E63D9C6-65B4-4B46-8BEB-E855D009CF8D.htm#EMASM3202
Views: 3169 Prasad Domala
Part 69   Merge in SQL Server
 
07:14
Text version of the video http://csharp-video-tutorials.blogspot.com/2014/09/part-69-merge-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2014/09/part-69-merge-in-sql-server_30.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists What is the use of MERGE statement in SQL Server Merge statement introduced in SQL Server 2008 allows us to perform Inserts, Updates and Deletes in one statement. This means we no longer have to use multiple statements for performing Insert, Update and Delete. With merge statement we require 2 tables 1. Source Table - Contains the changes that needs to be applied to the target table 2. Target Table - The table that require changes (Inserts, Updates and Deletes) The merge statement joins the target table to the source table by using a common column in both the tables. Based on how the rows match up as a result of the join, we can then perform insert, update, and delete on the target table. Merge statement syntax MERGE [TARGET] AS T USING [SOURCE] AS S ON [JOIN_CONDITIONS] WHEN MATCHED THEN [UPDATE STATEMENT] WHEN NOT MATCHED BY TARGET THEN [INSERT STATEMENT] WHEN NOT MATCHED BY SOURCE THEN [DELETE STATEMENT] Example 1 : In the example below, INSERT, UPDATE and DELETE are all performed in one statement 1. When matching rows are found, StudentTarget table is UPDATED (i.e WHEN MATCHED) 2. When the rows are present in StudentSource table but not in StudentTarget table those rows are INSERTED into StudentTarget table (i.e WHEN NOT MATCHED BY TARGET) 3. When the rows are present in StudentTarget table but not in StudentSource table those rows are DELETED from StudentTarget table (i.e WHEN NOT MATCHED BY SOURCE) Create table StudentSource ( ID int primary key, Name nvarchar(20) ) GO Insert into StudentSource values (1, 'Mike') Insert into StudentSource values (2, 'Sara') GO Create table StudentTarget ( ID int primary key, Name nvarchar(20) ) GO Insert into StudentTarget values (1, 'Mike M') Insert into StudentTarget values (3, 'John') GO MERGE INTO StudentTarget AS T USING StudentSource AS S ON T.ID = S.ID WHEN MATCHED THEN UPDATE SET T.NAME = S.NAME WHEN NOT MATCHED BY TARGET THEN INSERT (ID, NAME) VALUES(S.ID, S.NAME) WHEN NOT MATCHED BY SOURCE THEN DELETE; Please Note : Merge statement should end with a semicolon, otherwise you would get an error stating - A MERGE statement must be terminated by a semi-colon (;) In real time we mostly perform INSERTS and UPDATES. The rows that are present in target table but not in source table are usually not deleted from the target table. Example 2 : In the example below, only INSERT and UPDATE is performed. We are not deleting the rows that are present in the target table but not in the source table. Truncate table StudentSource Truncate table StudentTarget GO Insert into StudentSource values (1, 'Mike') Insert into StudentSource values (2, 'Sara') GO Insert into StudentTarget values (1, 'Mike M') Insert into StudentTarget values (3, 'John') GO MERGE INTO StudentTarget AS T USING StudentSource AS S ON T.ID = S.ID WHEN MATCHED THEN UPDATE SET T.NAME = S.NAME WHEN NOT MATCHED BY TARGET THEN INSERT (ID, NAME) VALUES(S.ID, S.NAME);
Views: 93948 kudvenkat
ORDS and the New SQL/JSON  Database Functions - Part 2
 
15:54
This is the second part of the "ORDS and the New SQL/JSON Database Functions" series which covers storing JSON in columns within your relational schema and in the new Oracle Database 12c JSON Document Store using Simple Oracle Document Access or SODA.
MEGA PICK A CARD: My Journey (Energy Update)
 
01:50:16
Hi I’m Ray, a metaphysics enthusiast and intuitive advisor. I stumbled upon tarot over a year ago, and decided to create this channel for fellow enthusiasts to connect. Timestamps: Giveaway Announcement: 04:02 Hair Clip 09:49 Ring 20:06 “ “ {27: 36 — pile 2} Buckle 33:21 “ “ {41:50 — pile 2} Green Gem 55:07 SD Cad 1:04:18 Bottle Cap 1:13:55 Key 1:19:52 Eggshell Earring 1:25:09 Bracelet 1:31:41 Buddha 1:41:42 Support the channel with a donation: paypal.me/SimplyIntuitiveReads PRIVATE READINGS OFFERED: My style is a unique blend of intuition, numerology, energy healing, and tarot. $3.33 – One card pull Can be general or a yes/no question. Up to 2 cards pulled. $10.10 - One Question Situational Read This is great if you’re looking for quick answers/guidance to your situation. Same style as pick-a-card readings. Up to 10 cards pulled. $25 – Three Question Personal Read Detailed reading on any topic of your choosing. Can be general, on your situation, about love or career. Pretty much anything you want clarity and guidance on. Session runs roughly 25 min. $35 – Prolonged Personal Read A longer personal reading on your chosen topic. Typical readings are on love, career, life, and relationships (family, friends, co-workers). Session runs roughly 35 min. $50 - Personal Year/Birthday Reading A reading on what this year holds for you. We go month to month to check in on the energies. You can book these up to 3 months prior to your birthday and includes info on your personal numerology year. $75 – One Hour Extensive Chat A detailed Skype/video or phone chat on any topic of your choosing. You can also book for assistance in these areas: - Career/Business planning and strategy - Guidance on goal setting plus where you’re headed - Deep dive into a love connection - Understanding relationship dynamics (family, friends, lover) and trauma Email me at [email protected] to schedule. All readings can be video or audio recorded (except for the one hour extensive chat). Readings are usually received within 3-5 days. Love to you all, and thank you for being amazing!
Views: 2743 Simply Intuitive
How to generate primary keys with JPA and Hibernate
 
09:08
Today, I will show you how to generate unique primary key values with JPA and Hibernate. But before we start, I want to know how you get the primary key values in your application? Do you use natural keys or UUIDs or do you generate technical IDs? Please post a comment below and tell me about it. I prefer to generate simple, numerical, technical IDs like you can see in the following code snippet instead of using natural keys which often require the combination of multiple attributes. Technical IDs are easier to manage and all involved systems, mainly the database and Hibernate, can index them very efficiently. This allows you to focus on the business logic of your application and avoids performance issues. If you like this video, please give me your thumbs up and share it with your friends and co-workers. Like my channel? Subscribe! ➜ http://bit.ly/2cUsid8 Join the free Member Library: https://goo.gl/dtyIIC Read the accompanying post: https://www.thoughts-on-java.org/jpa-generate-primary-keys/ Want to connect with me? Blog: http://www.thoughts-on-java.org/ Twitter: https://twitter.com/thjanssen123 Facebook: https://www.facebook.com/thoughtsonjava
Views: 3105 Thoughts On Java
VirtualBox and Windows 7 x64 Install
 
13:02
With the free VirtualBox software is it possible to setup demo environments very simple and fast. This video show the installation process of VirtualBox and then installation of Windows 7 x64 SP1 as a Virtual Machine. The installation is run on the following hardware AsRock Z68 Pro3-M motherboard, Core I7-2600K CPU, 16 GB of RAM, Dual 60 GB SSD and 2 TB traditional HDD. The processor is overclocked to 4.2 GHz using a better CPU cooler. Total cost of this system is less than $1000. Minimum hardware specification can be found on VirtualBox's site. https://www.virtualbox.org/wiki/End-user_documentation The ISO image for Windows 7 used in this video can be downloaded from MSDN (Microsoft Developer Network). A subscription is required to download from this site. Sorry, I'm currently not able to respond to comments. Google want to merge my company with my private information by forcing me to use Google+
Views: 765321 Mergetool
Solution - Unable to Create Machine ID Error
 
02:33
Fix "Unable to Create Machine ID, error retrieving information." error in minutes. If any problem, mention in comments. This error usually arrives when you are trying to Generate Machine ID after installing Intergraph Smart Plant License Manager (SPLM). Give Thumbs Up. Subscribe for more Updates. Follow us on:- Facebook :- https://goo.gl/jBZXqP Twitter :- https://twitter.com/TvTwinkle Google+ :- https://plus.google.com/+TwinkleTVi YouTube :- http://www.youtube.com/c/TwinkleTVi
Views: 10210 TwinkleTV
ASP.NET Tutorial 3- How to Create a Login website - Creating Database For website
 
13:42
Setting up the Database ASP.NET Site Building ASP.NET Web Applications with ASP.NET Web Pages Databases ASP.NET Web Forms Tutorial After creating Website using ASP.NET (c#), sqlserver(Database SQL server DAtabase Creating a Database ASP.NET Web Pages Tutorial Create a Database Application in 15 Minutes with ASP.NET Create a website with ASP.Net Create an ASP.NET website ASP.NET Web Pages Databases ASP.NET Web Forms Database
Views: 462329 ProgrammingKnowledge
Dynamic SQL in Stored Procedure
 
09:32
In this video we will discuss, using dynamic sql in a stored procedure and it's implications from sql injection perspective. We will discuss performance implications of using dynamic sql in a stored procedure in a later video. Text version of the video http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure.html Slides http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure_11.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All SQL Server Tutorial Videos https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists Consider the following stored procedure "spSearchEmployees". We implemented this procedure in Part 139 of SQL Server tutorial. This stored procedure does not have any dynamic sql in it. It is all static sql and is immune to sql injection. Create Procedure spSearchEmployees @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Select * from Employees where (FirstName = @FirstName OR @FirstName IS NULL) AND (LastName = @LastName OR @LastName IS NULL) AND (Gender = @Gender OR @Gender IS NULL) AND (Salary = @Salary OR @Salary IS NULL) End Go Whether you are creating your dynamic sql queries in a client application like ASP.NET web application or in a stored procedure, you should never ever concatenate user input values. Instead you should be using parameters. Notice in the following example, we are creating dynamic sql queries by concatenating parameter values, instead of using parameterized queries. This stored procedure is prone to SQL injection. Let's prove this by creating a "Search Page" that calls this procedure. Create Procedure spSearchEmployeesBadDynamicSQL @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Declare @sql nvarchar(max) Set @sql = 'Select * from Employees where 1 = 1' if(@FirstName is not null) Set @sql = @sql + ' and FirstName=''' + @FirstName + '''' if(@LastName is not null) Set @sql = @sql + ' and LastName=''' + @LastName + '''' if(@Gender is not null) Set @sql = @sql + ' and Gender=''' + @Gender + '''' if(@Salary is not null) Set @sql = @sql + ' and Salary=''' + @Salary + '''' Execute sp_executesql @sql End Go Add a Web Page to the project that we have been working with in our previous video. Name it "DynamicSQLInStoredProcedure.aspx". Copy and paste the HTML and code available on my blog at the following link http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure.html At this point, run the application and type the following text in the "Firsname" text and click "Search" button. Notice "SalesDB" database is dropped. Our application is prone to SQL injection as we have implemented dynamic sql in our stored procedure by concatenating strings instead of using parameters. ' Drop database SalesDB -- In the following stored procedure we have implemented dynamic sql by using parameters, so this is not prone to sql injecttion. This is an example for good dynamic sql implementation. Create Procedure spSearchEmployeesGoodDynamicSQL @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Declare @sql nvarchar(max) Declare @sqlParams nvarchar(max) Set @sql = 'Select * from Employees where 1 = 1' if(@FirstName is not null) Set @sql = @sql + ' and [email protected]' if(@LastName is not null) Set @sql = @sql + ' and [email protected]' if(@Gender is not null) Set @sql = @sql + ' and [email protected]' if(@Salary is not null) Set @sql = @sql + ' and [email protected]' Execute sp_executesql @sql, N'@FN nvarchar(50), @LN nvarchar(50), @Gen nvarchar(50), @sal int', @[email protected], @[email protected], @[email protected], @[email protected] End Go On the code-behind page, use stored procedure spSearchEmployeesGoodDynamicSQL instead of spSearchEmployeesBadDynamicSQL. We do not have to change any other code. At this point run the application one more time and type the following text in the "Firstname" textbox and click the "Search" button. ' Drop database SalesDB -- Notice "SalesDB" database is not dropped, So in this case our application is not succeptible to SQL injection attack. Summary : Whether you are creating dynamic sql in a client application (like a web application) or in a stored procedure always use parameters instead of concatnating strings. Using parameters to create dynamic sql statements prevents sql injection.
Views: 26720 kudvenkat
How to fix VirtualBox "Cannot create the machine folder" error
 
01:32
Displayed error message: This folder already exists and possibly belongs to another machine.
Views: 20250 furulevi
Oracle Eloqua Developer - Creating an App Provider
 
02:20
What is an App Provider in Oracle Eloqua? Watch this video to find out why you want one, and how to create one. For more information, see https://docs.oracle.com/cloud/latest/marketingcs_gs/OMCAB/index.html#CSHID=AppCloud.