Home
Search results “Oracle distinct in listagg”
Oracle 19C new feature LISTAGG DISTINCT
 
05:31
Oracle 19C New feature LISTAGG DISTINCT Click here to subscribe to my youtube channel http://www.youtube.com/channel/UCBt6VrxAIb5jLh9HLDcdwtQ?sub_confirmation=1 Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 629 Siva Academy
Oracle Interview question How To Get unique records without using distinct in oracle
 
11:56
Oracle Interview question How To Get unique records without using distinct in oracle? http://easy-learning-tech.blogspot.com/2018/07/how-to-get-unique-records-without-using.html List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 3415 Siva Academy
Oracle LISTAGG Function
 
04:57
https://www.databasestar.com/oracle-listagg/ The Oracle LISTAGG function allows you to aggregate or combine string values from multiple rows into a single row. For example, it turns this data: FIRST_NAME Adam Brad Carrie Into this data: FIRST_NAME Adam, Brad, Carrie The same data is shown, but it’s in one row and not multiple. It’s a valuable string manipulation function, and once you know what it is and how it works, you’ll be able to use it in your queries as needed. So what does it look like? The function is: LISTAGG ( measure_expr [, delimiter]) WITHIN GROUP (order_by_clause) [OVER query_partition_clause] These parameters are: measure_expr: This is a column or expression that you want to concatenate the values of. In the example above, it was the first_name column. Mandatory. delimiter: This is the character between each of the measure_expr values. Optional, the default is a comma. order_by_clause: This is the order that the values from the measure_expr are listed. Mandatory. query_partition_clause: This allows you to use LISTAGG as an analytic function, allowing you to show LISTAGG in groups for different rows. One thing to be aware of is that the output of the Oracle LISTAGG function is limited to 4,000 bytes. If you get more than this, you’ll receive an error. The most common way around this that I’ve seen is to write a custom function and use a CLOB. Watch the video to find out more and see some examples. For more information about the Oracle LISTAGG function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-listagg/
Views: 3702 Database Star
LISTAGG Function in Oracle Database
 
07:19
listagg in oracle 10g opposite of listagg in oracle oracle listagg distinct oracle listagg multiple columns oracle listagg limit
Views: 184 Adam Tech
LISTAGG Analytic Function in Oracle Database
 
03:01
This video gives a quick demonstration of the LISTAGG Analytic function introduced in Oracle database 11g Release 2. For more information see: LISTAGG Analytic Function in 11g Release 2 https://oracle-base.com/articles/misc/string-aggregation-techniques#listagg LISTAGG Function Enhancements in Oracle Database 12c Release 2 (12.2) https://oracle-base.com/articles/12c/listagg-function-enhancements-12cr2 LISTAGG DISTINCT in Oracle Database 19c https://oracle-base.com/articles/19c/listagg-distinct-19c Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Michael Rainey : Blog: https://medium.com/@mRainey Twitter : https://twitter.com/mRainey Cameo appearances are for fun, not an endorsement of the content of this video. All trademarks, product names and logos are the property of their respective owners.
Views: 794 ORACLE-BASE.com
Oracle LISTAGG Function Example and Demonstration
 
08:47
In this lesson Geoff dives into the explanation and demonstration of the LISTAGG aggregate function. See all the lessons in this tutorial - FREE - at http://www.skillbuilders.com/advanced-aggregations-with-oracle-sql.
Views: 2315 SkillBuilders
Oracle 12C New Feature Listagg function improvements
 
09:56
oracle 12c new features Queries used in the video are given in the blog link http://easy-learning-tech.blogspot.in/2018/04/oracle-12c-new-feature-listagg-function.html oracle 12c new features for developers
Views: 2266 Siva Academy
Урок 17. SQL advanced. Зaпрос в строчку listagg и разделитель.
 
