Home
Search results “Oracle partition standard”
SQL Partition By Explained
 
06:42
Using Oracle's SQL, I'll explain how to use Partition By. This will be similar in other SQL engines that have the Partition By keyword.
Views: 31721 Pretty Printed
Partitioning in Oracle Explained with Real project Examples : Introduction
 
22:43
This Video series will explain partitioning and its use cases referencing real project examples from different domain. It will explain what when and why of partitioning in a simple but elaborate manner. This is the 1st video which explains why partitioning is required and what are the advantages we gain from it. The following videos will explain when should we do it and how.
Views: 26938 Tech Coach
custom partitioning during RHEL7 installation
 
07:26
This video teaches how to specify a custom disk layout which installing RHEL 7. This video is provided as an update to my RHCSA complete video course.
Views: 12399 sander van Vugt
standard partition part1
 
08:39
create standard partition linux
Views: 32 redhatforall
SQL Server Tutorial 23: Partitioning Tables and Indexes
 
07:05
How to partition a table and an index using SSMS, or T-SQL. For more info, or a copy of the scripts used in this tutorial, please email me at [email protected]
Views: 21578 Johnny Deluca
11. Oracle Tutorial - What is Materialized View
 
18:05
This video tutorial on Oracle provides detailed information about the Materialized view in Oracle. It also provides a brief explanation about how to create and drop Materialized view. You can visit Oracle Database related videos here : https://www.youtube.com/watch?v=cDqlT7O8H0Q&list=PLRt-r4QiDOMfMmVU-8145pLcBxIdvAt8f&index=1 Website: http://guru4technoworld.wix.com/technoguru Facebook : https://www.facebook.com/a2zoftech/ Website: www.dronatechnoworld.com
Views: 87 Sandip M
PL/SQL tutorial 16: Table Auditing using DML Triggers in Oracle PL/SQL
 
09:55
Learn Table Auditing using DML Triggers in Oracle Database and Increase the level of security by keep an eye on user tempering your table data. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/table-auditing Previous Tutorial ► DML Triggers with Examples https://youtu.be/-OR7zLzCh_I ► Select-Into Statement: https://youtu.be/F5eMJhwmCQs ►Sysdate Blog : http://bit.ly/sysdate-in-oracle-by-rebellionrider ------------------------------------------------------------------------- ►►►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: 73735 Manish Sharma
Oracle Edition-Based Redefinition in 5 minutes
 
05:16
Visit my blog for more Oracle database related posts and presentations: http://db-oriented.com
Views: 3039 Oren Nakdimon
How to Code Oracle Analytic Functions
 
52:40
Many more free Oracle Database and SQL tutorials at http://skillbuilders.com/free-oracle-tutorials. SQL is a language that allows you to perform queries to answer a wide range of questions about your data. While standard SQL is quite powerful, there are many questions that it cannot answer at all or that it can only answer with complex and inefficient SQL workarounds. Questions about running totals, percent of total, and ranking within a group fall into this area. Also, more complex issues such as Top-N within a group and aggregates over a range also fall in this arena. These questions can be easily answered via a new class of SQL statements called Analytic Functions. This presentation will show you how to use Oracle's Analytic Function extensions to SQL to answer these questions simply and efficiently.
Views: 26323 SkillBuilders
Compression Options for Oracle Database
 
36:49
Held on August 9 2018 This session by Gregg Christman focuses on general questions and insights regarding Oracle Basic Compression, Oracle OLTP Table Compression and Oracle Advanced Row Compression. Here is a quick guide to the highlights: 2:25 Basic vs. Advanced Row Compression comparison 4:55 Should you expect the same compression ratio with Basic and Advanced Row Compression? 8:29 Should you compress all tables and partitions? 15:50 What is the overhead associated with Advanced Row Compression? 17:06 Do I need to change my application to use compression? 17:31 Who uses Advanced Row Compression? 18:35 Is there any ongoing administration with Advanced Row Compression 20:43 When does updated data get compressed? 26:30 What role does PCTFREE play in updates and compression? 28:44 Does Advanced Row Compression work with Oracle Encryption? 29:34 Does enabling compression online or offline make a difference? 31:38 What are the typical compression ratios with Basic and Advanced Row Compression? 32:56 Are there any suggested MOS notes related to compression? 34:12 Feedback about ACO from customers AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists. https://asktom.oracle.com/ Oracle Developers portal: https://developer.oracle.com/ Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit music: bensound.com
Views: 499 Oracle Developers
What is the RANGE-HASH SUBPARTITIONS in Oracle ?
 
