Home
Search results “Oracle scott emp”
[Hindi / Urdu] How to install Scott Schema in Oracle 11g Express Edition | Windows
 
04:29
Watch how to install Oracle database 11g Express edition https://youtu.be/U4elje290FE Oracle database express edition doesn't come with any sample schema. In this video, we will install scott schema in Oracle Database 11g Express Edition. Video Language is Hindi. Thanks to http://www.dl-sounds.com/ for providing royalty free audio for video intro. (“The audio files are licensed and approved by Dl-Sounds.com.”) Incoming Search Terms: conn scott/tiger , connect scott/tiger not working, scott does not exist Install scott schema Create scott user Login as scott/tiger
How to Create SCOTT Schema and default tables in Oracle Database 11g
 
04:31
Looking for a best Webhosting Company at low and Best Service click this link:https://www.ipage.com/join/index.bml?AffID=739220 From Last Few Months I Was Looking For Best Webshosting Company Where I Can Host My 100 Of Website At Low Price And With Best Quality Service , And Then I Came To Know About https://www.ipage.com/join/index.bml?AffID=739220 A Hosting Company Where I Get Hosting For Unlimited Domains At Just 1.6$ Per Month With Control Panel , 24hrs Support And All In All A Best Platform To Host Any Website( one-click install wordpress option) .Dont Be Late Offer Valid Till 25th October 2014 , Host Your WebSite With Best Service Provider Today By Clicking The Link Above Or Here: https://www.ipage.com/join/index.bml?AffID=739220 To get a responsive and Modern design contact http://www.variabletips.com and get at just 20$ Now !!! Check my Website: http://variabletips.com for more details. If there is no Oracle default scott schema is available after the installation of Oracle 11g database in windows, Then how to create the scott schema and the default tables like emp , dept, bonus, salgrade in database. Here is a easy step by step tutorial to create it in your database. Open the sql plus in your system. Login as username : sys as sysdba and the password which is given at the time of installation. After connected to Oracle database you need to create the scott schema. Run this script: CREATE USER scott IDENTIFIED BY tiger; scott is the user tiger is the password. Grant all access to user scott,run this script: GRANT ALL PRIVILEGES TO scott; Download the Oracle default tables file: https://www.dropbox.com/s/m9lr8cnc00vqy3i/oracle.zip https://drive.google.com/file/d/0BxJYa0O21A_udlZqQmNZaFBvNTA/edit?usp=sharing Extract the downloaded file in your system. Then Connect to Scott user as: CONNECT scott Password: tiger Then type this in your sql command prompt: @(extract file path)\oracle.sql; for example: @C:\Users\ABC\oracle\oracle.sql; Now you done all the steps completely and you can work with scott schema and all the default tables. Check This in your system to show all the tables in scott user: Select * from tab; After that you can see all the default table in scott user. Just run it to show the default data inside the tables. Select * from emp; If 14 row selected....Then You sucessfully Created the scott schema and the default Oracle tables in your system. Like and subscribe this video: http://www.youtube.com/watch?v=vHcAs7k93AQ
Views: 17147 variabletips
How to Create SCOTT Schema and default tables in Oracle Database 11g
 
04:31
If there is no Oracle default scott schema is available after the installation of Oracle 11g database in windows, Then how to create the scott schema and the default tables like emp , dept, bonus, salgrade in database. Here is a easy step by step tutorial to create it in your database. Follow these Steps One By One. File Download Link: https://sites.google.com/site/gpabukcbyarshman/gpa-semester-wise/oracle.zip?attredirects=0&d=1 For More...!! Facebook.Com/MrArshman
Views: 1685 Arshman Saleem
Oracle Database 12c Tutorial 4: How to install sample schemas / users in Oracle Database 12c
 
08:33
Learn how to install sample schemas or users in oracle database 12c, In this tutorial you will also learn how to create a pluggable database in oracle database 12c by manish sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/how-to-install-sample-schema-users-hr-sh-in-oracle-12c Previous Tutorial ► Tut 61: How To Unlock HR schema in Oracle Database 12c http://youtu.be/F81gfUnznZY ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- 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 1st 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: 51268 Manish Sharma
Oracle Hints Tutorial for improving performance
 
10:35
Oracle Hints Tutorial for improving performance APPEND PARALLEL JOIN INDEX NO_INDEX SELECT /*+ FIRST_ROWS(10) */ * FROM emp WHERE deptno = 10; SELECT /*+ ALL_ROWS */ * FROM emp WHERE deptno = 10; SELECT /*+ NO_INDEX(emp emp_dept_idx) */ * FROM emp, dept WHERE emp.deptno = dept.deptno; SELECT /*+ INDEX(e,emp_dept_idx) */ * FROM emp e WHERE e.deptno = 10; -- SELECT /*+ INDEX(scott.emp,emp_dept_idx) */ * FROM scott.emp; SELECT /*+ AND_EQUAL(e,emp_dept_idx) */ * FROM emp e; SELECT /*+ INDEX_JOIN(e,emp_dept_idx) */ * FROM emp e; SELECT /*+ PARALLEL_INDEX(e,emp_dept_idx , 8) */ * FROM emp e; SELECT /*+ LEADING (dept) */ * FROM emp, dept WHERE emp.deptno = dept.deptno; SELECT /*+ PARALLEL(8) CACHE (e) FULL (e) */ * FROM emp e ; SELECT /*+ PARALLEL FULL (e) */ * FROM emp e ; SELECT /*+ PARALLEL USE_MERGE (emp dept) */ * FROM emp, dept WHERE emp.deptno = dept.deptno; -- SORT Merge Join SELECT /*+ PARALLEL USE_HASH (emp dept) */ * FROM emp, dept WHERE emp.deptno = dept.deptno; -- Hash Join SELECT /*+ PARALLEL */ * FROM emp e ; INSERT /*+ APPEND */ INTO mytmp select /*+ CACHE (e) */ *from emp e; commit;
Views: 4801 TechLake
how to show the top 5 sal from table emp
 
