Home
Search results “Oracle tree structure”
Hierarchical Queries: Databases for Developers #16
 
09:38
Often data contains a parent-child relationship between rows in the same table. For example, company org charts and family trees. You can use the power of SQL to traverse these hierarchical relationships. There are two ways to do this in Oracle Database: - Connect By - Recursive With Watch this video to learn about data trees and find out how these work! Further reading: Hierarchical queries in the docs: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Hierarchical-Queries.html#GUID-0118DF1D-B9A9-41EB-8556-C6E7D6A5A84E Recursive subquery factoring in 11.2: https://oracle-base.com/articles/11g/recursive-subquery-factoring-11gr2 Take the course! https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-next-level.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: 2163 The Magic of SQL
Indexing in Oracle :B-Tree,Bitmap Indexing
 
25:48
This Video is the 1st tutorial in the video series Indexing in Oracle , The video series explains in detail, What are indexes?It's types, what index should be used in which scenario and other important thing in basic terminology. Note :You may want to watch the video with a higher playback speed(1.25 if it suits you more)
Views: 11870 Tech Coach
B*Tree Index Fundamentals(Indexes in Oracle-1)
 
17:42
Part -1 : Introduction to Indexes, B*Tree Indexes, Index scan methods. Part -2 : B*Tree Index Types(different types of B*Tree indexes) Part -3: Using B*Tree Indexes(When use B*Tree indexes, factors related to B*Tree Access) Part -4 : Index Organized Table Part -5 : Bitmap Indexes Part -6: Partitioned Indexes Part- 7: Other type of Indexes based on characteristics & use. Part -8: Managing Indexes
Views: 48858 Anindya Das
B-Tree Indexes
 
04:33
In this video, I'd like to take a look at B-tree indexes and show how knowing them can help design better database tables and queries.
Types of Indexes (A B-tree index,A bitmap index )
 
27:18
Hi guys today is very most important topic in oracle is INDEXES help to increase performance at the time of search and modification into table records. #TypesofIndexes #B-treeindex#bitmapindex
Views: 27855 Oracle World
Oracle Database Storage Structure
 
06:37
In this video i'm going to describe Oracle Storage Structure, how to store Data in Database if it is useful for you so please like my video and subscribe my channel and if you want to give any suggestions to please write in comment box.
Views: 2913 OCP Technology
SCPT 10: Introduction to Oracle Memory Structure
 
07:56
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 51556 Oresoft LWC
Oracle Hints Tutorial for improving performance with examples
 
11:16
Oracle Hints Tutorial for improving performance with examples Oracle Hints Oracle Tutorial for beginners SQL Tutorial for beginners SQL Hints SQL Performance tuning
Views: 2420 TechLake
07 02 B Tree Indexes
 
04:55
ORACLE
Views: 1952 oracle ocm
Trading Community Model | Managing Geography Structures, Hierarchies, and Validation
 
03:05
This video tutorial applies to Rel 10 through Rel 12. It shows you how to manage the geography structure, hierarchy, and validation for a country.
Oracle Multi Org Structure Step 1 (Company Hierarchy)
 
09:10
TRAINING KEY POINTS: End-to-End Implementation (Setup Steps) Real-time Examples (AIM Documents) Technical RICE Components (Reports, Interfaces, Conversions, Enhancements) Period End Process Study Material Support Availability Assistance in Making CV Online and Class Room Training Regular, Fast Track and Weekends By KIRAN KUMAR Having 9+ Years Real Time Experience https://in.linkedin.com/in/oracle-scm-financials-training VISIT FOR FULL COURSE CONTENT: WWW.PERUSETECHNOLOGIES.COM PH: +91-954 288 1790, +91- 789 393 0068, www.perusetechnologies.com, E-mail: [email protected]
How to Manage Account Hierarchy in Fusion Financials Cloud
 
