Home
Search results “Create database in oracle sql”
Create new connection with new user in Oracle SQL Developer
 
10:28
This video shows you how to create a new connection using a new user account (other than the system user account) in Oracle SQL Developer, so that you have a clean workspace without all the clutter of system tables. It is NOT a general introduction to using Oracle SQL Developer.
Views: 382920 Chitu Okoli
Oracle SQL Tutorial 11 - CREATE TABLE
 
05:04
The way you create a table is to use the CREATE TABLE command. CREATE TABLE users() So in this situation, the name comes right after the TABLE keyword. The next thing we do is put all of the columns on a line that we want to put in our table. CREATE TABLE users( user_id, username, first_name, last_name ) Notice the naming conventions here. For this series we are going to make columns with what is known as snake casing. This is where each individual word is separated by an underscore. if you have more than one column, all of them have to have commas except the last one. The comma is a way to say that another column is coming, so you don't need to do it on the last one. Now you would think we were done, but we also have to say what data type each column is. Later we will extensively discuss data types so we can focus on them exclusively. For now, here are the data types we are going to use: CREATE TABLE users( user_id NUMBER, username VARCHAR2(50), first_name VARCHAR2(50), last_name VARCHAR2(50) ) Now, inside of the parenthesis for varchar2, we pass in a number... This is the max length of the string. But the question is, what is it measured in? The default is actually in bytes, not characters. For example if we have the string hello, it is 5 characters, but it might take up a total of 10 bytes of storage. So I would recommend adding the keyword char right after the number so it defaults to 50 characters, not bytes. CREATE TABLE users( user_id NUMBER, username VARCHAR(50 CHAR), first_name VARCHAR2(50 CHAR), last_name VARCHAR2(50 CHAR) ) This will work to create a table, but it's really missing a lot of information… which column is the primary key? Are we adding any indexes? Is there any thing else we need to say about these columns? So as you can tell, we are making progress, but there is still so much to learn. The biggest gotcha to remember from this video is that the data type VARCHAR ends in a 2, stupid, right? who would end the name of something with a 2? Once again, this is Caleb from CalebTheVideoMaker2, and we will catch you in the next one! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 42008 Caleb Curry
How to download and create Oracle database
 
09:56
here i show you how to download or create database,.,.,. here i provide the link http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html ,.,.,.
Views: 44130 Yash Saxena
SQL tutorial 36: how to create database using database configuration assistant DBCA
 
12:11
Step by step process of creating oracle database using DBCA database configuration assistant, how to unlock user account of sample schema WATCH FULL VIDEO TO KNOW HOW TO UNLOCK HR SCHEMA Tutorial Consist: How to create general purpose transaction database using DBCA database configuration assistant in Oracle 11g, Links How to create database detail blog: http://bit.ly/how-to-create-database-using-dbca What is archiving and archivelog mode: http://bit.ly/what-is-archiving-in-oracle-database Video Tutorial 1 How to install oracle 11g database http://youtu.be/0NLsJQCvKXY Video tutorial http://youtu.be/-13SbeDavwk Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 Amazon Wishlist: http://bit.ly/wishlist-amazon Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 66764 Manish Sharma
SQL basics and creating a simple database - SQL tutorial for beginners
 
37:35
SQL tutorial for beginners for learnig SQL in a simple and practical way. This step-by-step SQL tutorial aims to teach beginners how to start working with SQL. This SQL tutorial will cover: 00:45 How to create a database 11:44 Creating the first table 19:19 Writing simple query 22:41 Normalization of the database This SQL tutorial for beginners is the 2nd video of the SQL for beginners course at Duckademy. The goal of this course is to teach you how to use the SQL programming language to easily manage databases. To achieve this goal you will learn SQL from the basics to advanced concepts. During the course and this SQL tutorial we will use MS SQL Server. Since the course material covers Transact-SQL, which is a standardized language, all that you learn here you can also use with MySQL, PostgreSQL and Oracle. This SQL tutorial is followed by an other SQL tutorial about basic SQL queries: https://youtu.be/tK-HXzuUunI SUBSCRIBE NOW FOR NEW FREE IT TUTORIALS! https://www.youtube.com/c/DuckademyITcourses?sub_confirmation=1 SUBSCRIBE TO OUR EMAIL LIST! https://www.duckademy.com/#dialog-newsletter FOLLOW US! Facebook ► https://www.facebook.com/duckademy Twitter ► https://twitter.com/duckademy Google+ ► http://gplus.to/duckademy Linkedin ► https://www.linkedin.com/company/duckademy ---------------------------------------------------------------------------------
Views: 105047 Duckademy IT courses
Oracle Database11g tutorials 14 : How to CREATE TABLE using sql developer and command prompt
 