01:18
i am executing this query on the oracle xe(express edition) on fedora (linux)
Views: 207 Rahul Bhadana
Session7 INSERT Statement
 
24:08
Session 7: Populating(INSERT) data into database table in Oracle. 1. Insert data into all columns(complete record) in a table. 2. Insert data into a table in same/random order of column. 3. Insert data into selective columns of a table. 4. Inserting NULL value into table. 5. Prompt the column to insert values in runtime using ‘&' and ‘&&'. 6. Insert data using select statement. 7. Create table as select.(create table with/without data). 8. Insert huge amount of dummy data using a PL/SQL block. — Create a table. CREATE TABLE emp (EmpID NUMBER(4) PRIMARY KEY, EName VARCHAR2(20) NOT NULL, Job VARCHAR2(20), DeptNo NUMBER(3), Sal NUMBER(7,2)); Insert data into all columns(complete record) in a table. same order of column: INSERT INTO emp VALUES(111, 'SCOTT', 'MANAGER', 10, 50000); INSERT INTO emp(EmpID, EName, Job, DeptNo, Sal) VALUES(112, 'JONES', 'DESIGNER', 20, 40000); Random order of column values: INSERT INTO emp VALUES(113, 45000, 10, 'SMITH', 'MANAGER'); — show error, why ?? INSERT INTO emp(EmpID, Sal , DeptNo, EName, Job) VALUES(113, 45000, 10, 'SMITH', 'MANAGER'); Insert data into selective columns of a table. INSERT INTO emp VALUES(122, 10, 'SMITH'); — show error INSERT INTO emp(EmpID, DeptNo, EName) VALUES(222, 10, 'SMITH'); Inserting NULL value into table. INSERT INTO emp VALUES(214, 'JONES', NULL, NULL, 40000); INSERT INTO emp(EmpID, EName, Sal) VALUES(215, 'ADEMS', 40000); Prompt the column to insert values in runtime using ‘&' and ‘&&'. INSERT INTO emp VALUES(&empid, '&ename', '&job', &deptno, &sal); INSERT INTO emp VALUES(&empid, &ename, &job, &deptno, &sal); INSERT INTO emp(EmpID, EName, Job, DeptNo, Sal) VALUES (&empid, '&ename', '&job', &deptno, &sal); INSERT INTO emp(EmpID, DeptNo, EName) VALUES (&empid, &deptno, '&ename'); INSERT INTO emp(EmpID, DeptNo, EName, Sal) VALUES (&empid, &&deptno, '&ename', &&sal); Insert data using select statement. INSERT INTO emp (SELECT 222, 'SATISH', 'MANAGER', 30, 60000 FROM DUAL); INSERT INTO emp VALUES(SELECT 223, 'RAHUL', 'SALESMAN', 30, 30000 FROM DUAL); — show error. Create table as select.(create table with/without data). CREATE TABLE emp_copy AS SELECT * FROM emp; — create table with same table structure, with data. SELECT * FROM tab; SELECT * FROM emp_copy; CREATE TABLE emp_copy2 AS SELECT * FROM emp where 1 != 1; — create table with same table structure, without data. SELECT * FROM tab; SELECT * FROM emp_copy2; Insert huge amount of dummy data using a PL/SQL block. BEGIN FOR i IN 1..100 LOOP INSERT INTO emp VALUES(i, 'Ename_'||i, 'Job_'||i, (MOD(i,5)+1)*10, (MOD(i,5)+1)*10000); END LOOP; END; / SELECT * FROM emp;
EMP and DEPT Table Script
 
11:40
EMP and DEPT Table Script
Views: 362 GROK ONLINE
How to Create table|Copy data from another schema table in Oracle11g?
 
10:39
hi friends... today I am going to show you some interesting and important queries in oracle.. 1.how to create table from another schema table without data? 2.how insert data in table from another schema table ? 3.how insert specific columns data in table from another schema table? here I want to create table name empdup based on scott schema emp table.. so guys please watch these carefully.. 1.how to create table from another schema table without data? syntax: create table tablename as select * from schema.tablename where 2=1; Eg:create table empdup as select * from scott.emp where 2=1; we can above example practically...so as shown in video,we have created table in hari user based scott schema emp table without data... 2.how insert data in table from another schema table ? syntax: insert into table_name select * from schema_name.table_name; Eg: insert into empduplicate select * from scott.emp; we can see this practically...so we got total rows(14) from scott schema emp table data into hari user's table empduplicate.. 3.how insert specific columns data in table from another schema table? Syntax: insert into table_name(col1,col1,...) select col1,col2.. from schema_name.table_name; Eg: insert into empduplicate empno,ename,job select empno,ename,job from scott.emp; we can also see this in practically.. first I delete total data before inserted in empduplicate.. after executing this query we got only specifice columns data into empduplicate table... that's it guys... thank u... Please Subscribe n Share My Channel for Update.. www.youtube.com/user/prasadamudalapalli
Views: 337 pa online
How to Export and Import Using Parameter file ( Parfile ). /* Step By Step */
 
04:33
My Today’s Scenario How to use parfile in Export and Import. Parfile export and Import used .par extension. Suppose Export command is very lengthy that case we create a parfile. In this file we write a Export command and file extension is .par File name= exp_scott.par -----------------------------------------------------------------------------------directory=mydump logfile=scott_exp.log dumpfile=scott_exp.dmp schemas=‘SCOTT’exclude=table:"IN(‘EMP',’DEPT’)“
Views: 1232 Parag Mahalle
Oracle Master Detail Report With Parameter (10G)
 
26:27
1. Oracle Report Builder 10G 2. User Scott 3. Table Master : DEPT and Detail : EMP
Views: 2095 MD Khairul Islam
1 Standard Audit In Oracle 11g
 
