Home
Search results “Apex oracle postgresql”
dblink oracle mysql
 
17:21
Views: 3917 Muhammad Rizal
Сравнительный обзор архитектуры PostgreSQL и Oracle | Виктор Егоров
 
45:25
Сравнительный обзор архитектуры PostgreSQL и Oracle | Виктор Егоров Доклад рассмотрит следующие компоненты СУБД PostgreSQL, сравнивая архитектурные решения с СУБД ORACLE: 1. Что представляет из себя экземпляр работающей базы, какие процессы присутствуют и за что они отвечают? 2. Какими структурами оперирует база? 3. Механизм отказоустойчивости. 4. MVCC механизм и возможности восстановления базы. 5. Хранение базы на физических носителях. Каждое из рассматриваемых решений будет оценено с точки зрения накопленного опыта работы в выбранных СУБД, удобства администрирования и доступных способов развития в будущем. Доклад будет интересен: пользователям PostgreSQL, т.к. позволит взглянуть на другую СУБД и её особенности; администраторам PostgreSQL, т.к. ORACLE предлагает большие административные возможности, которые могли бы быть реализованы и в Postgres; разработчикам PostgreSQL, т.к. Postgres активно развивается и этот доклад может задать новые направления развития; желающим перейти с ORACLE (или другой СУБД) на проекты с открытым исходным кодом, т.к. доклад продемонстрирует возможности открытой СУБД Postgres в сравнении с коммерческим продуктом, в котором Postgres выглядит очень достойно! Подробнее: https://pgconf.ru/2018/108306 #PGConfRu #PostgreSQL #Oracle
Views: 235 PGConf.Russia
Урок 24.SQL advanced.Индексы Oracle
 
08:31
Использование индексов в ORACLE DB Индексы предназначены для быстрого доступа к строкам таблиц, для быстрого нахождения ассоциированных строк таблицы. Индексы позволяют находить строку с определенным значением столбца, просматривая при этом лишь небольшую часть общего объема строк таблицы. 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/l24.txt
Creando DBlink desde Oracle 11g XE a MySQL con Oracle APEX y SQLPlus
 
