Home
Search results “Select remote database oracle” for the 2014
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: 278362 Manish Sharma
How to connect to Oracle Database using Toad for Oracle.
 
08:42
How to connect to Oracle Database using Toad for Oracle. Online Video to learn the simple way to connect to database through Toad for Oracle. Learn Oracle connectivity from configuring tnsnames.ora , net8 client configuration to connecting to toad. A complete oracle tutorial.
Views: 119467 Subhroneel Ganguly
How to connect to Oracle database using Python in Windows.
 
07:59
How to connect to Oracle database using Python in Windows. Program will connect to Oracle 12c database and retrieve data from a table. Link to Oracle 12c client library : https://pypi.python.org/pypi/cx_Oracle/5.1.3 Just chose your version matching your installed python
Views: 39089 Subhroneel Ganguly
Oracle Database Tutorial 52 : Data Pump expdp - How to Export full database using expdp
 
07:26
Oracle Database tutorial/SQL Tutorial 52 On Data Pump expdp utility here in this tutorial you'll learn how to export full/complete Database using expdp data pump utility of oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/database-full-export-using-expdp Tut 48 Roles: http://youtu.be/tyYxSrCXzCM ------------------------------------------------------------------------- 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! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 76324 Manish Sharma
Database connection in Eclipse (Oracle) : javavids
 
03:33
How to connect Oracle database in Eclipse? Part of Java online video tutorials: http://www.javavids.com
Views: 91148 Jiri Pinkas
How to connect to Mysql database through windows command line (cmd)!
 
07:31
Access your databases through command line, instead of user graphical user interface.
Views: 296158 ICT Trainer
Remote Database
 
24:22
For Remote Database Connection In Asp.NET Web Application Using LINQ to SQL
Views: 793 Skilltrix
Java- MySQL Connection (Create Table, Insert, Select)
 