09:17
Hi.. Friends In This Video We Learn How To Create Standard Auditing In Oracle 11g On Windows In This Video Used EMP Table Of SCOTT Users
Views: 198 PGT POINT
Gerar backup lógico expdp DATAPUMP oracle
 
07:45
--EXPDP -- DATAPUMP select * from dba_directories; CREATE OR REPLACE DIRECTORY DUMP AS '/oracle_files/dump'; GRANT READ, WRITE ON DIRECTORY DUMP TO scott; GRANT EXP_FULL_DATABASE to scott; -- Full Export expdp scott/tiger DIRECTORY=DUMP DUMPFILE=expdp_full.dmp FULL=y LOGFILE=expdp_full.log -- schema Export expdp scott/tiger DIRECTORY=DUMP DUMPFILE=exp_scott.dmp schemas=scott LOGFILE=exp_scott.log -- Table Export expdp scott/tiger tables=EMP directory=DUMP DUMPFILE=EMP_DUMP.dmp logfile=EMP_DUMP.log -- Compactado ExpDP expdp scott/tiger DIRECTORY=DUMP DUMPFILE=exp_scott.dmp schemas=scott LOGFILE=exp_scott.log compression=all
Views: 101 Vídeos Aulas TI
oracle apex 5.1 Run .rdf, .jsp report from oracle apex
 
05:29
oracle apex 5.1 Run .rdf, .jsp report from oracle apex Prerequisite 1. Oracle Application server 11g (forms, report) Steps 1. Create rdf, jsp file 2. configure cgicmd.dat file location C:\Oracle\Middleware\user_projects\domains\ClassicDomain\ config\fmwconfig\servers\WLS_REPORTS\applications\ reports_11.1.2\configuration\cgicmd.dat add line at last keemp: userid=scott/[email protected] server=RS_MIS_HVY3 desformat=pdf destype=cache paramform=no %* restart report server 3. Create url for Calling report http://ip:8888/reports/rwservlet?keemp+report=D:\emp.rdf+P_PID=179290 http://ip:8888/reports/rwservlet? keemp+report=file location .rdf or .jsp+parameter http://192.168.10.222:8888/reports/rwservlet?keemp+report=D:\emp.rdf 4. Call Report from apex button
Views: 2608 Mostafiz Mitul
Query Parameter in Oracle Datapump
 
19:05
Hello Friends Today, In this video I used to show you How to Used Data pump Query Parameter. In Query Parameter we can take export backup using particular query. Suppose iwant to take a export backup of EMP table but in this table i want to take backup only department no 20. so it is possible . please watch this video and subscribe In Some Methods i am showing you. Method 1: (Using Parameter File) ------------------------------------------------------------ 1. Create Table Test. (Create table scott.test as select * from scott.emp;) 2. Create Par file. ------------------------------------------------------------ directory=dump dumpfile=d1.dmp tables='SCOTT . TEST' query=TEST:"WHERE deptno=20" ---------------------------------------------------------------- Save this file test.par --------------------------------------------------------------- 3. Go to Command Prompt Export expdp system/admin parfile='/u01/app/parag/test.par’  Import impdp system/admin directory=dump dumpfile=d1.dmp tables=‘SCOTT . TEST‘ ------------------------------------------------------------------------------------- Method 2: ------------------------------------------------------------ 1. Create Table Test. (Create table scott.test as select * from scott.emp;) 2. Go to Command Prompt Export expdp system/admin directory=dump dumpfile=d2.dmp tables=‘SCOTT . TEST ’ query=TEST:\”WHERE deptno=20\”  Import impdp system/admin directory=dump dumpfile=d2.dmp tables=‘SCOTT . TEST ' -----------------------------------------------------------------------------------------------------------
Views: 379 Parag Mahalle
creating employee table in Oracle
 
04:37
employee table creation in oracle and the download link is given below:- http://clicknupload.com/ufsxmjklo6or
Views: 7274 Mohammed Abdul Farhan
database Oracle 10g (scott)
 
18:12
the password that i use is "a"
Views: 304 Rabee Qasem
Fazer impdp DATAPUMP oracle
 
15:10
--- IMPDP -- DATAPUMP -- Full Import impdp scott/tiger DIRECTORY=DUMP DUMPFILE=expdp_full.dmp FULL=y LOGFILE=imp_full.log -- ImpDP schema impdp scott/tiger DIRECTORY=DUMP DUMPFILE=exp_scott.dmp schemas=scott LOGFILE=imp_scott.log -- ImpDP schema Remap impdp scott_backup/tiger DIRECTORY=DUMP DUMPFILE=exp_scott.dmp schemas=scott LOGFILE=imp_scott.log remap_schema=scott:scott_backup remap_tablespace=users:scott_backup -- Table Import impdp scott/tiger tables=EMP directory=DUMP DUMPFILE=EMP_DUMP.dmp logfile=EMP_DUMP.log
Views: 193 Vídeos Aulas TI
Desbloquear la cuenta SCOTT de Oracle
 
01:11
Desbloquear la cuenta SCOTT desde SYSTEM o una cuenta privilegiada. 1) Abrir el SQL * Plus 2) Comprobamos si la cuenta SCOTT está bloqueada, conectándonos a él. 3) No saldrá un mensaje si la cuenta está bloqueada. 4) Nos conectamos con una cuenta privilegiada (SYS, SYSTEM). 5) Ingresamos la siguiente sentencia. ”ALTER USER scott ACCOUNT UNLOCK;” 6) Nos saldrá el mensaje que el usuario ha sido modificado. 7) Nuevamente conectémonos con el usuario SCOTT. “connect Scott/tiger” 8) Luego nos pedida cambiar el password (Lo podemos dejar en tiger). 9) La cuenta está habilitada. Comprobamos haciendo un SELECT a la tabla emp.
Views: 793 Aprendec
how to oracle hr unlock
 
04:29
oracle sql এর মাধ্যমে hr account থেকে unlock
Views: 22 Violet 7
demobld sql
 
