Home
Search results “Sql db version oracle”
How to download/install oracle database (software) 11g release 2 on Windows 10 Pro 64 bit
 
08:13
How to install oracle database 11g on Windows 10 Pro 64 bit, I'll explain the detail steps for downloading the oracle database 11g Release 2 then how to install it step by step. after that I will show you how to access oracle database(software) using SQL*Plus. thanks for watching. Subscribe for more: ---------------------------------- https://goo.gl/oL45FT SWE.Safaa Al-Hayali - saf3al2a TAGS: #How_to_install_oracle_database_11g_on_Windows_10_Pro_64_bit ----------------------------------------------------------------------------------------------------
Views: 167063 Safaa Al-Hayali
how to run sql query in oracle 11g | version 2 |
 
05:10
how to sql queries using oracle database
Views: 3985 Education 4u
How to connect to an Oracle Database? - Database Tutorial 37
 
12:37
Video 37 - How to connect to a Oracle Database? - Database Tutorial 37 This video explains how to connection to an oracle database. The database, which is Oracle 11g has been installed in a Windows 7 computer.
Views: 119517 Sam Dhanasekaran
ltrim & rtrim  | sql functions | oracle database 11g version 2 |
 
04:46
executed in oracle database 11g version 2
Views: 132 Education 4u
Oracle DB - SQL Commands
 
16:25
Oracle DB - SQL Commands Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
DML commands | SQL queries | Oracle database 11g version 2 |
 
14:54
how to write sql queries i.e DML commands in oracle
Views: 1182 Education 4u
Oracle SQL Tutorial 1 - Intro to Oracle Database
 
10:18
As illustrated in the video, Oracle Database is a program designed to hold lots of information, or data. There are all kinds of different databases and they all have their uses. Some of the most common ones are MySQL, SQL Server, Sybase, and MongoDB. All of these have different uses. The differences will be easier to understand after you learn more about each kind of database. We did not discuss it much in the video, but if you are wondering what “SQL” means in the title, it stands for structured query language. Structured query language is a human readable computer language that is used to tell databases to do things. We will discuss SQL and Oracle SQL Developer more in future videos. Databases are better than spreadsheets because they allow multiple users at one time, different levels of access given to users, recovery options and transactions, and it is more protected from hacking and malicious destruction. Programming languages often have very useful functions or methods that can be used to communicate to a database and therefore they are a naturally good option for the back end of programs. This course will go over all of the major parts of database programming using Oracle SQL. We will be using Oracle 11g, but these videos should still work with other versions, including the most recent 12c. Q and A ~~~~~~ How much does Oracle cost? The full enterprise edition costs thousands. They have other versions for less and they even have a FREE VERSION! This is known as the XE version (eXpress Edition). That is the one we will be using. How long does it take to learn SQL? You can learn all of the basics and be an efficient beginner database developer in only about a month of practice. To become an intermediate it can take anywhere from an additional 3 - 6 months with a only a few hours of studying and practicing each day. How can I learn SQL faster? Take notes and actually mess around with making your own database. Watch these videos until you understand the concepts within them, read articles and books that teach in more depth. Enjoy this content? You might enjoy my programming videos. Pick one and have some fun! 🙂 Learn Javascript - http://bit.ly/JavaScriptPlaylist Learn Java - http://bit.ly/JavaPlaylist Learn C# - http://bit.ly/CSharpTutorialsPlaylist Learn C++ - http://bit.ly/CPlusPlusPlaylist Learn C - http://bit.ly/CTutorialsPlaylist Donate!: http://bit.ly/DonateCTVM2. HELP ME! http://www.patreon.com/calebcurry. Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter ~~~~~~~~~~~~~~~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: 341015 Caleb Curry
length, concat & chr | sql functions | oracle database 11g version 2 |
 
05:24
executed in oracle database 11g version 2
Views: 120 Education 4u
How to install sql developer on Windows 10 Pro 64 bit
 