17:35
En éste video explico cómo crear un DBlink desde la Base de Datos Oracle 11g XE para poder realizar consultas a una tabla que se encuentra en una Base de Datos MySQL creando un ODBC para tal conexión.
Views: 10249 Clarisa Maman Orfali
How to Create Database Link in Oracle. /* Step By Step /*
 
17:21
Today I am showing you. How to create Database link (DB Link) in Oracle. What is Database Link ( DB Link ) ? A database link is a schema object in one database that enables you to access objects on another database. I have 2 databases 1. paragdb 2. orcl In Paragdb database 1. Create listener 2. Service Name 3. In Orcl Database 1. Create Listener 2. Service Name 3. Create new User 4.Grant connect,resource,create database link to username; 5. open user 6. create database link 1. create database link link1 connect to scott identified by tiger using 'connect_primary''; 7.select * from [email protected]; 8. select * from [email protected]; 9. views 1. select * from user_db_links; 2. select * from all_db_links; 10. conn sys as sysdba 11. grant public database link to username; 12. select * from dba_db_links; 13. conn username/pass 14. create public database link plink connect to scott identified by tiger using 'connect_primary'; 15. drop database link. drop database link link1; To follow this steps you will also create oracle database link. It is very easy to understand.
Views: 8856 Parag Mahalle
Python With Oracle Database
 
11:51
Import CSV data into oracle table using python Reference : http://guideme360.in/2017/08/25/python-oracle-database/ Channel : https://www.youtube.com/c/GuideMe #TheProgrammingGuy#GuideMe360 #python #pythontutorial
Views: 16527 The Programming Guy
Create Oracle SQL database with auto-incrementing integers for the primary key
 
12:49
Create a new Oracle SQL database using SQL. After the database is created, I demonstrate using an Oracle SQL sequence and trigger to create auto-incrementing integers which are used as the table's primary key.
Views: 12173 Mike Colbert
Oracle to PostgreSQL Database Migration Demo
 
15:22
The demo is showing an example of how SQLWays can convert Oracle to PostgreSQL database. http://www.ispirer.com/products/oracle-to-postgresql-migration?click=HPx2JAXdw08&from=youtube
Views: 11080 Ispirer Systems
Move tables between databases PostgreSQL with a DBLINK
 
03:51
Move tables between databases PostgreSQL with a DBLINK do $$ declare r record ; begin for r in select * from dblink ('host=localhost user=postgres password=password dbname=source', 'select indexdef from pg_indexes where tablename = ''mytable''') as linktable ( indexdef text ) loop execute r.indexdef; end loop; end $$
Views: 4676 randomtutorial
Demo: Oracle Plugin for PostgreSQL | Blue Medora
 
12:51
Monitor hundreds of PostgreSQL databases metrics, identify common bottlenecks, manage alerts and get query-level visibility--all within Oracle Enterprise Manager using the Oracle Plugin for PostgreSQL. Learn more at www.bluemedora.com/OEM.
Views: 755 Blue Medora
Урок9.PL SQL.Функции
 
06:23
Функция — это подпрограмма на языке ORACLE PL SQL, которая вычисляет значения и возвращает результат вычисления. У функции есть уникальное в рамках схемы БД имя и набор параметров. Функцию можно вызывать из другой процедуры или функции, а также из анонимного PL SQL блока. Oracle PL 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/plsql/l9.txt
Postgres dblink - conexión a otra base de datos
 
09:45
Como conectarse a otra base de datos incluso de otro servidor usando el módulo DBLINK que viene con nuestro manejador de base de datos PostgreSQL. Sisplani eirl [email protected] +51 1 4850153 / +51 997017670 -- /share/contrib/dblink.sql o dblink--1.1.sql create extension dblink CREATE TABLE doctipo ( doctipo_descri character varying(50) DEFAULT ''::character varying, -- descripción del tipo de documento doctipo_id character varying(5) NOT NULL DEFAULT ''::character varying, -- ID del tipo de documento CONSTRAINT pk_doctipo PRIMARY KEY (doctipo_id) ) WITH ( OIDS=FALSE ); CREATE OR REPLACE FUNCTION dblink_test() RETURNS void AS $BODY$ /* Autor: Guillermo Arias ejemplo: select base.dblink_test(); cargar: /share/contrib/dblink.sql o dblink--1.1.sql */ declare cRpta varchar; begin cRpta := (select dblink_connect('myconn','hostaddr=192.168.0.161 port=5432 dbname=hojavida user=postgres password=zxzx') ) ; raise notice '%',cRpta; insert into doctipo (doctipo_id ,doctipo_descri ) select * from dblink( --'hostaddr=192.168.1.7 port=5432 dbname=siscar user=postgres password=postgres' , 'myconn' , 'select doctipo_id, doctipo_descri from sscc.doctipo' ) as (doctipo_id varchar, doctipo_descri varchar ); perform dblink_disconnect('myconn'); -- select dblink_disconnect('myconn'); end; $BODY$ LANGUAGE 'plpgsql' VOLATILE COST 100; select * from dblink_test(); select * from doctipo;
Views: 2140 Sisplani eirl
Data import/export web application built in Oracle Application Express from http://dbswh.com
 
04:04
Data import/export application allows to make import and export of data in CSV, XML format, as well as copy paste data from spread sheets and import into existing or new table. It runs as Web application, no setup is required except having Oracle database and Apex :) Database can be Oracle XE that is free. This tool is useful for data quality, harmonization projects, company merge projects since it allows to load/unload data (also there can be built customized data processing routines in between that can be easily built in the middle).
Views: 14207 dbswhcom
Oracle to PostgreSQL Migration with ora2pg
 
