Home
Search results “Oracle lookup table”
How to Use Look Up Tables in ORACLE APPS R12 | Class 06
 
16:00
This videos displays How to Use Look Up Tables in ORACLE APPS
Database - Lookup Tables
 
14:01
Demonstrates multiple methods of handling lookup in databases
04 of 13 - Oracle APEX 5 - Generate a lookup table; set uniqueness constraint on field
 
08:26
A new series using APEX 18.1 is now available. https://youtu.be/lONi8Ig1sLg This is one video in a series about APEX 5. In this video we use the APEX wizard for generating a lookup table from data in a column in an existing table. Next, we set a uniqueness constraint on a column. Finally, we update the status of to-do tasks in the Team Development component of APEX. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 26446 Jennifer Kreie
How to use lookup table in oracle Apex
 
03:29
How to use lookup table in oracle Apex (Arabic)
Views: 383 ali saleh ali
Database Design 22 - Look up Table
 
16:53
Donate!: http://bit.ly/DonateCTVM2. A look up table is a table with a list of all possible values for a column in a different table. These values are then accessed through a foreign key. This is often used for one to many relationships where the many has only so many possibilities. More content: http://CalebCurry.com Courses for Download: http://www.udemy.com/u/calebcurry/ Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://Twitter.com/calebCurry Subscribe (it's free!): http://bit.ly/PqPyvH Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 41199 Caleb Curry
ORACLE DATA INTEGRATOR ODI Lookup & Aggregate components
 
01:00:18
ORACLE DATA INTEGRATOR ODI Lookup & Aggregate components
Views: 1866 srinu bondada
Practical 6 : Creating ETL Mappings- Part 5:Counties & Lookup table and Cube mapping | Oracle 11g DW
 
30:10
Creating ETL Mappings In Oracle 11g Data Warehousing and the 5th part is Counties table , Look-up table and Cube mapping. Data Warehousing part 5 of 6th Practical of Third Year B.Sc.IT. One Solution to all your queries for the Oracle Warehouse builder 11g. --------------------------------------------------------------------------------------------- NOTE : All content used is copyright to ProgrammingFiesta Use or commercial display or editing of the content without proper authorization is not allowed.0
Views: 460 PROGRAMMING FIESTA
ORACLE DATA INTEGRATOR ODI Lookup Component
 
46:29
ORACLE DATA INTEGRATOR ODI Lookup Component
Views: 702 srinu bondada
Advanced Data Masking with Oracle Database
 
59:39
Database Security Product Managers Manish Choudhary and Hakim Loumi lead this session on advanced masking formats. We'll dive into some of the more interesting masking techniques including conditional masking, deterministic masking, masking columns by group, the use of lookup tables, user-defined masking functions, and much more. 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
Views: 134 Oracle Developers
Use Lookups in Oracle Integration
 
00:54
Create lookup tables to map static values between different applications in Oracle Integration. ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll and http://docs.oracle.com. Copyright © 2017 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.
Database - Complex Queries - Aggregation and Lookup Tables
 
09:53
Demonstrates using lookup tables, category and code management, and use of aggregation to do complex aggregation queries using GROUP BY SQL operator.
Como crear Lookup Tables en Oracle Apex
 
06:14
Mi nombre es Alexis, soy un Oracle Certified Professional(OCP) en PLSQL, me encanta el mundo de Oracle en especial PLSQL y Oracle Apex. En este Video se mostrara como crear Lookup Tables con Oracle Apex. Cualquie duda o tema que te gustaria que hiciera un video puedes dejarlo en los comentarios. Creación del Ambiente Apex en Docker: https://github.com/martindsouza/docker-oracle-setup Mis redes Sociales. Blog: plsqladvices.blogspot.com LinkedIn: linkedin.com/in/alexisgaldamezplsql Twitter: twitter.com/alexiswcg Gmail: [email protected]
Views: 106 Alexis Galdamez
SFC_APEX_1.3_Create Lookup Table_SQL Workshop_120130_0.1
 
03:50
SFC บทเรียน : Oracle Application Express (APEX) บทที่ 1 : SQL Workshop ตอนที่ 3 : Create Lookup Table วันที่ Update ล่าสุด : 30 มกราคม 2012 เวอร์ชั่น : 0.1
Views: 145 sfc cloudgroup
SQL Tutorial - 13: Inserting Data Into a Table From Another Table
 