05:35
Hi guys in my today scenario I'm going to explain with you What is the RANGE-HASH SUB-PARTITIONS in Oracle,Oracle database #RANGE-HASHSUBPARTITIONS Unbeatable,Unbreakable Platform..
Views: 1422 Oracle World
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: 16672 Easysoft Limited
Бесплатная лицензия AOMEI Partition Assistant Pro
 
07:46
Бесплатная лицензия Aomei Partition Assistant Pro на русском языке, которая позволяет создавать, удалять, объединять, изменять размеры разделов жесткого диска. Скачать программу с бесплатной лицензией Aomei Partition Assistant Pro: https://progipk.blogspot.com/2018/03/aomei-partition-assistant-pro.html Бесплатная лицензия антивируса AVG Internet Security 2018: https://www.youtube.com/watch?v=tU-NoXsURNk Видео обзор, как скачать и пользоваться программой с бесплатной лицензией Aomei Partition Assistant Pro смотрите здесь: https://www.youtube.com/watch?v=L6kVMZJ0AH8
[HowTo] CentOS / RHEL 7 Installation with Custom Partitioning [www.tejasbarot.com]
 
22:02
RHEL 7 / CentOS 7 Installation Video. This Video will show you How to Install CentOS Operating System with Custom Paritioning, Please do not forget to give feedback on www.tejasbarot.com, Keep Visiting Blog.
Views: 42854 Tejas Barot
04 How to configure Hash partition in Oracle
 
06:56
Hash partitioning Use hash partitioning if your data does not easily lend itself to range partitioning, but you would like to partition for performance and manageability reasons. Hash partitioning provides a method of evenly distributing data across a specified number of partitions. Rows are mapped into partitions based on a hash value of the partitioning key The following example shows how to create a hash partition table. The following example creates a hash-partitioned table. The partitioning column is partno, four partitions are created and assigned system generated names, and they are placed in four named tablespaces (tab1,tab2, ...). CREATE TABLE products (partno NUMBER, description VARCHAR2 (60)) PARTITION BY HASH (partno) PARTITIONS 4 STORE IN (tab1, tab2, tab3, tab4);
Views: 796 Md Arshad
part 4 date range partition
 
02:33
date range paritition data warehousing range partition
Install CentOS 7 with standard partition
 
34:54
The video is about installation steps for CentOS 7 with standard partition. This video is created by using VirtualBox Video feature. Here is the blog post about how to get Video feature inside VirtualBox http://sharadchhetri.com/2014/10/07/ubuntu-14-04-install-virtualbox-guest-additions-also-create-videos/
Part 23 standard commit
 
07:16
This tutorial content is available in https://www.oercommons.org/authoring/21895-database-application-using-oracle-form-builder/3/view
Views: 2997 Dr. Girija Narasimhan
Volume Management: Hardware vs. Software
 
05:15
This video describes the differences between physical and logical volume management of storage. The advantages of a volume manager are explained.
Installing Linux & Windows in Dual Boot: CORRECT PARTITION SCHEME & BOOT LOADER SETUP
 
16:12
In this video, I will cover two important steps of Installing Linux alongside your windows OS. 1) Choosing the correct Partition scheme 2) Setting up your Windows Boot loader to boot to Linux instead of Linux bootloader (e.g : GRUB) During a standard Linux installation, a user do not have to worry about this. But when you are trying to install Linux in separate partition, keeping your current OS, it gets little trickier. If you do not configure these two options correctly, you might end up corrupting your bootloader or previous OS installation. I will also show how you can add your Linux os option to the Windows 8 bootloader using BCDedit. This is important so that in case in future if you decide to get rid of Linux OS, your computer boots normally without any issues.
Views: 87960 XPSTECH
SQL 2008 Series: SQL Partitions / partitioning
 
