Home
Search results “Oracle ddl dblink”
Oracle Tutorial || online training|| Adv Sql | Database Link Part - 2 by basha
 
17:33
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......
prm dul export ddl from corrupted oracle database
 
01:52
ddl include: table structure, index , constraint , sequence , view , dblink
Views: 5 Maclean Liu
SQL Tutorial - How to grant System and Object Privileges in Oracle Database
 
18:08
In this session I Explaining the Theory of Granting and Revoking System and Object privileges.... #Oracletutorialforbeginners #rmanrecoverytutorial #SQLTutorial #SystemandObjectPrivilegesinOracle by Lalit saini
Views: 12312 Oracle World
Connecting to DB2 database using SQL Developer and jdbc driver.
 
09:20
This tutorial is about connecting to DB2 database using Oracle SQL Developer client and third party jdbc driver. SQL Developer will not only help you to connect to DB2 database engine but also help you perform DDL and DML operation like create / alter / drop table. Select, insert, Update and Delete. Please find the third party jdbc driver : https://drive.google.com/open?id=0BznrW3lgX0ozRUxmcU0zbmVVZms
Views: 13044 Subhroneel Ganguly
Create new connection with new user in Oracle SQL Developer
 
10:28
This video shows you how to create a new connection using a new user account (other than the system user account) in Oracle SQL Developer, so that you have a clean workspace without all the clutter of system tables. It is NOT a general introduction to using Oracle SQL Developer.
Views: 361856 Chitu Okoli
PL/SQL tutorial 17: Make synchronized backup copy of a table using DML Trigger
 
07:23
Learn how to make a synchronized backup copy of a table using DML Trigger in oracle database by Manish sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/Synchronized-Table-backup-dml-trigger Previous Tutorial ► Giveaway announcement https://youtu.be/3vsPLcMsRwA ►Table Auditing using DML trigger https://youtu.be/i5fw-67P3XY ►Learn copy table with or without data using Create Table As http://bit.ly/create-table-as ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 44923 Manish Sharma
Oracle Database Express Edition (XE) Kullanıcı Oluşturma ve Toad'a Bağlama
 
01:31
sqlplus "/ as sysdba" create user denemeusr identified by sifre; grant CREATE SESSION, ALTER SESSION, CREATE DATABASE LINK, - CREATE MATERIALIZED VIEW, CREATE PROCEDURE, CREATE PUBLIC SYNONYM, - CREATE ROLE, CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE, - CREATE TRIGGER, CREATE TYPE, CREATE VIEW, UNLIMITED TABLESPACE - to denemeusr; C:\ORA_DS10GR2\NETWORK\ADMIN XXX= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521) ) (CONNECT_DATA = (SID = XE) ) )
Views: 154 Values
Types of commits in Oracle (implicit & explicit)
 
02:05
types of commits 's in oracle (implicit &explicit commit)
Views: 131 sreetheja amilineni
12. SQL Server for Oracle DBA's - Backup and Recovery
 
43:17
SQL Server for Oracle Database Administrators - Backup and Recovery http://dbacatalog.blogspot.com
Views: 257 dbacatalog
Oracle Database11g tutorials 14 : How to CREATE TABLE using sql developer and command prompt
 
08:36
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A TABLE. if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS. We can also say that SQL tables are kind of data structure which are used by database for efficient storage of data. To create a table in our database we use SQL CREATE TABLE command. SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL. To Create a table in your schema you will require CREATE TABLE system privilege. In our future videos we will see what are system and object privileges and how to grant them to a user. Today for this video we will be using Sample schema HR which already has all the necessary privileges. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets open our SQL developer I am connected to HR schema if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways of applying them on a column in a table. for this video we will concentrate on create table only so when you are done with all your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Views: 183633 Manish Sharma
7.ORACLE WORLD- FLASHBACK TRANSACTION QUERY
 
14:43
Hi guys today we will learn how to perform flashback transaction query to find out the DDL that performed by users. #FLASHBACKTRANSACTIONQUERY Oracle database Unbeatable,Unbreakable Platform..
Views: 1563 Oracle World
Oracle Core, Лекция 3-1
 
