Home
Search results “Oracle preserve rows on”
GLOBAL TEMPORARY TABLE (GTT) IN ORACLE SQL WITH EXAMPLES
 
13:33
This video demonstrates the usage and working of GTT in oracle SQL. The video shows how internally oracle works with GTT, and also explains the working of ON COMMIT DELETE ROWS and ON COMMIT PRESERVER ROWS in oracle with easy examples.
Views: 10302 Kishan Mashru
Temporary Table in Oracle  |GlobalTemporary Table in Sql|Advantages of Global Temporary Table in Sql
 
05:34
Temporary Table in Oracle | Global Temporary Table in Sql| Advantages of Global Temporary Table in Sql --------------------------------------------------------------------------------------------------------- use of global temporary table in oracle,advantages of global temporary table in oracle,local temporary table in oracle,how to use global temporary table in oracle procedure,create global temporary table in oracle,temporary, table, tables, global, oracle, sql, delete, create global temporary table, temporary tables, oracle sql, global temporary table in oracle, preserve, on commit, drop global temporary table, oracle pl/sql, global temporary table, sql insert data into temp table, difference between temporary table and global temporary table in oracle,limitations of global temporary table in oracle,oracle create temp table on the fly, sql tutorials for beginners, sql expert, sql expert tutorials, database, oracle, table, online training,insert into oracle,oracle insert into multiple rows,create table oracle,oracle 12c alter table add identity column,oracle create table default value sysdate,collections in oracle pl sql with examples,Oracle 12c, database, oracle database (software), sql, sql developer, sql tutorials, how to create database using dbca, how to create database in oracle,oracle cloud, database 12c, dba genesis,database services, database, create, 11g, dba, db, beginner, Please Subscribe My Channel
Oracle Core,  Лекция 4
 
43:44
Ссылка на файл с презентацией: https://docs.google.com/presentation/d/1hqsC6hEGybAbEEPko56razF7eLBJQEZ3L-ECWtp7rbM/edit?usp=sharing (презентация может быть с анимацией) Ссылка на краткий конспект лекции:https://docs.google.com/document/d/1UFayi0YIXxLrRuj4-JZj-jooyvpoa4rKLOryBloTtag/edit?usp=sharing 1. Create table: permanent tables, temporary tables (on commit delete/preserve rows) 2. Physical properties таблицы: tablespace, logging, pctfree, pctused, initrans 3. Pctfree и pctused 4. Initrans и maxtrans 5.Storage clause: initial, next, minextents, maxextents, pctincrease, freelists, freelist groups, optimal, buffer_pool (keep,recycle), flash_cache (keep, none), encrypt 6. Table properties: column_properties, cache, result_cache, enable_disable_clause, flashback_archive_clause 7. Alter table: column_clause, constraint_clause, alter_table_partitioning, move_table_clause, enable_disable_clause, rename to, shrink space 8. High water mark. Low high water mark 9. Create index: table index clause, index_expr, index_properties, unusable 10. Reverse indexes 11. Function based indexes 12. Alter index: сжатие (shrink space), параллелизм, физические атрибуты (pctfree, pctused, initrans), logging/nologging, rebuild, enable/disable, unusable, visible/invisible, rename to 13. Индекс по внешнему ключу 14. Причины неиспользования индексов 15. Оператор truncate 16. Неявный commit при выполнении ddl 17. Словари данных Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle
Oracle tutorial : Global Temporary Table In Oracle PL SQL
 
08:49
Oracle tutorial : Global Temporary Table In Oracle PL SQL create temp table sql This video will explain to you how to create Temporary Tables in Oracle Oracle tutorial : Global Temporary Table In Oracle 1)The data in such a table is stored only as long as the session or transaction lasts and is private for each session. 2)The definition is visible to all sessions. 3)After commit or disconnection, the data is lost but the definition of the table remains. 4)Indexes created on a temporary. 5)Scope of TRUNCATE command is a single database session. There is no effect of TRUNCATE on other sessions. 6)Foreign key constraints are not applicable in case of Temporary tables 7)Temporary tables cannot contain column of persistent collection type Syntax : CREATE GLOBAL TEMPORARY TABLE table_name ( column_name column_data_type … … ) ON COMMIT DELETE ROWS; CREATE GLOBAL TEMPORARY TABLE Emp ( id number(5) NOT NULL, name varchar2(50) NOT NULL, city varchar2(50) NOT NULL ) ON COMMIT DELETE ROWS INSERT INTO Emp VALUES (1, ‘Test1’, ‘city1’); INSERT INTO Emp VALUES (2, ‘Test2’, ‘city2’); INSERT INTO Emp VALUES (3, ‘Test3’, ‘city3’); SELECT COUNT(*) FROM emp; Result = 3 rows COMMIT; SELECT COUNT(*) FROM emp; Result = 0 rows For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond oracle temporary table create temporary table sql temp table
Views: 4179 Tech Query Pond
Global Temporary Tables (GTT) in Oracle
 
02:27
This video shows how global temporary tables (GTT) can improve the performance of DML against tables holding temporary data. For more information see: https://oracle-base.com/articles/misc/temporary-tables PS. My PhD kind-of involved the sexual habits of cabbages, hence the vicious rumour spread my uncle Martin! Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Martin Widlake (my crazy uncle) Blog: https://mwidlake.wordpress.com/ Twitter: https://twitter.com/MDWidlake Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 7672 ORACLE-BASE.com
8. Use LOG ERRORS to suppress SQL errors at the row level.
 