05:25
LISTAGG Функция LISTAGG объединяет значения заданного поля таблицы для каждой группы в cтроку через указанный разделитель Oracle SQL. учебная среда https://apex.oracle.com/pls/apex/f?p=4550:1:103440124..::::: схема: SQLADV польз: student1 пароль: student1 будут работать (student2/ student2, student3/ student3 .... student11/ student11) меню SQL Workshop , SQL Command или используйте http://sqlfiddle.com/ скрипт бд для загрузки в sqlfiddle http://sqladv.ru/dev/sql.txt урок и задания http://sqladv.ru/dev/sqladv/l17.txt
LISTAGG in Oracle
 
03:16
The theoretic description related to LISTAGG in Oracle to achieve the required which is shown in the Video.
Views: 1423 Techie Rajesh
TSQL: Group Items With Comma Separation
 
06:20
Grouping items separated by a column.
Views: 4907 SQLInSix Minutes
Oracle 12c New Feature On Delete Cascade
 
10:45
oracle 12c new features for developers Oracle 12c New Feature On Delete Cascade
Views: 656 Siva Academy
Oracle 18C New Feature Private Temporary Table
 
12:01
What is oracle private temporary table? This video explains about the global temporary table, and private temporary table concepts. A typo error in the slide, Please read "ON COMMIT DROP DEFINITION" instead of "ON COMMIT DELETE DEFINITION"
Views: 813 Siva Academy
Oracle sql Interview Question : How to change rows to column
 
09:18
This video tutorial talks about the frequently asked oracle sql interview question of changing rows to the column. Based on the given scenario, we are asked to change the presentation of data in a table with 3 rows and 2 column to 3 columns and 2 rows. Decode Function in oracle https://youtu.be/YUAjPMjqMws Pivot and unpivot in oracle https://youtu.be/6s0DI1YcWIM
Views: 21088 Kishan Mashru
Oracle regular expression regexp count
 
03:31
Unix Shell Scripting
Views: 1783 Sridhar Raghavan
05-Oracle SQL Arabic Course - Null Value & Column Aliases -اوراكل ديفلوبر
 
07:10
الدرس الخامس من سلسلة دروس تعلم أوراكل محتويات الدرس: 1- NULL Values. 2- Null values in Arithmetic Expressions. 3- Column Alias. .......................................­.................... تواصل معانا علي الفيس بوك من هنا : https://www.facebook.com/askgad .......................................­.................... تواصل معانا علي موقعنا من هنا : https://www.askgad.com/
Views: 5770 Ask Gad
How to Join Field values of a Table using LISTAGG function | Oracle Express Edition (APEX) Tutorials
 
01:46
Do you know how to join two field values of an Oracle Table using SQL? Do you know this can be achieved using functions in the SQL query? ----------------------------------------------------------------------------------------------------------- select listagg(empname,', ') within group(order by empname) as ALLNAMES from emp1; ----------------------------------------------------------------------------------------------------------- The LISTAGG function takes in two arguments: 1. The name of the field 2. Separator The separator can be any special character like comma, quotes, etc. The query performance may vary for large 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
Oracle Pivot with group total computation
 
13:41
Oracle Pivot with group total computation Watch this video for PIVOT clause https://youtu.be/smCBBgN8nEE Click here to subscribe to my youtube channel http://www.youtube.com/channel/UCBt6VrxAIb5jLh9HLDcdwtQ?sub_confirmation=1 Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 548 Siva Academy
Oracle Pivots
 
12:10
Oracle Pivots
Views: 92 Nook Tutorials
Oracle 12c new feature Identity column
 
09:48
Oracle 12c new feature Identity column oracle identity column identity columns in oracle 12c
Views: 527 Siva Academy
Oracle 12C New Feature - Multi Column List Partitioning
 
12:14
Oracle 12C New Feature - Multi Column List Partitioning
Views: 352 Siva Academy
Oracle CAST Function
 