07:00
In this tutorial we'll learn to use the INSERT Query to copy data from one table into another.
Views: 280707 The Bad Tutorials
Oracle Database 12c: Partitioning Improvements with Tom Kyte
 
08:08
Tom Kyte introduces the new partitioning improvements in Oracle Database 12c, followed by a demo of global index maintenance. For more information: "Asynchronous Global Index Maintenance for Dropping and Truncating Partitions" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=VLDBG14107 "Changes for Very Large Databases and Partitioning in Oracle Database 12c Release 1" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=VLDBG14100 "ALTER INDEX COALESCE Clause" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF52782 "DBMS_PART.CLEANUP_GIDX Procedure" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=ARPLS74409
Views: 14498 OracleDBVision
Informatica Training - Basic Populating CSV to Oracle Table Part 2 of 20
 
10:41
Bharati DW Consultancy cell:+1+562-646-6746 email: [email protected] website: http://bharaticonsultancy.in/ Informatica Basic Tutorial Cognos Training, Informatica Training, Qlikview Training, Tableau Training Cognos Tutorial, Informatica Tutorial, Qlikview Tutorial, Tableau Tutorial Loading CSV File into database table. ETL Flat file in database table, Informatica transformation tutorial, Informatica self learning, Informatica Powercenter CONTACT for remaining videos.
Views: 13394 BharatiDWConsultancy
Upsert Data into SQL Server and Oracle 700x Faster with SSIS
 
03:37
Conditionally insert or upsert data with SSIS into SQL Server and Oracle 700x faster with Task Factory's Upsert Destination. Learn how to configure the component in this video where we show you the SQL Server Integration Services pattern for upserting data the old and new way.
Views: 4363 Pragmatic Works
Oracle APEX 4.2.4 Tutorial (05 of 22) - Create a table using Object Browser and define a constraint
 
04:57
APEX 4.2.4 is out of date. Please try the APEX 18.1 video series. https://youtu.be/65LExgaQMHI See how to use Object Browser in APEX's SQL Workshop to create a table. How to add a constraint to field in a table is also shown. In this example a uniqueness constraints is added to a field.
Views: 20246 Jennifer Kreie
Beginners Informatica Powercenter 9x - Lookup, Router transformation tutorial 6
 
15:35
This video covers below:- --Create a Type1- SCD Slowly changing dimension (Insert Only) Informatica Powercenter 9x mapping using Connected Lookup and Router transformations for beginners series --Load an Oracle database target table --Create an Oracle relational database connection --Create a session and workflow for the corresponding mapping --Successfully running the corresponding workflow
Views: 32635 GoGeeko
Sharing Information Between Applications with Lookups in Oracle Integration Cloud Service
 
02:34
This video covers the challenges you face sharing information between applications and how you can share data easily using Integration Cloud Service. For the full online course, see Getting Started with Oracle Integration Cloud Service. https://apexapps.oracle.com/pls/apex/f?p=44785:141:129062268928964::NO:141:P141_PAGE_ID,P141_SECTION_ID:308,2411 ================================= For more information, see http://www.oracle.com/goto/oll 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.
MySQL Database Tutorial - 22 - How to Join Tables
 
08:29
Facebook - https://www.facebook.com/TheNewBoston-464114846956315/ GitHub - https://github.com/buckyroberts Google+ - https://plus.google.com/+BuckyRoberts LinkedIn - https://www.linkedin.com/in/buckyroberts reddit - https://www.reddit.com/r/thenewboston/ Support - https://www.patreon.com/thenewboston thenewboston - https://thenewboston.com/ Twitter - https://twitter.com/bucky_roberts
Views: 360915 thenewboston
08 of  13 - Oracle APEX 5 - List of values (LOV) for a field in a form; display a hidden column
 
13:22
A new series using APEX 18.1 is now available. https://youtu.be/vgrkiIpJEiQ This is one in a series of videos about creating an application using Oracle APEX 5. In this video we create two lists of values (LOVs) in the Shared Components section of our application. We use each LOV in place of a field in a form. We see how APEX will help us write the SQL for a LOV. The difference between a "display value"and a "return value"is discussed. Finally, we display the primary key field in a form, which APEX hides by default. See the primary key field in a form can be helpful during application development. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 41562 Jennifer Kreie
oracle apex course session 1 part 2
 