06:23
The impact of a non-query DML statement is usually "all or nothing". If my update statement identifies 100 rows to change, then either all 100 rows are changed or none are. And none might be the outcome if, say, an error occurs on just one of the rows (value too large to fit in column, NULL value for non-NULL column, etc.). But if you have a situation in which you would really like to "preserve" as many of those row-level changes as possible, you can add the LOG ERRORS clause to your DML statement. Then, if any row changes raise an error, that information is written to your error log table, and processing continues. IMPORTANT: if you use LOG ERRORS, you must must must check that error log table immediately after the DML statement completes. You should also enhance the default error log table. Related blog post: http://stevenfeuersteinonplsql.blogspot.com/2016/03/nine-good-to-knows-about-plsql-error.html ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Let's Learn SQL! Lesson 50 : Using the ON COMMIT DELETE ROWS Statement in a Volatile Table
 
03:59
Explore SQL with Tom Coffing of Coffing Data Warehousing! In this lesson, learn about why you use the ON COMMIT DELETE ROWS statement in a Volatile Table!
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: 808 Md Arshad
Column-Level Virtual Private Database (VPD)
 
07:19
Hi guys today we learn about security using VPD in oracle 11g release 2 to hide data from unauthorized users.#VirtualPrivateDatabase #VPD Oracle database Unbeatable,Unbreakable Platform..
Views: 2069 Oracle World
4 Benefits of Microdosing LSD & Shrooms Regularly
 
03:17
Learn how to microdose acid (LSD) or magic mushrooms in this educational whiteboard video. Produced by Mark from After Skool and Brandon from OnePercentBetter. Subscribe to After Skool ► https://www.youtube.com/channel/UC1KmNKYC1l0stjctkGswl6g ★★★ SUMMARY ★★★ **DISCLAIMER** We do not promote the use of legal or illegal drugs. This video is for informational purposes only. This video will walk you through what microdosing is, the potential benefits, and how to dose effectively based on James Fadiman’s book: The Psychedelic Explorer’s Guide. Lesson 1: What is Microdosing? It’s the act of consuming a sub-perceptual dose of a psychedelic substance, meaning the common sensory effects associated with higher doses like seeing visuals and tasting music - do not appear. The trend is growing, especially amongst corporates and entrepreneurs in Silicon Valley to get an edge over their competition. According to the inventor of LSD Albert Hofmann, “Sub-perceptual doses are the most under-researched area of psychedelics”. Tim Ferriss is also known for saying, “The billionaires I know almost without exception use hallucinogens on a regular basis”. Lesson 2: Potential Benefits of Microdosing In the reports James received from Microdosers in 2010, all said their experiences were positive and valuable. James has regularly felt 4 kinds of effects. The First: Physical He feels more energetic after an hour, notably different than a buzz from caffeine or a puff of pot. The Second: Emotional He feels more able to appreciate everyone and everything in his life. Watch the full video to learn more... ★★★ RELATED VIDEOS ★★★ 7 Habits of Highly Effective People ► http://youtu.be/4q9WAAsz03Y Top 7 Lessons From 134 Books ► http://youtu.be/Pr5e9b9ZjvA ★★★ HIGHLIGHTS ★★★ [0:36] LESSON 1: What is Microdosing? [1:32] LESSON 2: The 4 Potential Benefits [2:23] LESSON 3: How to Microdose EFFECTIVELY ★★★ BE A LAD ★★★ Subscribe to Become OnePercentBetter ► http://bit.ly/1Wvllz8 ★★★ WHAT SOFTWARE DO I USE? ★★★ VideoScribe - Get it here ► http://www.sparkol.com?aid=1371302 ★★★ WANT TO READ MORE IN LESS TIME? ★★★ Get Blinkist - 1,800+ best-selling nonfiction books, transformed into powerful shorts you can read or listen to in just 15 minutes ► http://jump.blinkist.com/SHX3 -~-~~-~~~-~~-~- Please watch: "The 50th Law by Robert Greene and 50 Cent ► Book Summary" https://www.youtube.com/watch?v=66NKywmi0Zs -~-~~-~~~-~~-~-
Views: 241285 OnePercentBetter
Oracle DV Visualization Plugins
 
04:50
Note: Deployment process described in this video is currently experimental. It may change in future releases of the product. Plugins may not be preserved on an upgrade install. It will be best to save a backup copy. Oracle BI Public Store: https://sites.google.com/site/oraclebipublicstore/downloads
Views: 2811 ORACLE ANALYTICS
MarkLogic 9: Security Enhancements
 
02:50
MarkLogic 9 continues to build upon its security features, with new abilities that address how the data is protected and exported, while the privacy remains preserved.
Views: 200 MarkLogic
Set On Current Row After Rollback and Execute in Oracle ADF
 
00:41
Set on Current row after Rollback Execute or page refresh using BindingContainer and Iterator Binding in Oracle ADF Read Complete Article- http://www.awasthiashish.com/2012/10/set-on-current-row-after-rollback.html
Difference Between Delete and Truncate
 