05:42
This Fusion Financials Tuorial gives a demo on how to build an accounts hierarchy through by specifying definition, levels & Access Rules. The trainer shows how to create parent & child account and validate them. Enroll for our complete trainings at: www.apps2fusion.com/packages Also, visit us at : http://apps2fusion.com/ Contact us at: t[email protected] or +44-207-193-5456 | +1-650-318-5241
Views: 2561 apps2fusion
Oracle Indexes - Beginner
 
12:12
Oracle Indexes - Beginner
Views: 64552 Chris Ostrowski
Grandparent, parent and child hierarchy SQL server or Bread Crumb
 
21:21
In this video general concept of getting parent child records and also hierarchy bread crumb generation is done also along with this exceptions which generally comes while making recursive CTE are also discussed and showed how to solve them. To get script of table as well as queries please check link below: http://www.techsapphire.in/index/grandparent_parent_and_child_hierarchy_sql_server_or_bread_crumb/0-170
Views: 14462 techsapphire
How to use Account Hierarchy Manager to maintain account structure in Oracle eBS GL?
 
06:01
I found Account Hierarchy Manager feature as a friendly and more flexible way to maintain accounting flex field structure for both adding new child or parent values to hierarchy and changing hierarchy structure. Hierarchy export functionality is also included in case you need to save for later reference or for offline review. For those interested about this subject I create below video following next steps: Step 1 - Open Account Hierarchy Manager (AHM) under GL responsibility Step 2 - Select desired account structure and open natural account segment Step 3 - Move child values from one parent to a different parent Step 4 - Arrange your screen for a better view over values properties Step 5 - Create a new account under an existing parent Step 6 - Export hierarchy for selected parent Step 7 - Drag and drop child between hierarchies Step 8 - Just checking that changes are visible into standard screen Account Hierarchy Manager setup overview For other interesting post visit http://oracle-ebs-hands-on.blogspot.com
Views: 2923 Oracle EBS Hands-On
Part 2   SQL query to get organization hierarchy
 
10:14
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-2-sql-query-to-get-organization.html To get the best out of this video, the following concepts need to be understood first. These are already discussed in SQL Server Tutorial. 1. Self-Join - http://www.youtube.com/watch?v=qnYSN_7qwgg 2. CTE - http://www.youtube.com/watch?v=ZXB5b-7HJHk 3. Recursive CTE - http://www.youtube.com/watch?v=GGoV0wTMCg0 Here is the problem definition: 1. Employees table contains the following columns a) EmployeeId, b) EmployeeName c) ManagerId 2. If an EmployeeId is passed, the query should list down the entire organization hierarchy i.e who is the manager of the EmployeeId passed and who is managers manager and so on till full hierarchy is listed. For example, Scenario 1: If we pass David's EmployeeId to the query, then it should display the organization hierarchy starting from David. Scenario 2: If we pass Lara's EmployeeId to the query, then it should display the organization hierarchy starting from Lara. We will be Employees table for this demo. SQL to create and populate Employees table with test data Create table Employees ( EmployeeID int primary key identity, EmployeeName nvarchar(50), ManagerID int foreign key references Employees(EmployeeID) ) GO Insert into Employees values ('John', NULL) Insert into Employees values ('Mark', NULL) Insert into Employees values ('Steve', NULL) Insert into Employees values ('Tom', NULL) Insert into Employees values ('Lara', NULL) Insert into Employees values ('Simon', NULL) Insert into Employees values ('David', NULL) Insert into Employees values ('Ben', NULL) Insert into Employees values ('Stacy', NULL) Insert into Employees values ('Sam', NULL) GO Update Employees Set ManagerID = 8 Where EmployeeName IN ('Mark', 'Steve', 'Lara') Update Employees Set ManagerID = 2 Where EmployeeName IN ('Stacy', 'Simon') Update Employees Set ManagerID = 3 Where EmployeeName IN ('Tom') Update Employees Set ManagerID = 5 Where EmployeeName IN ('John', 'Sam') Update Employees Set ManagerID = 4 Where EmployeeName IN ('David') GO Here is the SQL that does the job Declare @ID int ; Set @ID = 7; WITH EmployeeCTE AS ( Select EmployeeId, EmployeeName, ManagerID From Employees Where EmployeeId = @ID UNION ALL Select Employees.EmployeeId , Employees.EmployeeName, Employees.ManagerID From Employees JOIN EmployeeCTE ON Employees.EmployeeId = EmployeeCTE.ManagerID ) Select E1.EmployeeName, ISNULL(E2.EmployeeName, 'No Boss') as ManagerName From EmployeeCTE E1 LEFT Join EmployeeCTE E2 ON E1.ManagerID = E2.EmployeeId
Views: 273204 kudvenkat
Hierarchical Queries in Oracle/ عربي
 