09:55
This is a fast tutorial, intended for people who understand java, and the basics of SQL/MySQL who just want to see how to use my-sql-connector. How to create a MySQL Connection in java, then create a table, insert, and select, video 1 of 4. CODE: import java.sql.Connection; import java.sql.DriverManager; public static Connection getConnection() throws Exception{ try{ String driver = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://24.196.52.166:3306/testdb"; String username = "username"; String password = "password"; Class.forName(driver); Connection conn = DriverManager.getConnection(url,username,password); System.out.println("Connected"); return conn; } catch(Exception e){System.out.println(e);} return null; } Download JDBC https://dev.mysql.com/downloads/connector/j/ --06/07/2107
Views: 278328 Steven Byrne
MySQL Workbench: Connection Creation and Trouble Shooting (for beginners)
 
23:50
This video shows how to create connections in MySQL Workbench and what to do if problems arise with that. Please subscribe to the MySQL Youtube channel: http://www.youtube.com/mysqlchannel Like our MySQL Facebook page: http://facebook.com/mysql Follow us on Twitter at: http://twitter.com/mysql
Views: 363085 MySQL
How to save data from Arduino to MySQL Database Server
 
10:25
Arduino saves data to MySQL Database Server. You can download library and source code for this project at https://github.com/MD4N1/Wiz550io-Tutorial-Series
Views: 170750 Mohamad Dani
Using Oracle to read data from SQL Server
 
10:47
Hi everyone, Andy from Easysoft Limited here, what I want to show you today is how to get data from SQL Server into Oracle. Now for this we will be accessing SQL Server 2014 from Oracle 12 and getting data across. This could be quite easily be any SQL Server version from 2008 and any Oracle version from 11.2, the configuration and process is the same. We can obviously get access to data on SQL Server prior to 2008 and Oracle prior to version 11.2 but it will need a different configuration to what I am going to show you today The plan is also to add more data to the SQL Server table and show this new data back in Oracle. To start off you'll need access to ensure that you have access to your SQL Server and Oracle databases. You'll also need the Easysoft SQL Server ODBC Driver available from www.easysoft.com; just download it, install it and request the free 14 day trial licence. Before we start we need to make some changes to the standard Easysoft config files. cat /etc/odbc.ini Here I have changed Mars Connection to Yes. It must be set to "Yes" if you are connecting to SQL Server 2005 or newer. Easysoft supports all SQL data types from the version of SQL Server from version 7. Oracle supports data types that are common to most ODBC Drivers, but not some of the SQL Server ones. If you intend to access VARCHAR(MAX) for example, then there are some additional settings that need to be set up. Now as I would like to show you VARCHAR(MAX) data moving from SQL Server to Oracle, I have made the relevant change. As you can see, VarMaxAsLong says "Yes" We now need to create a link from Oracles Database Gateway (DG4ODBC) to the ODBC datasource that we already have, this is done in an init(sid) oracle file; let's have a look at our file. cat $ORACLE_HOME/hs/admin/initsqlsrv.ora Please note that HS_NLS_NCHAR must be set to UCS2 Oracle assume that most database vendors use UTF-8 for wide characters, however Easysoft, like almost all ODBC Driver vendors (including Oracles own ODBC Driver) uses UCS2 for wide characters. So that's the link between DG4ODBC and the datasource setup correctly. Next we need to set up the Listener entry The Oracle Listener waits for incoming requests from the Oracle database. For the Oracle Listener to listen for requests, information about DG4ODBC must be added to the Oracle Listener configuration file, listener.ora cat $ORACLE_HOME/network/admin/listener.ora The PROGRAM=dg4odbc tells the Listener that we are wanting to use the Oracle database gateway to communicate with ODBC. The ENVS=LD_LIBRARY_PATH tells Oracle what library to load Now that's all set up and OK we need to tell Oracle which server to attach the listener entry to. This is done in tnsnames.ora, and he is the file that we ensured was set up earlier. cat $ORACLE_HOME/network/admin/tnsnames.ora The Oracle Listener now needs to be restarted. lsnrctl stop lsnrctl start OK, that's now started the Listener up again. So we have ensured that all the configuration files are set up correctly. The Listener and tnsnames.ora both set up OK. The final step is to create a link from the Oracle database to the "tnsnames.ora" entry. CREATE PUBLIC DATABASE LINK ODBC CONNECT TO "test" IDENTIFIED BY "test" USING 'sqlsrv_ptr'; Right, that's all done. Let's access the data in SQL Server now. select * from [email protected]; Where 'demo' is the name of the SQL Server table and 'odbc' is the public database link name. OK, there we have the data. So to recap, I'm in Oracle and we have managed to read the data from SQL Server. Let's just add an additional row in that SQL Server table and retrieve the new data in Oracle. quit; /usr/local/easysoft/unixODBC/bin/isql.sh -v sqlsrv insert into demo values (2,'Easysoft') select * from demo select * from [email protected]; And there is the new data. Easysoft Limited can help you with your data access ... for our full range of ODBC and JDBC Drivers, Bridges and Gateways visit easysoft.com Be sure to let us know if you have any comments or questions. Until next time, thanks again and we'll see you again soon.
Views: 16337 Easysoft Limited
Amazon AWS RDS | How to create and connect RDS Database Instance | Part 1
 
11:38
How to launch create Amazon MySQL RDS Instance How to connect to Amazon RDS Instance How to terminate Amazon RDS Instance How to backup Amazon RDS Instance How to launch Amazon RDS Instance
Views: 101708 AWS Like a PRO!
Interacting with database in Android App using C# with Xamarin
 
01:13:26
In this video i will be explaining "how to interact with the database in Android Application" developed using Visual C# with the support of SQLite ORM Model FOR ONLINE TRAINING FOR XAMARIN [email protected] or reach me at +91-90109216169 / +91-9951890241 *** The code and presentation used in this video can be found at my website : www.sekhartheguru.net at code section This is the first part of the 3 videos on interacting with the database from android application 2)Second Part of the video will be interacting with the database using SQLite for .NET Developers using ADO.NET Providers method 3)Third and final part of this video will be interacting with the database using WCF Rest Services and using JSON result from an Android Application developed using C#
Views: 99020 sekhar srinivas
EXCEL VBA MACRO READ DATA FROM SQLSERVER
 
07:50
VBA EXAMPLE, EXCEL MACRO TO CONNECT DATABASE, EXCEL VBA CONNECT TO SQLSERVER, READ DATA FROM SQLSERVER TABLE TO EXCEL
Views: 38361 Excel Vba Tutorial
From Oracle DB to RESTful Web Services
 
15:23
Via REST, you can create APIs that can be accessed and consumed by external applications. Each API provides access to a subset of data in your database. In this screencast, using an OracleDB, you are shown exactly how to do that.
Views: 25810 NetBeansVideos
Java JDBC Tutorial - Part 1: Connect to MySQL database with Java
 
09:06
5 FREE JAVA VIDEO COURSES - CLICK HERE - https://goo.gl/7i95F8 --- View more videos on my "Java JDBC Tutorial" Playlist: http://goo.gl/crT4nS Closed-Captioning and English subtitles available. In this tutorial, you will learn how to connect to a MySQL database with Java. Download source code from - http://www.luv2code.com/2014/03/21/connect-to-mysql-database-with-java-jdbc/ Please subscribe to my channel. http://goo.gl/EV6Kwv ---- Follow luv2code: Website: http://www.luv2code.com YouTube: http://goo.gl/EV6Kwv Twitter: http://goo.gl/ALMzLG Facebook: http://goo.gl/8pDRdA --- Join my mailing list: Get advance notice on new tutorials. Emails about 1 per week. - http://www.luv2code.com/joinlist --- Questions or problems? Post them in the comments section below. --- Want to suggest a video? Leave a comment below. I'm always looking for new video ideas. Let me know what video you'd like for me to create. --- Video Transcript Time - 00:00 Hello. In this tutorial, you will learn how to connect to a MySQL database with Java. In this session we’re going to learn how to connect a MySQL database with Java. Before we get started there are some prep work that needs to take place. One is that you need to have a MySQL database already installed. If not, you can download one from the site listed here on the slide. Time - 00:20 Next, we’ll need to download and install a MySQL JDBC driver. This driver will allow the Java program to connect to the database. You can download it from this URL, and I’ll do that now. I’ll just take this URL, drop it into my favorite browser and here I am at the page. I’m on this page, this is for downloading the Connector/J browser. I’ll select the platform, platform independent. Now move down and I’ll select download and it will download a zip archive. Make sure you download the most recent version. In this case it’s 5.1.29. Make sure you download something at that version or later. Time - 01:04 Download, scroll down, select, “No thanks, just start my download.” This will start downloading the file for you. Now what we can do is show it in the finder. I’ll double click it to extract it. At this point I have the driver extracted. There’s a file in here called MySQL connector.jar that we’ll use later. Time - 01:34 Next, what I need to do is create a Java project in Eclipse. Let’s do that. On Eclipse I’ll say I’ll save file, new, Java project. This will be JDBC demo and I will select finish. What I’ll do is I will add a new class. New, class, this will be my driver and it will have a public static void main region. At this point we have a shell for our project created. Time - 02:28 Next, what we’ll do is we will talk to the actual development process and I really like this slide because it outlines exactly what we need to do. The first thing we’ll do is add the database driver to the classpath. Next, we’ll get a connection, we’ll submit a SQL query and then we’ll process the result set. Time - 02:48 Let’s start with step one, adding a MySQL database driver to the classpath. In our Eclipse project I’m going to add a new folder called lib, lib for library. In this lib folder I’m going to add the driver that I downloaded earlier. What I’ll do is I’ll just grab this driver. It’s the MySQL connector bin.jar and I’ll just drag and drop it to this lib folder. It will prompt me and I’ll say go ahead and copy the file. Time - 03:25 Next, I need to add the jar file, the driver to the classpath. I’ve set this up with properties, choose Java build path and then I’ll choose add jars. Expand this folder, that lib, I’ll grab that jar file and I’ll have it setup. Great. Time - 03:51 Now we can start coding. We need to get a connection, submit a SQL query and process a result set. Let me just sketch this out on a slide over here. The first thing I’ll do up top is I’ll just do an import on java.sql.* because all of the classes and interfaces that we need are in this package. Time - 04:17 I’ll also just setup a try catch block just to handle for any exception that may occur. Small typo there. Time - 04:40 Inside of this section I’m going to first get a connection to database. Then next I will create a statement. Then from here I will execute a SQL query and then I will process the result set. Time - 05:16 That’s my basic game plan, let’s fill it in with some real code. Here I’ll say connection, myConn = DriverManager.getConnection. I’ll give the jdbc:mysql://localhost:3306/demo student, student. Student is the user ID and student is also the password. [snip] Click the Transcripts tab for full transcript.
Views: 642033 luv2code
Database Video 3 - How to connect to Oracle 12c in windows 8.1 PC
 
05:49
This part three of the series, How to install Oracle 12c in Windows 8.1 PC. In this video we will explore how to connect to the Oracle 12c database that was installed using the method described in the second video
Views: 34600 Sam Dhanasekaran
How to Manage Multiple Databases
 
02:09
How to automatically create accurate scripts for different platforms like DB2, SQLServer, Sybase and Oracle with one tool. Learn how to simplify multi-platform database management with the award-winning DBArtisan from Embarcadero Technologies. Administer all the latest versions of Oracle, SQL Server, DB2 and Sybase.
Swift: Using External Databases and API's Part 1: Setting Up The Server
 
09:59
@SkipAllMighty Best viewed in 4k! Leave comments on any errata If you want to get right to coding go right to Part 2. PHP Blog API is here: https://github.com/skipallmighty/Blogtaculous
Views: 81941 Skip Wilson
Export Oracle query results to SQL Server
 
00:27
Export Oracle query results to SQL Server, by OracleToMsSql, http://www.withdata.com/oracletomssql/ . Download link: http://www.withdata.com/down/OracleToMsSql.exe .
Views: 165 Shiji Pan
Oracle External Tables using oracle_loader
 
05:50
Using External Tables oracle_loader type to import text base files.
Views: 4788 thehighway360
Connect Android with SQL Server, MySQL, Oracle, PostgreSQL, and Other RDBMS Servers
 
05:30
This video demonstrates how to synchronize Android devices through a relational database server with ITTIA DB Sync.
Views: 64335 ITTIA
How to create an SSH Connection using dbForge Studio for MySQL
 
01:52
Learn how to access the remote MySQL server over #SSH tunnel using dbForge Studio for MySQL: https://docs.devart.com/studio-for-mysql/connecting-to-db/creating-ssh-connection.html More about compatibility options of dbForge Studio for MySQL: https://www.devart.com/dbforge/mysql/studio/database-connections.html #MySQL #MySQLConnection #dbForge
Views: 2814 Devart
How to Create Custom Database Roles in Oracle Clinical and Remote Data Capture (RDC)
 
25:06
Learn how to create new custom database roles in Oracle Clinical and Remote Data Capture (RDC). -- One of the fundamental requirements of 21 CFR Part 11 is controlling user access in clinical trial applications. You do not want to unintentionally give someone access to something he or she should not have. To avoid these situations, Oracle Clinical and Remote Data Capture (RDC) comes with a set of predefined database roles that system administrators can set to enable users to perform specific tasks, yet prevent them from taking actions they are not authorized to take. While the predefined roles serve as a good starting point, it is critical for organizations to decide which roles make sense for the way they do business. In such cases, it may be beneficial to create new custom roles. While this process is not overly complex, it is easy to overlook several aspects that can make all the difference. Perficient’s Tammy Dutkin, director of Clinical Data Management and EDC, demonstrates how organizations can take ownership of their own database roles to ensure they remain compliant. To view this webinar in its entirety, please visit: http://www.perficient.com/Thought-Leadership/On-Demand-Webinars/2014/Taking-Ownership-of-Custom-Database-Roles-in-Oracle-Clinical-and-RDC Stay on top of Life Sciences technologies by following us here: Twitter: http://www.twitter.com/Perficient_LS Facebook: http://www.facebook.com/Perficient LinkedIn: http://www.linkedin.com/company/165444 Google+: https://plus.google.com/+Perficient SlideShare: http://www.slideshare.net/PerficientInc
Views: 541 Perficient, Inc.
Best way to connect Oracle with Visual Studio .NET (no BadImageFormatException or mismatch error)
 
09:45
BadImageFormatException Connect oracle database with visual studio .NET project with latest technology. If you are having BadImageException error or Architecture Mismatch error, this will be helpful more!
Views: 67375 Samiul Al Hossaini
Oracle Data Miner/SQL Developer + R Integration via SQL Query node
 
15:46
This presentation and demo shows the integration capabilities of Oracle Data Miner/SQL Developer + Oracle R Enterprise integration.
Views: 9362 Charlie Berger
How to connect to Oracle Database using PHP
 
09:48
How to connect to Oracle Database using PHP. Connect to Oracle 12c database with PHP 5.5. oci8 client download link: http://windows.php.net/downloads/pecl/releases/oci8/2.0.8/ Visual C++ Redistributable for Visual Studio 2012 Update 4 :for Windows 64 bit user : http://www.microsoft.com/en-gb/download/details.aspx?id=30679 Source Code Lik : https://drive.google.com/file/d/0BznrW3lgX0ozQWNtRnhhQUpGaVk/view?usp=sharing
Views: 31705 Subhroneel Ganguly
Database,SQL And Oracle Day4
 
02:56:05
Create user and grant and revoke ,oracle functions
Views: 210 Cloud9 Creations
How to connect to Oracle Cloud Database using SQL Developer?
 
03:15
As cloud is already our neighbor I was interested to find more about what Oracle provide as a trial for people interested about this topic. I was happy to find https://cloud.oracle.com/tryit site where you can register and in few days you have access to an Oracle Database in the Cloud. As per above site quote "Oracle Database Cloud Service provides the power and flexibility of the Oracle Database in the cloud with your choice of a dedicated database instance with direct network connections and full administrative control, or a dedicated schema with a full development and deployment platform managed by Oracle." Another trigger that make me investigate more about Oracle Database in cloud was Sql Developer version 4.0.2.15 that has Cloud Connections options. In this video I'll show how easy is to access and browse Oracle Database in cloud using SQL Developer 4.0.2.15
Views: 6130 Oracle EBS Hands-On
Mysql Installation on Linux
 
15:18
▶ For Best USB MicroPhone I use Yeti, check it out https://amzn.to/2GTjz6K ▶ Check out my list of recommended books on Hadoop/Spark/Storm/DataScience/Kafka/Cassandra/Mongodb -- http://bit.ly/2FaP1MF ***** ▶ Check out my selection of books on Python/DeepLearning/MachineLearning/TensorFlow http://bit.ly/2LvtxhX ***** ▶ Check out my list of DSLR and other recommended Gear http://bit.ly/2qXbgkp mysql installation on linux , mysql installation The MySQL™ software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. MySQL is a trademark of Oracle Corporation and/or its affiliates, and shall not be used by Customer without Oracle's express written authorization. Other names may be trademarks of their respective owners. The MySQL software is Dual Licensed. Users can choose to use the MySQL software as an Open Source product under the terms of the GNU General Public License (http://www.fsf.org/licenses/) or can purchase a standard commercial license from Oracle. See http://www.mysql.com/company/legal/licensing/ for more information on our licensing policies. The following list describes some sections of particular interest in this manual: For a discussion of MySQL Database Server capabilities, see Section 1.3.2, “The Main Features of MySQL”. For an overview of new MySQL features, see Section 1.4, “What Is New in MySQL 5.7”. For information about the changes in each version, see the Release Notes. For installation instructions, see Chapter 2, Installing and Upgrading MySQL. For information about upgrading MySQL, see Section 2.10.1, “Upgrading MySQL”. For a tutorial introduction to the MySQL Database Server, see Chapter 3, Tutorial. For information about configuring and administering MySQL Server, see Chapter 5, MySQL Server Administration. For information about security in MySQL, see Chapter 6, Security. For information about setting up replication servers, see Chapter 17, Replication. For information about MySQL Enterprise, the commercial MySQL release with advanced features and management tools, see Chapter 24, MySQL Enterprise Edition. For answers to a number of questions that are often asked concerning the MySQL Database Server and its capabilities, see Appendix A, MySQL 5.7 Frequently Asked Questions. http://mysql.com
Views: 12307 BigData 101
ORACLE in Telugu What is Database Part 1(www.timecomputers.in)
 
02:19
ORACLE in Telugu -~-~~-~~~-~~-~- Please watch: "Best Useful software For Windows Telugu" https://www.youtube.com/watch?v=puGZTRTSoVA hafiztime hafiz telugu videos #telugutechtuts #hafiztime
Views: 75898 Telugu TechTuts
Oracle Database In-Memory Demo By Juan Loaiza
 
19:13
Oracle Database In-Memory is one of the key new features in Oracle Database 12c. This 20 minute video demonstration walks you through everything you need to know about Oracle Database In-Memory and how it can improve the performance of analytical queries.
Views: 1084 Maria Colgan
Install and configure sql developer on Linux | Oracle Tutorial
 
05:28
How to Install SQL Developer on Linux 1) Download for the below link http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html 2) Make sure you have Java Development Kit installed with latest version. http://www.oracle.com/technetwork/java/javase/downloads/index.html 3) Install SQL developer as rpm -ihv sqldeveloper-xxx.noarch.rpm (replace xxx with exact version of your SQL developer) Run SQL developer on linux command prompt as $ sqldeveloper 4) Create a new connection to connect to user Technology Lair : www.technologylair.org Subscribe : http://www.youtube.com/subscription_center?add_user=technologylair For More Videos : http://www.youtube.com/user/technologylair/videos For Video Tutorials :http://www.youtube.com/playlist?list=PLC71CFFF7A916DCAA For Android : http://www.youtube.com/playlist?list=PLUXK1VpPWQKHI1l-NvM5jvNKKnmNy9eHp For Linux : https://www.youtube.com/playlist?list=PLUXK1VpPWQKHV2xOmjQgUNj3Hrmcslj-H Kalam e Iqbal : http://www.youtube.com/playlist?list=PLF057785BD260F061 Like us on Facebook : https://www.facebook.com/technologylair Tweet us : http://twitter.com/technologylair Follow us : https://plus.google.com/u/0/118196883367288585963/posts Pin us : http://www.pinterest.com/technologylair/
Views: 24030 TechLair
How to connect to Oracle 11g database from Crystal Report 11 release 2.
 