08:36
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is 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 E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A TABLE. if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS. We can also say that SQL tables are kind of data structure which are used by database for efficient storage of data. To create a table in our database we use SQL CREATE TABLE command. SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL. To Create a table in your schema you will require CREATE TABLE system privilege. In our future videos we will see what are system and object privileges and how to grant them to a user. Today for this video we will be using Sample schema HR which already has all the necessary privileges. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets open our SQL developer I am connected to HR schema if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways of applying them on a column in a table. for this video we will concentrate on create table only so when you are done with all your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Views: 191519 Manish Sharma
SQL Tutorial - Full course for beginners
 
04:20:39
In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS. The course is designed for beginners to SQL and database management systems, and will introduce common database management topics. Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more. 🔗Company Database Code: https://www.giraffeacademy.com/databases/sql/creating-company-database/ ⭐️ Contents ⭐ ⌨️ (0:00) Introduction ⌨️ (2:36) What is a Database? ⌨️ (23:10) Tables & Keys ⌨️ (43:31) SQL Basics ⌨️ (52:26) MySQL Windows Installation ⌨️ (1:01:59) MySQL Mac Installation ⌨️ (1:15:49) Creating Tables ⌨️ (1:31:05) Inserting Data ⌨️ (1:38:17) Constraints ⌨️ (1:48:11) Update & Delete ⌨️ (1:56:11) Basic Queries ⌨️ (2:08:37) Company Database Intro ⌨️ (2:14:05) Creating Company Database ⌨️ (2:30:27 ) More Basic Queries ⌨️ (2:26:24) Functions ⌨️ (2:45:13) Wildcards ⌨️ (2:53:53) Union ⌨️ (3:01:36) Joins ⌨️ (3:11:49) Nested Queries ⌨️ (3:21:52) On Delete ⌨️ (3:30:05) Triggers ⌨️ (3:42:12) ER Diagrams Intro ⌨️ (3:55:53) Designing an ER Diagram ⌨️ (4:08:34) Converting ER Diagrams to Schemas Course developed by Mike Dane. Check out his YouTube channel for more great programming courses: https://www.youtube.com/channel/UCvmINlrza7JHB1zkIOuXEbw 🐦Follow Mike on Twitter: https://twitter.com/GiraffeAcademy 🔗The Giraffe Academy website: http://www.giraffeacademy.com/ -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://medium.freecodecamp.org And subscribe for new videos on technology every day: https://youtube.com/subscription_center?add_user=freecodecamp
Views: 1688803 freeCodeCamp.org
SQL with Oracle 10g XE  #1 Creating Student Database!!!
 
07:41
hello guys I will show you how to create student database in oracle database software thank you so much for watching don't forget to like share comment and subscribe code part: create table studentdb(regno number(10) primary key, name varchar(20), dob date, marks number(10)); desc studentdb; alter table studentdb drop column marks; desc studentdb; alter table studentdb modify regno varchar2(20); desc studentdb; alter table studentdb add phoneno number(10); desc studentdb; insert into studentdb values (001,'kiran','06-aug-1991',8899007766); insert into studentdb values (002,'anbu','07-aug-1991',8899007755); insert into studentdb values (003,'prabhu','08-aug-1991',8899007744); insert into studentdb values (004,'nigam','09-aug-1991',8899007733); insert into studentdb values (005,'suraj','10-aug-1991',8899007722); select * from studentdb; please type commands carefully if you face any doubt don't feel shy to ask me thank you so much guys
Views: 11788 way2study
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: 290175 Manish Sharma
SQL tutorial 48: How to create Roles in Oracle Database
 
