Home
Search results “Key preserved table oracle”
Oracle Core,  Лекция 3-2
 
01:34:13
Ссылка на файл с презентацией: https://docs.google.com/presentation/d/1PzGVjjsR2lSlr5EXFzmbIpVN4RMGBkjwU_De6FQyxVI/edit?usp=sharing (презентация может быть с анимацией) Ссылка на краткий конспект лекции: https://docs.google.com/document/d/1x7-BCc_2Z83vSGjcFZiWGGdtVoRm1AJLRnxp-lXtchU/edit?usp=sharing 1. Таблица DUAL 2. Конструкция WITH. Рекурсивные запросы с конструкцией WITH 3. Иерархические запросы (self joins): START WITH, CONNECT BY, PRIOR, NOCYCLE, ORDER SIBLINGS BY, LEVEL, CONNECT_BY_ISCYCLE, CONNECT_BY_ISLEAF, SYS_CONNECT_BY_PATH, CONNECT_BY_ROOT 4. Псевдостолбцы (pseudocomlumns). 4.1 ORA_ROWSCN (SCN_TO_TIMESTAMP, TIMESTAMP_TO_SCN) 4.2 ROWID (DBMS_ROWID) 4.3 ROWNUM 5. Конструкция SAMPLE 6. Конструкция PIVOT 7. Конструкция UNPIVOT 8. Оператор INSERT INTO SINGLE TABLE 9. Оператор INSERT INTO MULTITABLE: INSERT ALL, INSERT FIRST 10. Оператор UPDATE 11. Оператор DELETE 12. Оператор MERGE 13. Обновляемая VIEW (KEY-PRESERVED TABLE) 14. SQL FUNCTIONS: SYSDATE, EXTRACT, ADD_MONTH, MONTH_BETWEEN, UPPER/LOWER, LENGTH, SUBSTR, INSTR, REPLACE, LTRIM/RTRIM/TRIM, LPAD/RPAD, TO_CHAR, TO_NUMBER, TO_DATE, POWER, ABS, ROUND, CEIL/FLOOR, USER, TRUNC, GREATEST/LEAST Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle
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: 19078 Caleb Curry
Encrypting Multiple Columns to Preserve Referential Integrity
 
10:49
In this demonstration, the Multi-Table Protect Job Wizard is used to define a rule for data in multiple Oracle tables. The rule locates columns that share the same type of data so that a protection rule for personally identifiable information (PII) can be applied to that data in multiple tables at the same time.
Views: 595 IRI TheCoSortCo
Oracle Encrypted Tablespaces
 
14:35
Oracle Encrypted Tablespaces
Views: 2114 The Silent DBA
Candidate Key in DBMS (Candidate key, Primary Key, Foreign Key, Alternate Key, Super Key)
 
06:59
Candidate key definition and understanding with the help of examples. Happy Learning and Keep rising.
Views: 96204 Edu Therapy
TDE - Wallet - Transparent Database Encryption  - Oracle 10g
 
26:46
Oracle Transparent Data Encryption (TDE) • Need for secure information • Automatic encryption of sensitive information: – Embedded in the Oracle database – No need to change application logic – Encrypts data and index values • Using an encryption key: – Master key for the entire database – Stored in Oracle Wallet
Views: 5610 Saurabh Joshi
Transparent Data Encryption
 
07:29
Encrypting data of table using oracle transparent data encryption For more information please visit https://www.koenig-solutions.com/oracle-training-certification-courses.aspx
Views: 1725 Koenig Solutions
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: 4342 Tech Query Pond
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: 822 Md Arshad
Working with the Trace File Analyzer Collector
 
28:22
The Trace File Analyzer (TFA) Collector Tool is a utility for collecting first failure diagnostics when creating Service Requests with Oracle Support. Using TFA Collector to make diagnostic collections removes questions about what files to collect and upload. TFA knows about all the well known Oracle and operating system diagnostic locations and collects only files that have been modified proximate to problem time specified from any of those well known locations. Larger files are also pruned proximate to problem time specified to reduce the size of the upload. If the system is a clustered environment TFA collects relevant diagnostics from the remote nodes as well. All of this can be accomplished with one simple command. Key features of TFA Collector include: RAC and single instance non-RAC support Time-based collection of relevant files OS Clusterware ASM DB OSW and CHMOS etc Large file pruning Cluster-wide time-relevant collections Analytics for key files DB alert logs Clusterware alert logs ASM alert logs system messages OSWatcher top and slabinfo data Flexible command-line interface Copyright © 2014 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.
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!
Informatica mdm online Training | Day14 Preserve source system keys in base object table
 