03:41
Below is link for Useful Pl/SQL Books http://goo.gl/XMy0tt ---------------------------------------------------------- Difference Between Delete and Truncate in Detail On bigger picture they serve the same purpose but there are many Differences listed with examples Point Delete Truncate 1. Data Recovery Delete: Come under the DML Category, we need to commit or Rollback explicitly to make the changes permanent, so we can recover the data by Rollback command fully with in a session or up to a point if Save Points are used Fall In DDL Category (DDL Command issue the Auto commit implicitly) so no chances of Recovery even not using the Flashback table method. But Truncate operations are also logged , they didn’t generate redo SQL but they are logged , view for truncated data info V$LOGMNR_CONTENTS 2. Data Removal Delete Can remove all or selected data using the Where Clause predicates. Or we can say delete any subset of rows We can Truncate complete table or a partition or sub partition of a table. 3. Speed Delete is Slower because oracle maintain the redo logs for Read Consistency (so that every session connected can see a consistent data at a given point of time ) Delete is very time consuming activity especially when table have numerous indexes and Triggers associated with table Faster as no data logs are maintained no associated trigger firing. 4. DML Triggers Firing DML (Delete) triggers associated with table will fire. DML Trigger will not fire in case of truncate method. 5. Flashback Technology Data can be recovered even after commit operation using Flashback Table options Flashback_transaction_query table will give what to recover and up to which point. Data cannot be recovered in truncate method by Flashback table option. 6. Referential Integrity Constraint Behavior if we don’t have related data in child table then we can delete the data from the parent table or we have variants like On Delete Cascade & on Delete set Null. We can’t truncate a table with enable Referential Integrity Constraint, even there is no data in the child table, we have to disable or drop the constraint if we want to truncate the table. Exception: Truncate is possible if the FK is self-referential means primary key and foreign key are on the same table. 7. Space De allocation or Space Utilization No extent reset with delete when deleting rows from a table, extents are not de allocated, So if there were 50 extents in the table before the deletion, there will still be 50 after the deletion. Truncate: When a table is truncated it will free the space allocated except in case of reuse storage clause. This space can subsequently be used only by new data in the table or cluster resulting from insert or update operations .All extents are de allocated leaving only the extents specified when the table was originally created .Example So if the table was originally created with min extents 3, there will be 3 extents remaining when the tables is truncated. When you truncate a table, NEXT is automatically reset to the last extent deleted. 8. High Water Mark Delete will not reset the high water mark Truncate will reset the High Water mark which is very important for performance point of view as in case of full table scan and full index scan oracle will read all the block under high water mark this makes a lot of difference in terms of performance. 9. Cluster No as such restriction with delete. You cannot individually truncate a table that is part of a cluster. You must truncate the cluster, Delete all rows from the table, or drop and re-create the table. 10. Information Capturing Delete : we can capture the row information what we have deleted using Delete Method, f you are deleting multiple records then use composite data types (collections & records) Truncate Don’t have this feature of capturing the deleted records. 11. Function Based Index Impact DELETE You cannot delete rows from a table if a function-based index on the table has become invalid. You must first validate the function-based index. Truncate: No as such restriction 12. UNUSABLE Indexes Delete no as such feature. Truncate if table is not empty then truncate make all unusable indexes to useable. 13. Complex views You cannot delete data from a Complex view except through INSTEAD OF triggers. But we can delete data from simple Views and MV. We cannot truncate a view simple or complex but you can truncate MV with special Features like Preserve MV Logs and Purge MV Logs. 14. Privileges Delete You need to provide delete table privilege on object. Truncate you must have drop table privilege there is no truncate table privilege exists. 15. Domain Index No as such restriction You cannot truncate the object having domain index in invalid or In progress state
Views: 13815 Ram Gupta
Formatting Columns Using Oracle BI EE
 
05:29
This video teaches you how to format columns in an analysis. You add color, add currency, override the data format, and add conditional formatting. To find out more about Oracle BI EE, see the documentation at https://docs.oracle.com/en/middleware Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Oracle SQL Tutorial 14 - Column-Level and Table-Level Constraints
 
04:15
In the previous video we talked about adding constraints at the column-level. We made it nice and simple by only requiring a few keywords, but the problem we were having is that we could not assign a name to the constraint, which many people like to do so we can reference easily if we need to at a later time. To do this, it requires a little bit more typing, but it will give us extra flexibility and many consider it to be the higher quality approach to adding constraints. Let's go though a simple example. Let's say we have a users table with a user_id column that we want to make a primary key. We will create the table like this: CREATE TABLE( user_ id NUMBER PRIMARY KEY ) Instead of adding the PRIMARY KEY keywords after the data type, we add: CONSTRAINT user_pk PRIMARY KEY Now, we have assigned the name user_pk to this constraint. You can do the same with other constraints, such as UNIQUE. The syntax would be CONSTRAINT username_un UNIQUE. The other way to create constraints requires to put all of our constraints at the bottom of our table creation rather than inline with the column. This type of constraint is known as a table-level constraints. To make a column a primary key using table-level constraints, we add it to the CREATE TABLE command as if it is another row and use the CONSTRAINT keyword to tell Oracle that what is coming is a constraint, not a column in our table. CREATE TABLE users( user_id NUMBER, username VARCHAR2(50 CHAR), CONSTRAINT username_un UNIQUE (username), CONSTRAINT users_pk PRIMARY KEY (user_id) ) The primary differences here is that you have to put the column you are talking about in parenthesis after the PRIMARY KEY keyword. That's because it's at the end of the table and you need a way to tell it what column you are talking about. The option of putting it at the end of the table has the added benefit in this situation because if we needed to have a primary key that is the combination of multiple columns, we can do that by just adding the other column in the PRIMARY KEY parenthesis right after a comma. In summary, there are three ways to make constraints. The first is at the column level, unnamed. The second is at the column level, named. The third is at the table level, also named. In the next video we are going to create a named constraint in Oracle SQL Developer, so stay tuned and be sure to subscribe! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 17329 Caleb Curry
How to configure Microsoft Excel to connect to an Oracle Database
 
11:52
Mike van der Velden, Product Manager at Simba Technologies, provides a step-by-step guide for configuring Microsoft Excel to connect with Oracle Database OLAP Option. Mike walks through the one-time set-up of Oracle's Transparent Networking Substrate (TNS), followed by the Data Source Name (DSN) and Office Data Connection (.odc). Once configured, Microsoft Excel connects easily to Oracle Database OLAP Option for ad hoc data query, data analysis and BI reporting.
How to use Oracle SQL Loader sqlldr to load data into table from text file
 