07:16
4th SQL Tutorial in the series of user privileges in oracle database user Roles in Oracle Database. In this tutorial you will learn ● What user roles ● How to create simple roles (Role with Not Identified clause) ● How to create secure roles (Role with Identified clause) ● How to create external role. ● How To create global role. ● How to Grant System Privilege to a user Role ● How to Grant Object Privilege to a user Role In oracle database. ● How to grant a Role to another Role ● How To grant a role to database users (with Admin option) ● How To enable role using SET ROLE statement This video will teach you the concept of user role in oracle database which is an extension to the user privileges. In this video I did 10 SQL queries on user Roles which makes this tutorial fun. Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/create_role_in_oracle System Privilege: http://youtu.be/EQzdtKPiErU Object Privilege: http://youtu.be/DuDL7NTPdqQ ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 25681 Manish Sharma
Using SQL Developer to create Database Objects
 
06:22
#Oracle Using #SQLDeveloper to create basic database objects and view information about them
Views: 703 Hemant K Chitale
8. CREATE, INSERT and SELECT commands
 
15:42
In this video you will learn how to execute CREATE, INSERT and UPDATE commands. I will show you by executing these command and you will understand it easily. We will also cover its theory part before demo. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 143427 ITORIAN
SQL Consulting | Connect SQL Developer to Oracle Database
 
05:34
Connect SQL Developer to Oracle Database Tutorial http://www.ReportingGuru.com Email us at [email protected] if you need help, custom reports, or reporting architecture setup. Our phone number is 1-(800) 921-4759. Reporting Guru is a US based development company with all resources located in the US. We have many senior level developers with over a decade of development experience. Please let us know if you would like to discuss your requirements or issues free of charge. Our process is taking your requirements and suggesting the best architecture or approach without trying to sell you any specific software. We work as needed and only charge for the hours we work. We do not charge a retainer and there is no minimum charge. We offer the following services: Custom Report Writing | Consulting | Database Development & Integration. Some of our specialties are: --SQL Server Reporting Services SSRS / SQL Server / SQL Server Integration --Services SSIS / SQL Server Analysis Services SSAS --Custom Application Development / Maintenance --Oracle --MySQL --Crystal Reports / Business Objects --BIRT --.NET Development --PHP Development --SharePoint --Microsoft Dynamics --Access --Excel and Pivot Tables --More! CUSTOM REPORT WRITING Our experienced data report writers take your report & business requirements to build the custom reports you need. We deliver reports on demand or on a timed schedule. CONSULTING When your data and reporting team needs guidance or whether you need to build new reports, convert reports, enhance existing reports or need advice on finding the right reporting solution for your business ReportingGuru is here to help. DATABASE DEVELOPMENT & INTEGRATION We create and develop the necessary structure to house business data in a clear and easily accessible manner, so you have the tools to pull the reports you need easily. CUSTOM SOFTWARE & APPS We also offer custom applications for our clients like our Dashboard Guru and Quickbooks Enterprise Connector http://www.reportingguru.com/products/. Reporting Guru's dashboarding software will give interactivity to static web based reports. Our Quickbooks Connector will pull data from Quickbooks into a database for custom reporting purposes. Connect SQL Developer to Oracle Database http://www.ReportingGuru.com Email us at [email protected] or call 1-(800) 921-4759.
Views: 103901 Reporting Guru
How connect Oracle SQL Developer to a local Oracle database
 
06:25
This video shows how to set up a local Oracle database and connect to it with SQL developer. LINKS: Oracle 11g database: http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html Oracle SQL Developer: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
Views: 9234 MineIsPolo
Oracle SQL Tutorial 6 - Relationships and Primary and Foreign Keys - Database Design Primer 3
 