16:39
start with & connect by prior Hierarchical Queries in Oracle ملاحظه : اشارة الاكبر غير مسموحة في الوصف --1--- select employee_id, first_name,last_name,manager_id from employees; --2--- select employee_id, first_name,last_name,manager_id from employees where manager_id=100; --3--- select employee_id, first_name,last_name,manager_id from employees where manager_id=101; --4--- select employee_id, first_name,last_name,manager_id from employees where manager_id=108; --5--- select employee_id, first_name,last_name,manager_id from employees where manager_id in (109,110,111,112,113) --6--- select employee_id, first_name,last_name,manager_id from employees start with employee_id=100 connect by prior employee_id=manager_id --top down --7--- select employee_id, first_name,last_name,manager_id from employees start with employee_id=113 connect by prior manager_id =employee_id --buttom up --8--- --let us take this and try to do nice thing --Neena Kochhar work for Steven King select employee_id, first_name,last_name,manager_id from employees start with employee_id=100 connect by prior employee_id=manager_id --top down --9--- select first_name||' '||last_name ||' work for '|| (select first_name||' '||last_name from employees e where e.employee_id=a.manager_id ) from employees a start with employee_id=100 connect by prior employee_id=manager_id --top down --10--- select first_name||' '||last_name ||' work for '|| prior first_name||' '||prior last_name from employees start with employee_id=100 connect by prior employee_id=manager_id --top down --11--- select level,employee_id, first_name,last_name,manager_id from employees start with employee_id=100 connect by prior employee_id=manager_id --top down --1 mean root --2 mean child of root --3 mean child of child , and so on --12--- select level,employee_id, first_name,last_name,manager_id from employees where level=2 start with employee_id=100 connect by prior employee_id=manager_id --13--- select lpad ('khaled',10, 0) from dual --14--- select level, case when level=1 then first_name||' '||last_name when level Greater sign 1 then lpad (first_name||' '||last_name,length(first_name||' '||last_name)+level-1, '-') end tree from employees start with employee_id=100 connect by prior employee_id=manager_id --top down ---------------------- --15--- select employee_id, first_name,last_name,manager_id from employees start with employee_id=100 connect by prior employee_id=manager_id --top down --16--- select employee_id, first_name,last_name,manager_id from employees start with employee_id=100 connect by manager_id= prior employee_id --top down
Views: 2396 khaled alkhudari
Indexes Overview and B Tree Index
 
38:05
Indexes Overview and B Tree Index watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
File Systems 1: File Indexes with B-Trees
 
12:36
One way to speed up file access is to use an index, and a common way to create such an index is by using a B-Tree, a particular type of self balancing tree. The structure of B-Trees is introduced, along with examples of how insertions modify the tree.
Views: 13965 Jacob Schrum
Position Hierarchy problem in Fusion - Solved
 
05:18
Position Hierarchy problem in Fusion - Solved. This was achieved by shifting the start date of the Position tree version by 2 years and did a row flattening after the status goes to Active. I now conduct training on Fusion Procurement and e Biz. Do contact me for training requirements to [email protected] Learn ABC of Fusion Applications The best Fusion Oracle online SCM Training Subscribe to youtube channel Anantha Nana. Click on bell icon adjacent to subscribe button...once...to get alerts upon new uploads Oracle Fusion Applications You Tube How to excel in Supply Chain in Fusion Applications
Views: 476 Anantha Nana
Oracle || Indexes Part-1 by dinesh
 
