Home
Search results “Deterministic oracle functions”
Efficient Function Calls From SQL (Part 2) : The DETERMINISTIC Hint
 
03:05
The second part of a mini-series of videos showing how you can improve the performance of function calls from SQL. In this episode, we take a look at the DETERMINISTIC hint. For more information see: https://oracle-base.com/articles/misc/efficient-function-calls-from-sql#deterministic-hint Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Dana Singleterry : Blog: https://blogs.oracle.com/dana/ Twitter: https://twitter.com/dsingleterry Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 2512 ORACLE-BASE.com
Getting Started with PL/SQL Table Functions: Pipelined Table Functions
 
14:49
Pipelined table functions are table functions in which rows are returned or "piped" back to the calling query before the function has completed, avoiding the blocking behavior of normal PL/SQL functions and reduce PGA consumption. This video is part of the Oracle Dev Gym class "Getting Started with Table Functions". You can watch it independent of the class, but then you miss out on the tutorials and quizzes! So visit https://devgym.oracle.com/pls/apex/dg/class/getting-started-with-pl-sql-table-functions.html and register for the class! ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2018 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.
Calling PL/SQL Functions From SQL
 
57:06
Isn't it great how you "extend" Oracle SQL by calling your own user-defined PL/SQL functions from within SQL statements? Yes, it really is nice, but there are things you need to know about and take into consideration, from read-consistency to optimizer nuances. Chris Saxon gave an overview of the key issues from performance to correctness. Highlights include: 03:30 - performance comparison of plain SQL vs. calling PL/SQL function 04:30 - SQL to PL/SQL context switches; what they are and how they affect performance 06:10 - Techniques to make calling PL/SQL from SQL faster: scalar subquery caching, deterministic keyword, function result cache, pragma UDF 14:00 - Performance comparison of these options 21:20 - Performance comparison when calling non-deterministic functions 35:30 - The danger when you have SQL that calls PL/SQL that calls SQL 41:30 - Calling PL/SQL in SQL dos and don'ts 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: 643 Oracle Developers
Efficient Function Calls From SQL (Part 5) : Pipelined Table Functions
 
03:48
The fifth part of a mini-series of videos showing how you can improve the performance of function calls from SQL. In this episode, we compare the performance of conventions table functions with pipelined table functions. For more information see: https://oracle-base.com/articles/misc/pipelined-table-functions https://oracle-base.com/articles/misc/efficient-function-calls-from-sql Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Mike Dietrich : Blog: https://blogs.oracle.com/UPGRADE Twitter: https://twitter.com/MikeDietrichDE Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 12522 ORACLE-BASE.com
Oracle Function Result Cache | Steven Feuerstein
 
02:35
Returning for his seventh 2 Minute Tech Tip, Oracle architect and "Oracle PL/SQL Programming 6e" author Steven Feuerstein delivers the details on the Function Result Cache, a feature introduced in Oracle Database 11g that can add a performance boost to your applications.
Views: 1077 ArchBeat Archive
Oracle DECOMPOSE Function
 
01:41
The Oracle DECOMPOSE function is used to transform a string into a Unicode string. It will split a character that has an accent, for example, into two characters. It’s the opposite of the COMPOSE function. The syntax of the DECOMPOSE function is: DECOMPOSE ( input_string [CANONICAL|COMPATIBILITY] ) The parameters of this function are: - input_string is the string that will be decomposed into separate character values in a string. It can be any character data type. - CANONICAL|COMPATIBILITY is an optional parameter and allows you to specify the mode of decomposition. CANONICAL is the default. CANONICAL means it can be re-composed with the COMPOSE function. COMPATIBILITY means that it can’t be re-composed, but it can be useful for katakana characters. For more information about Oracle SQL functions, visit Database Star: https://www.databasestar.com/sql-functions/
Views: 128 Database Star
Webinar: All About the Function Result Cache
 