29:40
HAPPY VALENTINES DAY!!! Let's talk relationships.. This is the 6th video in your Oracle Database series. We are discussing database relationships which are a key feature of relational database management systems. We first discussed entities and attributes. I talked about how each entity is assigned a table and each attribute is a column within a table. We moved on to the three kinds of relationships. The first was one-to-one. This describes an entity and an attribute. A piece of data that is exclusive to an entity is, by definition, an attribute of that entity. This is stored in one table with the attribute being a column within this table. The second relationship is one-to-many. This relationship is between two entities. The way we properly store this in a database is using a foreign key in the child table. Remember, the child table is the entity on the many side of the one-to-many relationship. Every row within the child table will have a value for the foreign key that references a primary key in the parent table. This assumes that the foreign key field is not optional (NOT NULL). If the foreign key is optional, than a reference is not required but any reference must be valid. The third kind of relationship is a many-to-many relationship. In this situation, we need 3 tables. The many-to-many relationship is broken up into two one-to-many relationships. The intermediary table will associate each entity from one table with the appropriate entities in the other table. There is debate as to whether this table needs a primary key. This is because you can intact use the combination of two foreign keys as a primary key. This works because we will never have two duplicate rows within the intermediary table and the two foreign keys work as a compound key because of this. We finally discussed primary keys and foreign keys. Primary keys are used to keep each row inside of a table unique. If this key is a computer generated number it is known as a surrogate key, otherwise it is known as a natural key. Natural keys have real world meaning. For example, a social security number may work, or an email address (in some situations), etc. Whichever type of key you choose is solely up to you and/or the company you may be working for. HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://Twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 50766 Caleb Curry
How to create database using Oracle SQL developer
 
16:26
This tutorial is on one of the simplest way to create database tables in Oracle SQL Developer with ease and simple SQL coding. Don't forget to: LIKE | COMMENT | SHARE | and SUBSCRIBE!!!
Views: 2991 CWTE Technologies
Oracle Database 11g XE (Express Edition) Install guide and connect with SQL Developer
 
18:16
Welcome to MyOnlineEdu.com's video tutorial. In this video you will learn how to install Oracle Database 11g XE (Express Edition) and then connect the database using Oracle SQL Developer IDE tool. You can avail an instructor based live class from MyOnlineEdu.com. To enroll click the lick: https://www.myonlineedu.com/course/view/6/oracle-sql-and-plsql-11g-fundamentals
Views: 383547 MyOnlineEdu.com
Configuring Linked Server in SQL Server to connect to Oracle database
 
11:17
This tutorial is about creating database linked server in Microsoft SQL Server 2014 to connect to Oracle Database XE. You require to install Oracle instant client and configure net service name to use as data source. Example of executing dml script is mentioned in this video.
Views: 19147 Subhroneel Ganguly
how to create database using sql developer in oracle 12c
 
01:23
The steps are shown in the following tutorial. https://fahmidasclassroom.com/how-to-use-sql-developer-and-connect-with-a-database/
Views: 874 Tutorials4urHelp
SQL tutorial 60: SQL View in Oracle Database By Manish Sharma RebellionRider
 
07:30
SQL View in Oracle Database. In this tutorial you will learn how to create a vie as well as how to replace a view along with the examples of all the DML e.g. DESCRIBE, SELECT, UPDATE, INSERT and Delete on view by Manish Sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-view-in-oracle-database Previous Tutorial ► Tut 5: SELECT statement http://youtu.be/f_mVBVgnqmM ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- 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: 45247 Manish Sharma
Sql Tutorial - How to create Views in oracle database
 
22:59
Hi friends in my today scenario i explaining how to create view in SQL and how view help to improve performance of SQL query. #SqlTutorial #createViewsinoracle Oracle database Unbeatable,Unbreakable Platform..
Views: 5605 Oracle World
How to Connect MS SQL Server Database with Oracle SQL Developer
 
05:38
how to connect sql server with sql developer how to connect sql server with sql develope How to Connect MS SQL Server Database with Oracle SQL Developer jtds - sql server and sybase jdbc driver cannot connect to microsoft sql server on localhost sql developer jtds-1.2.5.jar oracle sql developer oracle sql server download native sspi library not loaded sql developer jtds 3rd party jdbc driver oracle sql developer connect to microsoft sql server jtds-1.2.5.jar oracle sql developer jtds - sql server and sybase jdbc driver sql developer connect to sql server named instance jtds 3rd party jdbc driver sql developer cannot connect to microsoft sql server how to connect sql server with sql developer
Views: 16065 Oracle PL/SQL World
Oracle - PL/SQL - Database Triggers
 