09:35
this video explains how to genrate demonstration tables (emp,dept,salgrade,bonus) for practicing in oracle..www.facebook.com/psquaredba
Views: 2558 P-Square Technologies
05  emp and dept tables
 
00:36
emp and dept table creation script create table dept( deptno number(2,0), dname varchar2(14), loc varchar2(13), constraint pk_dept primary key (deptno) ); create table emp( empno number(4,0), ename varchar2(10), job varchar2(9), mgr number(4,0), hiredate date, sal number(7,2), comm number(7,2), deptno number(2,0), constraint pk_emp primary key (empno), constraint fk_deptno foreign key (deptno) references dept (deptno) ); insert into dept values(10, 'ACCOUNTING', 'NEW YORK'); insert into dept values(20, 'RESEARCH', 'DALLAS'); insert into dept values(30, 'SALES', 'CHICAGO'); insert into dept values(40, 'OPERATIONS', 'BOSTON'); insert into emp values( 7839, 'KING', 'PRESIDENT', null, to_date('17-11-1981','dd-mm-yyyy'), 5000, null, 10 ); insert into emp values( 7698, 'BLAKE', 'MANAGER', 7839, to_date('1-5-1981','dd-mm-yyyy'), 2850, null, 30 ); insert into emp values( 7782, 'CLARK', 'MANAGER', 7839, to_date('9-6-1981','dd-mm-yyyy'), 2450, null, 10 ); insert into emp values( 7566, 'JONES', 'MANAGER', 7839, to_date('2-4-1981','dd-mm-yyyy'), 2975, null, 20 ); insert into emp values( 7788, 'SCOTT', 'ANALYST', 7566, to_date('13-JUL-87','dd-mm-rr') - 85, 3000, null, 20 ); insert into emp values( 7902, 'FORD', 'ANALYST', 7566, to_date('3-12-1981','dd-mm-yyyy'), 3000, null, 20 ); insert into emp values( 7369, 'SMITH', 'CLERK', 7902, to_date('17-12-1980','dd-mm-yyyy'), 800, null, 20 ); insert into emp values( 7499, 'ALLEN', 'SALESMAN', 7698, to_date('20-2-1981','dd-mm-yyyy'), 1600, 300, 30 ); insert into emp values( 7521, 'WARD', 'SALESMAN', 7698, to_date('22-2-1981','dd-mm-yyyy'), 1250, 500, 30 ); insert into emp values( 7654, 'MARTIN', 'SALESMAN', 7698, to_date('28-9-1981','dd-mm-yyyy'), 1250, 1400, 30 ); insert into emp values( 7844, 'TURNER', 'SALESMAN', 7698, to_date('8-9-1981','dd-mm-yyyy'), 1500, 0, 30 ); insert into emp values( 7876, 'ADAMS', 'CLERK', 7788, to_date('13-JUL-87', 'dd-mm-rr') - 51, 1100, null, 20 ); insert into emp values( 7900, 'JAMES', 'CLERK', 7698, to_date('3-12-1981','dd-mm-yyyy'), 950, null, 30 ); insert into emp values( 7934, 'MILLER', 'CLERK', 7782, to_date('23-1-1982','dd-mm-yyyy'), 1300, null, 10 );
Views: 750 C4C
Oracle 12c PL/SQL Security Features - Lesson 4 of 8 - Roles and PLSQL
 
06:21
Learn how Roles really work with Oracle PL/SQL and why a privilege granted via a role can't be used in PL/SQL. Demonstrations, examples. See all lessons and many more free Oracle Database tutorials at https://www.skillbuilders.com/free-oracle-database-tutorials John Watson: We have the business of roles - roles and PL/SQL. The point here is that roles are invisible to PL/SQL. When you compile your code, only direct privileges are available. When you run your code, only direct privileges are available. This is for definer's rights, I should say. When you run the code, only direct privileges are available to grant to the definer. In effect, the definer's rights code, all roles are disabled within the stored procedure. And certainly roles are disabled when compiling the code. Functionally, it's equivalent to having issued the command SET ROLE NONE. Why is this? Why is it you can't use your privileges? It's perfectly straightforward. It's a technology limitation. Quickly to see what's going on. If I go in and say - let me connect or create a clear schema. I'll create myself, grant dba to jw identified by jw. I've created a user and given him ridiculously high privileges. Connect.... What can you do? You can do pretty much anything. If he wants to delete from scott.emp, he can do it. Let's roll back, because along with his dba role, he has the ability to pretty much anything to use the data. Now we'll create a procedure. If I create a procedure, create delemp as begin, and in there I delete from scott.emp, end, compilation errors. What are they? Show error. At line 2 table of view doesn't exist. That's line 2 delete from scott.emp. I remember way back in version 7, this cause so much confusion before we realized what was going on. It's quite simple that when we are within the code, as the definer or the invoker, because this is definer's rights code, when we are within the definer's rights code block or indeed when we are compiling a definer's rights code block, the roles are disabled and that's why we cannot see it. But why is this and why do I say it's a technology limitation? It's because roles can be enabled and disabled. They can be enabled or disabled. That makes it logically impossible to consider a role when executing a stored procedure because I might have the role enabled while I compile it, but how do I know that it's going to be enabled when I run it? If I grant execute on the code to a third party, he doesn't have the role at all and that he must not even be logged on. So it becomes a logical impossibility because of the way roles are used because roles are enabled or disabled. You can dynamically switch them on and off. It's a logical impossibility to use role within definer's rights program module. Invoker's rights code, however, is very different. That infuses some interesting issues. Invoker's rights code can use any roles that happen to be enabled for the user at the time that he invokes it in exactly the same way that an anonymous PL/SQL can use any enabled roles. In the security point of view, the definer can in effect grab any roles within his code that the invoker happens to have. Dave: [Question], John, pardon. How do you enable or disable a role? John: Right now there's several techniques. I won't spend too much time demonstrating. The easiest technique will be alter - I can set role none. And that will have disabled all my roles. Now if you look at this, I've got nothing. If I try to run my code and query - let's see. Yes. If I try to delete from scott.emp I can't see it. So I'll set role dba and now of course I can. That's the easiest way. In fact, there are much more [05:07 inaudible] ways to switch roles on and off. We can do it with operating system authentication and I can do it with proxy authentication. We have a persistent session through application server as well as a user when we pass that session out to many of the users that can switch roles on and off. That's the persistent session switch identities. Perhaps, best of all, I can create what I call secure application roles well it protect the role with a package and that can contest any number of issues - environment variables, maybe the time, maybe your IP address, perhaps the program you're using and switch roles on and off accordingly. So there are many ways for controlling roles and you should do it. Blindly granting roles and letting them be enabled all the time is not good security. The end result for this, however, you can get some pretty unexpected results within your code. I've tried to run through in our first half hour some of the issues that we see with PL/SQL in release 11g and earlier. After a short break, we'll move on to the 12c features.
Views: 270 SkillBuilders
Oracle 12c PL/SQL Security New Features - Session 6 of 8 - Granting Roles to Procedures
 