38:47
Informatica mdm online Training | Day14 Preserve source system keys in base object table . How to preserve source system keys in informatica mdm . load job in informatica mdm , base object table in informatica mdm , XREF table in informatica mdm . http://tutors99.com/en/online_training_content/course_content/2/Informatica-MDM-Online-Training Please contact us if you need any clarification regarding informatica online training . INIDA : +91-9015376513 USA : +1-3106681444 Email : [email protected] Email : [email protected] Informatica MDM Training informatica mdm Interview Questions And Answers #InformaticaMdmTraining , #InformaticaMdmOnlineTraining ,#InformaticaTraining, #MDMTraining ,#InformaticaMDMCertification,#InformaticaCertification , #InformaticaMdmInterviewQuestions ------------------------------------------ Best Informatica MDM 10.1 Online Training best Informatica MDM 10.1 training etl Informatica MDM 10.1 training free Informatica MDM 10.1 training free Informatica MDM 10.1 training material free Informatica MDM 10.1 training online free online Informatica MDM 10.1 training Informatica MDM 9.7 e learning Informatica MDM 9.7 training course Informatica MDM 9.1 tutorials Informatica MDM 9 course Informatica MDM 9 e learning Informatica MDM 9 free training Informatica MDM 9 online training Informatica MDM administrator training Informatica MDM classes Informatica MDM complete videos Informatica MDM corporate training Informatica MDM course Informatica MDM course in bangalore Informatica MDM course in hyderabad Informatica MDM data quality online training Informatica MDM data transformation e learning Informatica MDM data transformation training Informatica MDM data transformation training course Informatica MDM data transformation tutorials Informatica MDM demo classes Informatica MDM demo session Informatica MDM developer training Informatica MDM etl training Informatica MDM it training Informatica MDM learning material Informatica MDM live demo Informatica MDM live training Informatica MDM live videos Informatica MDM materials Informatica MDM mdm training Informatica MDM online course Informatica MDM online training hyderabad Informatica MDM online training in hyderabad Informatica MDM online training india Informatica MDM Online Training Part1 Informatica MDM online training usa Informatica MDM online training videos Informatica MDM online tutorial Informatica MDM power center training Informatica MDM power exchange training Informatica MDM powercenter course Informatica MDM powercenter e learning Informatica MDM powercenter online training Informatica MDM powercenter training Informatica MDM powercenter training course Informatica MDM powercenter training materials Informatica MDM powercenter training videos Informatica MDM powercenter tutorials Informatica MDM project training Informatica MDM training bangalore Informatica MDM training chennai Informatica MDM training course Informatica MDM training courses Informatica MDM training dallas Informatica MDM training for beginners Informatica MDM training in ameerpet Informatica MDM training in bangalore Informatica MDM training in chicago Informatica MDM training in hyderabad Informatica MDM training in india Informatica MDM training in nj Informatica MDM training in toronto Informatica MDM training in USA Informatica MDM training india Informatica MDM training institute Informatica MDM training materials Informatica MDM training tutorials Informatica MDM training videos Informatica MDM tutorial for beginners Informatica MDM tutorial videosa Informatica MDM Tutorials Informatica MDM tutorials online Informatica MDM video training Informatica MDM video tutorial Informatica MDM video Tutorials Informatica MDM videos Informatica MDM workflow manager Informatica MDM xml transformation learn Informatica MDM 8.6 learn Informatica MDM 9 learn Informatica MDM data transfomation learn Informatica MDM online learn Informatica MDM online free learn Informatica MDM powercenter learning Informatica MDM online Data warehouse ETL training Online Informatica MDM training online training for Informatica MDM online training Informatica MDM power center Informatica MDM tutorial informatica mdm master data management mdm solutions mdm server data management what is mdm master data what is informatica
NATURAL JOIN in SQL
 
04:49
Join Discussion:http://www.techtud.com/video-lecture/natural-join-sql IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 51151 Techtud
013-Using DDL Statements to Create and Manage Tables
 