03:23
https://www.databasestar.com/oracle-cast/ The Oracle CAST function allows you to convert one data type to another. It’s similar to the TO_NUMBER, TO_DATE, and TO_CHAR functions, but allows for more functionality, including converting to many other data types. The syntax of the CAST function is: CAST( {expr | MULTISET (subquery) } AS type_name ) The structure of this function is different to other functions, because it uses the word AS to separate parameters rather than a comma. You can run this function like many other functions, on a single row, which would look like this: CAST( expr AS type_name ) Or, you can run it as though it’s a subquery, using the MULTISET feature: CAST( MULTISET (subquery) AS type_name ) The parameters of the CAST function are: - expr (mandatory choice): This is the value or expression that is to be converted to another data type. - MULTISET (optional): This keyword indicates that the subquery results will return multiple rows, and are then CAST into a collection value. If this is omitted, and the subquery returns multiple rows, it will only return a single row. - subquery (mandatory choice): This is the subquery that can be run to be converted into a collection data type. - type_name (mandatory): This is the Oracle data type that the expr or subquery will be converted to. There are several data types that are compatible with the CAST function, both for converting from and to. You can find the full list in the article mentioned below. For more information about the Oracle CAST function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-cast/
Views: 2633 Database Star
Informatica Interview Scenario :Listagg Function in Informatica
 
15:27
A source table has values Col1 Col2 a l a m a n b p b q x y The target table should have values Col1 Col2 a l,m,n b p,q x y The Video Demonstrates 2 approaches to achieve the same using listagg function in SQ query and by using expression and aggregation in case of flat file. Please post in comments section in case you want help with any scenario i will try to cover it in my next video
Views: 7007 Tech Coach
APPROX_COUNT_DISTINCT Function in Oracle Database 11g and 12c
 
02:24
This video demonstrates how to quickly improve the performance of calculating the number of distinct values using the APPROX_COUNT_DISTINCT function. For more information see: https://oracle-base.com/articles/12c/approx-count-distinct-12cr1 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Kris Rice Blog: http://krisrice.blogspot.com/ Twitter: https://twitter.com/krisrice Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 791 ORACLE-BASE.com
How To Use Listagg In Sql Server
 
12:39
How To Achieve Listagg Function in Sql Server
Views: 199 C Plus+
Oracle 12c with clause enhancements
 
05:45
oracle 12c with clause enhancements https://easy-learning-tech.blogspot.in/2018/05/oracle-12c-with-clause-enhancements.html oracle 12c new features for developers
Views: 606 Siva Academy
SQL 12c  Tutorial 21 : SQL 12c Features APPROX_COUNT_DISTINCT
 
03:36
SQL 12c Tutorial 21 : SQL 12c Features APPROX_COUNT_DISTINCT for COUNT & DISTINCT Combination SQL 12c Tutorial for beginners Oracle SQL 12c Tutorial for beginners APPROX_COUNT_DISTINCT for COUNT and DISTINCT
Views: 1340 TechLake
Oracle SQL Tuning with Unique Constraints
 
02:28
Learn how to tune SQL with Constraints! In this lesson (4 of 5), OCM John Watson from SkillBuilders demonstrates how to improve query performance by adding not null constraints. See all lessons, free at http://www.skillbuilders.com/oracle-database-sql-tuning-with-constraints.
Views: 293 SkillBuilders
The New Oracle Database Release and Patching Model
 
26:46
For a higher resolution video please click here: https://youtu.be/JIfZPMzQDwA With Oracle Database 12.2 Oracle changes it's release and patching model. There are no first and second releases but yearly releases. And patching should be done with Updates or Revisions. This 26 min video explains the new model in depth. Please find more information on: https://MikeDietrichDE.com Or follow me on Twitter: MikeDietrichDE
Oracle PL SQL interview question RANK and DENSE RANK as Aggregate Function and Analytical Function
 
09:08
Oracle PL SQL interview question RANK and DENSE RANK as Aggregate Function and Analytical Function Click here to subscribe to my youtube channel http://www.youtube.com/channel/UCBt6VrxAIb5jLh9HLDcdwtQ?sub_confirmation=1 Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 1400 Siva Academy
Oracle 12c New Feature Spotlight Synchronous Refresh for Materialized Views
 