32:23
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Project Organization, Org Hierarchy, Implementation Options and Expenditure Types Practical
 
52:21
ProjectAccounting: Project Organization, Org Hierarchy, Implementation Options and Expenditure Types Practical
Views: 1284 chandra mohan Reddy
Master detail in tree and table using java in Oracle ADF
 
07:24
This video demonstrate how you can use view criteria and execute in view criteria in application module.On Selecting of tree row, we can refresh data in another view object.
Views: 5383 vinay kumar
Oracle || PL/SQL Arrays(Collections) Part - 1 by Dinesh
 
31:19
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
SQL: Indexes - Bit Map & B-trees
 
09:16
In this tutorial, you'll learn when to use b-tree and bitmap index
Views: 52851 radhikaravikumar
Tutorial 42 : INDEX in Oracle || B TREE INDEX.
 
05:21
Hi Friends! Here we are learning about B TREE INDEX. Hope the concept is clear to you. For any confusion or doubt let me know in comment box. Thanks. Happy Coding.
Views: 130 YourSmartCode
SQL Advanced Videos #1: B-Tree and Clustered Index
 
11:30
This Session is for advanced people already knowing basics of SQL. I am talking about the basic structure of the most common table in SQL Server, the clustered index table and the concept of a B-Tree on which everything is based. If you have any questions or remarks don't hesitate to use the comment section below.
Views: 13216 SQL TV
Oracle   Views Part -1 by Dinesh
 
33:18
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
B*Tree Index Types (Indexes in Oracle-2)
 
33:58
This video will cover different types of B-tree indexes: Descending index,Reverse key index,Key Compressed Index B-tree cluster index,Index Organized Table(IOT):
Views: 15320 Anindya Das
Intuition Behind Oracle Index
 
12:36
How index helps in performance For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 13788 Oresoft LWC
Internals of Binary Tree Indexes
 
09:52
Binary Tree Indexes For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 16666 Oresoft LWC
tree.mp4
 
04:15
oracle tree
Views: 2838 waleed muhammed
Oracle Separation of BQP and the Polynomial Hierarchy
 
01:02:38
Avishay Tal (Stanford University) https://simons.berkeley.edu/talks/tbd-11 Boolean Devices
Views: 165 Simons Institute
Programming Interview: B Tree (Introduction, Search and Insert)
 
17:11
This video lecture is produced by S. Saurabh. He is B.Tech from IIT and MS from USA. B Tree definition B Tree Search B tree insertion b tree insertion b tree pdf b tree ppt b tree animation b tree definition b tree applet b tree java To study interview questions on Linked List watch http://www.youtube.com/playlist?list=PL3D11462114F778D7&feature=view_all To prepare for programming Interview Questions on Binary Trees http://www.youtube.com/playlist?list=PLC3855D81E15BC990&feature=view_all To study programming Interview questions on Stack, Queues, Arrays visit http://www.youtube.com/playlist?list=PL65BCEDD6788C3F27&feature=view_all To watch all Programming Interview Questions visit http://www.youtube.com/playlist?list=PLD629C50E1A85BF84&feature=view_all To learn about Pointers in C visit http://www.youtube.com/playlist?list=PLC68607ACFA43C084&feature=view_all To learn C programming from IITian S.Saurabh visit http://www.youtube.com/playlist?list=PL3C47C530C457BACD&feature=view_all
Views: 223706 saurabhschool
AVL Tree L L Rotation | Data Structures Tutorial | Mr. Srinivas
 
08:34
"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 Visit Our Websites: http://nareshit.in/ http://nareshit.com/ 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. For Registration : https://goo.gl/r6kJbB For more updates on courses and tips follow us on: Facebook: https://www.facebook.com/NareshIT Twitter: https://twitter.com/nareshitech Google+: https://plus.google.com/NareshIT For Registration : https://goo.gl/r6kJbB Call: India- 8179191999, USA- 404-232-9879 Email: [email protected]
Views: 22523 Naresh i Technologies
Learn Hierarchies in SQL server using HierarchyID
 