01:08:47
Presented by Steven Feuerstein, Oracle Corporation The function result cache, added in Oracle Database 11g, offers developers a way to dramatically reduce the amount of time it takes to retrieve data requested repeatedly by database sessions (specifically, when the same rows of a table are fetched much more frequently than they are changed). This cache is stored in the SGA, shared across all sessions in the instance, and automatically purged of "dirty data" by the Oracle Database. Every application running on 11.1 or higher should be taking advantage of this feature. Best of all, there is minimal impact on your code to start using this feature.
Views: 1097 ODTUG
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: 2454 Database Star
Deterministic Approximate Counting for Degree-2 Polynomial Threshold Functions
 
33:09
Rocco Servedio, Columbia University Real Analysis in Testing, Learning and Inapproximability http://simons.berkeley.edu/talks/rocco-servedio-2013-08-28
Views: 256 Simons Institute
NULL-Related Functions in Oracle
 
02:52
An overview of some of the functions Oracle provides to handle NULL values in SQL and PL/SQL. For more information see: https://oracle-base.com/articles/misc/null-related-functions Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Bjoern Rost Blog: http://portrix-systems.de/blog/brost/ Twitter: https://twitter.com/brost Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 2787 ORACLE-BASE.com
Rev up your Oracle Functions using Result Cache
 
11:56
Dan shows you how to dramatically increase function response time using a newer Oracle memory structure called Result Cache. Still on Oracle10? Dan has a solution for you as well.
Views: 125 Dan Hotka
Webinar: Ten (Other) Top Tips for Improving PL/SQL Performance
 
01:08:03
Bulk processing (FORALL and BULK COLLECT), along with the function result cache, are the "big ticket" items when it comes to performance optimization with PL/SQL. But there's still more we can do to tweak our code for even better response times for our users. This third webast in the series starts with the automatic compiler optimization, showcases the extraordinary speediness of PGA data manipulation (a.k.a., package variables), and demonstrates the effect of the simple NOCOPY hint. We finish up with an introduction to pipelined table functions and some thoughts on optimizing your algorithms.
Views: 10894 ODTUG
Optimizing SQL Performance
 
51:42
Held on July 12 2018 In July's session we mainly looked at performance. Highlights include: 1:30 How does the database process subqueries? 5:20 Performance: comparing insert ... select to create tmp table, insert select from tmp; DDL in PL/SQL; dynamic SQL problems 12:45 18c private temporary tables; tables specific to a session; DDL you can rollback across! 21:00 Improving update performance: things to watch for; insert vs. update; "join-update" - create a view instead; create table as select "update" 34:05 Analytic function performance: first_value non-determinism; min keep vs first_value; computing function in a subquery; indexes for analytic functions 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: 728 Oracle Developers
Efficient Function Calls From SQL (Part 3) : PL/SQL Function Result Cache
 
02:11
The third part of a mini-series of videos showing how you can improve the performance of function calls from SQL. In this episode, we take a look at the Cross-Session PL/SQL Function Result Cache introduced in Oracle 11g. For more information see: https://oracle-base.com/articles/misc/efficient-function-calls-from-sql#oracle-11g-caching https://oracle-base.com/articles/11g/cross-session-plsql-function-result-cache-11gr1 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Auckland Oracle DBAs Meetup : Website: http://www.meetup.com/Auckland-Oracle-DBAs-Meetup/ Sponsors: - DBvisit: http://www.dbvisit.com/ - Datacom: http://www.datacom.co.nz/ - Oracle New Zealand: http://www.oracle.com/ - Pythian: http://www.pythian.com/ - Enterprise IT: http://www.enterpriseit.co.nz/ Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 3212 ORACLE-BASE.com
Oracle Function Pipelined
 
13:21
Como criar function pipelined
Views: 2999 MasterTraining
Deterministic Encryption: Theory and Applications
 
01:04:59
The focus of the talk is deterministic public-key encryption schemes. Besides being interesting from theoretical and historical perspectives, the deterministic encryption primitive has applications to fast and secure search on remote data. We study several new notions of security for deterministic encryption and relations among them. We present several very efficient deterministic encryption schemes that provably satisfy the strongest-possible security definition (in the random oracle model). We finally provide the constructions that achieve security for many practical settings, without relying on the idealized random oracle model. The talk is based on joint papers with Mihir Bellare, Serge Fehr and Adam O'Neill.
Views: 193 Microsoft Research
Oracle Function Pipelined
 