11:57
http://www.creativecommit.com This demo gives a brief overview of SQL partitions/partitioning/partition functions/partition schemes.
Views: 15581 creativecommIT
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: 1144055 freeCodeCamp.org
FIRST_VALUE and LAST_VALUE Analytic Functions in Oracle Database
 
14:51
FIRST_VALUE and LAST_VALUE in Oracle Database Oracle FIRST Function Oracle last Function
Views: 101 Adam Tech
Install Oracle DB 12c Release 1 Standard Edition One on Oracle Linux 7 - Part 1 of 3
 
13:15
PART 1 of 3. Detailed walk through of installing Oracle Linux 7 (on a VM) followed by installing Oracle Database 12c Standard Edition One 12.1.0.1. VMware ESXi 6. No Ads. (English - Canadian Accent) Table of Contents: 1) Planning 2) Create VM 3) Download OS ISO from OTN 4) Install Operating System - Oracle Linux 7 5) Postinstallation Tasks 6) Prepare system for Oracle RDBMS 7) Install Oracle Database 12c Release 1 Standard Edition One (12.1.0.1) Typical Installation (no ASM) 8) Postinstallation Tasks 9) Starting and Stopping Oracle and Listener 9) Open port 1521 and 5500 (firewalld) 10) EM Database Express 11) Conclusion
Views: 1358 Phany Langille
Let's Learn SQL! Lesson 29: Joins and ANSI Standard Syntax
 
05:30
Explore SQL with Tom Coffing of Coffing Data Warehousing! In this lesson, learn how you do Joins with the ANSI Standard Syntax!
3.Fine-Grained (FGA) Auditing | Oracle Database security
 
13:21
Hi friends today i will explain briefly how to audit changes of end user for security prupose. #Fine-Grained(FGA)Auditing Oracle database Unbeatable,Unbreakable Platform.
Views: 3527 Oracle World
SQL Server Table Partition - Part 1
 
02:01:22
For scripts, visit www.metamanager.com SQL Server table partitioning
Views: 32435 metamanager
Start Oracle Enterprise Manager
 
08:18
In this video i'm going to show you how to start and stop Oracle Enterprise Manager and how to use for creating a table step by step.
Views: 17426 OCP Technology
Part 5: Partition creation, ASM RPM installation & ASM DISK creation & grid software Installation
 
22:03
Real Application Clusters Oracle Real Application Clusters (RAC) is a database clustering solution that allows more than one instance to mount and open an Oracle database. RAC can only be used on special clustered systems with shared disk storage and a private network interconnect. A normal Oracle installation consists of a single Oracle instance that accesses a database on the same computer system. In contrast, RAC allows multiple instances on different computer systems (nodes in a cluster) to access the same database files simultaneously. Communication between instances is managed by the Distributed Lock Manager (DLM). To address the possibility of two or more instances attempting to modify the same information simultaneously, Oracle uses up to ten additional background processes, named LCK0 through LCK9, to lock the resources in use by these instances. RAC is available with Oracle Enterprise Edition, and under certain conditions, with Standard Edition as well. These restrictions (for Standard Edition) include: • Must use Oracle Clusterware (no third-party clusterware allowed); • Must use ASM to store database files; and • Can only use a max of 4 CPU sockets in the cluster (either 2 nodes with 2 CPUs each, or 4 nodes with 1 CPU each). • RAC was previously called Oracle Parallel Server (OPS). Oracle re-branded OPS as RAC when they released Oracle 9i. Benefits Running Oracle in RAC mode can benefit you in the following ways: • High availability - If some nodes fail, the remainder of the nodes will still be available for processing requests. Failover support is available from Oracle 8 with Oracle's Transparent Application Failover (TAF) technology and from Oracle 10g, server side load balancing. • Speedup (increased transaction response time) - RAC normally adds some overhead. However, for some DSS applications one can achieve increased performance by running operations in parallel (mainly for DSS applications). • Scale-up (increased transaction volume) - RAC can be used to provide increased application scalability (mainly used for OLTP applications).
Views: 701 Md Arshad
How to Create Disk partition in Linux-RHEL5 PART-1
 