24:48
Oracle - PL/SQL - Database Triggers https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
Oracle SQL Tutorial 3 - Downloading Oracle Database and Installing SQL Developer
 
10:18
This tutorial will take you through the process of downloading the oracle database, Oracle SQL Developer, and then teach you how to connect the Oracle SQL Developer to the database. We will be discussing how to access the advanced settings but will not be going in depth about all of the options. HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://Twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 111757 Caleb Curry
Oracle Database tutorial 67: How to create Tablespace using SQL Developer By RebellionRider
 
06:56
Learn (The easiest way)how to create tablespace in oracle database using Oracle SQL Developer GUI: SQL Developer trips and tricks tutorial ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/tablespace-using-sql-developer Previous Tutorial ► How to make SYS user Connection: http://bit.ly/how-to-create-new-connection-in-sql-developer ► Permanent tablespace https://youtu.be/vkwKZIssvfc ► Temporary Tablespace https://youtu.be/Hc_OXitKgWM ► Undo Tablespace https://youtu.be/HlSrHX7ffbI ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- 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 for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 34463 Manish Sharma
5. Create Database in SQL (Hindi)
 
05:09
Please Subscribe Channel Like, Share and Comment Visit : www.geekyshows.com
Views: 65161 Geeky Shows
PL/SQL tutorial : Trigger in Oracle Database 11g Complete guide
 
26:21
Learn in depth about trigger in oracle database 11g, and usage of trigger in Database, different types of trigger with syntax for various events along with writing advance trigger and capturing all details regarding authentication. Explained Instead of trigger. Trigger in Oracle, Trigger in PL/SQL, Oracle Trigger, PL/SQL Trigger, What is Trigger in pl/sql, How to use Trigger in pl/sql, How to write a Trigger in oracle, How to design Trigger in pl/sql, DDL trigger, DML trigger, Instead of trigger, Compound trigger, Logon trigger, Introduction to Triggers You can write triggers that fire whenever one of the following operations occurs: DML statements (INSERT, UPDATE, DELETE) on a particular table or view, issued by any user DDL statements (CREATE or ALTER primarily) issued either by a particular schema/user or by any schema/user in the database Database events, such as logon/logoff, errors, or startup/shutdown, also issued either by a particular schema/user or by any schema/user in the database Triggers are similar to stored procedures. A trigger stored in the database can include SQL and PL/SQL or Java statements to run as a unit and can invoke stored procedures. However, procedures and triggers differ in the way that they are invoked. A procedure is explicitly run by a user, application, or trigger. Triggers are implicitly fired by Oracle when a triggering event occurs, no matter which user is connected or which application is being used. How Triggers Are Used Triggers supplement the standard capabilities of Oracle to provide a highly customized database management system. For example, a trigger can restrict DML operations against a table to those issued during regular business hours. You can also use triggers to: Automatically generate derived column values Prevent invalid transactions Enforce complex security authorizations Enforce referential integrity across nodes in a distributed database Enforce complex business rules Provide transparent event logging Provide auditing Maintain synchronous table replicates Gather statistics on table access Modify table data when DML statements are issued against views Publish information about database events, user events, and SQL statements to subscribing applications Linkedin: https://www.linkedin.com/in/aditya-kumar-roy-b3673368/ Facebook: https://www.facebook.com/SpecializeAutomation/
Views: 13169 Specialize Automation
Oracle SQL Developer: Query Builder Demo
 
08:13
How to build queries with your mouse versus the keyboard. 2018 Update: If you'd like to see how to convert your Oracle style JOINS to ANSI style (in the FROM vs the WHERE clause) see this post https://www.thatjeffsmith.com/archive/2018/10/query-builder-on-inline-views-and-ansi-joins/
Views: 81849 Jeff Smith
Creating Database Manually using create database SQL command | BOUG | Step by Step creating Database
 