13:21
what is oracle PIPELINED FUNCTION
Views: 549 Gees info
Oracle Performance - Result Cache Exercises
 
11:09
Oracle Performance - Result Cache Exercises
Views: 769 The Silent DBA
Oracle 12C Pragma UDF Function
 
08:10
Oracle 12C Pragma UDF Function https://easy-learning-tech.blogspot.com/2018/06/pragma-udf-user-defined-function.html oracle 12c new features for developers
Views: 379 Siva Academy
Efficient Function Calls From SQL (Part 4) : Scalar Subquery Caching vs PL/SQL Function Result Cache
 
02:09
The fourth part of a mini-series of videos showing how you can improve the performance of function calls from SQL. In this episode, we compare Scalar Subquery Caching with the the Cross-Session PL/SQL Function Result Cache to see which we should use for best performance. For more information see: https://oracle-base.com/articles/misc/efficient-function-calls-from-sql#scalar-subquery-caching-revisited Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Alex Gorbachev : Blog: http://www.oracloid.com/ Twitter: https://twitter.com/alexgorbachev Website: http://www.pythian.com/about/alex-gorbachev/ Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 1671 ORACLE-BASE.com
Oracle LOBS
 
31:33
Oracle LOBS
Views: 2156 The Silent DBA
Function Calls From SQL  Pipelined Table Functions
 
03:48
Function from SQL pipeline table
Views: 486 Gees info
Join Elimination in Oracle
 
03:11
What better way to improve performance than to actually remove some of your code? That's exactly what Oracle can do in some circumstances using join elimination. For more information see: https://oracle-base.com/articles/misc/join-elimination Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Pablo Ciccarello : Website: http://www.iristools.com/en/home/ Twitter: https://twitter.com/pablociccarello Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 979 ORACLE-BASE.com
MNG4: Conditional Compilation in PL/SQL (PL/SQL Channel)
 
28:27
In Oracle Database 10g and higher, you can use "$" syntax to affect which lines of code in your source program will be compiled and which ignored. Conditional compilation feature can be of great assistance when writing code to run on multiple versions of Oracle and can be used to enforce at compile time code quality rules, among many applications of this feature. This video was taken from PLSQLChannel.com, originally recorded before Steven Feuerstein re-joined Oracle in March 2014. ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Efficient Function Calls From SQL (Part 6) : Function-Based Indexes
 
02:20
The sixth part of a mini-series of videos showing how you can improve the performance of function calls from SQL. In this episode, we look at using function-based indexes to improve the performance of queries that use function calls in the WHERE clause. For more information see: https://oracle-base.com/articles/8i/function-based-indexes https://oracle-base.com/articles/misc/efficient-function-calls-from-sql#functions-in-the-where-clause Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Ronald Bradford : Blog: http://ronaldbradford.com/blog/ Twitter: https://twitter.com/RonaldBradford Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 1520 ORACLE-BASE.com
Data 101: Probabilistic vs  Deterministic Data
 
00:57
Everyone talks about data-driven marketing, but what does that really mean? Is one audience truly different from the next? Join the Oracle Data Cloud team as we begin to explore today’s best ways to think about and utilize data. Together, we will use real world examples and insights to enable you to connect with your customers in a more genuine, personal way. Our goal is simple - to help brands better connect with their customers. Follow us on Twitter.com/OracleDataCloud Like us on Facebook.com/OracleDataCloud Read more at Blogs.Oracle.com/OracleDataCloud
Views: 776 Oracle Data Cloud
PL/SQL Tutorial: BULK COLLECT  LIMIT Clause
 
05:32
PL/SQL Tutorial: BULK COLLECT with LIMIT Clause SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 547 TechLake
Learn Oracle | Data Types in PL SQL
 