01:13:16
vision pharma project SQL workshop lookup table
Views: 2088 ali saleh ali
Oracle Database 12c: Adaptive Execution Plans with Tom Kyte
 
05:42
Tom Kyte introduces adaptive execution plans followed by a demo. "Adaptive Plans" in SQL Tuning Guide" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=TGSQL221 "Controlling Adaptive Optimization" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=TGSQL257 "Generating and Displaying SQL Execution Plans" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=TGSQL271 "Keeping Your Database Secure" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=DBSEG009
Views: 14632 OracleDBVision
Manage Lookups in Oracle Fusion HCM
 
06:02
http://www.apps2fusion.com - A video tutorial by Jayashree Prakash. This article covers the topic of Managing Lookups in Oracle Fusion HCM
Views: 4676 apps2fusion
What is a HashTable Data Structure - Introduction to Hash Tables , Part 0
 
07:37
This tutorial is an introduction to hash tables. A hash table is a data structure that is used to implement an associative array. This video explains some of the basic concepts regarding hash tables, and also discusses one method (chaining) that can be used to avoid collisions. Wan't to learn C++? I highly recommend this book http://amzn.to/1PftaSt Donate http://bit.ly/17vCDFx STILL NEED MORE HELP? Connect one-on-one with a Programming Tutor. Click the link below: https://trk.justanswer.com/aff_c?offer_id=2&aff_id=8012&url_id=238 :)
Views: 833956 Paul Programming
Oracle APEX Tutorial 13 - Constraints Using Alter Table
 
05:56
Hi! I’m Abdulrhman Uthman, a student of King Faisal University in Saudi Arabia. This series is intended for the practical class of Database Concepts students in our university, but anyone who wants to learn database, SQL or Structured Query Language and use Oracle’s APEX are welcome aboard. In this video we will discuss SQL’s constraints by recalling our DDL statements for altering tables. We will use Alter Table to add and drop a constraint. This video is related to Lesson 12, so make sure you have done that before continuing here. I would like to acknowledge the following people for their support: Dr. Majed Alshamari, Dr. Mohammed Bonais, Dr. Abdullah Alaulaimie, Dr. Mohammed Al-Naeem, Mr. Ahmed Alshawayrid, Mr. Naif Bo-Hasan, Mr. Mohammed Tawfiq, my sister, Ms. Reem Uthman, and my brother, Anas Uthman for editing the video.
Views: 1081 Abdulrhman Uthman
SQL Tutorial - PIVOT
 
13:11
Another video brought to you by BeardedDev, bringing you tutorials on Business Intelligence, SQL Programming and Data Analysis. In this video I talk about using PIVOT in Microsoft SQL Server. T-SQL Querying https://www.amazon.com/gp/product/0735685045/ref=as_li_tl?ie=UTF8&camp=1789&creative=9325&creativeASIN=0735685045&linkCode=as2&tag=beardeddev05-20&linkId=e93b0f7483b1fa06aca5a3aec4f7764b T-SQL Fundamentals https://www.amazon.com/gp/product/150930200X/ref=as_li_tl?ie=UTF8&camp=1789&creative=9325&creativeASIN=150930200X&linkCode=as2&tag=beardeddev05-20&linkId=70aa2ffa3e84cab66cb964ca1e9cee62 Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions https://www.amazon.com/gp/product/0735658366/ref=as_li_tl?ie=UTF8&camp=1789&creative=9325&creativeASIN=0735658366&linkCode=as2&tag=beardeddev05-20&linkId=b88746aea666c9f98da147e70b4491ca Using PIVOT allows us rotate data from rows to columns making the data more readable. PIVOT is ideal for reporting in SQL Server and can be used as a starting point to visualise trends. In this PIVOT tutorial I demonstrate the difference between how data is presented compared to GROUP BY. PIVOT Syntax SELECT [columns] FROM ( [source_query] ) PIVOT ( [aggr_function]([aggr_column] FOR [spreading_column] IN ([spreading_elements])) SQL Queries in the video: Results using GROUP BY statement SELECT Sales_Customer_Id , DATENAME(MONTH, Sales_Date) AS [Month] , Sales_Amount FROM dbo.Sales GROUP BY Sales_Customer_Id , DATENAME(MONTH, Sales_Date) Results using PIVOT statement SELECT Sales_Customer_Id , [January] , [February] , [March] FROM ( SELECT Sales_Customer_Id , DATENAME(MONTH, Sales_Date) AS [Month] , Sales_Amount FROM dbo.Sales ) AS Src PIVOT ( SUM(Sales_Amount) FOR [Month] IN ([January], [February], [March]) ) AS Pvt Alternative PIVOT statement SELECT [Month] , [1] , [2] , [3] , [4] , [5] , [6] , [7] , [8] FROM ( SELECT Sales_Customer_Id , DATENAME(MONTH, Sales_Date) AS [Month] , Sales_Amount FROM dbo.Sales ) AS Src PIVOT ( SUM(Sales_Amount) FOR Sales_Customer_Id IN ([1], [2], [3], [4], [5], [6], [7], [8]) ) AS Pvt Please feel free to post comments.
Views: 6989 BeardedDev
SSIS Tutorial Part 60-Perform Upsert  (Update/Insert  SCD1) by Lookup Transformation in SSIS Package
 