07:47
How to install sql developer on Windows 10 Pro 64 bit, and also in this video I will show you how to access oracle database (software) 11g r2 using sql developer thanks for watching. Subscribe for more: ---------------------------------- https://goo.gl/oL45FT SWE.Safaa Al-Hayali - saf3al2a TAGS: #How_to_install_sql_developer_on_Windows_10_Pro_64_bit ----------------------------------------------------------------------------------------------------
Views: 104548 Safaa Al-Hayali
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
mod, power  sqrt & trunc | sql functions | oracle database 11g version 2 |
 
07:19
executed in oracle database 11g version 2
Views: 171 Education 4u
Should I Learn Oracle or SQL Server?
 
02:17
Should I learn Oracle or SQL Server? While Oracle DBA certification pays well, the classes and getting a practice version of Oracle is expensive. I heard you could get versions of SQL Server for free. Part of it depends on the software developers you're working with. Use SQL Server if you're working with Microsoft's .Net, whereas Java developers are more likely to use Oracle. I didn't know that SQL Server was a Microsoft brand. So if you'll be working on MS servers and MS databases, you need to learn the SQL server. Which one is better for my career? There are typically more MS SQL jobs, but the Oracle jobs pay more. Oracle doesn't have as many jobs, but you have less competition. Those who didn't join the Microsoft cult pay a price for it. Which one is harder to learn? Oracle is rather complex, whereas MS SQL Server is simpler because it has a good graphical user interface. It's nice to hear that Microsoft made at least one good user interface. They usually put out crap, but once in a while, there's a good one. I've heard MySQL is more popular. Only because of the so called popularity of Microsoft. Oracle is the heavyweight database tool. Which relational database is better? MySQL works with almost any web-based application. Oracle is more stable, secure and scalable for enterprise wide applications. I'm glad to know that the big data that is running the world isn't all beholden to Bill Gates. No, but most PCs that generate the data still are. It sounds like I need to learn Oracle. Fortunately, you can learn Oracle inside and out and a little MS SQL and do almost any database admin job you'd like. You're guaranteed to get dates if you can proudly announce you have stable, well paying employment. It's like saying you're a musician, artist and athlete at once. Girls will just be happy if she doesn't have to pay for the date these days.
Views: 35887 Techy Help
ascii,instr | sql functions | oracle database 11g version 2 |
 
07:21
executed in oracle database 11g version 2
Views: 211 Education 4u
Oracle DB Vs MySQL for Enterprise DataBase Deployments
 
08:54
Oracle DB is big, and expensive, but it brings a lot to the "table" when compared with MySQL. MySQL has limited ability to audit. MySQL's security is unsophisticated. There are no groups or roles, no ability to deny a privilege (you can only grant privileges). A user who logs in with the same username and password from different network addresses may be treated as a completely separate user. There is no built-in encryption comparable to Oracle. MySQL's Authentication is built-in. There is no LDAP, Active Directory, or other external authentication capability. MySQL has no MPP (massively parallel processing ) support. Unlike Oracle MySQL has no fractional-second storage type for times, dates, or intervals. There is no RAC (Real Application Cluster) support in My SQL, and no failover or server promotion either. These are strong features in Oracle MySQL's number of joins per query is limited to 61. Oracle's limit is much larger. MySQL Replication is asynchronous and has many limitations and edge cases. For example, it is single-threaded, so a powerful slave can find it hard to replicate fast enough to keep up with a less powerful master.
Views: 20737 Biz of Tech
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
Managing Oracle SQL Code with SQLDeveloper and Git in Oracle Developer Cloud Service
 
10:27
Manage the lifecycle of your Oracle database code using Oracle Developer Cloud Service. Manage versions and branch with Git, Track to-do lists, and perform code reviews. With Oracle SQLDeveloper as the dev tool. Related blog - https://blogs.oracle.com/shay/entry/managing_oracle_database_code_with
Views: 9994 ShayJDev
How To Identify Your SQL Server Version And Edition
 