11:37
How to use Oracle SQL Loader sqlldr to load data into table from text file create table emp(empno number(10),ename varchar(30)); insert into emp values(10,'asif'); set echo off newpage 0 space 0 pagesize 0 feed off head off trimspool on spool d:\oradata\sqlloader\data.txt select empno || ',' || ename from emp; spool off delete emp; update file named data.txt create a file named control.txt load data infile 'd:\oradata\sqlloader\data.txt' into table emp fields terminated by "," optionally enclosed by '"' ( empno, ename ) sqlldr asif/asif control=d:\oradata\sqlloader\control.txt
Views: 47716 Abbasi Asif
SSMA for Oracle 7.0 — Overview of Data Migration Features
 
03:25
SQL Server Migration Assistant (SSMA) 7.0 supports data migration. In this video we'll show how to migrate data in SSMA. Check out the blog post at https://www.dbbest.com/blog/ssma-oracle-overview-data-migration-features/ to learn more about data migration issues.
Views: 1271 DB Best Technologies
Adding Pivot Tables and Action Links to an Analysis in Oracle Fusion HCM Cloud
 
06:49
In this tutorial you learn how to add pivot tables and action links to an analysis in that shows absence data by business unit. The example in this video is from HCM but applies to all applications that use OTBi and OTBI Enterprise including Oracle Financials Cloud, Oracle Project Portfolio Management Cloud, and Oracle Procurement Cloud. Please note that all of the techniques and concepts in this tutorial also apply to OTBI Enterprise although the available subject areas will be different.
Views: 7261 Oracle EPM Tutorials
Applying Filters and Conditional Formatting to an Analysis in Oracle Fusion HCM Cloud
 
05:56
In this tutorial you learn how to add filters and conditional formatting to an analysis that shows salary information for workers by location. The example in this video is from HCM but applies to all applications that use OTBi and OTBI Enterprise including Oracle Financials Cloud, Oracle Project Portfolio Management Cloud, and Oracle Procurement Cloud. Please note that all of the techniques and concepts in this tutorial also apply to OTBI Enterprise although the available subject areas will be different.
Views: 6024 Oracle EPM Tutorials
Simplified DBA-026-02-Total Recall with Flashback Data Archive
 
06:14
Flashback Data Archive helps you see old values preserved in FDA.
Creating a BI Publisher Report using SQL Query in Oracle Fusion HCM Cloud
 
04:23
In this video you learn how to create a BI Publisher report using SQL Query. The example in this video is from HCM but applies to all applications that use OTBi and OTBI Enterprise including Oracle Financials Cloud, Oracle Project Portfolio Management Cloud, and Oracle Procurement Cloud. Please note that all of the techniques and concepts in this tutorial also apply to OTBI Enterprise although the available subject areas will be different.
Views: 32856 Oracle EPM Tutorials
SQL Loader Bad file and Discard file Part 2  | Oracle SQL Tutorial | Mr.Murali
 
22:40
►For Registration : https://goo.gl/r6kJbB ►Call: +91-8179191999 ► Visit Our Website: http://nareshit.in/ http://nareshit.com/ ► About NareshIT: "Naresh IT is the Best Software Training Institute for Hadoop, Salesforce, AWS, DevOps, Sprak, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in Hyderabad, Chennai and Vijayawada, India which provides online and classroom training classes" ►For Registration : https://goo.gl/r6kJbB ►Call: India- 8179191999, USA- 404-232-9879 Email: [email protected] ►Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5.Share Video's of each and every session. Check The Below Links: ►For Course Reg : https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Visit Our Website: http://nareshit.in/ http://nareshit.com/
Views: 8682 Naresh i Technologies
OPTIC LCS GO INTO THE FINAL WEEK COMMITTED |  Oracle Episode 8 - At All Costs
 
12:57
We aren't where we wanted to be coming into the final week of the split. We might feel disappointed and down, but the one thing we will not allow ourselves to do is give up. Champion Represent: http://opt.gg/store ---Socials--- http://opt.gg/twitter http://opt.gg/insta http://opt.gg/facebook #PrepareToWin with SCUFGAMING: ● Discount code: "OpTic" for 5% off your purchase ● Controllers: http://opt.gg/scuf Hear everything, defeat everyone with TURTLE BEACH: ● Use Code "OpTic" for a discount off Headset ● Headset: http://opt.gg/turtlebeach Official gaming chair provider for the #GREENWALL - DXRACER: ● Use Code "OpTic" for 10% off ALL DXRacer Gaming Chairs! ● Chairs: https://opt.gg/dxracer --- Niship ‘Dhokla’ Doshi --- Twitter: https://twitter.com/dhoklalol Twitch: https://www.twitch.tv/dhoklalol   --- William ‘Meteos’ Hartman --- Twitter: https://twitter.com/MeteosLoL Twitch: https://www.twitch.tv/meteos   --- Lee ‘Crown’ Min-ho --- Twitter: https://twitter.com/Crown   --- Donghyeon ‘Arrow’ Noh --- Twitter: https://twitter.com/ArrowDongTak Twitch: https://www.twitch.tv/opticarrow   --- Terry ‘Big’ Chuong --- Twitter: https://twitter.com/FakeBigT Twitch: https://www.twitch.tv/lol_big --- Kieran ‘Allorim’ Logue --- Twitter: https://twitter.com/AllorimLoL Twitch: https://www.twitch.tv/allorim Youtube: http://www.youtube.com/AllorimLoL   --- Austin ‘Gate’ Yu --- Twitter: https://twitter.com/Gate_LoL   --- Joshua ‘Dardoch’ Hartnett --- Twitter: https://www.twitter.com/Dardoch Twitch: https://www.twitch.tv/dardoch Insta: https://instagram.com/dardochlol   --- Toan ‘Asta’ Tran --- Twitter: https://www.twitter.com/ukpneo --- Thomas ‘Zaboutine’ Si-Hassen --- Twitter: https://twitter.com/Zaboutine Twitch: https://www.twitch.tv/zaboutine
Views: 7129 OpTic Gaming
Adding Excel Formulas in Oracle Planning and Budgeting Cloud
 