01:17:54
Ссылка на файл с презентацией: https://docs.google.com/presentation/d/1SuOAg8hWW0v2I6394Epzj8V6HeqIKc2ePCuxG8vUaPA/edit?usp=sharing (презентация может быть с анимацией) Ссылка на краткий конспект лекции: https://docs.google.com/document/d/1Mool1fZydho51W9F888yUqAVGTa8SaoBdWWVmRZhEdk/edit?usp=sharing 1. История SQL (развитие стандарта) 2. Группы команд SQL: DDL, DML, DCL, TCL 3. Оператор SELECT, его структура 4. Соединения таблиц (JOINS): 4.1 Внутреннее соединение (INNER JOIN) 4.2 Внешнее соединение (OUTER JOIN): левое внешнее соединение (LEFT OUTER JOIN), правое внешнее соединение (RIGHT OUTER JOIN), полное внешнее соединение (FULL OUTER JOIN) 4.3 Декартово произведение (CARTESIAN PRODUCT) 4.4 SELF JOIN 4.5 PARTITIONED OUTER JOIN 4.6 ANTIJOIN 4.7 SEMIJOIN 5. Подзапросы (SUBQUERY) 6. SET операторы: UNION, UNION ALL, MINUS, INTERSECT 7. Группировка: group by clause, group by cube, group by rollup, group by grouping sets 8. Агрегатные функции: MIN, MAX, COUNT, AVG, SUM 9. Условия ANY, ALL, SOME 10. Условие IN 11. Условие LIKE 12. Условие REGEXP_LIKE 13. Условие EXISTS 14. Условие BETWEEN 15. Выражение CASE Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle
How to install a JDBC driver in Oracle SQL Developer
 
02:38
To connect to a third party database in SQL Developer, you will need to install a jdbc driver. The drivers are free downloads. Review the supported jdbc driver versions at http://www.oracle.com/technetwork/products/migration/jdbc-migration-1923524.html. 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.
Views: 155698 Oracle Learning Library
How to compare database environments with multi-schema compare in Toad for Oracle
 
08:04
https://www.quest.com/products/toad-for-oracle/ Learn how to compare database environments with multi-schema compare in Toad for Oracle.
Views: 2552 Quest
ORACLE SQLPLUS.✓ Acceso con Command ✓ Ejecución de *.txt ✓ Formato Fecha ✓ Spool
 
10:53
Prof.: Juan Miguel Vargas Rivera. Contenidos de la Sesión ✓ SqlPlus se puede abrir desde la ventana de comandos (Windows+R), ingresando 'sqlplus usuario/contraseñ[email protected]'. ✓ Recordar que para ingresar debemos utilizar 'connect'; para cerrar cerrar debemos ingresar 'disconnect' y luego 'exit'. ✓ Uso de archivo de texto para cargar lineas de codigo sql. Una vez creado el archivo ingresar 'start' o "@" seguido de la ubicacion del archivo. ✓ Mostrar tablas del usuario usando la estructura 'select table_name from user_tables'. ✓ Para modificar la fecha de sistema debemos ingresar: "alter session set nls_date_format='yyyy-mm-dd' ". Para visualizar la fecha de sistema ingresamos 'sysdate'. ✓ Uso de 'spool'. Sirve para guardar el registro de las consultas y resultados. Se utiliza ingresando 'spool' seguido de la ruta del archivo de destino. Al final se ingresa spool off y nos da como resultado un archivo con todas las operaciones y resultados obtenidos con el SqlPlus.
Views: 75 Elías Jurado
Connecting to Oracle Database using Hibernate Framework
 
28:41
A basic hibernate mvc tutorial which connect to Oracle database 12c and do some DDL and DML operation using hibernate framework. I have used Oracle database 12c release 1 on Red Hat Linux 6.4 64 bit and used Eclipse Helios 64 bit and Hibernate Framework 3.6.4. I am uploading the project and sharing the link. The main contents of the project is hibernate.cfg.xml, UserDetails.java and OracleTest.java. https://drive.google.com/file/d/0BznrW3lgX0ozTE9aM1Q4M0tCeXc/view?usp=sharing
Views: 13226 Subhroneel Ganguly
How to Connect Toad For Oracle To Oracle Database
 