32:33
In this video from PG Day 2011, CEO of Consistent State, Kevin Kempter, talks to us about migrating from Oracle to PostgreSQL with the new ora2pg. Kevin will start by giving us an overview of ora2pg, he will tell us where to download it and talk about the prerequisites, he will go through the install, and we will spend some time with the config file, finally he will show us some examples of ora2pg being used.
Views: 15114 InfoQ
PostgreSQL Cross Database Queries using DBLink Extension - dbrnd.com
 
03:57
Database Research & Development (dbrnd.com): In this video help, I demonstrated to execute cross database queries using dblink extension in the PostgreSQL. You can refer this original post for scripts, http://www.dbrnd.com/2015/05/postgresql-cross-database-queries-using/
Views: 4380 Anvesh Patel
Migrating from Oracle® to Postgres Plus Advanced Server 9.3
 
02:42
http://bit.do/dSPa5 Secret sale page at EasyFrom. EDB Migration Toolkit을 이용하여 손쉽게 Oracle을 PPAS(Postgres Plus Advanced Server)로 마이그레이션을 할 수 있습니다. 1. Oracle (AS-IS) 데이터베이스 정보 확인하기 - Query One Tool 사용 2. PPAS (TO-BE) 데이터베이스 정보 확인 - PEM Client Tool 사용 - Query One Tool 사용 ** PPAS : Postgres Plus Advanced Server ** PEM : Postgres Enterprise Manager 3. EDB Migration Toolkit을 이용하여 Postgres Plus Advanced Server 로 마이그레이션 수행 4. 마이그레이션 완료 후, 데이터베이스 및 테이블, 테이블 건수 확인
Python with Oracle
 
05:55
Oracle connection using Python script from scratch.
Views: 389 Mukunthan Ragavan
HVR PostgreSQL
 
10:49
Heterogeneous, real-time replication SQL Server to PostgreSQL
Views: 903 HVR
Урок 34.PL SQL. Функция как результат запроса piplined
 
07:40
А можно ли как в MS SQL в Oracle извлечь данные из некоторой процедуры или функции в табличном виде Для этого в PL SQL используется специальный тип функций pipelined Oracle PL 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/plsql/l34.txt
create android apps by oracle apex mobile application
 
02:53
Oraclec Apex create android apps by apex mobile application steps 1. Create apex mobile application Did it for HR or according to ur requirements 2. Its a process to Convert web application into native Android - url https://gonative.io - Now u can do by yourself - Paste ur apex url http://43.240.102.187:7070/apex/f?p=109 - then Build - Receive email - find Private Management URL from email and click on that - and than u will find --Download Android APK-- on that page - Download apk file - Transfer apk into ur cell phone - Internet should be available - Hope it works 3. Run thats it Thanks . . .
Views: 4221 Mostafiz Mitul
Building Python Messaging Apps with Oracle Database
 
42:57
Nancy Ikeda, Consulting Member of Technical Staff, Oracle Christopher Jones, Senior Principal Product Manager, Oracle Anthony Tuininga, Software Developer 5, Oracle Come see how Python applications and microservices can efficiently communicate asynchronously. Messaging is the key to architectural scalability. The Python cx_Oracle interface provides a flexible, native API for Oracle Advanced Queuing. This session examines this API and presents examples.
Views: 943 Oracle Developers
Integrating Google Maps in an APEX Application
 
07:21
Integrating Google Maps in an APEX Application
Views: 18342 dbconpl
Building a Web Service for up and downloading files to Oracle Database
 
25:11
Using just SQL and PL/SQL with Oracle REST Data Services, I'll show you how to build a REST API to POST and GET files to and from your Oracle Database. The files are stored in a table as BLOBs. The sample code and slides can be found here: https://www.thatjeffsmith.com/archive/2018/11/building-a-web-service-for-uploading-and-downloading-files-the-video/ You can skip the intro and get straight to the demo: Demo begins at 4:25
Views: 1107 Jeff Smith
EnterpriseDB  Migrating from Oracle to Postgres Plus Advanced Server
 
05:45
EnterpriseDB Migrating from Oracle to Postgres Plus Advanced Server
Differences Between Oracle And PostgreSQL Open Source Database [2015]
 