04:27
Don't forget to subscribe to our channel. https://www.youtube.com/tricksthatmakesmart https://www.facebook.com/tricksthatmakeyousmart https://www.facebook.com/groups/tricksthatmakeyousmart
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: 336819 TechLair
DDL commands | SQL queries | Oracle database 11g version 2 |
 
15:11
how to write sql queries i.e DDL commands in oracle
Views: 329 Education 4u
Using Git with Oracle SQL Developer
 
06:24
How to configure Oracle SQL Developer to use Git
Views: 4962 Blaine Carter
SQL: WITH Clause
 
06:11
In this tutorial, you'll learn will learn how to use with clause PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 13740 radhikaravikumar
How to Install Oracle Database 11g on Windows 10 By Manish Sharma
 
08:24
Detail tutorial on How to install Oracle database 11g enterprise edition on Windows 10 Professional 64 bit. Full installation under 9 mins. You can follow the steps for installing Oracle 11g on Windows 10 32 bit home or any other version. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Previous Tutorial ► Download Link http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html ►Create Database using DBCA https://youtu.be/enFFezPYhCg ►How To Unlock User using ALTER USER https://youtu.be/sMqq9MSVmQo ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/TheRebellionRider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 341500 Manish Sharma
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: 357049 MyOnlineEdu.com
sql operators | BETWEEN , LIKE, IN |oracle database 11g version 2| by bhanu priya
 
06:45
sql operators on oracle database 11g version 2
Views: 145 Education 4u
SQL tutorial 38: How to create user using SQL Developer in Oracle database
 
06:52
How to create new user accounts using SQL Developer in oracle database. In This tutorial you will learn how to create a new user account. How to setup a database connection with SyS user. How to grant privileges to the user ----_Links_--- Blog :http://bit.ly/create_user_account Video Tut 4: http://youtu.be/wSqoXRlXDUU How to create database: http://youtu.be/enFFezPYhCg 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: 64906 Manish Sharma
SQL Commands | order by, group by, having clause | oracle database 11g version 2 | by bhanu priya
 
09:07
order by, group by, having clause on oracle database 11g version 2
Views: 192 Education 4u
SQL: Sequence Generator
 
04:41
In this tutorial, you'll learn how to make use of sequence generator. PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 8190 radhikaravikumar
How to push database changes to a Git remote repository in SQL Server Management Studio
 
01:54
SQL Server MVP Steve Jones shows you how to push changes to a Git remote repository straight from SQL Server Management Studio using Redgate's SQL Source Control. SQL Source Control is an add-in for Management Studio that lets you version control your database with your existing version control system. You can try SQL Source Control free for 28 days: http://www.red-gate.com/sql-source-control
Views: 13180 Redgate Videos
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: 54044 Manish Sharma
How To Install MySQL on Windows 10
 