04:16
This tutorial demonstrates how to write business calculations using Excel formulas in Oracle Planning and Budgeting Cloud. You learn how to add Excel formulas and functions that quickly calculate data in Smart Forms, without adding members or using Essbase calculations.
Views: 1950 Oracle EPM Tutorials
Trace It, Log It, Format It - Part 1
 
01:28:11
Oracle Performance Tuning - Logging and Tracing in Oracle In this video I have explained how to enable Oracle Trace for a session, service, module, action or client identifier using Oracle Event 10046, SQL_TRACE, DBMS_MONITOR, DBMS_SUPPORT, DBMS_SYSTEM, location of log and trace files and how to write custom messages to alert.log file
Views: 5205 Satish Lodam
Excel Magic Trick 1349: Power Query with Input Variables from Excel Sheet to Extract Records
 
18:02
Download File: http://people.highline.edu/mgirvin/excelisfun.htm See how to use Power Query (Get & Transform) with Input Variables from Excel Sheet to Extract Records and create a Revenue Report. Here are the steps: 1. (00:15) Introduction including Preview of Finished Solution and Preview of steps necessary to accomplish this goal. 2. (02:00) Import and transform Data Set, including removing Columns, Filter For Records and adding an extra Column to calculate Net Revenue using the Number.Round Power Query Function. 3. (06:38) Load Report to Sheet 4. (07:09) Import each Parameter/Criteria Table. 5. (07:36) Convert each Criteria Table to a single Text Item using the Record.Field Power Query Function. 6. (11:38) Declare and Insert Variables into M Code for Report 7. (14:10) Test Reporting System 8. (14:30) Create Recorded Macro To Refresh All and assign it to a Form button 9. (16:40) Test Macro and Reporting System 10. (17:25) Summary
Views: 84186 ExcelIsFun
Managing Type 1 Slowly Changing Dimensions (SCD) Using T-SQL
 
09:46
When building dimensional models it is crucial to decide on how changes in source data will be represented in dimension tables. This phenomena is called slowly changing dimensions. When it is not necessary to preserve the history, a Type 1 Slowly Changing Dimension can be used. This technique is commonly used in situations when the changed is implemented to correct an error. This tutorial provides a practical , follow-along, demonstration of how to manage Type 1 Slowly changing dimensions using T-SQL I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-analysts/?couponCode=ANALYTICS50%25OFF
Views: 3803 Steve Fox
Toyota Motor Manufacturing Alabama at Hays Nature Preserve National Public Lands Day 2018
 
02:54
TMMAL's annual volunteer activity with the Land Trust of North Alabama on National Public Lands Day. This is the 2nd year in a row TMMAL partnered with Hays Nature Preserve in Huntsville, AL. This year the group helped with the construction of the new TMMAL Educational Pavilion, erected new safety fencing, planted a flower garden, freshened up playground equipment, and helped created a new butterfly habitat.
Views: 113 michael phillips
T-SQL: column-level encryption
 
09:03
--step 1 USE TESTDB ; CREATE MASTER KEY ENCRYPTION BY PASSWORD = '[email protected]#$789'; --DROP MASTER KEY --step 2 CREATE TABLE TABLE3 (ID int, PERSONNAME nvarchar(200), AGE int, HOBBY nvarchar(200), SALARY varbinary(128)) --step 3 CREATE CERTIFICATE MyCertificate1 WITH SUBJECT = 'Secret info - Salary'; GO --drop CERTIFICATE MyCertificate1 CREATE SYMMETRIC KEY SSN_Key_01 WITH ALGORITHM = AES_256 ENCRYPTION BY CERTIFICATE MyCertificate1; GO --drop SYMMETRIC KEY SSN_Key_01 --step 4 OPEN SYMMETRIC KEY SSN_Key_01 DECRYPTION BY CERTIFICATE MyCertificate1; INSERT INTO TABLE3 VALUES (1,'Alex',40,'skateboarding', EncryptByKey(Key_GUID('SSN_Key_01'), '1000')), (2,'John',32,'wrestling',EncryptByKey(Key_GUID('SSN_Key_01'), '1500')), (3,'Asti',25,'jogging',EncryptByKey(Key_GUID('SSN_Key_01'), '24560')), (4,'Jay',53,'football',EncryptByKey(Key_GUID('SSN_Key_01'), '502')), (5,'Selena',40,'yoga',EncryptByKey(Key_GUID('SSN_Key_01'), '2500')) --truncate table TABLE3 --DROP TABLE TABLE3 --step 5 OPEN SYMMETRIC KEY SSN_Key_01 DECRYPTION BY CERTIFICATE MyCertificate1; SELECT *, CONVERT(varchar, DecryptByKey(SALARY)) AS [Decrypted Salary] FROM TABLE3 CLOSE SYMMETRIC KEY SSN_Key_01
Views: 8026 Alex Dargelis
Blue Prism Video Tutorial | 021 | Debugging basics - Stepping, breakpoint and set next stage
 
06:53
This video will provide you a detailed walkthrough of the essential debugging tools in Blue Prism - Run/debugging speed, step, step over, step out, set next stage and breakpoint.
Views: 47663 Busy Ping
Joins: Databases for Developers #5
 