13:14
Pebbles present, Learn Oracle 10g with Step By Step Video Tutorials. Learn Oracle 10g Tutorial series contains the following videos : Learn Oracle - History of Oracle Learn Oracle - What is Oracle - Why do we need Oracle Learn Oracle - What is a Database Learn Oracle - What is Grid Computing Learn Oracle - What is Normalization Learn Oracle - What is ORDBMS Learn Oracle - What is RDBMS Learn Oracle - Alias Names, Concatenation, Distinct Keyword Learn Oracle - Controlling and Managing User Access (Data Control Language) Learn Oracle - Introduction to SQL Learn Oracle - Oracle 10g New Data Types Learn Oracle - How to Alter a Table using SQL Learn Oracle - How to Create a Package in PL SQL Learn Oracle - How to Create a Report in SQL Plus Learn Oracle - How to Create a Table using SQL - Not Null, Unique Key, Primary Key Learn Oracle - How to Create a Table using SQL Learn Oracle - How to Create a Trigger in PL SQL Learn Oracle - How to Delete Data from a Table using SQL Learn Oracle - How to Drop and Truncate a Table using SQL Learn Oracle - How to Insert Data in a Table using SQL Learn Oracle - How to open ISQL Plus for the first time Learn Oracle - How to Open SQL Plus for the First Time Learn Oracle - How to Update a Table using SQL Learn Oracle - How to use Aggregate Functions in SQL Learn Oracle - How to use Functions in PL SQL Learn Oracle - How to use Group By, Having Clause in SQL Learn Oracle - How to Use Joins, Cross Join, Cartesian Product in SQL Learn Oracle - How to use Outer Joins (Left, Right, Full) in SQL Learn Oracle - How to use the Character Functions, Date Functions in SQL Learn Oracle - How to use the Merge Statement in SQL Learn Oracle - How to use the ORDER BY Clause with the Select Statement Learn Oracle - How to use the SELECT Statement Learn Oracle - How to use the Transactional Control Statements in SQL Learn Oracle - How to use PL SQL Learn Oracle - Data Types in PL SQL Learn Oracle - Exception Handling in PL SQL Learn Oracle - PL SQL Conditional Logics Learn Oracle - PL SQL Cursor Types - Explicit Cursor, Implicit Cursor Learn Oracle - PL SQL Loops Learn Oracle - Procedure Creation in PL SQL Learn Oracle - Select Statement with WHERE Cause Learn Oracle - SQL Operators and their Precedence Learn Oracle - Using Case Function, Decode Function in SQL Learn Oracle - Using Logical Operators in the WHERE Clause of the Select Statement Learn Oracle - Using Rollup Function, Cube Function Learn Oracle - Using Set Operators in SQL Learn Oracle - What are the Different SQL Data Types Learn Oracle - What are the different types of Databases Visit Pebbles Official Website - http://www.pebbles.in Subscribe to our Channel – https://www.youtube.com/channel/UCNNjWVsQqaMYccY044vtHJw?sub_confirmation=1 Engage with us on Facebook at https://www.facebook.com/PebblesChennai Please Like, Share, Comment & Subscribe
Views: 2785 Pebbles Tutorials
Efficient Function Calls From SQL (Part 1) : Scalar Subquery Caching
 
02:33
The first part of a mini-series of videos showing how you can improve the performance of function calls from SQL. In this episode, we take a look at Scalar Subquery Caching. For more information see: https://oracle-base.com/articles/misc/efficient-function-calls-from-sql#scalar-subquery-caching Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Bruno Borges : Blog: https://blogs.oracle.com/brunoborges/ Website: http://brunoborges.com/ Twitter: https://twitter.com/brunoborges Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 2597 ORACLE-BASE.com
COL11: Set-Level Manipulation of Nested Tables (MULTISET)
 
22:23
Oracle offers set-level operators and functions to manipulate nested tables. You can perform unions and intersects, check nested tables for equality and more. This lessons explores the MULTISET features of nested tables in detail. This video was taken from PLSQLChannel.com, originally recorded before Steven Feuerstein re-joined Oracle in March 2014. ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
MNG3: Compile-Time Warnings in PL/SQL (PL/SQL Channel)
 