21:48
Creating Database Manually using create database SQL command Step by Step creating Database How to create database manually in oracle Creating a oracle database using command line How to create Oracle Database Manually Oracle 11g Administration Database Administration Bangladesh Oracle User Group ►►►FACEBOOK GROUP◄◄◄ ========================== https://www.facebook.com/groups/BangladeshOracleUserGroupBOUG/ ►►►FACEBOOK PAGE◄◄◄ ======================== https://www.facebook.com/BangladeshOracleUserGroup ►►►WEBSITE◄◄◄ ================== www.boug.org #Bangladesh_Oracle_User_Group #ORACLE_COMMUNITY #Database_Administration
Oracle SQL Tutorial 7 - Normalization - Database Design Primer 4
 
20:38
The database normal forms are used to normalize a database. What does it mean to normalize a database? It means to break it up into multiple tables to prevent redundant, conflicting, and bad data. The three normal forms are 1nf, 2nf, and 3nf. These stand for first normal form, second normal form, and third normal form. There are other normal forms, such as Boyce Codd normal form (BCNF), but the first 3 normal forms are the ones that are really important to know. The normal forms depend on one another. It is kind of like a ladder. In order to be in 2nd normal form, you must first be in first normal form. In order to be in 3rd normal form, you must first be in 2nd normal form. First normal form is all about individuality and giving data its space. Each column must be atomic...that is, in the smallest indivisible piece. Each value for the column must also only contain one value. To fix first normal form when you have a column violation, break the column into multiple columns. To fix first normal form when you have data violation, break the column into a new table and have a column that references the old table. Second normal form is all about partial dependencies. A partial dependency is when a column only depends on part of the primary key. This is often seen when you have an intermediary table in a many to many relationship (as a reminder, we break up many to many relationships into one to many relationships with intermediary tables in between). The solution to get rid of partial dependencies is to put the data in the table to where the column depends entirely on the key. If you do not already have a table that fits the rule, you can consider creating one. Third normal form is all about transitive dependencies. This is when a column in a table depends on another column instead of depending solely on the primary key. The solution to this is to take the column that is directly dependent on the primary key and bring it into its own table. Then, you can use foreign keys to connect the tables. This video concluded with a noble speech on how database design is very subjective. Thus is so because as we normalize more and more, the design becomes more and more complex. If we get to the point where we have hundreds of tables for a relatively small database, we can really hurt performance and increase risk of mistakes. Hopefully this video was helpful to everyone. See you in the next one! Support me: http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 30996 Caleb Curry
SQL with Oracle 10g XE #2 Creating Library Database!!!
 
09:35
hi guys in this video I will show you how to create library database.....using oracle thank yo so much for watching my video don't forget to subscribe if you have any doubt please leave a comment...
Views: 536 way2study
Oracle Database 12c Tutorial 3:Connect HR/SYS user with SQL Developer in Oracle12c Using TNS Service
 
05:24
Learn how to connect HR and Sys User of Oracle database 12c With SQL Developer using TNS service. Connect HR user which is in pluggable database to SQL Developer ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : Previous Tutorial ► Tut 61: How To Unlock HR schema in Oracle Database 12c http://youtu.be/F81gfUnznZY ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- 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: 58514 Manish Sharma
SQL tutorial 61: SEQUENCE in Oracle Database By Manish Sharma RebellionRider
 
08:05
This tutorial is all about Sequence In Oracle Database. In this SQL Tutorial you will learn How to create a sequence How to populate a Primary key column (auto increment in Oracle) using Sequence How to drop a sequence ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-sequence-in-oracle-database-rebellionrider-manish-sharma Previous Tutorial ► How To Insert Data into Table using SQL Developer http://youtu.be/YYQCSV6MzTk ► INSERT INTO Command http://youtu.be/uQXgqFtxI_k ► How to copy /Insert data into a table from another table http://youtu.be/m3Ep8tAMqok ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- 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 for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 46747 Manish Sharma
ORACLE DBA - How to create Oracle Database Manually using SQL Queries(without dbca)
 