06:13
How to connect to Oracle 11g release 2 from Crystal Report 11 release 2. This tutorial demonstrate crystal reports 11 oracle connection using OLEDB (ADO) driver.
Views: 12301 Subhroneel Ganguly
Ch01 Oracle Database Server Overview
 
12:09
Sub:-Oracle Basic Architecture Explanation. Uploaded by:-Nischal Sepahiya, Senior Oracle DBA.
Views: 17 Nischal Sepahiya
How to find your sql server name (instance) for Management Studio
 
03:40
This tutorial shows you how to find your server name or instance for connecting to SQL Management Studio (SSMS). Step by step tutorial on how to check if SQL is installed on your machine using the services to check that Microsoft SQL Server has been started. Next how to find your instance name using SQL Server Configuration Manager using SQL 2012 or 2014 folder. I show you how to connect to the instance name in the Connect to Server SQL Sever 2014 box. The Server Name is made up of the following: ServerName/Instance Name 1: To find the Server name type the following into command prompt: SQLCMD -L 2: To find the instance name go to Microsoft configuration manager there you will see your version of sql server in my case sql server express as such I know my instance name is sql server express 3. Put the server name and instance name together as per the video SOPHIA-HP/SQLEXPRESS To request a video: http://itsophy.com/request-video/ More SQL Server videos: http://www.youtube.com/playlist?list=PLrTXCzXE7TKKhIhGtl65lYMAHP6xN5Wa4 My Blog: http://itsophy.com/
Views: 121715 ITSophy
Oracle SQL Tutorial 1:How to connect to oracle database through command prompt
 