03:41
This video shows how to connect Toad for oracle to an oracle database via direct connection.
Views: 24173 SQL TUTORIALS
Dynamic SQL in PL/SQL
 
35:47
Held on July 3 2018 Steven Feuerstein offers a quick overview of key recommendations for dynamic SQL in PL/SQL, including: only use dynamic SQL when it's necessary, choose binding over concatenation, protect from SQL injection with DBMS_ASSERT. 01:22 What's wrong with this code? 02:15 Only use dynamic SQL when necessary 04:00 Bind, don't concatenate 09:47 Protect your concatenations 13:03 Other dynamic SQL good-to-knows 17:50 Take advantage of the Oracle Dev Gym and Live SQL websites 21:27 Q&A 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: 730 Oracle Developers
Oracle Tablespace PITR Recovery Lab Activity | TS-PITR Part - 2
 
12:24
https://dbagenesis.com/p/oracle-advanced-rman-backup-recovery Recovery Manager (RMAN) automatic TSPITR enables you to quickly recover one or more tablespaces in a database to an earlier time without affecting the rest of the tablespaces and objects in the database. RMAN TSPITR is most useful for the following situations: 1. You want to recover a logical database to a point different from the rest of the physical database, when multiple logical databases exist in separate tablespaces of one physical database. For example, you maintain logical databases in the orders and personnel tablespaces. An incorrect batch job or DML statement corrupts the data in only one of the tablespaces. 2. You want to recover data lost after DDL operations that change the structure of tables. You cannot use Flashback Table to rewind a table to before the point of a structural change such as a truncate table operation. 3. You want to recover a table after it has been dropped with the PURGE option. 4. You want to recover from the logical corruption of a table. You can also use Flashback Database to rewind data, but you must rewind the entire database rather than just a subset. Also, unlike TSPITR, the Flashback Database feature necessitates the overhead of maintaining flashback logs. The point in time to which you can flash back the database is more limited than the TSPITR window, which extends back to your earliest recoverable backup.
Views: 527 DBA Genesis
Oracle Core,  Лекция 2
 
55:04
Ссылка на файл с презентацией: https://docs.google.com/presentation/d/1MeqLip8n8LWD2rORUMdFTwmHIH7VCVEhB3lrCLwRk2E/edit?usp=sharing (презентация может быть с анимацией) Ссылка на краткий конспект лекции: https://docs.google.com/document/d/13WM7Y_q2PZ_zaM7tk22OJYSKX3BtdJPWUXONpiYKyUQ/edit?usp=sharing 1. История развития СУБД Oracle 2. Схема (Schema). Оператор CREATE USER 3. Таблица (Table). Типы таблиц Oracle 4. Традиционные таблицы (heap organized table) 5. Индекс-таблицы (index organized table) 6. Кластеризованные индекс-таблицы (index clustered table) 7. Кластеризованные хэш-таблицы (hash clustered table) 8. Отсортированные кластеризованные хэш-таблицы (sorted hash clustered table) 9. Вложенные таблицы (nested table) 10. Временные таблицы (temporary table) 11. Внешние таблицы (external table) 12. Rowid 13. Индекс (index). Типы индексов 14. Индексы со структурой B-дерева (b-tree index) 15. Кластерные индексы со структурой B-дерева (b-tree cluster index) 16. Индексы по реверсивным ключам (reverse index) 17. Битовые индексы (bitmap index) 18. Функциональные индексы (functional index) 19. Констрейнт (constraint). Типы констрейнтов. 20. Представление (view). Оператор CREATE OR REPLACE VIEW 21. Последовательность (sequence). Оператор CREATE SEQUENCE 22. Триггер (trigger) 23. Процедура/функция (stored procedure/functions) 24. Пакет (package) 25. DBlink 26. Пространства имен (namespaces) Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle
How to download Oracle Sql Developer
 
05:47
Today I'm am going to help you downloads Oracle's Sql Developer.
Views: 87 webfreeinfo com
Oracle SQL comandos basicos
 