54:18
Materialized views can perform a number of roles, such as improving query performance or providing replicated data. Prior to Oracle 12c, materialized views used traditional refresh methods where changes were applied to the base tables and then the materialized views were refreshed separately with one of several methods. Synchronous refresh is a new approach in Oracle 12c R1 for maintaining tables and materialized views where tables and materialized views are refreshed at the same time. This webinar will discuss the benefits of the synchronous refresh method along with how to implement it.
Views: 530 Themis Education
Subscriber Comments Reply Video 17 | Values from multiple rows into single row
 
12:19
Subscriber Comments Reply Video 17 | Values from multiple rows into single row Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 406 Siva Academy
Oracle 12c new feature READ object Privilege READ ANY TABLE System Privilege
 
08:31
Oracle 12c new feature READ object Privilege READ ANY TABLE System Privilege
Views: 565 Siva Academy
Oracle 18c New Feature Focus - Private Temporary Tables
 
31:38
Oracle 18c brings us Private Temporary Tables. A Private Temporary Table is stored in memory and is visible only to the session that created it and is dropped at the end of the session or transaction depending on the setup. In this webinar OCP DBA John Mullins will cover the creation and management of Private Temporary Tables along with their benefits and restrictions. In addition, Private Temporary Tables will be compared to Global Temporary Tables. Get the slides from this and other webinars at: https://www.themisinc.com/webinars
Views: 231 Themis Education
Subscriber Comments Reply Video 11 Find and Delete Duplicate Routes
 
08:13
Subscriber Comments Reply Video 11 Find and Delete Duplicate Routes Click here to subscribe to my youtube channel http://www.youtube.com/channel/UCBt6VrxAIb5jLh9HLDcdwtQ?sub_confirmation=1 Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 508 Siva Academy
Oracle 19c Features
 
05:24
Trabalho de Pós graduação em Banco de Dados e BigData - PUC - PR
Views: 44 Anderson Zelenski
Oracle Database 19c:  Multitenant Cloud Database Architecture
 
07:40
Multitenant is the database-native containerization architecture of Oracle Database. Pluggable Databases (PDBs) are consolidated into Container Databases (CDBs). Multitenant reduces costs, reduces risk and increases agility. 50% savings on TCO are typical. PDBs are isolated and secure and compliance is simplified because you can manage many as one. Major use cases include Database as a Service, Production Consolidation and Software as a Service.
SQL Server'da Where ile Having Arasındaki Fark
 
04:32
SQL Server'da Where ile Having Arasındaki Fark hakkında bilgi verildi.
Use the Oracle Advanced Queuing (AQ) Adapter for Object Queue Type
 
01:55
This video demonstrates how the Oracle Advanced Queuing (AQ) Adapter supports the Object queue type 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 © 2019 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.
What's New in Oracle Exadata 19.1 and Oracle Database 19c
 
09:36
Learn what's new in Oracle Exadata 19.1, and why customers should consider upgrading to Oracle Database 19c.
Subscriber Comments Reply Video 1
 
11:01
Subscriber Comments Reply Video 1 Click here to subscribe to my youtube channel http://www.youtube.com/channel/UCBt6VrxAIb5jLh9HLDcdwtQ?sub_confirmation=1 Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 840 Siva Academy
JSON_OBJECT Function Enhancements in Oracle Database 19c
 