23:07
SSIS Tutorial Scenario: Let's say we have to load a dimension table from text file. Our business Key is SSN. We need to insert new records depending upon values of SSN column, If any new then we need to insert this records. If SSN already existing in Table then we need to find out if any other column is changed from Source columns values. If that is true then we have to update those values. What we will learn in this video How to Read the data from Flat file in SSIS Package How to perform Lookup to Find out Existing or Non Existing Records in Destination Table From Source How to Insert new Records by using OLE DB Destination How to update existing Records by using OLE DB Command Transformation in SSIS Package Link to the blog post for this video with script if used http://sqlage.blogspot.com/2015/05/perform-upsert-updateinsert-scd1-by.html Check out our Full Step by Step SQL Server Integration Services(SSIS) Tutorial http://www.techbrothersit.com/2014/12/ssis-videos.html
Views: 37899 TechBrothersIT
Oracle SQL Tutorial 11 - CREATE TABLE
 
05:04
The way you create a table is to use the CREATE TABLE command. CREATE TABLE users() So in this situation, the name comes right after the TABLE keyword. The next thing we do is put all of the columns on a line that we want to put in our table. CREATE TABLE users( user_id, username, first_name, last_name ) Notice the naming conventions here. For this series we are going to make columns with what is known as snake casing. This is where each individual word is separated by an underscore. if you have more than one column, all of them have to have commas except the last one. The comma is a way to say that another column is coming, so you don't need to do it on the last one. Now you would think we were done, but we also have to say what data type each column is. Later we will extensively discuss data types so we can focus on them exclusively. For now, here are the data types we are going to use: CREATE TABLE users( user_id NUMBER, username VARCHAR2(50), first_name VARCHAR2(50), last_name VARCHAR2(50) ) Now, inside of the parenthesis for varchar2, we pass in a number... This is the max length of the string. But the question is, what is it measured in? The default is actually in bytes, not characters. For example if we have the string hello, it is 5 characters, but it might take up a total of 10 bytes of storage. So I would recommend adding the keyword char right after the number so it defaults to 50 characters, not bytes. CREATE TABLE users( user_id NUMBER, username VARCHAR(50 CHAR), first_name VARCHAR2(50 CHAR), last_name VARCHAR2(50 CHAR) ) This will work to create a table, but it's really missing a lot of information… which column is the primary key? Are we adding any indexes? Is there any thing else we need to say about these columns? So as you can tell, we are making progress, but there is still so much to learn. The biggest gotcha to remember from this video is that the data type VARCHAR ends in a 2, stupid, right? who would end the name of something with a 2? Once again, this is Caleb from CalebTheVideoMaker2, and we will catch you in the next one! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 43843 Caleb Curry
06 of  13 - Oracle APEX 5 - Define UI (user interface) defaults; modify a navigation menu item
 