24:18
In this post we will learn how to How To Install MySQL on Windows 10. The same procedure can be used for installing MySQL on Windows 8 / Windows 7. But first let's see What is MySQL . MySQL is a very popular, open source database. Officially pronounced “my Ess Que Ell” (not my sequel). Handles very large databases; very fast performance. Why are we using MySQL? Free (much cheaper than Oracle!) Each student can install MySQL locally. Easy to use Shell for creating tables, querying tables, etc.Easy to use with Java JDBC. While installing MySQL, it will prompt you to create a root password . At this stage please select a safe and secure password . Make sure you remember the password, to use it later.MySQL tutorial for beginners and professionals with examples on CRUD, insert statement, select statement, update statement, delete statement, use database, keys, joins etc. -------------------Online Courses to learn---------------------------- Data Analytics with R Certification Training- http://bit.ly/2rSKHNP DevOps Certification Training - http://bit.ly/2T5P6bQ AWS Architect Certification Training - http://bit.ly/2PRHDeF Python Certification Training for Data Science - http://bit.ly/2BB3PV8 Java, J2EE & SOA Certification Training - http://bit.ly/2EKbwMK AI & Deep Learning with TensorFlow - http://bit.ly/2AeIHUR Big Data Hadoop Certification Training- http://bit.ly/2ReOl31 AWS Architect Certification Training - http://bit.ly/2EJhXjk Selenium Certification Training - http://bit.ly/2BFrfZs Tableau Training & Certification - http://bit.ly/2rODzSK Linux Administration Certification Training-http://bit.ly/2Gy9GQH ----------------------Follow--------------------------------------------- My Website - http://www.codebind.com My Blog - https://goo.gl/Nd2pFn My Facebook Page - https://goo.gl/eLp2cQ Google+ - https://goo.gl/lvC5FX Twitter - https://twitter.com/ProgrammingKnow Pinterest - https://goo.gl/kCInUp Text Case Converter - https://goo.gl/pVpcwL ------------------Facebook Links ---------------------------------------- http://fb.me/ProgrammingKnowledgeLearning/ http://fb.me/AndroidTutorialsForBeginners http://fb.me/Programmingknowledge http://fb.me/CppProgrammingLanguage http://fb.me/JavaTutorialsAndCode http://fb.me/SQLiteTutorial http://fb.me/UbuntuLinuxTutorials http://fb.me/EasyOnlineConverter
Views: 563698 ProgrammingKnowledge
Oracle 12c Database - How to install Oracle 12c Database in Windows 7
 
13:09
This video is a step-by-step guide for installing Oracle 12c Database in a Windows 7 desktop. Oracle Database 12c software can be downloaded from Oracle's website.
Views: 182460 Sam Dhanasekaran
How to Install Oracle Database 11g release 2 and SQL developer 3.2  on Windows 8 64 bit computer
 
09:57
Oracle database 11g is the latest version of Oracle database.It has lot of new features.Size of 11g is around 2GB , available as two zip folder.In order to install Oracle Database 11g and SQL developer , first download all required files. Download latest JDK Download Oracle Database 11g Enterprise and standard version Download SQL developer 32 bit with JDK 1.6
Views: 75863 7chip
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: 10217 Specialize Automation
SQL: LEAD Function
 
06:30
In this tutorial, you'll learn how to make use of lead function in oracle sql PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 2060 radhikaravikumar
SQL: TRIM function
 
06:35
In this tutorial, you'll learn how to use trim function PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 2858 radhikaravikumar
Oracle 18c : THE FUTURE DATABASE
 
08:27
In this video, I am going to have a look on the latest and future database’s introduction. As Mr. Larry Ellison has been announced in Oracle OpenWorld 2017 about the future database that is a huge change in the world of Oracle technology. In the world of automation, we have seen huge changes from basic daily life to professional life. There is a huge advancement in each and every area of life. The journey of Oracle database started from Oracle v2.3 reached on 12c. In the latest announcement, we have look on Oracle 18c. Most of the companies cost to go on performance tuning and maintenance of database due to bad performance business has to suffer from lots of issues like loss of business, workload etc. this kind of key points kept in mind while designing Oracle 18c which is now Oracle Autonomous Database Cloud. It offers total automation based on machine learning and eliminates human labor, human error, and manual tuning. It has lots of new features which prefer No human labor means half cost, no human error means 100x reliable. Its main aim is “self-driving” database. Here No Human Labor represents automation in Installation, Patching, Upgrades and Tuning of Oracle Database which uses the Robot Technique with the help of Machine Learning. This ground-breaking Oracle Database technology automates management to deliver unprecedented availability, performance, and security—at a significantly lower cost. As in previous of version of Oracle, the database had huge development but yet something was missing which is completed in new one database. there is some reason why so we can say Oracle Revolutionizes Cloud with the World’s First Self-Driving Database which is mention below:- 1. Self-Driving 2. Lower Cos 3. Reliable Facebook Page https://www.facebook.com/ishwaracademy/
Views: 8587 Ishwar Academy
PL/SQL tutorial | Stored Procedure in Oracle Database 11g Complete guide
 
