Thanks for Watching
please Like, Subscribe and Share...
BoxCut Media.
Views: 27693
BoxCut Media
This video shows you how to create a new user and to grant privileges to them.
Syntax to create a new user:
create user username identified by password
Views: 36456
Thamizharasan Mohan
This video is about how to solve the error insufficient privileges in oracle and how to create a new user in oracle.........
You can use this method for sql developer. After opening sql developer go to command prompt and follow this instruction ....
I hope this will help you for solving the insufficient privileges in oracle 10g......
--------------------------------------------------------------------------------
If face any problem then ..
Contact/Follow on........
Email : [email protected]
Google+ : https://plus.google.com/102074100342156490577
Twitter : https://twitter.com/Alamgir21409730
Facebook : https://www.facebook.com/computersoftwaresolution/
Subscribe this youtube channel : https://www.youtube.com/channel/UCkE_J-tXiqxzASO6nlB8D6w
Views: 7259
Education Help
how to create user ,drop user,grant permissions to user?
this video completely describes and show you creation ,droping,modifying users in oracle 11g using sqlplus..
the people who new to oracle can easily understand this..it may help you in future reference and complete understanding of user creation ,modfying etc..
in furthur videos i will explain grant,revoke permissions to users fro m admin user
so please subscribe and like for future update
https://www.youtube.com/user/prasadamudalapalli
how to create Hibernate App and Save data in data table?
how to download Eclipse-oxygen in windows7?
how to uninstall oracle 11g in windows 7?
how to download oracle 11g 64 bit in windows 7?
how to step java project in Eclipse oxygen?
how to configure tomcate server 9.0 in Eclipse oxygen?
how to open and connect sqlplus in windows7?
how to download ,install and connect sqldeveloper?
how to create ,drop ,modifer user in oracle 11g?
Views: 373
pa online
In this video you see how to analyze the use the system and object privilege use of a user who has been granted the DBA role and who performs database tuning operations.
Copyright © 2014 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: 1734
Oracle Learning Library
This video shows you how to use the SYSBACKUP privilege (new to Oracle Database 12c) for DBA role separation.
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: 12155
Oracle Learning Library
...................................................Finish..................................................
To get my others videos just go to the link which is given below..
https://www.youtube.com/channel/UCFcOAx6xy6aQgKzJFaJ_8zQ
Stay connected with information...
Stay Connected with my tutorial..
Stay connected with updated reports tutorial...
Keep learning about Oracle Databese .......
Thanks for watching...
Subscribe my Channel : Mahfujur Rahman
Subscribe my channel : Mahfujur Rahman
Thanks For Watching
MdMahfujur Rahman
Database Design and Development
IDB-BISEW IT Scholarship Project.
01673472384
Views: 22724
Mahfujur Rahman
I want to show in this tutorial, What is Oracle Profile,Benefits of Profile,CREATE PROFILE,Alter Profile and how to assign users on Profile.
Views: 1696
Sayif Uddin
Views: 4311
Mony HO
In this tutorial I explain how to insert a user into the mysql database, with all privileges required to become a "super user". I also show you how you can remove the user from the database with the DROP command.
Views: 60801
Davids Videos
SQL tutorial on How to unlock user or schema in oracle database or how to unlock hr account/user/schema in oracle database using alter user SQL command. you can use the steps to change the password of any user in oracle database explained in detail.
Celebrating 1000 subscribers. Thanks a lot guys for all your love and support.
-------------------------------------------------------------------------
Blog Link: http://bit.ly/unlock-user-in-oracle
--------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the first one to see my
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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/
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: 39087
Manish Sharma
4th SQL Tutorial in the series of user privileges in oracle database user Roles in Oracle Database. In this tutorial you will learn
● What user roles
● How to create simple roles (Role with Not Identified clause)
● How to create secure roles (Role with Identified clause)
● How to create external role.
● How To create global role.
● How to Grant System Privilege to a user Role
● How to Grant Object Privilege to a user Role In oracle database.
● How to grant a Role to another Role
● How To grant a role to database users (with Admin option)
● How To enable role using SET ROLE statement
This video will teach you the concept of user role in oracle database which is an extension to the user privileges. In this video I did 10 SQL queries on user Roles which makes this tutorial fun.
Celebrating 1000 subscribers. Thanks a lot guys for all your love and support.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/create_role_in_oracle
System Privilege: http://youtu.be/EQzdtKPiErU
Object Privilege: http://youtu.be/DuDL7NTPdqQ
-------------------------------------------------------------------------
Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage
https://copy.com?r=kb4rc1
--------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the first one to see my videos!
--------------------------------------------------------------------------
Amazon Wishlist: http://bit.ly/wishlist-amazon
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►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
[email protected]
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: 23982
Manish Sharma
Use this video as a Lab for connecting as a SYSDBA to your Oracle Database.
Views: 8230
Sam Dhanasekaran
In This Video How To Know The Username and Password of Newly Created User Account in Oracle Database 10G. With This Video You Will have knowledge on How To Find How many Number of Users are present in Your Oracle Database.
Views: 18439
Be a Santa
Create, Alter, Drop, Grant Rights, Default Tablespace, Temporary Tablespace, Quota Setup, View Users Information, Lock / Unlock user account
select username,account_status,default_tablespace, temporary_tablespace,created from dba_users;
create user myuser identified by myuser;
alter user myuser quota unlimited on mytbs;
alter user myuser quota 100m on mytbs;
alter user temporary tablespace temp;
alter user myuser default tablespace mytbs;
alter user myuser accout unlock;
alter user myuser account lock;
alter user myuser password expire;
alter user myuser identified by youuser;
create user myuser identified by myuser default tablespace users temporary tablespace temp quota unlimited on users;
grant create session, resource to myuser;
grant create session, resource to myuser with grant option;
drop user asif;
drop user asif cascade;
Views: 41487
Abbasi Asif
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: 353004
Chitu Okoli
all education purpose videos
Views: 279233
Chandra Shekhar Reddy
Shows how to Install and configure SQL developer, unlock the Hr schema and alter oracle database privileges/roles
Views: 8402
Victor
How to create new user accounts using SQL Developer in oracle database.
In This tutorial you will learn how to create a new user account. How to setup a database connection with SyS user. How to grant privileges to the user
----_Links_---
Blog :http://bit.ly/create_user_account
Video Tut 4: http://youtu.be/wSqoXRlXDUU
How to create database: http://youtu.be/enFFezPYhCg
Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage
https://copy.com?r=kb4rc1
Amazon Wishlist: http://bit.ly/wishlist-amazon
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 liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
Views: 65184
Manish Sharma
The video will show how to create a user with the help of SQL in oracle database.
Views: 1995
hammadshams
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: 180078
Manish Sharma
Creación de Roles, creación de grants o permisos, utilizando oracle 11g
Views: 1409
EducacionOnlineGT
in this video i'll show you how to change password of your any user on oracle 11g.
Views: 9319
Raihan N Tarek
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: 7223
Tech Tips
Auditing in Oracle database will help you to what a user doing??
Views: 4635
Athar Fahad
Demo of how to create a user with EM Express.
Views: 37181
OracleDBVision
In this SQL Tutorial you will learn How To Grant System Privilege using Grant Data Control Language (DCL) along with ADMIN OPTION flag.
First SQL Tutorial in the series of user privileges in oracle database
------------------------------------------------------------------------
►►►Timeline◄◄◄
1:50- Query 1- How To grant Basic System Privilege (i.e.Create Table system privilege) to a user
2:40- Query 2 - How to Grant Multiple System Privilege To a user in Single Grant (Data Control Language) Statement
3:52- Query 3 - How To grant System Privilege To Multiple Users in Single Grant (Data Control Language) Statement
4:50- Query 4- How To Grant System Privilege WITH ADMIN OPTION flag
5:26- WITH ADMIN OPTION demonstration
------------------------------------------------------------------------
Celebrating 1000 subscribers. Thanks a lot guys for all your love and support.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog (Link for SQL Script is at the end of this article) : http://bit.ly/system_privilege_admin_option
Link for How To create user
●SQL Tutorial 37 - Using Create User Statement
http://youtu.be/4QbK2Y-1LZw
●SQL Tutorial 38- Using SQL Developer
http://youtu.be/GS4udgR44Ls
●SQL Tutorial 39- Using Oracle Enterprise Manager
http://youtu.be/zGjh-Bb3HrI
List of few System Privileges Available in Oracle Database
http://wp.me/p3r6sw-7M
Previous Tutorial: Introduction To User Privileges
http://youtu.be/iQFb86lM1gs
-------------------------------------------------------------------------
Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage
https://copy.com?r=kb4rc1
--------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the first one to see my videos!
--------------------------------------------------------------------------
Amazon Wishlist: http://bit.ly/wishlist-amazon
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►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
[email protected]
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: 24862
Manish Sharma
This video tutorial demonstrates how to create an OBIEE user through the WebLogic Console. We also show you the relationships between the users and groups, as well as groups and application roles. Check out all of our OBIEE online training courses here - https://www.fireboxtraining.com/obiee-training
Views: 15323
Firebox Training
This video will show you:
- How to create user
- How to create role
- How to create new connection
- How to grant permission to user/role
- How to grant role to user
- How to revoke permission
Views: 1269
Progtips 4 Devs
In this video we will show you how to Create Role in SAP Hana and how to Assign Role to User in SAP Hana. Creation of Role in SAP Hana. SAP HANA Role Creation. Drop Role in SAP HANA. Revoke Role in SAP HANA. SAP HANA role Revoke SQL Query. SQL Query to Assign role to user in SAP Hana. SQL Query to Create Role in SAP Hana. What are Role in SAP Hana. SAP Hana Role Management. Create Role in SAP Hana Studio. SAP HANA Studio role creation.
creating Role. Creating Role in SAP hana.HANA Security How to Create a Role in SAP HANA Studio. SAP HANA User Administration and Role Management.
SAP Hana is a in memory database. Learn sap hana database. sap hana tutorial for beginners.sap hana tutorial.sap hana training videos, sap hana administration, sap hana training videos for beginners, sap hana training videos for beginners.
-------------------------------------------------------------------------------
Types of Privileges in SAP Hana: http://hightechnology.in/types-of-privileges-in-sap-hana/
What is role in SAP Hana: http://hightechnology.in/role-management-in-sap-hana/
------------------------------------------------------------------------------
HOW TO INSTALL SAP ECC 6.0 EHP7 IN YOUR LAPTOP/DESKTOP.
SAP ECC6.0 SR3 Installation with Oracle 11G on Linux.
-----------------------------------------------------------------------------------------
How to install SAP HANA Studio: https://youtu.be/XSX4op2Y2hE
Start & Stop SAP HANA Database:https://youtu.be/Rm8Be0WFNaY How to Create Tenant Database in SAP HANA: https://youtu.be/QfljgKeBtiQ
How to Take SAP HANA Database Backup: https://youtu.be/zmdjQuWxt4c
How to Install SAP HANA Studio Plugin in Eclipse: https://youtu.be/lnVvmXs8x6Q
How to Install SAP HANA Express Edition on SUSE Linux: https://youtu.be/ruL2bob4vrM
Step By Step SAP ECC installation on Linux With Oracle | Install SAP ECC 6 on Linux With Oracle: https://youtu.be/Jy-Li1ucNx8
Schedule SAP HANA Database Backup in SAP HANA Cockpit | SAP Hana Database Backup Schedule in Cockpit: https://youtu.be/6J7UV-GHKrM
How to Create User in SAP Hana Database | SAP Hana User Creation | Create user in SAP Hana: https://youtu.be/MP6As2kLFdc
-----------------------------------------------------------------------------------------
Share, Support, Subscribe!!!
Youtube: http://www.youtube.com/c/hightechnologyin
Twitter: http://www.twitter.com/hightechnology1
Facebook: http://www.facebook.com/hightechnologyblog
Google Plus: https://plus.google.com/+TheHightechnology
Website: http://hightechnology.in/
-----------------------------------------------------------------------------------
Somewhere In Nature by Simon More @user-73416670
Music provided by Free Music for Vlogs www.youtube.com/watch?v=TvXwCUow2Tk
------------------------------
• Contact the artist:
@user-73416670
www.instagram.com/simonmoremusic/
------------------------------
Free Music for Vlogs
This Youtube Channel is dedicated to search, catalog, sort and publish free music for vlogs and videos destined to content creators and filmmakers.
Views: 694
Hightechnology TV
How to Start,Stop Pluggable database-Oracle 12C administration
===================================================
Important Command
SQL= show con_name;
CON_NAME
------------------------------
CDB$ROOT
SQL-- sho pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 PDB MOUNTED
SQL alter session set container=PDB;
Views: 5899
ANKUSH THAVALI
To learn more about other SciNote features visit our website at https://scinote.net/.
This tutorial will walk you through the basics of managing SciNote user privileges and roles. It will show you which user authorities there are at the Team, Project and Experiment levels, as well as how to reassign and remove user roles.
Views: 1718
SciNote - Electronic Lab Notebook
This Linux video tutorial from https://www.fireboxtraining.com/linux demonstrates how to create users and groups on a Linux server. We will take a closer look at the /etc/passwd and /etc/group files so you better understand the relationship between users and groups.
Views: 71450
Firebox Training
Please avoid or flag spams/hateful comments. And do not spam. Enjoy :)
I am using the Oracle Sql server 10g express edition which is free to use. Download it from oracle website.
Subscribe my Channel:-
http://www.youtube.com/user/SanketRooney?sub_confirmation=1
Facebook Page:-
https://www.facebook.com/UnpossibleNS
Twitter Account:-
https://twitter.com/UnpossiblePOG
How To Run .sql File In Oracle Command Line | SQL Tutorial | PL/SQL Programming
How To Run .sql File In Oracle Command Line | SQL Tutorial | PL/SQL Programming
How To Run .sql File In Oracle Command Line | SQL Tutorial | PL/SQL Programming
How To Run .sql File In Oracle Command Line | SQL Tutorial | PL/SQL Programming
Views: 13185
Unpossible POG
Shows you how to add appropriate privileges to a user type so that users of that type can make calls to the Oracle Field Service REST API.
Views: 956
Oracle Applications Cloud Tutorials
This video shows you how to manage users and roles for Oracle Cloud services.
Copyright © 2014 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: 3639
Oracle Learning Library
Senior instructor Darryl Balaski shows you how to set up and use Oracle Database profiles to grant and limit access to database usage and instance resources for various users.
Views: 3987
Oracle Learning Subscriptions
How to change SYS/SYSTEM password in 12C-Oracle 12C Administration
===================================================
[email protected]= alter session set container=CDB$ROOT;
Session altered.
[email protected]=show con_id
CON_ID
------------------------------
1
[email protected]= alter user SYSTEM identified by oracle container=all;
User altered.
[email protected]= alter session set container=pdb1;
Session altered.
[email protected]= show con_id
CON_ID
------------------------------
3
=============================================
Hi Folks,
Greetings!!
I am professional part time oracle dba trainer and having good experience in oracle database administration.
This is the right place to enroll yourself for Oracle DBA real time course.
Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily.
Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge.
Mobile No : + 91 9960262955 (WhatsApp Number)
EmailID: [email protected]
Views: 4324
ANKUSH THAVALI
In this tutorial, you'll learn how to set linesize and pagesize .
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: 17806
radhikaravikumar
http://quest.com/products/toad-edge
This short video shows how to view and modify user privileges in Toad Edge in two ways: per object or per user.
Views: 1053
Quest
In this video I will show you how to change the name of existing table and also how to drop the table. Dropping table can delete your all records exist in that database table.
For Support
===========
Email: [email protected]
Contact Form: http://www.learninhindi.com/home/contact
Our Social Media
================
Facebook: https://www.facebook.com/LearnInHindi
Twitter: https://twitter.com/LearnInHindi
For Training & Videos
=====================
For more videos and articles visit:
http://www.learninhindi.com
Free Java Programming In Hindi Course
=====================================
https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH
Free Oracle PL/SQL Programming In Hindi Course
==============================================
https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6
Free C Programming In Hindi Course
==================================
https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq
Trips & Tricks Channel
======================
https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw
Programming in Hindi Channel
============================
https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 32512
ITORIAN
In this video tutorial, i am going to show you how to create a Simple HANA Database Schema and Grant access permission to those Schema.
Views: 2180
Arun krishnamoorthy
This video shows how to create a new Oracle database user as EM Express DBA using the predefined DEFAULT privilege and predefined roles, such as EM_EXPRESS_ALL.
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: 2250
Oracle Learning Library
Views: 15091
Oratrix
error in writing to directory temp oracle universal installer needs you to have permission in this area to install. installation cannot continue . please make sure temp is set to a valid writable directory.
Views: 9196
MD.Moniruzzaman ShadhiN
Easy method to unlock any user account in Oracle database 10g and 11g. In this tutorial I have unlocked hr user account you can unlock any user account from following list:
Anonymous
CTXSYS
SCOTT
EXFSYS
MDSYS
OLAPSYS
SYS
SYSTEM
click start and type sqlplus
then type the user-name: sys / as sysdba
then type the password that you have set during the installation of
the oracle software
type the following to unlock account
alter user scott account unlock;
type the following to set password for user account
alter user scott idenfied by tiger;
where tiger is your password
Thanks for watching and subscribe for more. . . :)
Views: 5960
Abdul ReHmaN
This video shows how to run autotrace reports using Oracle SQL Developer to analyze query performance. It also discusses the privileges you need to enable database users to run autotrace.
============================
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: 19115
The Magic of SQL
In this video, we’ll learn how to reset the password for an account in Oracle XE.
Are you running Oracle database XE 11.2 and forgot your password?
It can be for any Oracle XE version actually, but this is the latest one at the moment.
Don’t worry, there are a few ways to recover this password.
It also depends on if you know the password, and if you’re able to log in to the account still, as there is a time limit on these passwords.
If you’ve forgotten it, then you won’t be able to log in as that account. But this video will help you reset the password so you can use the account again.
For more information on Oracle SQL, check out DatabaseStar:
https://www.databasestar.com/
Views: 1797
Database Star