00:25
Oracle SQL Tutorial 1:How to connect to oracle database through command prompt
Views: 72274 Math Cube
Install and configure Sql Developer on Windows | Oracle Tutorial
 
05:12
How to Install SQL Developer on Windows 1) Download for the below link http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html 2) Make sure you have Java Development Kit installed with latest version. http://www.oracle.com/technetwork/java/javase/downloads/index.html 3) Install SQL developer as rpm -ihv sqldeveloper-xxx.noarch.rpm (replace xxx with exact version of your SQL developer) Run SQL developer on linux command prompt as $ sqldeveloper 4) Create a new connection to connect to user Technology Lair : www.technologylair.org Subscribe : http://www.youtube.com/subscription_center?add_user=technologylair For More Videos : http://www.youtube.com/user/technologylair/videos For Video Tutorials :http://www.youtube.com/playlist?list=PLC71CFFF7A916DCAA For Android : http://www.youtube.com/playlist?list=PLUXK1VpPWQKHI1l-NvM5jvNKKnmNy9eHp For Linux : https://www.youtube.com/playlist?list=PLUXK1VpPWQKHV2xOmjQgUNj3Hrmcslj-H Kalam e Iqbal : http://www.youtube.com/playlist?list=PLF057785BD260F061 Like us on Facebook : https://www.facebook.com/technologylair Tweet us : http://twitter.com/technologylair Follow us : https://plus.google.com/u/0/118196883367288585963/posts Pin us : http://www.pinterest.com/technologylair/
Views: 336254 TechLair
How to Connect Toad For Oracle To Oracle Database
 