08:56
En esta presentacion vemos los comandos basicos de la consola de comandos del motor de bases de datos Oracle en sus variantes mas simples, utilizando SQLPlus bajo un entorno linux. Visiten mi blog para mas tutoriales en http://descubriendooracle.blogspot.com Descubriendo el Mundo Oracle
Views: 46204 Clarisa Maman Orfali
Oracle Database: Working with External Tables
 
02:29
“External tables can be a fantastic tool for reading files into your database using SQL,” says Oracle SQL Developer advocate Chris Saxon. “However, they can be a bit tricky to work with.” In this 2 Minute Tech Tip recorded at ODTUG Kscope 2018, Chris explains how using the external table parameter override clause can make things a lot less tricky, and, even better, how Oracle Database 18c allows you to create inline external tables. https://developer.oracle.com/ https://cloud.oracle.com/en_US/tryit
Views: 508 Oracle Developers
SQL Developer 3.1 - Database Copy
 
04:55
This demonstration will show how to copy objects and data from one database to another. This video is part of the SQL Developer Release 3.1 New Features series. --------------------------------------------------------------------- Copyright © 2012 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.
create user and grant privileges in oracle sql programming language
 
06:13
create user and grant privileges in oracle sql programming language
Views: 712 Vijay dubey
How To Create Oracle Database - Using GUI - Browser
 
05:29
Use oracle database in GUI. Connect, Create Workspace and User Oracle Database Express Edition 11g Release 2 download link http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html
Views: 7747 Tech Tips
37강 oracle 11g user add(사용자 생성)
 
12:36
1. 처음 시작하는 MySQL DataBase https://www.udemy.com/softcampus-mysql/?couponCode=SOFTMYSQL 2. 처음시작하는 구글 공식 개발 언어 : 코틀린(Kotlin) https://www.udemy.com/softcampus-kotlin/?couponCode=SOFTKOTLIN 유데미에서 서비스 되는 소프트캠퍼스 강의 아래 경로를 통해 수강신청하시면 무조건 $9.99에 결재 됩니다. 3. Mobile App UI UX GUI Design Tutorials(모바일 앱 UX UI GUI디자인 실무) 할인쿠폰 https://www.udemy.com/mobpp-uxui-design-working-level-uxui/?couponCode=SOFTUXUI 4. 코틀린 기반 안드로이드 기본(Kotlin for Android: Beginner) 과정 https://www.udemy.com/sofrtcampus_adroid/?couponCode=SOFT_KAD 5. 유니티 클릭커 게임 과정 https://www.udemy.com/unity3d-clicker/?couponCode=SOFTCLICKER 6. 개발자 및 디자이너를 위한 HTML & HTML5 Tutorials https://www.udemy.com/softcampus-html5/?couponCode=SOFTHTML 7. node.js server Tutorials https://www.udemy.com/nodejs-server-tutorials/?couponCode=SOFTNODE 8. 처음시작하는 JQuery programming https://www.udemy.com/softcampus-jquery/?couponCode=SOFTJQ 9. 처음시작하는 JavaScript Tutorials https://www.udemy.com/softcampus-javascript/?couponCode=SOFTJAVAST 10. 개발자 및 디자이너를 위한 CSS & CSS3 Tutorials https://www.udemy.com/css-css3-tutorials/?couponCode=SOFTCSS 11. 처음시작하는 파이썬(Python) https://www.udemy.com/python-soft/?couponCode=SOFTPYTHON 12. unity 3D(유니티 3D) defense game(디펜스 게임) 할인 쿠폰 https://www.udemy.com/softcampus-unitydefense/?couponCode=SOFTDUNITY 강사 : 김일한 (주)소프트캠퍼스 http://www.softcampus.co.kr 더많은 무료 강의는 사이트에서 확인하실수 있습니다. 1강 오라클 데이터 베이스 구조 2강 오라클 자격증 종류 3강 데이터베이스 설치 4강 select 기능과 타입 5강 SQL 연산자 6강 SQL 조건 연산자 7강 where query 8강 논리연산자,Between in 9강 정렬(like,sort) 10강 주요함수, 숫자함수 11강 SQL 문자 함수 12강 날짜함수 13강 변환함수 14강 데이터 함수의 적용 15강 SQL 조건식 16강 그룹 함수 집계 데이터 17강 GROUP BY 18강 HAVING 19강 join data 20강 slef join 21강 Outer join 22강 Sub Join 23강 Sub query 24강 Sub query 25강 set 26강 set 27강 set 28강 DML 29강 DML 30강 COMMIT ROLLBACK 31강 DDL 32강 DDL 33강 데이터 무결성을 위한 제약 조건 34강 View 35강 시권스 36강 인덱스 37강 사용자 생성 38강 권한 부여 39강 객체권한 40강 Review 41강 Review 42강 Review
Views: 436 소프트캠퍼스
Identifying Host Names and IP Addresses in SQL and PL/SQL using Built-in Oracle Functionality
 