12:04
A new series using APEX 18.1 is now available. https://youtu.be/9_2Hxi7rANw This is one in a series of videos about creating an application using Oracle APEX 5. In this video we look at the user interface (UI) defaults for columns in tables and how to change these. Changing UI defaults to user-friendly text will help make APEX-generated reports and forms easier to read and use. We also look at how to change a navigation menu item so that it opens a different report page. This edit is done in the Shared Components section of APEX. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 45887 Jennifer Kreie
Step By Step to Create Table With Oracle Application Express 5
 
05:52
In relational database we will need to create several tables that is related by its primary key and foreign key. Oracle Application Express 5 (APEX 5) possess ability to create table using Graphical User Interface (GUI) that will ease user effort on creating table. This video will describe step by step process of creating relational table on Oracle database using Oracle Application Express 5. Please Subscribe
Views: 1867 Boby Siswanto
13 of  13 - Oracle APEX 5 - Views with one-sided and full outer joins; make pages public
 
21:25
A new series for APEX 18.1 is available. https://youtu.be/vXkNH3ktdaI This is one in a series of videos about creating an application using Oracle APEX 5. In this video we create a view that uses one-sided outer joins to show ALL records from one table and any related records from other tables. We use a full outer join to to show ALL records in both tables. (By default, when you join 2 tables you only see records that are related between the two tables.) Next, we modify the main navigation menu. Last, we make some pages public so no login is required to view these pages. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 14915 Jennifer Kreie
OSIsoft: Configuring Table Lookup Data References [v2.9.5.8368]
 
08:52
Learn three methods of using Table Lookup Data References. [00:27] Discussion of three Table Lookup Data Reference examples to be configured [01:26] -LOOKUP NAME OF PUMP MANUFACTURER IN AN INTERNAL TABLE- [01:55] Create New Attribute Template [02:15] Look at internally stored Table containing Pump Manufacturer data [02:45] Configure Table Lookup Data Reference [03:02] Configure WHERE Clause using Substitution Parameters [04:00] -USE PARAMETERIZATION TO PASS @NAME VARIABLE TO EXTERNALLY LINKED TABLE- [04:18] View setup of Externally Linked Table to be used with Parameterization (@Name variable linked to Manufacturer column in External Table) [05:30] Use Table Parameters in Table Lookup Data Reference dialog box to link @Name variable to Pump Manufacturer Attribute [06:30] -INTERPOLATE BETWEEN TABLE DATA- [06:46] View Oil Temperature Table [07:39] Configure WHERE Clause to use INTERPOLATE Video content is copyright of OSIsoft, LLC © 2018. All rights reserved. Any redistribution or reproduction of part or all of the contents in any form is prohibited other than for your personal and non-commercial use.
Views: 903 OSIsoft Learning
Lookups in oracle data Integrator 11g v1
 
04:40
Get Certified in ODI: It's my birthday month, and I'd like you to join me in celebrating. I'm offering my ODI 11g Hands on Video Tutorials course with 3 Practice tests to get certified in ODI for 50% off The price is approx 5799 rupees ($99) after discount. Please use the below link to get 50% discount https://www.udemy.com/odi11gvideos/?couponCode=ODIGURU Please contact for online ODI training [email protected] www.odigurus.com
12 of  13 - Oracle APEX 5 - Master-detail-detail form; add hyperlink to open another form
 
21:34
A new series for APEX 18.1 is available. https://youtu.be/vlPxEuYnt1Q This is one in a series of videos about creating an application using Oracle APEX 5. In this video we create a master-detail form with two detail sections. We add a hyperlink to each detail section and these open other forms in the application. Finally, we add a button to the master form and configure it to open another form to a specific record. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 36077 Jennifer Kreie
ORACLE DATA INTEGRATOR  12C Joins with example
 
06:18
HOW TO JOINS PERFORM IN ORACLE DATA INTEGRATION
Views: 5927 pattil reddy
APEX01 of 30: Create a schema in Oracle XE and create a workspace in APEX
 
07:21
APEX 18.1 video 1 of 30: This video shows the commands used to create a schema (account) in Oracle XE and how to create a workspace in APEX that uses that schema. Scripts for the videos are at: http://db.kreie.net
Views: 2688 Jennifer Kreie
How to register table in oracle apps | Oracle Shooter
 