08:36
Hello friends In This Video in Hindi I'm showing to you How to Create Disk partition in #RHELLinux5 #CreateDiskpartition By Lalit Saini ...
Views: 1671 Oracle World
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: 14618 radhikaravikumar
TSQL: Get the Standard Deviation
 
10:18
Finding the standard deviation the quick or long way.
Views: 1392 SQLInSix Minutes
Partition Tables in SQL Server 2008 R2
 
10:20
Learn how to partition tables in SQL Server 2008 R2. Visit http://www.thomasliddledba.com for scripts used in this video.
Views: 55605 Thomas Liddle
How to increase partition  in linux using LVM
 
12:15
How to increase parition in linux using LVM http://solutionsatexperts.com/how-to-increase-partition-in-linux-using-lvm/ Resize of LVM partition is very easy in Unix , resize of LVM partition can be done without unmounting the the existing file system partition.
Views: 10471 Solutionsatexperts
How to Move a Datafile in Oracle Database - Part 1
 
01:32
Dozens of free Oracle tutorials at http://skillbuilders.com/free-oracle-tutorials. See Part 2 (the demonstration) of this tutorial at http://skillbuilders.com/How-to-Move-Datafiles-Oracle-12c. How do you move a datafile in an Oracle Database? Well, it just got a lot easier in 12c! Watch this free video tutorial - OCM John Watson of SkillBuilders will demonstrate both techniques, 11g and 12c. There are many reasons to move a datafile in an Oracle database. Here are just a few: Renaming datafiles to a standard Moving from one file system to another Converting from file system storage to ASM Changing from SAN to NFS storage In 11g, we need to take the tablespace offline, meaning downtime. Argh! In 12c, all that is required is ALTER DATABASE MOVE DATAFILE; this is an online operation with zero downtime. Even "critical" files such as the files associated with the SYSTEM tablespace can be moved online. Consider the ease of migrating to ASM this provides! This also functions in an Active Data Guard standby environment. And, there are syntax options that allow you to keep or delete the original file. Very cool stuff.
Views: 2587 SkillBuilders
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: 2158 radhikaravikumar
Running Sum using Oracle
 
08:35
Running Sum using Oracle
Views: 1370 CONNECT TO LEARN
Ten SQL Tricks that You Didn’t Think Were Possible (Lukas Eder)
 
45:10
SQL is the winning language of Big Data. Whether you’re running a classic relational database, a column store (“NewSQL”), or a non-relational storage system (“NoSQL”), a powerful, declarative, SQL-based query language makes the difference. The SQL standard has evolved drastically in the past decades, and so have its commercial and open source implementations. In this fast-paced talk, we’re going to look at very peculiar and interesting data problems and how we can solve them with SQL. We’ll explore common table expressions, hierarchical SQL, table-valued functions, lateral joins, row value expressions, window functions, and advanced data types, such as XML and JSON. And we’ll look at Oracle’s mysterious MODEL and MATCH_RECOGNIZE clauses, devices whose mystery is only exceeded by their power. Most importantly, however, we’re going to learn that everyone can write advanced SQL. Once you learn the basics in these tricks, you’re going to love SQL even more.
Views: 15544 Devoxx FR
06 Oracle ASM RPM installation  &  partition creation & ASM disk creation
 