02:11
This video demonstrates how to do DNS lookups and idenitify server and client host names and IP addresses in SQL and PL/SQL from Oracle. For more information see: https://oracle-base.com/articles/misc/identifying-host-names-and-addresses For information on Network Access Control Lists (ACLs) see: https://oracle-base.com/articles/11g/fine-grained-access-to-network-services-11gr1 https://oracle-base.com/articles/12c/fine-grained-access-to-network-services-enhancements-12cr1 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Mike Donovan Blog: http://blog.dbvisit.com/author/miked/ Twitter: https://twitter.com/dbvisitmike Website: http://www.dbvisit.com/ Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 8441 ORACLE-BASE.com
Oracle Database11g tutorials 5:  how to retrieve Data Using SQL SELECT statement || SQL tutorials
 
05:13
This SQL tutorial and Oracle database 11g tutorial for beginners will show how to retrieve data using SQL SELECT statement. Tool used in this tutorial is SQL developer. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 You can download the Script which is used in this SQL tutorial from this link https://copy.com/yDQ46Tb64efm Contacts Email [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/RebellionRider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from The Code makers
Views: 199015 Manish Sharma
Mysql Tutorial in Hindi Part 2 create database
 
07:05
Mysql Tutorial in Hindi Part 2 create database Link to next video : http://youtu.be/FufKJ70OcX0 In this video i have shown how to create database and table inside it and how to insert data into the table. Welcome to Computergirlvids Hey I am Neha and this is my Youtube channel where you will get easy oriented way of learning programming skills.I will walk you through tones of programming language tutorials, so please do subscribe , like and share my channel to get updated with my latest videos. Subscribe to Computergirlvids:https://www.youtube.com/channel/UCVYsEFbxCCo_n08obIJFfCw Facebook Page:https://www.facebook.com/computergirlvids/ Google+ Page:https://plus.google.com/u/0/107555751921434071626 Twitter Page:https://twitter.com/computergirlvid
Views: 68047 computergirlvids
Roman Bazhin - «A pentester’s view of Oracle Database Communication Protocol»
 
44:24
Slides - http://2014.zeronights.org/assets/files/slides/oracle-database-communication-protocol.pdf
Views: 443 ZeroNights
membuat username dan password sql developer
 
08:03
make connection wit sql command in sql develepoer
Views: 38 jhon leo
How to add new Database in PLSQL Developer
 
02:01
How to add new Database in PLSQL Developer
Views: 3208 Real Videos
Триггеры и Транзакции. PostgreSQL основы. Урок 6
 
12:58
Промокод на скидку 15% на все курсы ITVDN- H94BCAB Полный видео курс- https://itvdn.com/ru/video/postgresql?utm_source=yb_promo_postgresql Научить студентов создавать функции и триггеры. Дать теоретические знания о транзакции. Научить выбирать для себя подходящие уровни изоляции транзакций. Благодарим всех за лайки, перепосты, добавление в избранное! Также подписывайтесь на нас в социальных сетях: https://vk.com/itvdn https://www.facebook.com/ITVDN.EDU https://twitter.com/ITVDN/ https://www.linkedin.com/company/itvdn https://plus.google.com/u/0/+ItvdnEDU... Свои предложения присылайте на почту: [email protected]
Views: 821 ITVDN
How to create database using Oracle SQL developer
 