05:09
You use a join to return related rows from two or more database tables. In this episode, Chris gives a quick rundown of the following types of join: - Inner join - Outer join - Full outer join - Cross join For more details on joins, read the Oracle Database SQL Language reference: http://docs.oracle.com/database/122/SQLRF/Joins.htm#SQLRF52355 Take the Databases for Developers FREE SQL course at https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html Need help with SQL? Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ ============================ The Magic of SQL with Chris Saxon Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 6642 The Magic of SQL
The Great Theatre of Epidaurus
 
02:30
The Great Theatre of Epidaurus (In a canyon, in 340 BC, an Argos architect Polykleitos the Younger, built, according to Pausanias, the theatre of Epidaurus. Among all the ancient theatres, Epidaurus theatre is the most beautiful and best preserved. Destined for the fun of the patients of Asklipieio, it had a capacity of 13,000 spectators. It was divided into two parts: A 21-rows of seats part, aimed for the citizens and a 34-rows of seats part aimed for the priests and rulers. The superb acoustics as well as the very well preserved construction, contributed to the creation of Epidaurus Festival S.A., )επιδαυρπς
Views: 4193 Drone Tv
Setting Ad Hoc Options in Smart View with Oracle Planning and Budgeting Cloud
 
03:50
This tutorial demonstrates how to set Ad Hoc options with Oracle Planning and Budgeting Cloud. Using Smart View, you learn how to set Ad Hoc options at a Global or Sheet level, and how to control how Ad Hoc actions are performed or how Ad Hoc grids are displayed. You see how to specify cell styles to apply visual cues such as font, background color, and border format to members or data cells in grids. You also see how to select Sheet options to customize how your data is displayed and formatted.
Views: 3850 Oracle EPM Tutorials
005 – Restore screen position after refresh
 
09:58
Learn how to restore your scroll position, when using Oracle Application Express, after a Dynamic Action refreshes a report. We’ll use jQuery’s scrollTop() function to make this happen.
Views: 1072 Jorge Rimblas
(Copyright Dawk Ins) Stephen Curry 22 points vs Magic (Full Highlights) (12/02/14) Winner 3 Pointer!
 
05:59
OAKLAND, Calif. (AP) Golden State Warriors coach Steve Kerr saw the look in Stephen Curry's eyes and the bounce in his step as he sprinted with the ball in transition. "I was thinking, `Don't call timeout,"' Kerr said. Good move, Coach. Curry made a go-ahead 3-pointer with 2.2 seconds remaining, sending the Warriors to a thrilling 98-97 win over the Orlando Magic on Tuesday night for their 10th straight win. "I wanted to go to my left down the middle and go to the basket and maybe get fouled or something, but he kind of bit on the in-and-out move and I was able to get a rhythm shot in transition," Curry said. In the most dramatic finish to their streak, Curry lost Tobias Harris with some crafty dribbling before pulling up to swish the shot. Curry shook his shoulders and pounded his chest as the announced sellout crowd of 19,596 roared at noisy Oracle Arena. "It's just kind of a rush that every player loves to experience," Curry said. "Especially at home when you're able to do that and get a huge win, you remember those moments." Draymond Green, who sprained his right thumb in the first quarter, deflected Kyle O'Quinn's pass to Harris on Orlando's last possession to preserve Golden State's streak. Curry finished with 22 points and five assists, and Klay Thompson scored 20 as the Warriors rallied from nine points down in the final four minutes. The Warriors (15-2) extended the best start in franchise history and moved within one game of matching the team record for consecutive victories set in the 1971-72 season. They have not lost since Nov. 11 to the defending champion San Antonio Spurs and are finding ways to win even when they're not at their best. "That's what the good teams do," said Warriors center Andrew Bogut, who had 12 rebounds, seven points and five blocks. Victor Oladipo scored 27 points, and O'Quinn had 21 points and 11 rebounds in a stunning collapse for the young Magic. Orlando had lost four in a row before beating Phoenix on Sunday. "That's some of the best basketball we've played all year and it comes out disappointing because Steph made a lot of tough shots, big-time shots," Harris said. In their first game home since a 5-0 road trip, the Warriors gave their fans quite a show in the closing minutes. Oladipo's 3-pointer put the Magic up 93-84 with 4:11 left. But Curry came back with a 3, and Thompson connected on consecutive shots from beyond the arc to quickly tie the game. The teams traded scores and misses - with the Warriors clanking three 3s on one possession - before Harris banked in a running shot over Bogut, who couldn't finish an alley-oop from Curry on Golden State's next time down. After Elfrid Payton's missed a difficult layup, Curry got the ball and raced down court for the tying shot from long range, where the Warriors had struggled most of the night. Golden State ended 8 for 27 from deep. Curry (sprained left ankle) and Thompson (bruised right quadriceps) were questionable before the game and took more than three quarters to find a rhythm. Both said they felt fine afterward. TIP-INS Magic: C Nikola Vucevic sat out with back spasms. He is questionable for Wednesday's game at the Los Angeles Clippers. ... Orlando has lost four in a row against the Warriors, dropping the season series for the second straight year. Warriors: F David Lee remains out indefinitely with a left hamstring injury. ... The Warriors are 7-0 against the Eastern Conference. GREEN'S FINGER The Warriors survived a scare when Green tumbled into a row of photographers on the baseline following a missed layup in the opening minutes. The team said he sprained his right thumb and X-rays were negative. Green returned with his thumb and wrist taped. He finished with 11 points, seven rebounds and six assists - and the game-saving steal. QUOTE OF THE NIGHT "That's why he's Steph Curry." - Kerr on the game-winning shot. UP NEXT: Magic: At the Los Angeles Clippers on Wednesday. Warriors: Host New Orleans on Thursday.
Views: 16783 Mark Anthony Garrett
Ancient Nicopolis Odeon
 