08:43
In this Tutorial we will see how we can configure 11.2 standalone database with ASM manually. You might have to create ASM instance manually when you want to have allocation unit (AU_SIZE) other than 1 MB(default). For 11.2.0.1 and 11.2.0.2 Grid Installation OUI or AMSCA does not have provision to modify allocation unit while creating the instance. This feature is available from 11.2.0.3 ASMCA. Following environment was used to test this setup on VMWare. Operating System : OEL 5.3 (32 bit) Oracle Version : 11.2.0.2 Grid Infrastructure Version : 11.2.0.2 The approach would remain same for different 11.2 patchset on Linux platform. We will NOT be covering installation of VMWare, guest OS and VMWare tools in this article. You can find lot of articles helping you to do this. So lets start with list of tasks that needs to be done to accomplish our goal. Install Missing RPM packages Add disks at OS level for ASM Create oracle user and directories Set Kernel Parameters Install ASMLib and configure devices Install Grid Infrastructure Binaries Install Oracle Database Binaries Start CSSD service Create ASM Service & Instance Create Database Service & Instance Install Missing RPM packages Login as root and ensure that following packages are applied. rpm -q binutils compat-libstdc++ elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel- glibc-headers ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel Install any of the missing packages. Add disks at OS level for ASM For ASM we will be needing disks. In a production environment this would be provided by storage admin. For this test setup I am utilizing VMware ability to add disks.
Views: 168 Md Arshad
How to Delete or Remove disk partition from file system in linux-RHEL5
 
07:53
Hello friends in this video i am going to show you how to unmounted permanent disk partition from /etc/fstab file system and also delete using fdisk command. #Removediskpartition #linux-RHEL5
Views: 4427 Oracle World
How to create and delete a partition on centos 6.7/7
 
17:33
Partitions create and delete on centOS6-all
Views: 1845 venkatesh kondapalli
Resizing of standard xfs Partition in centos (NOT LVM)
 
06:18
NOTE :- First do this on a test environment 1. I made the partition type as Standard and let Centos create them Automatically.. / partition was /dev/sda3 and with 8.71GB Format Option was xfs 2. After running "parted" it shows my existing disk size is 10.7GB .. Lets increase it up to 15Gb and give a restart 3. Run a "Parted" again and check new disk size. now it shows 16.1GB 4. Now we are going to increase size of / partition (/dev/sda3). Please note that to do this the partition you are going to increase should be the last partition on partition table . 5. First we have to delete the existing / partition entry from Partition table . Dont worry this will not delete your data . 6. Run fdisk /dev/sda 7. Type "p" to print partition table . Check if the /dev/sda3 drive have bootable flag (*) and make a note of the starting cylinder. When creating the new parttion with increased size the starting cylinder of the new partition should be the same as the old one 8. Type "d" and select partition that you are going to delete . ( the last one) 9. Now create a new one . Make the partition type as primary . Extend will destroy everything 8. Give the starting cylinder as same as the old one . If your are going to use the whole available space for this partion just type return for the end cylinder . it will allocate all available space to this new partition 9. Now type "w" and write these changes to the partition table . 10. Check blkid of the new partition and make changes to fstab if necessary 11. Now go ahead and restart your computer . 12. This partition will not be resized until we run resize2fs or xfs_growfs . resize2fs only supports ext file format partitions . This is a xfs partition so we have to use xfx_growfs tool . 13. First run xfs_info /dev/sda3 to check current details of the partition . 14. Then run xfs_growfs /dev/sda3 this will do on-line resize of our / partion . Thats it . Hope this tutorial helped you .
Views: 5153 Sinethra Seneviratne
MSSQL - What is Table Partitioning Explained
 
05:49
Link to Scripts in Demo - https://goo.gl/JCQLUm Link to Adventure Works DB - http://msftdbprodsamples.codeplex.com/releases/view/55330 Brief explanation of what is Table Partitioning in SQL Server 2014 and a short Demo
Views: 13708 CodeCowboyOrg
Oracle Database 12c: Recovering by Using an Encrypted Backup
 
04:26
This demo shows you how to recover a broken Oracle Database 12c with a previously created encrypted backup by using the Data Recovery Advisor. Copyright © 2013 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Video 50 - Recovering GPT Partitions from Disks with Faulty Sector 0...manually
 
07:43
Video 50 show you how to take control and manually add undetected partitions to your case using X-Ways Forensics. Full narrative is at http://www.xwaysclips.co.uk/2016/01/video-50-recovering-gpt-partitions-from.html
Views: 2638 TED SMITH
Best Way to Write Basic SQL Queries
 