29:27
In this video, I explore compile-time warnings, a fantastic feature of the PL/SQL compiler that will help you improve the quality and performance of your code, and increase your awareness of the full feature set of the PL/SQL language. This video was taken from PLSQLChannel.com, originally recorded before Steven Feuerstein re-joined Oracle in March 2014. ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
T-SQL - Stored Functions
 
04:33
T-SQL - Stored Functions Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited
Oracle Hints explained
 
42:56
Oracle Hints
Views: 615 FAKE News
Creating Computed Columns with User Defined Functions - SQL Server
 
04:35
-- IN THIS VIDEO WE ARE GOING TO LEARN ABOUT ADDING A COMPUTED COLUMN BY USING A USER DEFINED FUNCTION WHICH IS ALSO KNOWN AS CUSTOM FUNCTION --Create a function (NON DETERMINISTIC) CREATE FUNCTION [dbo].[MyFunc] (@val int) RETURNS int AS BEGIN RETURN @val*2; END --Test the function select dbo.myFunc (200); -- should give output: 400 -- Add a computed column using ALTER TABLE query ALTER TABLE jobs ADD double_salary AS dbo.myFunc(salary) Go --Get data from table SELECT * FROM jobs --Find if User Defined function is Deterministric SELECT id, Name, OBJECTPROPERTY(id, 'IsDeterministic') AS isDeterministic FROM dbo.SysObjects WHERE XType = 'FN' ORDER BY OBJECTPROPERTY(id, 'IsDeterministic') DESC, Name --Create a deterministic function WITH SCHEMABINDING CREATE FUNCTION [dbo].[MyDetFunc] (@val int) RETURNS int WITH SCHEMABINDING AS BEGIN RETURN @val*2; END -- Add a computed column with PERSISTED option ALTER TABLE jobs ADD double_salary2 AS dbo.myDetFunc(salary) persisted Go -- Again Get data from table SELECT * FROM jobs
Views: 328 Zia Ahmed Shaikh
PL/SQL Tutorial  4 :  PLSQL Procedures %Type, %ROWTYPE & NOCOPY
 
09:23
PLSQL Tutorial For Beginners 4 : PLSQL Procedures %Type, %ROWTYPE & NOCOPY SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 1308 TechLake
79/125 Oracle PLSQL: Design consideration  / parallel_enable/ result_cache
 
13:48
تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL EXAM 1Z0-144 https://docs.oracle.com/database/121/DBLIC/editions.htm#DBLIC116
Views: 600 khaled alkhudari
Oracle Tutorial || Oracle|Adv Sql | Marge Command Part - 1 by basha
 
33:27
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 Model Clause - 01 - An Introduction
 
10:48
SQL Model Clause - Series 01
Views: 431 Rajeshwaran Jeyabal
PL/SQL Tutorial : RETURNING INTO Clause examples
 
04:16
PL/SQL Tutorial : PLSQL RETURNING Clause examples PLSQL Tutorial SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 374 TechLake
JavaScript Module as UDF in Oracle SQL
 
05:24
This is a demonstration of Oracle's experimental Multilingual Engine (MLE) technology. A module from NPM is installed in the client, uploaded to the database, and then called as a user-defined function from SQL. Learn more here: http://www.oracle.com/technetwork/database/multilingual-engine/overview/index.html ============================ 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.
How to create Virtual Columns in Oracle Database
 