06:37
See www.skillbuilders.com/12c-plsql-security for all free modules in this tutorial. It is now in Oracle Database 12c possible to grant roles to the stored program units. Remember this didn't apply to anonymous PL/SQL. Anonymous PL/SQL as always executed with the enabled roles of the invoker. But we can now grant role to a stored procedure. There are a couple of conditions. The role granted must be directly granted to the owner. I'm not sure if this is documented or not or it could've been issues I had during my own testing but certainly the last time I tested this thoroughly I found that if I granted roles to roles to roles to roles as I go down to three, it no longer functions. So that could've been just me or it may be documented. But certainly to be sure, the role granted must be granted directly to the person who's writing the code. Also and it is documented, the owner still needs direct privileges on the object that the code references. That make perfect sense because the role might be disabled at the time that he happens to be creating the object. So you need the role, you need direct privileges on the object referenced by the code. [pause] The invoker however needs absolutely nothing. The invoker now needs nothing, no roles, no privileges. All he needs is execute on the procedure. The invoker will then take on that role during the course of the call. This will tighten up the definer's rights problem and that our user doesn't have much at all. He needs the bare minimum and then only that role will be available, only the role is available to the invoker during the call. Not everything else that the owner happens to have. You can combine this as well with invoker's rights and either way we are controlling privilege inheritance. Invoker's rights plus roles restrict the ability of definer's to inherit privileges from invokers and invokers inherits privileges from definers, both of which raise that ghastly possibility of privilege escalation associated typically to SQL injection. [pause] Grant create session, create procedure to dev, and that will give him select on scott.emp to dev. I've given dev the minimum he needs to write code that hits that table. Then create a role. [pause] Create role r1 and that'll grant select on scott.emp to r1. Finally, grant r1 to dev. It has met the requirements. The role is granted to the owner, the owner does have direct privileges. [pause] So connect as dev/dev and create my favorite procedure. [pause] The same procedure has executed definer's rights and query scott.emp. But now what we can do this new is I can grant r1 to procedure list_emp. [pause] I'll create a very low privileged user now. I need to connect as sysdba and create user low identified by low, and all I shall give him is create session. [pause] And execute on that procedure. [pause] Grant execute on dev.list_emp to low. That's all he's got. He can log on and he can run, run one procedure. What actually is going to happen to him? Let me try to log on. Connect sys low/low set server output on and see if he can run that thing. Just to check, if he tries to select star from scott.emp he is the lowest of the low is my user low. But then execute dev.list_emp, trying to retrieve the CLARKs and it works. And because my user low has virtually no privileges at all, there's no possible danger of the malicious developer being able to inherit dangerous privileges from him. [pause] The final step, that functioned because of the privilege that I mentioned earlier - the privilege that we saw on the previous slide which was inheriting privileges. If I revoke that - and this is what you should be doing in all your systems after upgrade - revoke inherit privileges on user low from public, connect there, and it fails. So the final bit of tightening up the security is to grant the privilege specifically we grant inherit privileges on user low to dev. Now we have a totally secure system and that my low privilege user dev can do that. [pause] And nothing more. My low privileged developer dev can't grab anything in his too as well. That tightens things up totally.
Views: 2817 SkillBuilders
miPrimerProgramaPLSQL 03
 
11:11
Consulta Basica de Datos de la Tabla EMP del usuario SCOTT, en un programa PL/SQL Utilizando un SELECT que traiga un solo registro de la Base de Datos (Single Row Query).
How to Export and import oracle 10g database .rm
 
03:55
طريقة استيراد و تصدير قاعدة بيانات من أوراكل
Views: 76103 MahmoudRFarra
Oracle Database 12c Security - Oracle Virtual Private Database (VPD)
 