07:28
This tutorial is all about to create an oracle 10g/11g database manually using sql queries without using DBCA Steps: 1. create few directories(see video) 2. Create Pfile and add parameters 3. create a sql file(which will create database) 4. startup database using pfile upto nomount state 5. run sql file created in step 3 6. create spfile from pfile 7. run catalog.sql and catproc.sql files. 8. create orapw file (password file)
Views: 2879 Ankit Saini
PL/SQL tutorial 19: How To Create Database Event  'LogOn' Trigger In Oracle By Manish Sharma
 
06:51
RebellionRider.com presents Oracle PL/SQL Tutorial 19: Logon Trigger a type of database event trigger also known as Systeme Event triggers in Oracle Database. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/log-on-trigger Previous Tutorial ► DDL Trigger https://youtu.be/XLBNKDUrHs0 ► Intro Of Triggers [Interview] https://youtu.be/R3fvX_xf5P4 ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 39200 Manish Sharma
What is SQL Profile in Oracle Database
 
03:14
n this video you will understand what is an SQL profile and how does it help in SQL plan generation and execution. The entire course on Interpreting an AWR report is available at udemy https://www.udemy.com/oracle-database-troubleshooting-and-tuning You can use Coupon Code YOUTUBETT for discount Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 3383 Ramkumar Swaminathan
SQL Developer 3.1 - How to Create a Report
 
02:11
This demonstration will show how to create a report. This video is part of the Report Features series. Search for SQL Developer Reports to view all the videos in the series. Copyright © 2012 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Connect to Remote Oracle database using Oracle Sql Developer on Windows.
 
19:40
Three methods of connection to oracle database using sql developer in Windows Operating System, is demonstrated in this online video. 1. Connect using general settings with database service name. 2. Connect by importing xml configuration file. 3. Connect using connection string with jdbc thin client. Oracle SQL Developer download link : http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
Views: 20741 Subhroneel Ganguly
PL/SQL tutorial 56: How to create VARRAY as Database Object in Oracle By Manish Sharma
 
07:45
RebellionRider presents PL/SQL tutorial on How to create VARRAY as Database Object in Oracle. Here you will also learn ● How to insert data into VARRAY and ● How to Retrieve data from VARRAY ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/varrays-3 Previous Tutorial ►Tut 54 Introduction to Varray: https://youtu.be/GsKCppCHUNs ►Tut 55 Varray inside PL/SQL Block: https://youtu.be/7bOU0m2FoYs ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 12237 Manish Sharma
SQL tutorial 43: How to create an EXTERNAL USER in oracle database By Manish Sharma RebellionRider
 
05:08
Learn another DBA trick. In this tutorial you will learn how to create an user actually an External user / schema. Being an Oracle DBA you must know how to create an external user/ schema Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Website: http://bit.ly/how-to-create-external_user-oracle Previous Tutorial: How to unlock user using SQL Developer http://youtu.be/xRBfeTO1Pc8 Tutorial 38: http://youtu.be/GS4udgR44Ls Links of how to create user tutorial Create user using SQL Developer http://youtu.be/GS4udgR44Ls Create user using Create user command http://youtu.be/4QbK2Y-1LZw Create user using EM http://youtu.be/zGjh-Bb3HrI ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] -------------------------------------------------------------------------- ►Connect with me on my LinkedIn and please endorse my skills Thanks in Advance http://in.linkedin.com/in/mannbhardwaj/ -------------------------------------------------------------------------- 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: 19867 Manish Sharma
SQL tutorial 62: Indexes In Oracle Database By Manish Sharma RebellionRider
 
04:03
Watch and learn concepts of SQL Index In Oracle Database. In this tutorial you will learn about B-Tree Index and Function based Index. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : Previous Tutorial ► ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- 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 for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 43734 Manish Sharma
PL/SQL tutorial 38: Introduction to PL/SQL functions in Oracle Database
 