23:55
Learn in depth about stored procedure in oracle,usage of SP in Database. Creating Stored Procedure using in, out ,in/out parameter and handling exception inside with example. Stored Procedure in Oracle, Stored Procedure in PL/SQL, Oracle Stored Procedure, PL/SQL Stored Procedure, What is Stored Procedure in pl/sql, How to use Stored Procedure in pl/sql, How to write a Stored Procedure in oracle, How to create Stored Procedure in pl/sql, Parameterized stored procedure in pl/sql, Benefit of using stored procedure in oracle, Advantages of Using Stored Procedures: Maintainability (because scripts are in one location, updates and tracking of dependencies based on schema changes becomes easier) Can be tested independent of the application Isolation of Business Rules,(Having Stored Procedures in one location means that there’s no confusion of having business rules spread over potentially disparate code files in the application) Speed / Optimization ( Stored procedures are cached on the server Execution plans for the process are easily reviewable without having to run the application) Utilization of Set-based Processing (The power of SQL is its ability to quickly and efficiently perform set-based processing on large amounts of data; the coding equivalent is usually iterative looping, which is generally much slower) Security ( Limit direct access to tables via defined roles in the database, provide an “interface” to the underlying data structure so that all implementation and even the data itself is shielded. Securing just the data and the code that accesses it is easier than applying that security within the application code itself ). Drawbacks to Using Stored Procedures: Limited Coding Functionality Stored procedure code is not as robust as app code, particularly in the area of looping (not to mention that iterative constructs, like cursors, are slow and processor intensive) Portability issue for complex and large Stored Procedure. Testing :Any data errors in handling Stored Procedures are not generated until runtime Cost :Stored Procedure development could potentially require a dedicated database developer. Some businesses will not allow developers access to the database at all, requiring instead a separate DBA. Alternatives to Stored Procedures: In-line or Parameterized Queries (These are written within the application code itself) Object Relational Mapping (ORM) (Provides an abstraction to the database without having to manually write data ) Linkedin: https://www.linkedin.com/in/aditya-kumar-roy-b3673368/ Facebook: https://www.facebook.com/SpecializeAutomation/
Views: 4324 Specialize Automation
How to Install Oracle SQL Developer
 
09:17
This video explains how to install SQL Developer. Oracle's SQL Developer is a free SQL IDE, which allows you to write and run SQL statements on an Oracle database. It can be used with Oracle Express, or the full version of Oracle database. In summary, the steps are: 1. Download SQL Developer from www.oracle.com 2. Optionally, download the JDK from the same page 3. Extract the ZIP files 4. Optionally, install the JDK 5. Run SQL Developer 6. Set up a connection to your database SQL Developer has improved over the last few years and it's a great IDE to use for your development. It's recommended by many in the industry, and it's easy to set up as well. If you enjoy this video, please like it and subscribe to my channel. Thanks!
Views: 2793 Database Star
TCL save point | sql queries |oracle database 11g version 2 | by bhanu priya
 
05:42
SQL queries on oracle database 11g version 2
Views: 94 Education 4u
Oracle Database tutorials 1: How to install Oracle Database 11g on windows 7
 
08:54
How To install Oracle Database 11g enterprise edition On windows 7 64 bit. Full installation in Single video. Enjoy SQL and Oracle Database Download Oracle Database 11g from here http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Related Tutorial ► Tut 16 How To Uninstall Oracle 11g http://youtu.be/pk-E-QxWe38 ► Tut 25 How To Install Oracle 11g XE r2 http://youtu.be/-13SbeDavwk ► Oracle 12c Tut 1 How To Install Oracle 12c http://youtu.be/T-rCbe1MMG4 ►Oracle 12c Tut 5 How To Uninstall Oracle 12c http://youtu.be/lyN9aJfMlzQ ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/TheRebellionRider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ You can also Email me at [email protected] You can help me in getting a good job by connecting with me on my LinkedIn and Endorsing my Skills. Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 1424795 Manish Sharma
Oracle SQL Developer: Online Migration 3.1
 