02:34
This video gives a quick demonstration of the JSON_OBJECT function enhancements in Oracle database 19c. For more information see: JSON_OBJECT Enhancements in Oracle Database 19c https://oracle-base.com/articles/19c/json_object-enhancements-19c SQL/JSON Generation Functions in Oracle Database 12c Release 2 (12.2) https://oracle-base.com/articles/12c/sql-json-functions-12cr2 JSON Support in Oracle Database 12c Release 1 (12.1.0.2) https://oracle-base.com/articles/12c/json-support-in-oracle-database-12cr1 JSON Support Enhancements in Oracle Database 12c Release 2 (12.2) https://oracle-base.com/articles/12c/json-support-in-oracle-database-12cr2 JSON Support Enhancements in Oracle Database 18c https://oracle-base.com/articles/18c/json-support-in-oracle-database-18c JSON Support Enhancements in Oracle Database 19c https://oracle-base.com/articles/19c/json-support-in-oracle-database-19c JSON : All Articles https://oracle-base.com/articles/misc/articles-misc#json Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Patrick Jolliffe : Blog: https://jolliffe.hk/ Twitter : https://twitter.com/jolliffe Cameo appearances are for fun, not an endorsement of the content of this video. All trademarks, product names and logos are the property of their respective owners.
Views: 233 ORACLE-BASE.com
Oracle PL/SQL Tutorials | PRAGMA EXCEPTION_INIT | Mr.Vaman Deshmukh
 
07:23
Oracle PL/SQL Tutorials | PRAGMA EXCEPTION_INIT | Mr.Vaman Deshmukh ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 ► Visit Our Website for Classroom Training: https://nareshit.in ► For Online Training: https://nareshit.com/ #OraclePLSQLTutorials #PRAGMAEXCEPTION_INIT -------------------------- ► About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, 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 USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ► 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 Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ► Follow us on Instagram: https://www.instagram.com/nareshitech/ -------------------------------------------------------------------------------------------------------- #oracletutorials #oraclevideos #sqltraining #sqltutorials #oracletraining
PL/SQL: Brief on V-arrays
 
03:35
In this tutorial, you'll learn the points to be noted on V-arrays PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 4186 radhikaravikumar
Oracle SQL Practical question with answer | Sort the NUMBERS in the comma separated list
 
14:39
Oracle SQL Practical question with answer | Sort the NUMBERS in the comma separated list https://sivakacademy.blogspot.com/2019/06/sort-numbers-in-comma-separated-list.html Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 694 Siva Academy
Private Temporary Tables in Oracle Database 18c Onward
 
03:25
This video demonstrates the Private Temporary Table functionality introduced in Oracle database 18c. For more information see: Private Temporary Tables in Oracle Database 18c https://oracle-base.com/articles/18c/private-temporary-tables-18c Global Temporary Tables https://oracle-base.com/articles/misc/temporary-tables Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Ronald Luttikhuizen : Blog: http://blog.vennster.nl/ Twitter : https://twitter.com/rluttikhuizen Cameo appearances are for fun, not an endorsement of the content of this video. All trademarks, product names and logos are the property of their respective owners.
Views: 533 ORACLE-BASE.com
Oracle Exadata System Software 19.1
 
09:09
Oracle Exadata System Software Release 19.1.0.0.0 lays the foundation for Autonomous Database and improves every aspect of Exadata with 20+ features and enhancements. All new features and enhancements are available on all supported Exadata generations
LNNVL FUNCTION IN ORACLE SQL
 
09:11
This video is the 5th video in the series of 'working with null', this video explains the working of the lnnvl function in oracle sql with simple and easy to understand example. LNNVL provides a concise way to evaluate a condition when one or both operands of the condition may be null. The function can be used only in the WHERE clause of a query. It takes as an argument a condition and returns TRUE if the condition is FALSE or UNKNOWN and FALSE if the condition is TRUE. LNNVL can be used anywhere a scalar expression can appear, even in contexts where the IS [NOT] NULL, AND, or OR conditions are not valid but would otherwise be required to account for potential nulls. Oracle Database sometimes uses the LNNVL function internally in this way to rewrite NOT IN conditions as NOT EXISTS conditions. In such cases, output from EXPLAIN PLAN shows this operation in the plan table output. The condition can evaluate any scalar values but cannot be a compound condition containing AND, OR, or BETWEEN.
Views: 716 Kishan Mashru