01:45
The Roman Odeon, among the more important and best preserved monuments in Nikopolis, is a true architectural masterpiece by some unknown but great architect. It lies at the centre of the town, on the west side of the Early Christian wall, adjacent to the Roman agora (forum). It was used for lectures, literary and musical contests and theatrical performances during the Nea Aktia religious games honouring Apollo. Being adjacent to the agora, it probably operated as a bouleuterion (council chamber) for the remaining months of the year. It was built during the reign of Augustus (early first century AD) and frequently repaired and remodelled in the late second century - early third century AD. The odeon consisted of the cavea, the orchestra and the scene. The cavea contained 19 rows of seats and was divided into two sections by a small horizontal central corridor. The seats were encrusted with limestone; the first row, which has not been preserved, seated the officials. On the tenth row were small openings in favour of acoustics. Three semicircular porticos support the cavea and ensure its sloping tendency. These porticos are of different heights: the inner one is the lowest and the outer is the highest. At the centre of the cavea there is one more entrance with paved floor and walls, directly linking the underground galleries of the cavea to the orchestra. At the Late Roman period, this passage narrowed due to the construction of an altar. Spectators accessed the tiers through a double stairway at the middle of the south fa?ade of the cavea, while two smaller stairways at the lateral sides were leading to the inner part of the cavea. The semicircular orchestra was adorned with multicoloured marble works, parts of which are preserved up to our days. The parodoi (passageways) on both sides of the cavea were vaulted and had a paved floor. The scene disposed of three entrances giving access to the road on the north of the odeon
Stephen Curry Winner 3 Pointer vs Magic!
 
02:59
OAKLAND, Calif. (AP) Golden State Warriors coach Steve Kerr saw the look in Stephen Curry's eyes and the bounce in his step as he sprinted with the ball in transition. "I was thinking, `Don't call timeout,"' Kerr said. Good move, Coach. Curry made a go-ahead 3-pointer with 2.2 seconds remaining, sending the Warriors to a thrilling 98-97 win over the Orlando Magic on Tuesday night for their 10th straight win. "I wanted to go to my left down the middle and go to the basket and maybe get fouled or something, but he kind of bit on the in-and-out move and I was able to get a rhythm shot in transition," Curry said. In the most dramatic finish to their streak, Curry lost Tobias Harris with some crafty dribbling before pulling up to swish the shot. Curry shook his shoulders and pounded his chest as the announced sellout crowd of 19,596 roared at noisy Oracle Arena. "It's just kind of a rush that every player loves to experience," Curry said. "Especially at home when you're able to do that and get a huge win, you remember those moments." Draymond Green, who sprained his right thumb in the first quarter, deflected Kyle O'Quinn's pass to Harris on Orlando's last possession to preserve Golden State's streak. Curry finished with 22 points and five assists, and Klay Thompson scored 20 as the Warriors rallied from nine points down in the final four minutes. The Warriors (15-2) extended the best start in franchise history and moved within one game of matching the team record for consecutive victories set in the 1971-72 season. They have not lost since Nov. 11 to the defending champion San Antonio Spurs and are finding ways to win even when they're not at their best. "That's what the good teams do," said Warriors center Andrew Bogut, who had 12 rebounds, seven points and five blocks. Victor Oladipo scored 27 points, and O'Quinn had 21 points and 11 rebounds in a stunning collapse for the young Magic. Orlando had lost four in a row before beating Phoenix on Sunday. "That's some of the best basketball we've played all year and it comes out disappointing because Steph made a lot of tough shots, big-time shots," Harris said. In their first game home since a 5-0 road trip, the Warriors gave their fans quite a show in the closing minutes. Oladipo's 3-pointer put the Magic up 93-84 with 4:11 left. But Curry came back with a 3, and Thompson connected on consecutive shots from beyond the arc to quickly tie the game. The teams traded scores and misses - with the Warriors clanking three 3s on one possession - before Harris banked in a running shot over Bogut, who couldn't finish an alley-oop from Curry on Golden State's next time down. After Elfrid Payton's missed a difficult layup, Curry got the ball and raced down court for the tying shot from long range, where the Warriors had struggled most of the night. Golden State ended 8 for 27 from deep. Curry (sprained left ankle) and Thompson (bruised right quadriceps) were questionable before the game and took more than three quarters to find a rhythm. Both said they felt fine afterward. TIP-INS Magic: C Nikola Vucevic sat out with back spasms. He is questionable for Wednesday's game at the Los Angeles Clippers. ... Orlando has lost four in a row against the Warriors, dropping the season series for the second straight year. Warriors: F David Lee remains out indefinitely with a left hamstring injury. ... The Warriors are 7-0 against the Eastern Conference. GREEN'S FINGER The Warriors survived a scare when Green tumbled into a row of photographers on the baseline following a missed layup in the opening minutes. The team said he sprained his right thumb and X-rays were negative. Green returned with his thumb and wrist taped. He finished with 11 points, seven rebounds and six assists - and the game-saving steal. QUOTE OF THE NIGHT "That's why he's Steph Curry." - Kerr on the game-winning shot. UP NEXT: Magic: At the Los Angeles Clippers on Wednesday. Warriors: Host New Orleans on Thursday.
Views: 17098 Mark Anthony Garrett
Matt Cain Perfect Game Final Out and Celebration at AT&T Park - June 13, 2012
 
03:35
From seats behind home plate, the final out of Matt Cain's perfect game, the first in Giants history.
Views: 6489 Andy Anderson
BluePrism RPA-Web Service- Merge Two Excel files into one Excel File -Aditya RPA Academy
 
14:23
BluePrism RPA - Web Service- Merge Two Excel files into one Excel File -Aditya RPA Academy
Views: 870 Aditya Chereddy
SQL Data Types: Don't Convert To String when Sorting/Displaying Values
 