05:10
PL/SQL tutorial for beginners Introduction to PL/SQL functions in Oracle Database by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/introduction-to-plsql-function Previous Tutorial ► Blocks in Oracle Database https://youtu.be/rbarR4_gaH8 ► ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL, MY VIEWERS AND SUBSCRIBERS
Views: 54787 Manish Sharma
SQL Developer 3.1 - Database Copy
 
04:55
This demonstration will show how to copy objects and data from one database to another. This video is part of the SQL Developer Release 3.1 New Features series. --------------------------------------------------------------------- Copyright © 2012 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
SQL SERVER PART-12: Oracle Linked Database Server
 
03:46
HOW TO CREATE LINKED SERVER AND HOW TO QUERY ORACLE DATABASE FROM SQL SERVER MANAGEMENT STUDIO. SQL server 2017 makes it easy to configure linked server. You can use open-query to get or manipulate data of linked server database. CONFIGURATION SUMMARY: PROVIDER : oracle provider for oledb. DATA SOURCE : It is usually a combination of oracle server IP: port number/t.n.s listener name. e.g. 192.168.1.10:5121/orcl OPEN QUERY : select * form openquery(linked_server_name, ' sql query statement ') Configure a linked server to enable the SQL Server Database Engine to execute commands against OLE DB data sources outside of the instance of SQL Server. Typically linked servers are configured to enable the Database Engine to execute a Transact-SQL statement that includes tables in another instance of SQL Server, or another database product such as Oracle. Many types OLE DB data sources can be configured as linked servers, including Microsoft Access and Excel. Linked servers offer the following advantages: • The ability to access data from outside of SQL Server. • The ability to issue distributed queries, updates, commands, and transactions on heterogeneous data sources across the enterprise. • The ability to address diverse data sources similarly. An oracle linked server require OLE DB provider. An OLE DB provider is a DLL that manages and interacts with a specific data source. If your oracle database is not in same server then you have to install The Oracle Data Access Components (ODAC) for Windows consists of Oracle client side drivers. An OLE DB data source identifies the specific database that can be accessed through OLE DB. Although data sources queried through linked server definitions are ordinarily databases, OLE DB providers exist for a variety of files and file formats. These include text files, spreadsheet data, and the results of full-text content searches. Typically, linked servers are used to handle distributed queries. When a client application executes a distributed query through a linked server, SQL Server parses the command and sends requests to OLE DB. The row set request may be in the form of executing a query against the provider or opening a base table from the provider.
Views: 2529 G Tech
PL/SQL tutorial 33: Table Based Record Datatype In Oracle Database by Manish Sharma
 
06:48
Learn how to create a table based record type variable in Oracle Database By Manish Sharma from RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/table-based-records Previous Tutorial ► Introduction To Records: https://youtu.be/1iHbZDuDbis ► SELECT-INTO Statement: https://youtu.be/Zt0vlmTqhP4 ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 36100 Manish Sharma
SQL Tutorial - How to grant System and Object Privileges in Oracle Database
 
18:08
In this session I Explaining the Theory of Granting and Revoking System and Object privileges.... #Oracletutorialforbeginners #rmanrecoverytutorial #SQLTutorial #SystemandObjectPrivilegesinOracle by Lalit saini
Views: 12999 Oracle World
How to connect with Pluggable Database using SQL Developer by Manish Sharma
 
12:07
RebellionRider.com presents Oracle Database 18c tutorial 4 on how to connect with Pluggable Database (PDB) through sample user like HR using SQL Developer. How to install SQL Developer https://youtu.be/zliF8kXVmeE Timestamp ● 00:59 Start Must Listen ● 01:42 How to create a basic connection ● 09:17 How to create a connection with TNS alias ● 10:53 How to connect with PDB using the above mentioned connections ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/pdb-with-SQLDev Previous Tutorial ► Oracle Database 18c Tutorial 2 https://youtu.be/maLrgeY0InA ► Oracle Database 18c Tutorial 3 https://youtu.be/z0dfSom97GU ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS #Oracle18cByRebellionRider #RebellionRider
Views: 3767 Manish Sharma
Oracle Tutorial || online training|| Adv Sql | Database Link Part - 1 by basha
 
33:27
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......