23:28
Hierarchy ID is nothing other then column which represent relational value in numeric format on which DFS (Depth First Search) & BFS (Breadth First Search) can be used The concept is very simple, when we have to make relational structures which shows parent child level tree hierarchy, we can use hierarchyid datatype. With hierarchy ID recursive queries can be converted into range query. DFS (Depth First Search) and BFS (Breadth First Search) can be implemented using additional index which improves performance. Uses .NET assembly library defined methods to provide easy maintenance. Hierarchy ID is scalar column and is sequence of no. of var binary values. For script follow link below: http://www.techsapphire.in/index/learn_hierarchies_in_sql_server_using_hierarchyid/0-173
Views: 8600 techsapphire
Global Temporary Tables in Oracle Database - DBArch Video 21
 
16:02
Learn about Global Temporary Tables in Oracle Database. You will learn the internals of Global Temporary tables in Oracle database, and also a demo for the same. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 4944 Ramkumar Swaminathan
DBMS Indexing: The Basic Concept
 
09:52
A quick introduction to the concept of indexing in RDBMSs
Views: 157562 Brian Finnegan
DML Processing in an Oracle Database -  DBArch Video 8
 
09:07
This video explains the steps involved in processing a DML statement in an Oracle Database Server. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 49719 Ramkumar Swaminathan
Oracle Commerce Cloud: Manage Business Account Hierarchies
 
11:59
Define and view account hierarchies, navigate the account hierarchy tree, designate principal accounts, create sub-accounts, configure property inheritance on sub-accounts, and move accounts within the account hierarchy.
Views: 194 Oracle Commerce
Clustered vs. Nonclustered Index Structures in SQL Server
 
08:04
Clustered and nonclustered indexes share many of the same internal structures, but they're fundamentally different in nature. Watch Microsoft Certified IT Professional Jon Seigel explain the similarities and differences of clustered and nonclustered indexes, using a real-world example to show how these structures work to improve the performance of SQL queries. Blog post on primary key vs. the clustered index: http://voluntarydba.com/post/2012/10/02/The-Primary-Key-vs-The-Clustered-Index.aspx CREATE INDEX statement reference: http://technet.microsoft.com/en-us/library/ms188783.aspx ALTER INDEX statement reference: http://technet.microsoft.com/en-us/library/ms188388.aspx Index navigation internals by example: http://sqlblog.com/blogs/paul_white/archive/2011/08/09/sql-server-seeks-and-binary-search.aspx Sample index data is from the AdventureWorksLT2008R2 sample database: http://awlt2008dbscript.codeplex.com/releases/view/46169 Visit my channel for more database administration videos: https://www.youtube.com/voluntarydba Subscribe to get notified about my latest videos: https://www.youtube.com/voluntarydba?sub_confirmation=1 Read additional content on my blog: http://voluntarydba.com Follow on Twitter: https://twitter.com/voluntarydba Like on Facebook: https://facebook.com/voluntarydba
Views: 282581 Voluntary DBA
How Oracle SQL Query work
 
09:22
This video will give to understanding of SQL Parsing, Syntatic check , semantic check, spool file check, Sql Optimization, row source generation and sql execution.
Views: 18413 amit wadbude
Right Ways to Climb the OpenJDK Source Tree
 
55:52
This presentation focuses on the mistakes developers make in working with OpenJDK source code and how to avoid them. It covers the code Web interface, mercurial tool configuration issues, OpenJDK changeset metadata structure, build tags, changeset comments specific to OpenJDK, and procedures for cloning a particular build and looking for source code differences via a given OpenJDK bug ID. It also describes the changeset graph, how merges work, and how a collection of repositories can create problems. The session demonstrates how mercurial graphical tool visualization will help reveal and help you understand common OpenJDK issues with respect to the development code tree structure and proposed solutions. Copyright © 2013 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.

dating american culture
your dating my best friend quotes
dating your best friend's younger brother
best australian dating sites free
iphone dating apps uk