04:59
In this Video you will come to know the differences between Oracle And PostgreSQL Databases. In coming days I will do more videos based on this topic. This video help the developers to Migrate from Paid database to opensource database. 60% Oracle queries working properly in PostgreSQL, So its easy to migrate. PostgreSQL contains ACID property. Compare to Oracle, PostgreSQL retrieve data quickly (Refer my Blog: http://clearosapps.blogspot.in/2015/10/oracle-vs-postgresql-which-is-faster.html ). The queries which i used in this video are available in my blog - http://clearosapps.blogspot.in/ If you have any difficulties, any queries drop comments, like the video, Share it and subscribe the Channel for further updates. Background Music used: Gold Coast by Jens Kiilstofte https://machinimasound.com/music/gold-coast/ Licensed under Creative Commons Attribution 4.0 International (http://creativecommons.org/licenses/by/4.0/)
Views: 17488 8bitzs
PostgreSql 9.2 vs Oracle 11g Xe vs Ms Sql Server 2005 Express Test
 
10:32
PostgreSql 9.2 vs Oracle 11g Xe vs Ms Sql Server 2005 Express Test
Views: 9969 Erdoğan UĞUZ
Jaspersoft Studio 6 2 0 Sample Report Creation Using postgresql
 
08:17
Jasper Sample Report Creation Using PostgreSQL DB as Data source
Views: 4468 Know BI Tools
Execute PL/SQL calls with Python and cx_Oracle
 
08:54
How to use cx_Oracle to make PL/SQL calls from a Python application. Additional Resources: - Companion blog post: https://learncodeshare.net/2018/07/30/execute-pl-sql-calls-with-cx_oracle/ - CRUD with Python: https://www.youtube.com/playlist?list=PL1T-f7vLvANmcEOHjtRTYkHxY_UHkerOn - cx_Oracle Documentation: http://cx-oracle.readthedocs.io/en/latest/ - Get started with Python: https://www.python.org/about/gettingstarted/ - Steven Feuerstein’s Blog: https://stevenfeuersteinonplsql.blogspot.com/ - Bryn Llewellyn’s Blog: https://blogs.oracle.com/author/bryn-llewellyn - Oracle DevGym: https://devgym.oracle.com/ - Oracle LiveSQL: https://livesql.oracle.com/apex/livesql/file/index.html
Views: 292 Blaine Carter
Rank Your Results: Using Full Text Search with Natural Language Queries to get Ranked Results
 
54:49
Check out http://www.pgconf.us/2015/event/73/ for the full talk details. PostgreSQL text search has the capability to perform natural language searches and return a ranked list of matching documents, similar to a Google-style search. The capability, along with an automatic list of 'stop' words that are ignored and synonyms that are matched, is excellent for advanced document and comment-field search applications. About the Speaker Jamey Hanson is a reformed Oracle database administrator and developer currently working to migrate US Federal Government Oracle applications to PostgreSQL. He has presented at multiple Oracle and PostgreSQL conferences as well as taught Oracle, Internet Security and Project Management for the University of Maryland. He is interested in using PostgreSQL to explore large data sets.
Views: 966 Postgres Conference
Curso Impresión en Oracle APEX con el kit de Jasper Reports Integration e iReport
 
06:58
En éste video presento una nueva propuesta basada en aprender a crear reportes personalizados con iReport Designer y poder llamar a esos reportes con Oracle Application Express utilizando el kit de Jasper Reports Integration de Opal Consulting. Para adquirir el curso ingresa al siguiente enlace: http://www.clartechacademy.com Visita mi blog en http://descubriendooracle.blogspot.com/
Views: 3414 Clarisa Maman Orfali
Урок 12.PL SQL. Курсоры в PL SQL.
 
10:21
Для работы с наборами данных на основе запросов с командой SELECT в PL SQL есть специальные конструкции - курсоры В PL/SQL поддерживаются два типа курсоров: явные и неявные. Явный курсор объявляется разработчиком, а неявный курсор не требует объявления. Курсор возвращает набор данных. Курсор может быть объявлен в секциях объявлений любого блока PL/SQL, подпрограммы или пакета. Для управления явным курсором используются операторы CURSOR , OPEN , FETCH и CLOSE . Oracle PL 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/plsql/l12.txt
Database Link
 
02:48
Views: 4355 KannaTech2013Videos
SQL: Sequence Generator
 
04:41
In this tutorial, you'll learn how to make use of sequence generator. 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: 8657 radhikaravikumar
Liquibase with Oracle DB and Developer Cloud Service
 
11:47
How to manage your database scripts lifecycle with Liquibase. Demo with Oracle DB, MySQL, and Oracle Developer Cloud Service. Related blog - https://blogs.oracle.com/shay/introduction-to-liquibase-and-managing-your-database-source-code
Views: 3913 ShayJDev
PIVOT Tutorial - generating dynamic column with PIVOT Interview Question SQL
 
14:14
In this lecture you will learn about PIVOT operator and using it to generate dynamic columns.PIVOT is very use full operator to convert values into columns. PIVOT: •Convert your output from (values)vertical order to horizontal(making columns) one Topic to cover: •PIVOT example •PIVOT syntax •Interview Question •PIVOT on northwind •Dynamic PIVOT query http://www.techsapphire.in/index/pivot_sql_lesson_with_generating_dynamic_columns_with_pivot/0-158
Views: 30691 techsapphire
Migrate data from Oracle table to PostgreSQL
 
00:16
Migrate data from Oracle table to PostgreSQL, by OracleToPostgres, http://www.withdata.com/oracletopostgres/ . Download link: http://www.withdata.com/down/OracleToPostgres.exe .
Views: 694 Shiji Pan
Using Apex for REST Integration
 
01:09:40
Part of what truly makes a platform is an ability to integrate with third party devices, servers and software. Join Ami Assayag and Kirk Steffke from CRM Science and Developer Evangelist Josh Birk as they breakdown examples of using Apex for integration solutions. Apex has robust methods for handling both inbound requests into Salesforce and outbound calls into third party systems. This webinar will break down how Apex can be used in these cases as well as how to test the code once it is up and running. Key Takeaways - How Apex fits into an integration solution - Using Apex to create custom endpoints - Handling outbound calls with Apex - How to achieve test coverage with mock interfaces
Views: 14830 Salesforce Developers
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: 258208 The Bad Tutorials
Migrate data from PostgreSQL table to Oracle
 
00:16
Migrate data from PostgreSQL table to Oracle, by PostgresToOracle, http://www.withdata.com/postgrestooracle/ . Download link: http://www.withdata.com/down/PostgresToOracle.exe .
Views: 209 Shiji Pan
Framework multi-conexión v6.0(Firebird, SQL Server, MySQL, PostGreSQL, Oracle y etc.)
 
11:55
Framework multi-conexion v6.0, en esta nueva versión se añade una clase exclusiva para realizar mantenimiento y/o catalogo de las tablas como (cliente, proveedor, categoría, linea, etc.), se conecta a cualquier motor de base de datos desde Visual FoxPro sin la necesidad de cambiar el código fuente, incluye ejemplo y ademas una nueva forma de desarrollar. interesados enviarme un correo a rycjesusrj @ hotmail.com y les diré como obtener esta excelente herramienta.
Views: 2951 MALKASOFT A.D.P.I.
1С 8 и Oracle Database.
 
17:37
http://onlineadmin.kuharbogdan.com - уроки по 1С бесплатно!
Oracle 11g Основы PL SQL. Модуль 09. Создание хранимых процедур
 
55:47
- Модульный и многоуровневый дизайн подпрограмм - Модульность разработки с помощью блоков PL-SQL - Среда исполнения кода PL-SQL - Преимущества использования подпрограмм PL-SQL - Различия между анонимными блоками и подпрограммами - Создание, вызов и удаление хранимых процедур при помощи команды CREATE и SQL Developer - Использование параметров в процедурах и различные режимы параметров - Просмотр информации о процедурах в представлениях словаря данных
Views: 4351 Tech Net
PostgreSQL a Oracle.  ¿Como realizar la migración de la base de datos PostgreSQL a Oracle?
 
14:11
En esta demo presentación vamos a hablar de la herramienta de migración proporcionada por Ispirer Systems para migración de PostgreSQL a Oracle. ¿Como realizar la migración de la base de datos PostgreSQL a Oracle ? Para obtener más información: http://www.ispirer.es/products/postgresql-to-oracle-migration https://www.youtube.com/watch?v=kZnIVrwLr40 https://www.youtube.com/user/IspirerSystems Oracle, PostgreSQL , ispirer mnmtk, ispirer systems, migrar a Oracle, migrar de PostgreSQL, convertir PostgreSQL, convertir a Oracle, migrar PostgreSQL a Oracle , migrar base de datos, convertir base de datos, migración a Oracle, herramienta de migración, PostgreSQL a Oracle , PostgreSQL a Oracle , conversión a Oracle, conversión de PostgreSQL, convertir PostgreSQL, convertir a Oracle, lógica de negocio, datos, banco de datos, herramienta de migración, conversión
Views: 301 Ispirer Systems
Install ORACLE on MacBook
 
10:26
install oracle in any mac os like desktop laptop, For practice OracleDB::::: Download VirtualBox ---::::::: https://download.virtualbox.org/virtualbox/5.2.6/VirtualBox-5.2.6-120293-OSX.dmg Dowload OracleDB ---::::: http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html
Views: 13637 EVERYTHING is possible
Урок10a.PL SQL.Циклы в PL SQL
 
11:09
Практически в любом алгоритмическом языке программирования существуют синтаксические конструкции, отвечающие за организации повторения одинаковых частей программы. Такие повторения назеваются циклами, а операторы – операторами для организации циклов. В отличие от других языков с их repeat while в ORACLE PL SQL циклы упрощены, но вместе с тем удобны, хорошо воспринимаются и позволяют реализовать практически любой сложный алгоритм. Oracle PL 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/plsql/l10a.txt
3 Bases de Datos bajo la lupa: SQL Server, PostgreSQL y Oracle
 
01:36:16
Este hangout contará con la participación de Edgar Sánchez de LogicStudio por Microsoft SQLServer, Jaime Casanova de 2Qndquadrant por PostgreSQL y Paola Pullas de Refundation por Oracle Database Pocas veces se puede tener a personas APASIONADAS por la tecnología reunidas y hablando de los que más les gusta en un ambiente de camaradería.
Views: 7564 Paola Pullas
Creating and Running a Database Application Using Oracle Application Express 4.2 - OLL Live Webcast
 
48:35
Watch how to create a web-based Database Application using Oracle Application Express 4.2. You will also see how to add a Mobile User Interface to the database application, thereby allowing users to access the application on a mobile device. Learn how to use a responsive theme in an application, so that the application can be viewed on any device such as desktops, mobiles, smartphones or tablets. The related tutorial is here https://apex.oracle.com/pls/apex/f?p=44785:24:0::::P24_CONTENT_ID,P24_PREV_PAGE:8176,1 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.
Explore Data in Oracle Data Visualization V4
 
03:42
In Oracle Data Visualization Desktop or Oracle Analytics Cloud..... Create a new project. Add a visualization type, add a sort, create a marquee selection, keep a selection, swap data elements, change a visualization type, save the project, and view the story. ================================= 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.
Connect Any External Datasource with Custom APEX Connector (1)
 
19:33
The APEX Connector Framework enables developers to leverage the flexibility of Salesforce Connect to virtually integrate data from external systems. It provides powerful capabilities to develop your own custom adapter when the other available Salesforce Connect adapters aren't suitable for your needs. Join us to learn the general concepts of the APEX Connector Framework, get an introduction to upcoming and planned product features, and learn how to build a custom connector on your own.
Views: 1208 Salesforce Developers