05:54
Preserve data types; allowing the user interface to format as needed. This will allow sorting to properly be done..
Views: 133 David Rodecker
BluePrism Env and Session Variables BPES 1002 - Aditya RPA Academy BTM Layout
 
08:57
BluePrism Env and Session Variables BPES 1002 - Aditya RPA Academy
Views: 1032 Aditya Chereddy
2007 ASG: Barry Bonds is introduced at AT&T Park
 
00:44
7/10/07: Barry Bonds is introduced to the home crowd at AT&T Park during the All-Star Game Check out http://m.mlb.com/video for our full archive of videos, and subscribe on YouTube for the best, exclusive MLB content: http://youtube.com/MLB About MLB.com: Commissioner Allan H. (Bud) Selig announced on January 19, 2000, that the 30 Major League club owners voted unanimously to centralize all of Baseball's internet operations into an independent technology company. Major League Baseball Advanced Media (MLBAM) was formed and charged with developing, building and managing the most comprehensive baseball experience available on the internet. In August 2002, MLB.com streamed the first-ever live, full length MLB game when the Texas Rangers and New York Yankees faced off at Yankee Stadium. Since that time, millions of baseball fans around the world have subscribed to MLB.TV, the live video streaming product that airs every game in HD to nearly 400 different devices. MLB.com also provides an array of mobile apps for fans to choose from, including At Bat, the highest-grossing iOS sports app of all-time. MLB.com features a stable of club beat reporters and award-winning national columnists, the largest contingent of baseball reporters under one roof, who deliver over 100 original articles every day. MLB.com also offers extensive historical information and footage, online ticket sales, official baseball merchandise, authenticated memorabilia and collectibles and fantasy games. Major League Baseball consists of 30 teams split between the American and National Leagues. The American League, originally founded in 1901, consists of the following teams: Baltimore Orioles; Boston Red Sox; Chicago White Sox; Cleveland Indians; Detroit Tigers; Houston Astros; Kansas City Royals; Los Angeles Angels of Anaheim; Minnesota Twins; New York Yankees; Oakland Athletics; Seattle Mariners; Tampa Bay Rays; Texas Rangers; and Toronto Blue Jays. The National League, originally founded in 1876, consists of the following teams: Arizona Diamondbacks; Atlanta Braves; Chicago Cubs; Cincinnati Reds; Colorado Rockies; Los Angeles Dodgers; Miami Marlins; Milwaukee Brewers; New York Mets; Philadelphia Phillies; Pittsburgh Pirates; San Diego Padres; San Francisco Giants; St. Louis Cardinals; and Washington Nationals. Visit MLB.com: http://mlb.mlb.com Subscribe to MLB.TV: mlb.tv Download MLB.com At Bat: http://mlb.mlb.com/mobile/atbat Get tickets: http://mlb.mlb.com/tickets Official MLB Merchandise: http://mlb.mlb.com/shop Join the conversation! Twitter: http://twitter.com/mlb Facebook: http://facebook.com/mlb Instagram: http://instagram.com/mlb Google+: https://plus.google.com/+MLB Tumblr: http://drawntomlb.com/ Pinterest: http://pinterest.com/MLBAM
Views: 3044 MLB
Carroll Co. dedicates new park to preserve area's history
 
00:50
As part of Indiana's bicentennial celebration, Carroll County is working hard to preserve a piece of the state's history.
Views: 49 WLFITV
Blue Prism RPA -Utility – Environment - Set and Get Clipboard - BPENV 4006 - Aditya RPA Academy
 
03:17
Blue Prism RPA -Utility – Environment - Set and Get Clipboard - BPENV 4006 - Aditya RPA Academy Aditya Chereddy M.Tech.,
Views: 1291 Aditya Chereddy
0605 SET column type
 
13:28
Getting Started Welcome What You'll Need Database Basics What Is A Database? RDBMSs Tables and Data SQL Basics Finding Your Way About Creating a Database Creating a Table Column Types-String Column Types-Numeric Retrieving Data With Search Criteria Changing Existing Data Altering A Table Keys And Indexes Basics Syntax Recap Operators in MySQL Arithmetic Operators Numeric Comparison Operators String Comparison Operators Logical Operators Bitwise Operators Regular Expressions 1 Regular Expressions 2 Operators Syntax Recap Querying Your Data Sorting Retrieved Data Specifying Numbers of Results Joining Tables More On Joining Tables Data Aggregation Queries Syntax Recap More Complex SQL Using Default Data Date And Time 1 Date And Time 2 ENUM column type SET column type Using Variables Conditional: IF() Complex Syntax Recap Good Practises Using SQL batch files Data Modeling Normalization Optimizations Security Users And Privileges More About Users And Privileges The 'mysql' Database Encryption Security Syntax Recap Building A Database Application Planning The Structure Designing The Database Creating The Database Logging In And Out Checking Videos In And Out Searching For A Video Adding A New Title Signing Up A New Customer Hiring And Firing Employees Listing Debtors
Views: 30 Wong Jonie
BluePrism RPA - Web Service - Exposing Web Services - BPWS 6002 - Aditya RPA Academy
 
02:41
BluePrism RPA - Web Service - Exposing Web Services - BPWS 6002 - Aditya RPA Academy
Views: 456 Aditya Chereddy
BluePrism RPA - Microsoft Excel Integration With BluePrism RPA-6002 - Aditya RPA Academy BTM Layout
 
07:22
BluePrism RPA - Microsoft Excel Integration With BluePrism RPA 6002 - Aditya RPA Academy Bangalore Aditya Chereddy M.Tech.,
Views: 1172 Aditya Chereddy

Turbulent flow momentum equation open
Brull liege dermatologie praha
Oil tanker simulators games
Standard liege kortrijk preview
Regional press photography awards flower