03:41
This video shows how to connect Toad for oracle to an oracle database via direct connection.
Views: 23766 SQL TUTORIALS
Omnichannel Services - Access a Database
 
05:28
Today I'm going to show you how to setup and access a simple database. When building omnichannel services, this could be a way to access a back-end database or to store data that is not available in the back-end systems. If the data in the back-end system change very seldom and need to be aggregated, a database for the omnichannel services can offer an efficient cache. In this example, I will use a MySQL database that was installed when you set up your cloud server as I showed in one of my previous videos, http://youtu.be/o-QJAFQ17j0, and a similar approach can be used to access any of the other major databases like PostgreSQL, Oracle, SQL Server, or DB2. To make the database accessible from PHP, we open a terminal (or PuTTY on Windows), login to the virtual server, and enter the following commands: sudo apt-get install mysql-client sudo apt-get install php5-mysql sudo apt-get install php5-mysqlnd sudo service apache2 restart To make the database accessible remotely, you need to edit the MySQL configuration file with... sudo nano /etc/mysql/my.cnf ...and comment (put a # at the beginning of the line with) the bind-address (exit and save with Ctrl+X, Y and Enter). Then login to MySQL... mysql -u root -p ...enter the password for the root account (that you chose during the installation of MySQL) and grant remote access... grant all on *.* to root identified by 'password'; ...where you replace password with a suitable password (exit with the "quit" command), and restart MySQL: sudo service mysql restart You also need to open the default MySQL port in the virtual server's firewall (on Amazon it's called security group), which you can see how to do on http://docs.aws.amazon.com/gettingstarted/latest/computebasics-linux/getting-started-security-group.html. Let's start by creating a simple table, and you can do that using Coda (https://panic.com/coda), but here I'm going to show you how it's done using the terminal and by entering the following commands: mysql -u root --p use test; create table person (id int, name varchar(30)); insert person (id,name) values(1,'Chris'); insert person (id,name) values(2,'Eliza'); select * from person; quit; With the table in place, let's create a service that access it and return its contents. First we connect to the database (line 2) and select the database (line 3). Then we query the database (line 4), and for each found row (line 6), the columns are inserted into an entity (line 8-10) that is added to an array (line 11). Then a root object (line 14) and headers (line 15-16) are added to the response before it's converted to JSON and returned to the app (line 17). To put this code on your server (using https://panic.com/coda), I just create a new file, and then it can be called with (replace 0.0.0.0 with the IP address of your server): http://0.0.0.0/getFromDatabase There you have an omnichannel service that query a database and transform the data to JSON that can be easily consumed by your apps or webs. Download the source code: http://cforsberg.com/wp-content/uploads/OmnichanServDatabase.zip Follow me on Twitter https://twitter.com/chrisforsberg Visit my site http://cforsberg.com
Views: 156 Chris Forsberg
Oracle using SQL Developer Data Pump for export and import
 
04:50
Using Oracle SQL Developer to export and import data via the data pump facilities.
Views: 66624 thehighway360
Part 4 - Using MySQL Workbench To Access Your Data Export
 
06:12
This is a brief tutorial on using MySQL Workbench to access your Oracle RightNow database that has been imported into MySQL Community server.
How to copy one table records into another new table in oracle
 
02:19
we can copy a table data into a new table easily..with this query I'm going to create one new table student_new with the student table data. Query used in video: create table student_new as select * from student; Thanks for watching...:)
Views: 5863 WingsOfTechnology
How to Setup Amazon Web Services EC2 Instance with Apache, PHP, MySQL
 
25:47
How to Setup Amazon Web Services EC2 Instance with Apache, PHP, MySQL Instructions: Go to http://aws.amazon.com/ and create a new account if you do not have an account already. A credit card or debit is required. Sign into your AWS account under console management. Select EC2 and create a new instance. Choose one of the Ubuntu AMIs, and leave everything default. Under Security groups, create a new security group with SSH and HTTP. Name your key and download. Under the terminal, maneuver to the key and chmod 400 to make sure that the permissions are correct. Under windows, you may have to run as administrator the command prompt or cygwin to chmod properly. Or you can use the command that I did, which was: chown :Users testTutorial.pem Then I did: chmod 400 testTutorial.pem Allows only me to read Then: ssh -i testTutorial.pem [email protected](public IP) Once you are on the Ubuntu AMI, you can start to mess around with the packages to install. I recommend the following: Run the command: sudo apt-get install apache2 libapache2-mod-php5 php5 mysql-server php5-mysql You can also get phpadmin if you would like. Remember to restart the apache service: service apache2 restart Then, run a secure installation of mysql: mysql_secure_installation Go put in your browser the public IP. It works! But what if you want to change the index.html Well, go cd ../../var/www In this directory www, you can edit the index.html sudo vim index.html You can change the index.html to anything you want using the editor of your choice. The site changes. Twitter: https://twitter.com/microwavesam Blog: http://slothparadise.com Consider supporting our group in making stuff: ►https://www.patreon.com/slothparadise ►Twitter: https://twitter.com/slothparadise
Views: 378460 MicrowaveSam
Migrate data from SQLite table to Oracle
 
00:18
Migrate data from SQLite table to Oracle, by SqliteToOracle, http://www.withdata.com/sqlitetooracle/ . Download link: http://www.withdata.com/down/SqliteToOracle.exe .
Views: 185 Shiji Pan
Omnichannel Services - Access a Database
 
05:54
Christian Forsberg is the Global Digital Channels Lead Architect at Sogeti building digital solutions for organizations around the world. This time he shows you how to setup and access a simple database from an omnichannel service. "-When building omnichannel services, this could be a way to access a back-end database or to store data that is not available in the back-end systems. If the data in the back-end system change very seldom and need to be aggregated, a database for the omnichannel services can offer an efficient cache. In this example, I will use a MySQL database that was installed when you set up your cloud server as I showed in one of my previous videos, http://youtu.be/o-QJAFQ17j0, and a similar approach can be used to access any of the other major databases like PostgreSQL, Oracle, SQL Server, or DB2. To make the database accessible from PHP, we open a terminal (or PuTTY on Windows), login to the virtual server, and enter the following commands: sudo apt-get install mysql-client sudo apt-get install php5-mysql sudo apt-get install php5-mysqlnd sudo service apache2 restart To make the database accessible remotely, you need to edit the MySQL configuration file with... sudo nano /etc/mysql/my.cnf ...and comment (put a # at the beginning of the line with) the bind-address (exit and save with Ctrl+X, Y and Enter). Then login to MySQL... mysql -u root -p ...enter the password for the root account (that you chose during the installation of MySQL) and grant remote access... grant all on *.* to root identified by 'password'; ...where you replace password with a suitable password (exit with the "quit" command), and restart MySQL: sudo service mysql restart You also need to open the default MySQL port in the virtual server's firewall (on Amazon it's called security group), which you can see how to do on http://docs.aws.amazon.com/gettingstarted/latest/computebasics-linux/getting-started-security-group.html. Let's start by creating a simple table, and you can do that using Coda (https://panic.com/coda), but here I'm going to show you how it's done using the terminal and by entering the following commands: mysql -u root --p use test; create table person (id int, name varchar(30)); insert person (id,name) values(1,'Chris'); insert person (id,name) values(2,'Eliza'); select * from person; quit; With the table in place, let's create a service that access it and return its contents. First we connect to the database (line 2) and select the database (line 3). Then we query the database (line 4), and for each found row (line 6), the columns are inserted into an entity (line 8-10) that is added to an array (line 11). Then a root object (line 14) and headers (line 15-16) are added to the response before it's converted to JSON and returned to the app (line 17). To put this code on your server (using https://panic.com/coda), I just create a new file, and then it can be called with (replace 0.0.0.0 with the IP address of your server): http://0.0.0.0/getFromDatabase There you have an omnichannel service that query a database and transform the data to JSON that can be easily consumed by your apps or webs." Download the source code: http://cforsberg.com/wp-content/uploads/OmnichanServDatabase.zip Follow Christian on Twitter https://twitter.com/chrisforsberg Visit Christian's site http://cforsberg.com
Views: 176 Sogeti Worldwide