12:29
Learn how to use Oracle Virtual Private Database (VPD) to secure your data. See all lessons at http://skillbuilders.com/12c-TSDP-Tutorial First, Virtual Private Database. What is it? Answer: It's a declarative technique for enforcing security. Typically, it's based on user application context. That was the first limitation of 8i. Backed with 8i context were session-specific. The context variables were sort in the PGA. That means you simply couldn't use this in a web environment. However, global context, with use of 9i, Virtual Private Database became usable for web applications with connection pooling. But whether you're using it to client server or on a three tier environment, it's declarative technique rather than a programmatic technique. I can go behind the back of the application as a DBA and generate predicates to get appended to all SQLs. Select, insert, update, delete the end users. Issue the SQL and I will generate a predicate that filters the access. It's impossible to bypass. All users will have predicates appended to all their code. It doesn't matter whether they're using SQL Plus, Discoverer, Business Objects, Crystal Reports, eBusiness Suites, whatever they're using, I as DBA can filter their access to roles. The end result, different users see different data sets while running the same code and accessing the same tables, hence, the name Virtual Private Database. Different users will think they're seeing a totally different set of tables, but in fact it's one column database, one set of tables hosting a single application shared by all the users. The mechanism - you can apply VPD to tables, to views, to synonyms, and a declarative technique. Once the technique you write a function that generates the predicate, you associate the function with the table. From then on whenever the user issue SQL against that table the Cost-Based Optimizer rewrites the code. The Cost-Based Optimizer rewrites the user SQL to call the function to generate the predicate. The predicate is then appended to the SQL and it's the modified SQL that is parsed and executed. Let's see how this actually works. I'm working here by the way. This is just a perfectly normal 12.1 database. But what I'm going to demonstrate at this point will in fact work on 11g as well. I'm not going to be using any of the 12c enhancements to VPD for this little demonstration. I'll work in the scott schema. What do we have to do? We write a function to generate the predicate string. Create function. And I'll my function vpdf. The function must conform to a fixed specification. It must take two varchar arguments. One of the arguments is intended to be the schema to which the function will be applied. The other argument is the object within the schema to which the function will be applied. And it must return a varchar2, which is the generated predicate. Let's begin. Within this function you can do just about anything. There are some limitations. It's impossible for the function to query or update the table against which the VPD calls here is going to be applied or we violate the rules of purity that we come across so often with PL/SQL. But apart from that, it can do just about anything - including a number of dreadful side effects can be introduced by writing VPD functions. I'm going to do a very simple one on this one. I'll shall simple return immediately a predicate. What predicate? Ename, which is the ename column from this scott.emp table. Ename should equal sys_context. I'll go to the local context, my user end context, and just extract session user. We can see that John has tested this earlier today and therefore the object already was suggesting and he's just dropping it now and cleaning up the recreate. I hope you realize these really are live demonstrations. I'm not just running scripts. I've created a function. What's that function going to do? It's going to return this value here. Test it. Always test it and see what it's actually going to do. I'll select vpdf. I have to give it a couple of arguments. This one will do for now.
Views: 4350 SkillBuilders
"Four Swords!!" - Smash Bros. with Scott - #18
 
15:18
MC and Scott throw down the formalities and get into an all out brawl in Super Smash Bros. Suggest your crazy character/stage/specialty matchups in the comments! Want more SMASH?! http://patreon.com/SuperMCGamer Check out Scott: http://youtube.com/GreatScottLP For more information on Project M: http://projectmgame.com/ ▲ FOLLOW ▲ Twitch - http://bit.ly/SMCGTwitch Twitter - http://bit.ly/SMCGTwitter Merch - http://bit.ly/SMCGStore Facebook - http://bit.ly/SMCGFacebook ▲ CREDITS ▲ All content within is owned by their respected companies, developers and publishers.
Views: 2932 SuperMCGamer
How to unlock oracle account
 
02:56
U will learn how to unlock the oracle user account
Views: 4897 Ram chander
export and import tables in oracle
 
04:43
This video displays the exporting the tables from one oracle user to import that tables to another oracle user .
Views: 4664 Venkatesh Modadugu
How to Exclude Schemas and Tables using Export and Import. /* Step By Step */
 
08:33
Today I am showing you 1. How to perform Export and Import with Exclude Schemas and Tables in Oracle Datapump utility. When we take a Export Full database Backup but I don’t take a backup of Scott and System Schemas. That time we can use Exclude command. We can Export Scott Schema but exclude EMP , DEPT Tables. If the expdp exclude parameter is used directly from the command line (and  not in a parameter file (parfile)), the special characters (quote marks) in the exclude clause may need to be escaped with  backslash (\) character . Because of this, it is recommended that you always use a parameter file (parfile). In Windows we used round bracket ( ) in IN clouse. But In Linux, we used { } bracket. Exclude Schema: expdp system/admin directory=mydump FULL=Y dumpfile=full.dmp exclude=schema:\"=\'SCOTT\'\“ expdp system/admin directory=mydump FULL=Y dumpfile=full.dmp exclude=schema:\”In{\'SCOTT\‘,\’SYSTEM\’}\“ Exclude Tables: expdp system/admin directory=mydump schemas='SCOTT' dumpfile=scott.dmp exclude=table:\"=\'EMP\'\“ OR expdp system/admin directory=mydump dumpfile=scott.dmp schemas=‘SCOTT’ exclude=:\"IN {\’EMP\',\’ DEPT\‘}\“ It is very easy to understand.
Views: 1323 Parag Mahalle
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: 7122 Parag Mahalle
Simplest way to create Tables on Oracle 12c
 