10:01
Using Oracle SQL Developer 3.1 to migrate a Sybase database to Oracle.
Views: 65108 oraclesqldev
Redgate SQL Source Control - an intro with Steve Jones
 
07:06
Steve Jones, SQL Server MVP and founder of SQL Server Central, explains how to share simple database changes between developers, using Team Foundation Server, SQL Server Management Studio, and Redgate SQL Source Control. Find out more and download a free trial at http://www.red-gate.com/sql-source-control
Views: 54875 Redgate Videos
SQL - 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: 933666 freeCodeCamp.org
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: 179257 Manish Sharma
Oracle Schema Compare Tools and SQL Deployment Script Generation in Visual Studio
 
08:11
This video shows how you can use Schema Compare, a feature of Oracle Developer Tools for Visual Studio, to visualize differences between two schemas and to generate a diff SQL script to upgrade a target schema to the level of the source schema. If you would like to try out what you see in this video you will need to download and install Oracle Developer Tools for Visual Studio version 12.1 or higher. This software can be found on the .NET Developer center (http://otn.oracle.com/dotnet) as part of the "ODTwithODAC" download packaging. For instructions on how to install this, see the Quick Start Video: https://www.youtube.com/watch?v=zrzDOk8gg5A Visual Studio 2012 and 2013 is supported - any edition except Express Edition (Community Edition is supported).
Views: 6262 Oracle .NET
TCL commit and rollback |  sql queries | oracle database 11g version 2 | by bhanu priya
 
05:46
SQL queries on oracle database 11g version 2
Views: 98 Education 4u
PL/SQL: Ref Cursors
 
09:28
In this tutorial, you'll learn what is ref cursors. PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 27368 radhikaravikumar
pl sql developer - connect to oracle 12c database using pl sql developer with tnsnames.ora
 
06:22
pl sql developer - connect to oracle 12c database using pl sql developer with tnsnames.ora Connect to oracle database - how to connect to oracle database using sqlplus in windows: https://youtu.be/8GK4RQuCx_8 In this tutorial "pl sql developer - connect to oracle database using pl sql developer with tnsnames.ora" will show you how to configure tnsname.ora in pl sql developer for oracle database connection, create table in pl sql developer, insert data in pl sql developer, and select result in pl sql developer. You can find me: Facebook: https://www.facebook.com/HingTipi Instagram: https://www.instagram.com/pi_sapphire/?hl=en Linkedin: https://www.linkedin.com/in/tipi-hing-93080261/ Google plus: https://plus.google.com/u/0/115396916707479934437 Twitter: https://twitter.com/TiPiHing photo credit: CREDIT PHOTO https://www.flickr.com/photos/[email protected]/10614978976/in/photolist-hb1xqU-4A4jrh-fPduyd-rcmbAc-fPcRfU-r8Jbhv-5gAYFx-bqrToM-dRFrZg-fNVyov-62Yv2h-nQug-9h8PzA-5aZeqx-9h5FM4-7H6iUU-9h8PrQ-9h5FAc-b78rj-9h5Fv8-fJt9Ex-kqoVuF-jcK5w5-hEoyms-9h5FJ8-Ro3Xc9-9h5FGK-8b8puq-9h5FBR-dfUthv-agLG6c-9h5Fz8-pSbCPg-5A8zDb-jC4vYX-RT31DE-9h8Pqm-4VMqsw-SCqtuw-4VMpCo-bofeWo-fPrqnP-aznTRJ-8vh3ny-7heoWE-jC5rn8-bTzxkx-gYu6fR-9GywxF-fNUJjF Subscribe. Like. Share. Comment. Thanks, pl sql developer connect to oracle 12c database using pl sql developer
Views: 21912 Junior Geek