10:20
#oracleshooter #table #registertable Full Blogs Link :- https://oracleshooter.blogspot.com/2019/05/register-table-in-oracle-apps.html Contact Info :- Instagram:- https://www.instagram.com/oracleshooter Facebook :- https://www.facebook.com/oracleshooter Twitter :- https://twitter.com/oracleshooter Blogger :- https://oracleshooter.blogspot.com/ Email Id :- [email protected]
Views: 32 Oracle Shooter
Oracle Database 12c: Creating a Unified Audit Policy
 
04:25
Overview and demo of using a unified audit policy to audit database behaviors, database components, and database users. "Monitoring Database Activity with Auditing" in Oracle Database Security Guide: http://www.oracle.com/pls/topic/lookup?ctx=db121&id=CCHEHCGI "Auditing Database Activity" in Oracle Database 2 Day + Security Guide: http://www.oracle.com/pls/topic/lookup?ctx=db121&id=BCGGIAIC "Keeping Your Oracle Database Secure" in Oracle Database Security Guide: http://www.oracle.com/pls/topic/lookup?ctx=db121&id=CHDCEBFA
Views: 2815 OracleDBVision
05 of  13 - Oracle APEX 5 - Create an application; create a form with interactive report
 
14:51
A new series using APEX 18.1 is now available. https://youtu.be/8P0OdAHpxFQ This is one video in a series about APEX 5. In this video we generate an application in APEX (a container for the application design elements) and we look at the difference in theme styles for an application. Next, we create a form with report which actually creates two pages--one for the form and one for the report. The report is interactive and has many readily available features for filtering, sorting, grouping, etc. The form allows a new record to be created and updates to an existing record. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 62842 Jennifer Kreie
Filter Column Data according to another Table Column | SQL | Oracle ExpressEdition Tutorials
 
00:50
Learn to filter a table's column data in output based on another table's column data. How is this done? -- Using the LIKE operator when we have to deal with strings (char/varchar/varchar2). Here's the query: ----------------------------------------------------------------------------------------------------------- select emp1.empid, empname, dept1.deptid, dept1.city from dept1 inner join emp1 on(emp1.deptid = dept1.deptid) where dept1.city in (select emp1.city from emp1) or dept1.city like (emp1.city || '%'); ----------------------------------------------------------------------------------------------------------- Here the tables are joined using the inner join on the department IDs as they are not related by the foreign key constraint. The LIKE Operator and the wildcard character % helps to filter the string data here. The first section of the where clause is to filter the exact names of cities. Removing this will remove 'california' from the result. This can be very useful to filter candidate names or locations or any string data which is present in two tables. Hop on to learn more! Subscribe to my channel to learn new Oracle/SQL tips and tricks to obtain a particular output. Use the Oracle Express Edition for quick learning! Check out my other videos: -------------------------------------------------- Clone an Oracle table using SQL: https://youtu.be/8MICKuNoT1w Add Primary Key to Existing Table: https://youtu.be/DgGoedEBLoU Create an Application Workspace: https://youtu.be/Tl9hddgUSdI Download the latest Oracle Express Edition release here: http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html Follow me on Instagram: https://www.instagram.com/the_perfect_tutorials/ Follow me on Facebook: https://www.facebook.com/theperfecttutorials Sound: Bensound
Oracle Database 12c: Better PL/SQL From SQL
 
02:33
Overview and demonstration of using the plsql_declarations clause to embed a PL/SQL function in a SQL SELECT statement. "plsql_declarations" in Oracle® Database SQL Language Reference http://www.oracle.com/pls/topic/lookup?ctx=db121&id=BABJCBCC
Views: 2899 OracleDBVision
How to Create Data Load for Apex  5.1 ?
 
02:36
Developer : Md.Abdullah Al Mamun Contact : 01827712531
Views: 4002 Oracle Apex
02 of  13 - Oracle APEX 5 - Run SQL scripts to create tables, sequences, triggers and insert data
 
09:07
A new series using APEX 18.1 is now available. https://youtu.be/acnRWpRSrbI This video in the APEX 5 tutorial series shows how to use SQL Scripts (part of SQL Workshop) to run scripts that create tables, sequences (to generate unique values for primary keys), triggers and insert data (INSERT INTO statements). SQL scripts for this series are available to download at: http://db.kreie.net
Views: 52983 Jennifer Kreie
03 of  13 - Oracle APEX 5 - Create a table; set a uniqueness constraint on a field; import data
 