04:30
--EMPLOYEE TABLE CREATE TABLE "EMP" ( "EMPNO" NUMBER(4,0), "ENAME" VARCHAR2(10 BYTE), "JOB" VARCHAR2(9 BYTE), "MGR" NUMBER(4,0), "HIREDATE" DATE, "SAL" NUMBER(7,2), "COMM" NUMBER(7,2), "DEPTNO" NUMBER(2,0) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ; REM INSERTING into EMP SET DEFINE OFF; Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (5258,'ALEX','MANAGER',null,to_date('25-JAN-89','DD-MON-RR'),1500,500,null); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7875,'Aziz','MANAGER',7839,to_date('17-NOV-97','DD-MON-RR'),5000,1000,10); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7899,'HADI','PRESIDENT',null,to_date('09-MAY-99','DD-MON-RR'),9000,null,10); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (3576,'ABDURAUF','MANAGER',null,null,null,null,null); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (3131,'EBAD','CR',null,to_date('25-JAN-81','DD-MON-RR'),1500,500,null); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7955,'JOHNABRAHM','QWERT',null,to_date('18-JUN-20','DD-MON-RR'),2000,null,30); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (5952,'JENN','MANAGER',null,to_date('25-JAN-81','DD-MON-RR'),1500,500,null); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7369,'SMITH','CLERK',7902,to_date('17-DEC-80','DD-MON-RR'),800,null,20); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7499,'ALLEN','SALESMAN',7698,to_date('20-FEB-81','DD-MON-RR'),1600,300,30); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7521,'WARD','SALESMAN',7698,to_date('22-FEB-81','DD-MON-RR'),1250,500,30); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7566,'JONES','MANAGER',7839,to_date('02-APR-81','DD-MON-RR'),2975,null,20); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7654,'MARTIN','SALESMAN',7698,to_date('28-SEP-81','DD-MON-RR'),1250,1400,30); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7698,'BLAKE','MANAGER',7839,to_date('01-MAY-81','DD-MON-RR'),2850,null,30); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7782,'CLARK','MANAGER',7839,to_date('09-JUN-81','DD-MON-RR'),2450,null,10); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7788,'','ANALYST',7566,to_date('19-APR-87','DD-MON-RR'),3000,null,20); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7839,'KING','PRESIDENT',null,to_date('17-NOV-81','DD-MON-RR'),5000,null,10); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7844,'TURNER','SALESMAN',7698,to_date('08-SEP-81','DD-MON-RR'),1500,0,30); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7876,'ADAMS','CLERK',7788,to_date('23-MAY-87','DD-MON-RR'),1100,null,20); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7900,'JAMES','CLERK',7698,to_date('03-DEC-81','DD-MON-RR'),950,null,30); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7902,'FORD','ANALYST',7566,to_date('03-DEC-81','DD-MON-RR'),3000,null,20); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7934,'MILLER','CLERK',7782,to_date('23-JAN-82','DD-MON-RR'),1300,null,10); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (5230,'SCARLET','MANAGER',null,to_date('26-JAN-81','DD-MON-RR'),1600,600,null); CREATE UNIQUE INDEX "PK_EMP" ON "EMP" ("EMPNO") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ; ALTER TABLE "EMP" ADD CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "EMP" ADD CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO") REFERENCES "DEPT" ("DEPTNO") ENABLE;
Views: 51 Fareed Ullah
install oracle DB, unlock HR table ,connect sql developer and NetBeans
 
08:07
oracle DB HR table unlock, oracle xe installation and conntect with Sql developer ,NetBeans
Views: 22021 TAYFUN ÇELİK
scott account unlocking in oracle 10g
 
02:07
scott account unlocking in winxp
Views: 7448 EDUCATION
Creating Matrix Report Manually using Developer 6i Reports
 
07:09
This example demonstrates how to create a simple matrix report, listing managers, their departments and employees from the departments they manage. Schema: Scott, Table(s) used: emp
Views: 12395 Windows7bugs blog
Install Oracle on Local system and Unlock HR Schema
 
09:56
Today, lets see how to install Oracle 11g XE and unlock the HR schema tables and practice our lab exercises on the local system. Download : http://www.oracle.com/technetwork/products/express-edition/downloads/index.html Query : ALTER USER HR IDENTIFIED BY HR ACCOUNT UNLOCK;
Views: 40422 Karthik Avinash
Top and bottom Records
 
14:01
Interview question: For each department, find top and bottom paid employees (could be more than 1). Use scott.emp table . Visit https://sqlpatterns.wordpress.com/ for more SQL tips and tricks. You may also check my book here: https://www.amazon.com/Oracle-SQL-Tricks-Workarounds-Excellence/dp/1463421370/ The source code is available here: https://livesql.oracle.com/apex/livesql/s/f927mcq6z5k6jqyjxfa075kj0
Mise en place d'Oracle Express Edition 11g
 
04:13
Création d'un utilisateur Attribution de droit d'accès et de création d'objets Création de la base SCOTT (connu EMP) et de la base FPJ
P6 常用命令和数据准备 —— MySQL教程零基础从入门到精通
 
05:33
喜欢的朋友欢迎订阅!!我会持续更新。。。。。 本节中所倒入的sql文件,请保存为 ‘ bjpowernode.sql ’ 进行导入 -----------start-------------- drop table if exists dept; drop table if exists salgrade; drop table if exists emp; create table dept( deptno int(10) primary key, dname varchar(14), loc varchar(13) ); create table salgrade( grade int(11), losal int(11), hisal int(11) ); create table emp( empno int(4) primary key, ename varchar(10), job varchar(9), mgr int(4), hiredate date, sal double(7,2), comm double(7,2), deptno int(2) ); insert into dept(deptno,dname,loc) values(10,'ACCOUNTING','NEW YORK'); insert into dept(deptno,dname,loc) values(20,'RESEARCHING','DALLAS'); insert into dept(deptno,dname,loc) values(30,'SALES','CHICAGO'); insert into dept(deptno,dname,loc) values(40,'OPERATIONS','BOSTON'); insert into salgrade(grade,losal,hisal) values(1,700,1200); insert into salgrade(grade,losal,hisal) values(2,1201,1400); insert into salgrade(grade,losal,hisal) values(3,1401,2000); insert into salgrade(grade,losal,hisal) values(4,2001,3000); insert into salgrade(grade,losal,hisal) values(5,3001,5000); insert into emp(empno,ename,job,mgr,hiredate,sal,comm,deptno) values(7369,'SIMITH','CLERK',7902,'1980-12-17',800,null,20); insert into emp(empno,ename,job,mgr,hiredate,sal,comm,deptno) values(7499,'ALLEN','SALESMAN',7698,'1981-02-20',1600,300,30); insert into emp(empno,ename,job,mgr,hiredate,sal,comm,deptno) values(7521,'WARD','SALESMAN',7698,'1981-02-22',1250,500,30); insert into emp(empno,ename,job,mgr,hiredate,sal,comm,deptno) values(7566,'JONES','MANAGER',7839,'1981-04-02',2975,null,20); insert into emp(empno,ename,job,mgr,hiredate,sal,comm,deptno) values(7654,'MARTIN','SALESMAN',7698,'1981-09-28',1250,1400,30); insert into emp(empno,ename,job,mgr,hiredate,sal,comm,deptno) values(7698,'BLAKE','MANAGER',7839,'1981-05-01',2850,null,30); insert into emp(empno,ename,job,mgr,hiredate,sal,comm,deptno) values(7782,'CLARK','MANAGER',7839,'1981-06-09',2450,null,10); insert into emp(empno,ename,job,mgr,hiredate,sal,comm,deptno) values(7788,'SCOTT','ANALYST',7566,'1987-04-19',3000,null,20); insert into emp(empno,ename,job,mgr,hiredate,sal,comm,deptno) values(7839,'KING','PRESIDENT',null,'1981-11-17',5000,null,10); insert into emp(empno,ename,job,mgr,hiredate,sal,comm,deptno) values(7844,'TURNER','SALESMAN',7698,'1981-09-08',1500,null,30); insert into emp(empno,ename,job,mgr,hiredate,sal,comm,deptno) values(7876,'ADAMS','CLERK',7788,'1987-05-23',1100,null,20); insert into emp(empno,ename,job,mgr,hiredate,sal,comm,deptno) values(7900,'JAMES','CLERK',7698,'1981-12-03',950,null,30); insert into emp(empno,ename,job,mgr,hiredate,sal,comm,deptno) values(7902,'FORD','ANALYST',7566,'1981-12-03',3000,null,20); insert into emp(empno,ename,job,mgr,hiredate,sal,comm,deptno) values(7934,'MILLER','CLERK',7782,'1982-01-23',1300,null,10); select * from dept; select * from salgrade; select * from emp; -----------end----------------
Views: 29 Jomy King
Oracle SQL Join Tutorials
 