09:02
How to create Virtual Columns in Oracle Database 12c When queried, virtual columns appear to be normal table columns, but their values are derived rather than being stored on disc. The syntax for defining a virtual column is listed below. column_name [datatype] [GENERATED ALWAYS] AS (expression) [VIRTUAL] If the datatype is omitted, it is determined based on the result of the expression. The GENERATED ALWAYS and VIRTUAL keywords are provided for clarity only. The script below creates and populates an employees table with two levels of commission. It includes two virtual columns to display the commission-based salary. The first uses the most abbreviated syntax while the second uses the most verbose form. CREATE TABLE employees ( id NUMBER, first_name VARCHAR2(10), last_name VARCHAR2(10), salary NUMBER(9,2), comm1 NUMBER(3), comm2 NUMBER(3), salary1 AS (ROUND(salary*(1+comm1/100),2)), salary2 NUMBER GENERATED ALWAYS AS (ROUND(salary*(1+comm2/100),2)) VIRTUAL, CONSTRAINT employees_pk PRIMARY KEY (id) ); INSERT INTO employees (id, first_name, last_name, salary, comm1, comm2) VALUES (1, 'JOHN', 'DOE', 100, 5, 10); INSERT INTO employees (id, first_name, last_name, salary, comm1, comm2) VALUES (2, 'JAYNE', 'DOE', 200, 10, 20); COMMIT; Querying the table shows the inserted data plus the derived commission-based salaries. SELECT * FROM employees; ID FIRST_NAME LAST_NAME SALARY COMM1 COMM2 SALARY1 SALARY2 ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- 1 JOHN DOE 100 5 10 105 110 2 JAYNE DOE 200 10 20 220 240 2 rows selected. SQL The expression used to generate the virtual column is listed in the DATA_DEFAULT column of the [DBA|ALL|USER]_TAB_COLUMNS views. COLUMN data_default FORMAT A50 SELECT column_name, data_default FROM user_tab_columns WHERE table_name = 'EMPLOYEES'; COLUMN_NAME DATA_DEFAULT ------------------------------ -------------------------------------------------- ID FIRST_NAME LAST_NAME SALARY COMM1 COMM2 SALARY1 ROUND("SALARY"*(1+"COMM1"/100),2) SALARY2 ROUND("SALARY"*(1+"COMM2"/100),2) 8 rows selected. SQL Notes and restrictions on virtual columns include: 1)Indexes defined against virtual columns are equivalent to function-based indexes. 2)Virtual columns can be referenced in the WHERE clause of updates and deletes, but they cannot be manipulated by DML. 3)Tables containing virtual columns can still be eligible for result caching. 4)Functions in expressions must be deterministic at the time of table creation, but can subsequently be recompiled and made non-deterministic without invalidating the virtual column. In such cases the following steps must be taken after the function is recompiled: a)Constraint on the virtual column must be disabled and re-enabled. b)Indexes on the virtual column must be rebuilt. c)Materialized views that access the virtual column must be fully refreshed. d)The result cache must be flushed if cached queries have accessed the virtual column. e)Table statistics must be regathered. 5)Virtual columns are not supported for index-organized, external, object, cluster, or temporary tables. 6)The expression used in the virtual column definition has the following restrictions: a.It cannot refer to another virtual column by name. b.It can only refer to columns defined in the same table. c.If it refers to a deterministic user-defined function, it cannot be used as a partitioning key column. e.The output of the expression must be a scalar value. It cannot return an Oracle supplied datatype, a user-defined type, or LOB or LONG RAW.
Views: 567 OracleDBA
EXAMPLE FOR AUTHID CURRENT USER AND AUTHID INVOKER
 
12:08
This is an example to show that how you can use invoker rights in procedure . We user authid current_user and authid invoker clause.
Views: 1339 Pushpjeet Cholkar
Analytic Functions: Databases for Developers #13
 
05:42
Analytic or windowing functions are one of the most powerful features of SQL. They allow you do to things like: - Add running totals - Generate row numbers - Calculate moving averages This video explains how to use them to analyze your data. Want to learn more? Take the course! https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-next-level.html Further reading: Analytic functions in the docs: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Analytic-Functions.html Analytic SQL video series: https://www.youtube.com/watch?v=0cjxYMxa1e4&list=PLJMaoEWvHwFIUwMrF4HLnRksF0H8DHGtt 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: 1274 The Magic of SQL
95/125 Oracle PLSQL: Creating Triggers / Compound triggers 2
 
05:57
Learn Oracle PLSQL Creating Triggers in oracle Compound triggers in oracle EXAM 1Z0-144
Views: 738 khaled alkhudari
Oracle AUTHID current user/ شرح عربي
 
12:13
how to use AUTHID in oracle procedure my website is coming soon (In Ramadan 2016) موقعي سيكون موقع احترافي من الدرجه الاولى و سينافس اقوى المواقغ العالميه [email protected]
Views: 501 khaled alkhudari