13:33
SQL Server Query writing strategies is something I have yet to find in any book. When enthusiastic SQL students do this, they experience a revelation. The number of errors drops significantly and the speed at writing complex queries increases immediately. Knowing how to narrow down what we are looking for amongst a vast list of choices helps immensely. Grabbing the right tables first and then the fields second is akin to grabbing the right menu before ordering an item from it. In fact, one student named Tim took this back to his team of SQL developers and they immediately implemented this process. We are all used to following steps. Most of the time, actions are sequential from top to bottom or left to right. Other times we complete things in phases. The two phases we are going to use in this exercise apply to joining tables. This is easy to implement as we only need remember to organize first and clean up second. When visiting a new restaurant, we will ask to see the menu, because we want to see all they have to offer. The odds are that we might be interested in half of the items, but only need a few dishes for our group at the table. Looking at the menu is like starting a query with a ‘SELECT *’ statement. Once we have looked at all the fields, we narrow our choice(s) to only the items we want at the time. Sometimes restaurants have multiple menus. My favorite restaurant has a kids’ menu, an adult menu, a gluten-free menu and a drink menu. These menus were each gathered at our table. Ultimately, in my head, a selection was narrowed to what was needed. Phase I: Organize. When building a new query from many tables, we often find ourselves wondering, “Where do I start?” First, lay the steps out by identifying which tables contain the essential data. Second, get all the table joins working with a basic ‘SELECT *’ statement. Third, add any basic filtering criteria. Phase II: Itemize. Once all joins and criteria, such as SELECT, FROM and WHERE are working, we are ready for Phase II. This entails going back and changing our ‘SELECT *’ to an itemized SELECT field list as the final step. Let’s explore how this two-phase process of Organize and then Itemize can be a big time-saver. We are going to use one of the challenges from the last lab. In Lab 3.2 (Outer Joins), Skill Check 2, we needed to get four fields from two different tables. If we were to list all four desired fields and test one table at time, we will get an error as seen on the right side of the figure below. In the figure below we write a SELECT statement and part of the FROM clause. When completed, the FROM clause will have two tables, but for now we just want to get the Location table working. By using the ‘SELECT *’ strategy, we remove any possible errors from line 1. From there, we can focus on the more complicated logic used for joining tables together. We can add tables one at a time until everything is working. This is the Organize phase. NOTE: SELECT * never results in an Error message stating “invalid column name”, however; a SELECT list with itemized field(s) can have this error. After our query is organized and working, we can go back and itemize the SELECT field list to display only the fields that are necessary. This is done during Phase II (Itemize). The steps for this system are broken down as follows: Since SELECT is always the first statement in a query, it’s natural to want to write the field names before writing the FROM clause. However; we can save time and trouble by using the ‘*’ until the entire query is working properly. When this is complete, it is very easy to itemize the field list, with the confidence of knowing it will not cause any problems. Exercise: Simple membership for a club: Table1 (id_Member,name_Member, email_member, title, age, company) Table2 (id_Club,club_name, club_Location, address) Table3 (id_club, id_member,membership_date) Q1: Show all member names, email, age, and company from Table1 Q2: Show all club name, location, and address data Q3: Show member name, club name, club location (hint: Use joins and all 3 tables) You can find all other classes related to this video here: http://www.joes2pros.com/joes2pros/Course/Introduction_To_Microsoft_SQL_Server Enroll Today & Get the First Month for only $1! Use code: YOUTUBE1
Views: 241608 Joes2Pros SQL Trainings
Oracle Analytic Functions
 
09:33
Learn Advanced Oracle Analytic Functions. SQL is a language that allows you to perform queries to answer a wide range of questions about your data. While standard SQL is quite powerful, there are many questions that it cannot answer at all or that it can only answer with complex and inefficient SQL workarounds. Questions about running totals, percent of total, and ranking within a group fall into this area. Also, more complex issues such as Top-N within a group and aggregates over a range also fall in this arena. These questions can be easily answered via a new class of SQL statements called Analytic Functions. This presentation will show you how to use Oracle's Analytic Function extensions to SQL to answer these questions simply and efficiently.
Views: 4857 SkillBuilders