19:48
Oracle SQL Join Tutorials. Different types of joins and examples. For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=4 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 101598 Oresoft LWC
SQL Error ORA-00942 Table or View Does Not Exist in Oracle Database
 
05:03
How to use Tab View (Data Dictionary) of Oracle Database to solve the SQL Error ORA-00942 Table or View Does Not Exist error in Oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/ora-00942 Previous Tutorial ► ------------------------------------------------------------------------- ►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 http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the 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: 5273 Manish Sharma
Oracle 11g installation steps
 
17:58
This Video shows the step by step instruction of how to install and set up Oracle 11g database. Link to download demobld.sql - http://trainingpoint.weebly.com/blog/oracle-11g-installation-steps
Views: 100 Training Point
BETWEEN AND Operator in SQL Query with Example
 
02:34
SQL BETWEEN ... AND Operator: The operator BETWEEN and AND, are used to compare data for a range of values. For Example: to find the emp details who have salaries between 2500 and 5000, the query would be like, select * from emp where sal between 2500 and 5000; The output would be similar to: EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ---------- ---------- --------- ---------- --------- ---------- ---------- ---------- 7566 JONES MANAGER 7839 02-APR-81 2975 20 7698 BLAKE MANAGER 7839 01-MAY-81 2850 30 7788 SCOTT ANALYST 7566 09-DEC-82 3000 20 7839 KING PRESIDENT 17-NOV-81 5000 10 7902 FORD ANALYST 7566 03-DEC-81 3000 20
Views: 2024 WingsOfTechnology
How to find out Highest ,Second highest Third highest salary and Nth highest salary in SQL Server
 
07:25
A Chanel Where you can learn about Computer Information and Technology Like Asp.Net C#,Asp.Net MVC,SQL Server,Bootstrap,Oracle and more Website design. Website : http://www.dawacit.com Facebook : https://www.facebook.com/dawacit05 Twitter : https://twitter.com/dawacit How to send email in ASP.NET C# using Gmail smtp server step by step https://youtu.be/rnQphXehu7g How to send email with attachment in Asp.Net through Gmail smtp server,simple steps https://youtu.be/mhRe_we4hhA How to create Navigation bar in Asp.Net with CSS https://youtu.be/xVgtAdxhIxk How to create website using ASP.NET very attractive design https://youtu.be/uAKWaCl-vK4 How to create login and logout in Asp.Net MVC https://youtu.be/7E8IK_eAsWE
Views: 27478 Dawa CIT
(Pt1/3) OUR UNIVERSE IN PERSPECTIVE: Scott Owen Talks Earth Changes Live on Bob Tuskin May 13, 2011
 
14:43
Preparedness for Post Glacial Rebound ie: Flooding, Earthquakes, Nuclear Disasters, Fires, Animal Die Offs, HAARP, CERN, New Madrid Seismic Zone, Bermuda Triangle, Dragon's Triangle, EMP's, Evergreen Air, Chemical and Oil Spills, and NWO thrills. Scott Owen USGS validated professional seeks to explain the phenomenon associated with post glacial rebound effect and what it means for all species that share the Earth in the next coming years. Live on Bob Tuskin May 13, 2011 Oracle Broadcasting. THIS VID INCLUDES: San Andreas Fault California Super Quake Santa Cruz Animal Die Offs Costa Rica Quake Epic Mudslides Worldwide Japan History of Major Quakes CERN Bending Light Project Cartoons Predict 9/11 Static Discharge and EMP Mississippi Flooding PA Hydrofracting Inccident Pt 1 Scott's Friday May 13, 2011 Vid http://www.youtube.com/watch?v=er9-1zlCld8&feature=player_profilepage Pt 2 Scott's Friday May 13, 2011 Vid http://www.youtube.com/watch?feature=player_profilepage&v=Acdml_qiqyY Scott Owens Youtube Channel Please SUB http://www.youtube.com/User/Believersunderground Oracle Broadcasting Website http://www.Oraclebroadcasting.com
Views: 1884 MrJamenard

Program specialist cover letter examples
School admission cover letter example
Sample cover letters for employment gaps in resumes
Nyu admissions essay 2012
Writing letter to judge uk