56:21
013-Using DDL Statements to Create and Manage Tables استخدام جمل ال ddl لانشاء الجداول والتعديل عليها
Views: 285 tootshare
Oracle 12gR1 Database Installation Tutorial
 
39:32
In this tutorial we install an Oracle 12gR1 database on a Oracle Linux 7.2 server. More information including a list of the commands used are available at http://CloudApprentice.com
Views: 948 OracleIdentity
Incremental Data Load - The SSIS Approach
 
25:12
https://www.youtube.com/user/masterkeshav This blog demonstrates Staging to Production Data Sync up. We look to take the SSIS approach and see the options available to be able to sync up Insert/Update/Delete for changed records from the Staging to the Production tables.
Views: 50915 Keshav Singh
How to map and unmap tables and columns with SQL Compare
 
05:10
In this quick how-to video Data Platform MVP Grant Fritchey shows you how easy it is to map and unmap tables and columns using SQL Compare. SQL Compare is the fastest way to compare & deploy SQL Server schemas. With our industry-standard tool you will save ime comparing and deploying SQL Server database schemas. Find and fix errors, and create deployment scripts in minutes. Try it now for free: https://www.red-gate.com/sqlcompare
Views: 2944 Redgate Videos
Normalization | Database Management System
 
07:35
To ask your doubts on this topic and much more, click on this Direct Link: http://www.techtud.com/video-lecture/lecture-normalization IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 517804 Techtud
SQL Subqueries: Databases for Developers #11
 
07:45
In SQL you can base queries on the results of other queries. This video explains the various types of subquery and their uses, covering: - Inline views - IN & EXISTS - Common table expressions/subquery factoring/with clause - Scalar subqueries Take the course; Databases for Developers: Next Level https://blogs.oracle.com/academy/take-your-sql-skills-to-the-next-level-with-this-free-online-10-part-tutorial Further reading: About Queries and Subqueries: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/About-Queries-and-Subqueries.html Using Subqueries: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Using-Subqueries.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: 2155 The Magic of SQL
Protecting Your Information with Oracle Transparent Data Encryption | Rob Lockard
 
02:28
Veteran DBA, developer, and designer Rob Lockard returns for his third 2 Minute Tech Tip with advice on using Oracle Transparent Data Encryption. Want a deeper dive? Rob is presenting a webinar on Oracle Transparent Data Encryption Baseline Practices on August 27, 2015. for more information please see: http://oraclewizard.com/Oraclewizard/2015/07/16/oracle-transparent-data-encryption-baseline-practices-webinar/
Views: 461 ArchBeat Archive
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: 14331 Ram Gupta
Importing Data from Excel into Oracle Database using SQL Developer 4.1
 
02:23
One of SQL Developer’s most popular features has undergone a significant upgrade. Users can quickly define and recall delimited or Excel files to be imported to a new or existing Oracle table. Data preview and validation is provided for each column, as well as ‘best guess’ data type and date format mask mapping. This process can now be automated via the SQL Developer command line interface (SDCLI) ‘Import’ command. NOTE: This is a video only. There is no audio. 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.
SAP HANA Academy - Smart Data Integration/Quality: SAP ECC Replication [SPS09]
 
13:17
In this video tutorial, Tahir Hussain Babar introduces the concepts of Replication when using Smart Data Integration. In this basic introduction to the concept, we look at using Remote Sources to connect to a SAP ECC system in DB2. We import the KNA1 table, which holds Customer Master Data, and then we look at simply updating some data in SAP GUI, using transaction code XD02 to update some data using the SAP GUI. We check to see that the data is updated in the Virtual table in the Remote Data Source. Next, we look at how data is replicated into SAP HANA by using a .hdbflowgraph to build a simple replication task which extracts data from the Virtual Table, and loads it into the table in SAP HANA, via a "Real-Time" task. Lastly, we look at launching the Realtime Task by executing a Stored Procedure, and demonstrating that the real-time task works. Scripts; https://github.com/saphanaacademy/SDI/blob/master/SPS09.txt Video by the SAP HANA Academy.
Views: 24342 SAP HANA Academy
Lec-10: Foreign Key(Part -2)| Database Management System
 
18:19
Lecture By: Mr. Varun Singla Facebook page link : https://www.facebook.com/gatesmashers/ GATE 2005 question for practice The following table has two attributes A and C where A is the primary key and C is the foreign key referencing A with on-delete cascade. A C ----- 2 4 3 4 4 3 5 2 7 2 9 5 6 4 The set of all tuples that must be additionally deleted to preserve referential integrity when the tuple (2,4) is deleted is: A (3,4) and (6,4) B (5,2) and (7,2) C (5,2), (7,2) and (9,5) D (3,4), (4,3) and (6,4)
Views: 32542 Gate Smashers
Oracle Forms to APEX Modernization
 
01:15:34
Held on September 20 2018 Watch Joel Kallman, Senior Director of Software Development, along with a number of experts from the global APEX Community, to discuss Oracle Forms Modernization. Learn about the positive aspects, together with the challenges, of using Oracle APEX to modernize your Oracle Forms applications. Real-world success stories, challenges, and tips are presented. Session Chats: https://apex.oracle.com/pls/apex/f?p=20051:4:1757390683715::NO::P4_ASKTOM_OFFICE_HOUR_ID:157276294837434079139335725983223048710 Key Video Timestamps: Panel Introduction [9:15] Question 1 [11:55] - Can you please give a brief overview of one of your completed projects (or something which is underway)? Question 2 [20:50] - What would you say is your approach in modernization with APEX? Rewrite? Partial migration? Create new apps adjacent to the existing Oracle Forms apps? Question 3 [29:40] - What were some of the biggest challenges you faced in this type of project? Question 4 [36:15] - What was the biggest benefit to the customer? Has the customer been satisfied with the result? Question 5 [41:50] - We always talk about preserving your investment in the back-end business logic, in SQL and PL/SQL. Is this a fallacy? How much of the back-end code had to be modified to work in the new world with APEX? Question 6 [46:30] - Can you describe the process you follow to assess if something is appropriate to be modernized with APEX? Can you give an example of something you would not use APEX to modernize a Forms app? Question 7 [50:55] - How do you go about educating someone to use APEX, who comes from a Forms background? It is Web, and Web is different. Question 8 [1:01:45] - How long does it take for the existing Forms developers to become competent in APEX and Web development? Were they able to carry on with further development on their own? Question 9 [1:04:35] - Can customers do this migration on their own? This Office Hours forum is comprised of our many partners, and if I were watching this, I might think “wow, I need outside help to get this done”. What would you say? Question 10 [1:08:40] - For anyone watching this, who is contemplating modernizing some fo their Forms apps with APEX, do you have any specific advice? 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: 3027 Oracle Developers
20 How to Determine Keys in a relation | Candidate keys and Super Keys
 
20:23
#Call_9821876104 #BestInstitute #NTANET Thank you for watching our lectures. These Lectures are created for Thorough Understanding of Concepts for the Competitive examinations specially for UGC NET Computer Science and Applications. For Complete Study Material for UGC NET Exam preparation please call/whatsapp us at 9821876104/02 or email us at [email protected] . If you liked the video and it was helpful for you Please like the video and share it on Facebook with your friends so that others can also get benefitted from them. You can also check and visit out other playlists. I am sharing the links of other playlists here. You can also Add me on Facebook at facebook.com/Himanshu.kaushik.2590 or visit our websites www.gatelectures.com and www.digiimento.com Checkout our other playlists  Programming and Data Structures https://goo.gl/66Ndja  C Programming https://goo.gl/HGSbCR  Operating System https://goo.gl/1qp6gj  Digital Logic https://goo.gl/qhsRwH  Discrete Mathematics https://goo.gl/FjsiEk  Computer Networks https://goo.gl/DuRQPv  Theory of Computation https://goo.gl/CNKn25  Database Management System https://goo.gl/vJpDDU  UGC NET Paper 1 https://goo.gl/97Cpvo  Previous year paper Solutions https://goo.gl/KEDL9f  Compiler Design https://goo.gl/RykvXj  Artificial Intelligence https://goo.gl/WRdyYb  C Plus plus https://goo.gl/YPJsCi  Linear Programming Problem https://goo.gl/r58RxQ  UGC NET Paper 2 Solutions https://goo.gl/3Pia9w  Computer Graphics https://goo.gl/tRFa39  Microprocessor 8085 https://goo.gl/Z57Uit  DSSSB Computer Science https://goo.gl/kiZVvx  Placement Preparation https://goo.gl/siG3Ta  Daily Current Affairs  UPPSC LT Grade Teacher https://goo.gl/iZ3CY2  Current Affairs https://goo.gl/kJdnX5  NIELIT Scientist https://goo.gl/4GKNXG  Quantitative Aptitude https://goo.gl/Rzs6fj
Table Partitioning: Secret Weapon for Big Data Problems
 
01:09:17
For demo code and more go to https://johnsterrett.com/presentations/table-partitioning-secret-weapon-for-big-data-problems/ Big Data starting to slow you down? Data growth putting your maintenance tasks in danger of not meeting your SLAs? Wish you could archive old data with minimal impact to your tables during the archive process or that you could eliminate most of the data in your tables when you query them? If so, it’s time you consider implementing table partitioning to help with general performance and reduce your window for completing maintenance tasks. Come learn how table partitioning works and when it should be implemented. You’ll see how to initially configure partition functions and partition schemes to have a rock-solid partitioned table. And you’ll learn how to implement an automated sliding window to maintain your partitioned tables and ensure optimal performance.
Views: 445 Procure SQL LLC
Joins in SQL: 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 SQL 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: 7165 The Magic of SQL
Add Constraint, Alter Table on APEX 5.1.3
 
05:30
Add Constraint on APEX 5.1.3, Alter Table on APEX 5.1.3
Views: 438 Solution Wizard
Purge & Archive Projects Data in Oracle EBS R12
 
02:02
Purge & Archive Projects Data in Oracle EBusiness R12. Useful Solution to selectively purge data to reclaim DB space & maintain a healthy ERP system. Solution Demo for Purging Oracle Projects Definitions.
Views: 507 TxSolve
SQL - Multisets, Distinct operator, Set Operators & String Comparison
 
24:07
For Complete Video Series visit http://www.studyyaar.com/index.php/module/14-sql More Learning Resources and Full videos are only available at www.studyyaar.com This video clip is part of module available at http://www.studyyaar.com/index.php/learning-program/2-database-management-system-part-1
Views: 2028 StudyYaar.com
Building Prompts and Dashboards in Oracle Fusion HCM Cloud
 
09:14
In this tutorial you learn how to build a dashboard prompt, and a dashboard with multiple pages. You also learn how to embed analytics content in dashboard pages. 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: 10953 Oracle EPM Tutorials
Oracle alter multple columns data type - krumony
 
10:33
Oracle alter multple columns data type - krumony
Views: 13 Mony HO
ODI SCD TYPE 2 MAPPING
 
03:42
Follow the full step by step ODI training tutorial at: http://www.bisptrainings.com/course/Oracle-Data-Integration
Views: 1228 Amit Sharma
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: 7680 Oracle EPM Tutorials
Relational Database #4 - Referential integrity
 
11:35
شرح التكامل المرجعي Referential integrity مع أمثلة بلغة Sql و PHP
SAP HANA Academy - Smart Data Integration/Quality: Data Sources & Template Tables [SPS09]
 
10:49
In this video tutorial, Tahir Hussain Babar introduces the concepts of Data Sources and Data Sinks (Templates Tables) when using Smart Data Quality. He first starts with creating .hdbflowgraphs in order to create Smart Data Quality tasks, which can be used to perform ETL routines. After that, a simple extract and load routine is created which although simple, focuses on explaining the end-to-end steps of creating an ETL task in order to move data from one data source to another. Next, the different objects in the "General" and "Data Provisioning" tabs are investigated and finally we look at how to execute a task. Scripts; https://github.com/saphanaacademy/SDI/blob/master/SPS09.txt Video by the SAP HANA Academy.
Views: 10567 SAP HANA Academy
DBMS- VI- Constraints and Keys
 
10:30
A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data. Database Management System or DBMS in short refers to the technology of storing and retrieving users’ data with utmost efficiency along with appropriate security measures. This tutorial explains the basics of DBMS such as its architecture, data models, data schemas, data independence, E-R model, relation model, relational database design, and storage and file structure and much more.
Views: 479 Rumuni Education
Null Values in Attributes | Database Management System
 
01:21
This lecture explains about Null Values in attributes. To ask your doubts on this topic and much more, click on this Direct Link: http://www.techtud.com/video-lecture/lecture-21 IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE(for 'All India Test Series for GATE-2016'): http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate/ Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about our regularly uploaded new videos.
Views: 18791 Techtud
Oracle SQL Developer Tutorial For Beginners  94   Alias for Columns
 
02:44
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 730 Sam Dhanasekaran
Illustration on Division Operation | Database Management System
 
08:39
To ask your doubts on this topic and much more, click on this Direct Link: http://www.techtud.com/video-illustration/lecture-division IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 22885 Techtud
How to generate Table DDLs in ILM Data Archive
 
04:31
Use the Create Table standalone job to generate the table DDL. Provide a path relative to ILM server so the script file gets dumped there.
Views: 884 Informatica Support
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: 3879 Steve Fox
Why UPSERT is weird
 
52:43
by Peter Geoghegan Counterintuitive lessons learned from the implementation effort Talk that examines implementation process on the INSERT...ON DUPLICATE KEY LOCK FOR UPDATE feature proposed for PostgreSQL. "UPSERT" can loosely be described as a DBMS feature that allows a DML statement's author to atomically either insert a row, or on the basis of the row already existing, update that existing row instead, while safely giving little to no further thought to concurrency. One of those two outcomes must be guaranteed, regardless of concurrent activity, which is the essential property of UPSERT. Examples include MySQL's INSERT...ON DUPLICATE KEY UPDATE, or the SQL standard's MERGE statement (as implemented in a number of proprietary systems). The absence of this feature from Postgres has been a long-standing complaint from Postgres users, and an effort to implement an extension to the Postgres INSERT statement, that implements something broadly in line with user expectations in this area was undertaken in 2013. This talk considers the experience of working on that implementation, and examines how the proposed INSERT...ON DUPLICATE KEY LOCK FOR UPDATE feature deals with concurrency issues, visibility issues, the interplay of value locking and row locking, and the general avoidance of unprincipled deadlocking. In order to come up with an implementation that satisfied user expectations, while still preserving and respecting long standing abstractions and conceptual precepts, some interesting and counterintuitive choices were made to resolve the fundamental tension in tying value locking (as always required on a limited scale for unique index enforcement) to row locking (to LOCK FOR UPDATE). Finally, the talk examines the strategic significance of UPSERT, and further use-cases enabled by the feature in the area of multi-master replication conflict resolution.
Views: 567 Andrea Ross
SAP HANA Training - Complete SAP HANA Course - SP9 and SP12
 
50:15
This video covers SAP HANA Modeling which is part of our SAP HANA Training course. We offer complete SAP HANA Training. For complete course please visit http://www.tekvdo.com/course/sap-hana-online-training There are more SAP HANA Tutorials available in complete course. SAP HANA Training videos will help learning the module at your own pace.The best practice is to watch each video twice with the trainer and try to implement the same steps in your system. This way you will get a good grip in the module. Introduction to SAP HANA 1. Introduction to SAP HANA 2. Rapid Deployment options 3. Deployment Options Look and Feel (HANA Studio) 1. Administration perspective 2. Modeler perspective 3. Developer perspective 4. BW Tools 5. Navigator View 6. Quick launch screen Architecture Architecture Overview ......1. IMCE and Surroundings ......2. Row Store ......3. Column Store Persistent Layer Backup & Recovery Data Provisioning Method 1: Data loading from Flat files using HANA Studio Method 2: Data loading using Data Services 4.0 (ETL Based Approach) ......1. Data Services 4.0 Architecture in detail ......2. Data Stores in BODS ......3. BODS Objects and different components ......4. Building Data Flows in Designer (to Load the Data to SAP HANA) ......5. Query Transform in the Data Flow ......6. Loading the Data from diff files to SAP HANA using SAP BODS (Text files, spread sheets, XML files) ......7. Using Merge Transform, Date Generation Transform, SQL Transform, Pivot Transform ......8. Using Reverse Pivot, Match Transform, Case Transforms, Validation Transforms ......9. Using KEY Generation Transform, Table Comparison Transform ......10. Using History Preservation Transform ......11. Map operation Transform in BODS Data Flow to load the data to SAP HANA ......12. Creating Repository Users ......13. Creating a Local Repository ......14. Loading data from SAP ERP system to HANA. ......15. Loading the Data from Non-SAP Source Systems to SAP HANA using SAP BODS Method 3: Data provisioning using SLT (Real-time) ......1. Positioning and Key Concepts ......2. Overview on Configuration Aspects ......3. Selective Data replication Method 4: Data provisioning using Direct Extractor Connection (DXC) ......1. Using SAP provided Business Content Extractor ......2. ABAP Data Flows for Table and Pool clusters Method 5: Data provisioning using Sybase Replication (Real-time) ......1. Introduction to SRS ......2. How to perform real-time replication using SRS Using SQL in HANA Studio 1. Writing DDL statements 2. Writing DML statements 3. SQL Functions Modeling 1. Use of SAP HANA Studio 2. Different Modeling objects 3. Attribute Views 4. Different joins ......a. Inner ......b. Left Outer ......c. Right Outer ......d. Full Outer ......e. Text ......f. Referential and Union 5. Using Hierarchies (Level Based and Parent-Child Hierarchies) 6. Creating Calculated Column in Attribute View 7. Analytic Views 8. Calculation Views 9. Creating Advanced Calculation Views using GUI and SCRIPT methods 10. Creating Restricted and Calculated Measures 11. Using Filter Operations 12. Using Variables, input parameters 13. Currency Conversion for Measures 14. Export & Import: Server and Client sides 15. SQL Script and Procedures 16. Comparing Versions of Information Objects 17. Checking Model References 18. Generate Auto Documentation 19. Managing Modeling Content ......a. Manage Schemas ......b. Import and Export data Models ......c. Copy Information Objects Smart Data Access 1. Introduction 2. Configuring Oracle/SQL as SDA Source 3. Create Connection and virtual tables in HANA 4. Create Modeling objects in HANA Predictive Analytics Library 1. Introduction 2. Installation of PAL Library 3. Executing PAL algorithms in HANA Reporting 1. Introduction to reporting options on HANA 2. Introduction to SAP BOBI 4.1 3. Connectivity options to different BOBI tools 4. Busing Universes using Information Design Tool (IDT) 5. Reports creation using Web Intelligence 6. Crystal Report for Enterprise with HANA 8. Creating Analysis Views using Analysis edition for OLAP (HANA OLAP connection) 9. Using SAP Lumira as reporting tool 10. Others & MS Excel 2010 User Management & Data Security 1. Creation of Users 2. Creation of Roles 3. Creation of Role Hierarchy 4. Assignment of Users to Roles 5. Analytic Privileges New features in SAP HANA SP9 1. Advanced Data Processing 2. Dynamic Tiering 3. Enterprise Information Management 4. Smart Data Streaming 5. Spatial Analytics New Features in SPS10, 11 and 12 Support for SQL based Analytic Privileges (SPS10) Rank Node supporting output rank column (SPS10) Multiple default values for IPs, VARs (SPS10) SAP HANA Studio Development Perspective Core Data Services - CDS Support for CDS Entities as Data Source (SPS10) SQL-based Analytic Privileges with CDS (SPS11) Hierarchy Enhancements (SPS10) Time dependent hierarchies (SPS10)
Super Key, Candidate Key and Primary Key | Database Management System
 
09:49
The concept of Super Key Candidate Key and Primary Key and the conceptual difference. To ask your doubts on this topic and much more, click on this Direct Link: http://www.techtud.com/video-lecture/lecture-super-key-candidate-key-and-primary-key IMPORTANT LINKS: 1) Official Website: http://www.techtud.com/ 2) Virtual GATE: http://virtualgate.in/login/index.php Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share! Our Social Media Links: Facebook Page: https://www.facebook.com/techtuduniversity Facebook Group: https://www.facebook.com/groups/virtualgate Google+ Page: https://plus.google.com/+techtud/posts Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 319580 Techtud
Order by example in MySQL
 
02:05
This tutorial shows you how to write in MySQL for ordering the results in ascending or descending order. Check more details at http://www.roseindia.net/answers/viewqa/SQL/32385-Order-by-example-in-MySQL.html Check more tutorials at: http://www.roseindia.net/ http://www.roseindia.net/java/ http://www.roseindia.net/hibernate/ http://www.roseindia.net/struts/ http://www.roseindia.net/spring/ http://www.roseindia.net/ajax/ http://www.roseindia.net/jsp/
Views: 70 roseindiatutorials
Part 8.10 outer join full outer join left outer join right outer join complete outer join in sql in
 
06:01
Phone no: 9958021083 • Counselling Guruji is our latest product & a well-structured program that answers all your queries related to Career/GATE/NET/PSU’s/Private Sector etc. You can register for the program at: https://goo.gl/forms/ZmLB2XwoCIKppDh92 You can check out the brochure at: https://www.google.com/url?q=http://www.knowledgegate.in/guruji/counselling_guruji_brochure.pdf&sa=D&ust=1553069285684000&usg=AFQjCNFaTk4Pnid0XYyZoDTlAtDPUGcxNA • Check out our website http://www.knowledgegate.in/ • Please spare some time and fill this form so that we can know about you and what you think about us: https://goo.gl/forms/b5ffxRyEAsaoUatx2 • Your review/recommendation and some words can help validating our quality of content and work so Please do the following: - 1) Give us a 5 star review with comment on Google https://goo.gl/maps/sLgzMX5oUZ82 2) Follow our Facebook page and give us a 5 star review with comments https://www.facebook.com/pg/knowledgegate.in/reviews 3) Follow us on Instagram https://www.instagram.com/mail.knowledgegate/ 4)Follow us on Quora https://www.quora.com/profile/Sanchit-Jain-307 Outer Join • the join operations we studied earlier that do not preserve nonmatched tuples are called inner join operations, to distinguish them from the outer-join operations. The problem with natural join or join is only those values that appears in both relation will manage to reach final table, but if some value is explicitly in table one or in second table then that information will be lost, and that will be loss of information. • The outer join operation works in a manner similar to the join operations we have already studied, but preserve those tuples that would be lost in a join, by creating tuples in the result containing null values. • There are in fact three forms of outer join: o The left outer join (left join) preserves tuples only in the relation named before (to the left of) the left outer join operation. o The right outer join (right join) preserves tuples only in the relation named after (to the right of) the right outer join operation. o The full outer join preserves tuples in both relations. • In contrast, the join operations we studied earlier that do not preserve nonmatched tuples are called inner join operations, to distinguish them from the outer-join operations. outer join sql,outer join in dbms,outer join vs inner join,outer join inner join left join right join,outer join and inner join in sql,outer join sql in hindi,left outer join sql,left outer join vs right outer join,left outer join sql server,left outer join and right outer join with examples,left outer join sql example,right outer join sql,right outer join left outer join,full outer join in sql,full outer join in sql in hindi,full outer join in hindiouter join sql,outer join in dbms,outer join vs inner join,outer join inner join left join right join,outer join and inner join in sql,outer join sql in hindi,left outer join sql,left outer join vs right outer join,left outer join sql server,left outer join and right outer join with examples,left outer join sql example,right outer join sql,right outer join left outer join,full outer join in sql,full outer join in sql in hindi,full outer join in hindiouter join sql,outer join in dbms,outer join vs inner join,outer join inner join left join right join,outer join and inner join in sql,outer join sql in hindi,left outer join sql,left outer join vs right outer join,left outer join sql server,left outer join and right outer join with examples,left outer join sql example,right outer join sql,right outer join left outer join,full outer join in sql,full outer join in sql in hindi,full outer join in hindiouter join sql,outer join in dbms,outer join vs inner join,outer join inner join left join right join,outer join and inner join in sql,outer join sql in hindi,left outer join sql,left outer join vs right outer join,left outer join sql server,left outer join and right outer join with examples,left outer join sql example,right outer join sql,right outer join left outer join,full outer join in sql,full outer join in sql in hindi,full outer join in hindiouter join sql,outer join in dbms,outer join vs inner join,outer join inner join left join right join,outer join and inner join in sql,outer join sql in hindi,left outer join sql,left outer join vs right outer join,left outer join sql server,left outer join and right outer join with examples,left outer join sql example,right outer join sql,right outer join left outer join,full outer join in sql,full outer join in sql in hindi,full outer join in hindi
Views: 973 KNOWLEDGE GATE