10:37
A new series using APEX 18.1 is now available. https://youtu.be/acnRWpRSrbI This is one in a series of videos for an APEX 5 tutorial. In this video we see how to create a database table using APEX. Then we set a uniquenss constraint for a field in an existing table. Finally, we import data from a CSV file into a table. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 35758 Jennifer Kreie
Oracle Identity Manager Training -- Session 1
 
01:08:34
Hello Guys, I have started my training classes on Oracle Identity Manager. If anyone wants to join can ping me or call me on my whatsapp no +91-9046881874. Please find the course details below:- Course Overview:- The course "Learn Oracle Identity Manager" is designed for students with little or no background in Oracle Identity Manager. The course start with very basic and then gradually move on to the very advanced topic in Oracle Identity Manager. Course Content:- Module 1:- Overview of Oracle Identity Manager  Overview of Oracle Identity Manager  Consoles in Oracle Identity Manager Module 2:- Starting and Stopping the Service  WebLogic Start/Stop  OIM Start/Stop  SOA Start/Stop  BI Publisher Start/Stop Module 3:- Provisioning and Reconciliation  Provisioning  Reconciliation  Types of Reconciliation  Managing Reconciliation Events Module 4:- Managing Forms  Creating  Searching  Modifying Module 5:- Application Instances  Application Instance Concept  Managing Application Instances  Configuring Application Instances  Developing Entitlements Module 6:- Lookup  Creating  Searching  Modifying Module 7:- Access Policies  Creating Access Policy  Managing Access Policy  Provisioning Multiple Instances of the same resource.  Troubleshooting issues with Evaluate User Policy Job Module 8:- Approval Policies  Understanding Workflow rules  Configuring Approval Workflow rules Module 9:- Disconnected Applications  Disconnected Application Architecture  Managing Disconnected Application instance  Provisioning Operation on a Disconnected Application  Managing Entitlement Module 10:- Connectors  Connector Life Cycle  Installation  Cloning a Connector Module 11:- Understanding OOTB Schedulers  Architecture about ENT List and ENT Assignment  Catalog Sync  Evaluate User Policy  Sun set and Sun rise Module 12:- Understanding Database tables  Request Related tables  Entitlement Related tables  Application instance Related tables  User Related tables  Approval and access policy related tables  Workflow related tables  Provisioning and Reconciliation related tables Advanced Topics 1. OIM and LDAP Integration 2. OIM and UNIX Server Integration 3. OIM and Database Server Integration 4. Adding Custom Attributes in OIM 5. UI Customization Basics 6. OIM API Basics For sample videos do reach on my YouTube channel. For more info do reach me on WhatsApp +91-9046881874 or write me on [email protected] or [email protected]
Views: 12748 Amit Kumar Gupta
Oracle APEX Tutorial 29   SQL's SELECT with JOINing of 3, 4 or 5 Tables
 
04:05
Hi! I’m Abdulrhman Uthman, a student of King Faisal University in Saudi Arabia. This series is intended for the practical class of Database Concepts students in our university, but anyone who wants to learn database, SQL or Structured Query Language and use Oracle’s APEX are welcome aboard. In this video, we will try to JOIN 3, 4, and even 5 tables I would like to acknowledge the following people for their support: Dr. Majed Alshamari, Dr. Mohammed Bonais, Dr. Abdullah Alaulaimie, Dr. Mohammed Al-Naeem, Mr. Ahmed Alshawayrid, Mr. Naif Bo-Hasan, Mr. Mohammed Tawfiq, my sister, Ms. Reem Uthman, and my brother, Anas Uthman for editing the video.
Views: 2364 Abdulrhman Uthman
11 of  13 - Oracle APEX 5 - Create simple and complex views; compare classic and interactive reports
 
16:52
A new series for APEX 18.1 is available. https://youtu.be/jYaOyiUWnk0 This is one in a series of videos about creating an application using Oracle APEX 5. In this video we create some simple views that combine information from two tables. We create a more complex view that uses other views and tables. We use these views to create a classic APEX report and then an interactive APEX report. A few options from the interactive report are demonstrated. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 17635 Jennifer Kreie