16:26
This tutorial is on one of the simplest way to create database tables in Oracle SQL Developer with ease and simple SQL coding. Don't forget to: LIKE | COMMENT | SHARE | and SUBSCRIBE!!!
Views: 1846 CWTE Technologies
How to Install Oracle Database 11g on Windows 10 By Manish Sharma
 
08:24
Detail tutorial on How to install Oracle database 11g enterprise edition on Windows 10 Professional 64 bit. Full installation under 9 mins. You can follow the steps for installing Oracle 11g on Windows 10 32 bit home or any other version. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Previous Tutorial ► Download Link http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html ►Create Database using DBCA https://youtu.be/enFFezPYhCg ►How To Unlock User using ALTER USER https://youtu.be/sMqq9MSVmQo ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/TheRebellionRider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 356243 Manish Sharma
Watch Oracle DB Session Activity With My Real-Time Session Sampler
 
02:41
Watch Oracle DB Session Activity With My Real-Time Session Sampler For details about this tool, I created a special posting in my blog, A Wider View. Have a look! http://blog.orapub.com/20140811/Watch-Oracle-DB-Session-Activity-With-The-Real-Time-Session-Sampler.html The rss.sql tool is included in the OraPub System Monitor (OSM) toolkit (v13j), which can be downloaded http://resources.orapub.com/OSM_OraPub_System_Monitor_p/osm.htm Watching session activity is a great way to diagnose and learn about Oracle Database tuning. There are many approaches to this. I wanted something simple, useful and modifiable. I wanted no Oracle licensing issues. And, I wanted something I could give away. The result is what I call the Oracle Real-Time Session Sampler (OSM: rss.sql). The tool is simple to use. Based on a number of filtering command line inputs, it repeatedly samples active Oracle sessions and writes the output to a file in /tmp. You can do a "tail -f" on the file to watch session activity in real time!
Views: 679 OraPub, Inc.
Oracle Trigger Example - After Insert - krumony
 
08:52
Oracle Trigger Example - After Insert - krumony
Views: 98 Mony HO
Oracle Core, Лекция 7
 
53:01
Ссылка на файл с презентацией: https://docs.google.com/presentation/d/1Afp1WPhUBryLLSQz9hLffrva27KIaGUNlSo6ycL7CvU/edit?usp=sharing (презентация может быть с анимацией) Ссылка на краткий конспект лекции: https://docs.google.com/document/d/1_eXR7XOgdxcGXSO09Pbuh5_pLkysXeHNkZ-8Q5Ym1tE/edit?usp=sharing 1. Структура процедуры/функции: create or replace procedure/function. Вызов с правами создателя/вызывающего (authid definer/current_user). Pipelined функции. Determenistic функции. 2. Пакеты. Структура спецификации и тела пакета: create or replace package/create or replace package body. 3. Перегрузка процедур/функций в пакетах 4. Глобальные переменные в пакетах 5. INLINE Pragma 6. SERIALLY_REUSABLE Pragma 7. Conditional compilation Pragma 8. Ограничения языка PL/SQL 9. Package Writing Guidelines 10. PL/SQL Source Text Wrapping 11. Спецификация без тела 12. Dependencies: dependent object, referenced object. Представление dba_dependencies. 13. Типы зависимостей: direct dependent, indirect dependent, cascading invalidation, coarse-grained invalidation, fine-grained invalidation 14. Запуск удаленных процедур (через dblink) 15. Jobs. Представления dba_jobs, dba_jobs_running. Пакет dbms_job 16. Метод dbms_job.submit 17. Scheduler. Представления dba_scheduler_jobs, dba_scheduler_running_jobs. Пакет dbms_scheduler 18. Методы dbms_scheduler.create_job и dbms_scheduler.drop_job 19. Периодичность запуска scheduler jobs 20. Создание цепочек (chans) джобов. Методы: dbms_scheduler.create_chain, dbms_scheduler.define_chain_step, dbms_scheduler.define_chain_rule, dbms_scheduler.enable 21. Native/interpreted компиляция Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle