Home
Search results “Oracle sqlplus open file”
Oracle DBA Justin - How to execute sql and Sqlplus commands from an external script
 
09:33
How to execute sql and Sqlplus commands from an external script
Views: 90727 jbleistein11
How to run Oracle Multiple .sql Script files using Single .sql file using sqlplus command line?
 
05:46
This Video will show you how to execute Scripts in Multiple Schemas through Command Prompt. sqlplus execute sql file? how to run sql script in sqlplus command line? how to run sql script in oracle sql developer? sqlplus execute command? how to run sql script in sqlplus command line in windows? sqlplus script example sqlplus command line example sqlplus run script output to file sqlplus run script command line sqlplus command line example sqlplus command line options sqlplus command example how to run sql script in sqlplus command line in windows sqlplus command in unix sqlplus script example sqlplus command line windows
Views: 4508 Oracle PL/SQL World
Oracle SQL Loader - How to load data from file(.csv, .dat, .txt) into table - Tutorial - 3
 
16:44
This video is the third tutorial on Oracle SQL*Loader tutorial series created by Kishan Mashru. Oracle SQL Loader utility is used to load data from flat files like .csv files, .dat files, .txt files into Oracle database tables. In this video tutorial, we demonstrated how to load data from excel to oracle using sql loader We showed the SQL Loader control file example and loaded data from the .csv file into the database table. Check out the first video: https://youtu.be/fSV51bljrwY Check out the second video: https://youtu.be/ogidUWHHRL8 Check out the advantages of using TRUNCATE over a DELETE from the following video: Delete VS Truncate : https://youtu.be/u76wMm2byXo #KishanMashru #Oracle #SqlLoader #SqlLoaderExample #LoadCSV #LoadExcel #SQLandPLSQL #OracleSqlLoader #ETL #database
Views: 8713 Kishan Mashru
How to import .dmp file into Oracle Database
 
05:28
This video tutorial is created for all those beginners who want to import any .dmp file from another Oracle Database to their own database.
Views: 19239 Uzair Awan
Oracle(How to create a spool file or list file in Oracle)
 
03:33
how to create a list file or spool file in oracle ...
Views: 14895 sreetheja amilineni
How to connect to an Oracle Database? - Database Tutorial 37
 
12:37
Video 37 - How to connect to a Oracle Database? - Database Tutorial 37 This video explains how to connection to an oracle database. The database, which is Oracle 11g has been installed in a Windows 7 computer.
Views: 130273 Sam Dhanasekaran
Parameter files in Oracle- Pfile & SPFile
 
07:50
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] Please visit my official website for oracle database training and hadoop blog. https://www.orcldata.com/ Please donate on below link if you think I am helping you with your career. https://www.paypal.me/ankushthavali OR Google Pay : 9960262955 OR Account No : 31347845762 IFSC: SBIN0012311 parameter file in oracle 11g what is parameter file in oracle parameter file definition pfile parameters in oracle 11g list of initialization parameters in oracle 11g static and dynamic parameters in oracle init.ora file location in oracle 12c spfile in oracle
Views: 1822 ANKUSH THAVALI
how to solve Cannot create save file "afiedt.buf" error in SQL
 
03:22
how to solve Cannot create save file "afiedt.buf"
Views: 15109 www.itsoftpoint.com
CSV file import into Oracle
 
04:52
An example to show how to upload a CSV file into an Oracle database usin SQL Loader.
Views: 75580 WoolFool
confrigure tnsnames file on oracle 11g client
 
02:54
confrigure tnsnames file on oracle 11g client
Views: 14828 Jamaal Khan
how to run Oracle commands by notepad...?
 
04:21
how to run Oracle commands by notepad... #sqltutorial#oracletutorial#databasetutorial
Views: 6611 Luckybaba Vlogs
How to run sql script in sqlplus command line in linux
 
05:24
My channel is mainly helpful for those who are looking to start their career in Oracle DBA | oracle databases administration technology. Channel will provide you in depth understanding for all oracle database concept.You will find the YouTube channel helpful for cracking oracle database administration interview. The explanation is clear and practically represented. Please reach me vie email [email protected] if you are looking for online training. https://www.orcldata.com Email: [email protected] Mob No: +91 9960262955 Please use the following link to get unlimited videos. https://www.skillshare.com/r/profile/Ankush-Thavali/5208062 Below is the coupon code for skillshares. https://www.udemy.com/draft/1412310/?couponCode=DBSHOT Please donate on below link if you think I am helping you with your career. https://www.paypal.me/ankushthavali OR Google Pay : 9960262955 OR Account No : 31347845762 IFSC: SBIN0012311 how to run sql script in sqlplus command line in linux how to run sql script in sqlplus command line in windows sqlplus script example sqlplus execute command how to run sql script in oracle sql developer run oracle sql script from batch file oracle sql script example execute sql file in unix shell script
Views: 1751 ANKUSH THAVALI
41. Ed or Edit Buffer Command in Oracle
 
02:12
In this video you will learn about Ed or Edit command which is also known as buffer command. I will show you a really quick example to show it. I will also show you how to fix SP2-0110: Cannot create save file "afiedt.buf" error. 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: 20723 ITORIAN
Oracle SQL Tutorial : How to connect oracle database using sqlplus command line
 
02:20
Oracle tutorial: How to connect oracle database using sqlplus command line sqlplus tools to connect to oracle database In this tutorial you can see using SQLPLUS commands how we can connect the oracle database . After connecting the oracle database you can able execute the sql query. oracleconnection oracle sqlplus connect to database Oracle SQL Tutorial
Views: 22740 Tech Query Pond
how to configure and connect oracle 12c database for the first time
 
06:31
how to configure and connect oracle 12c database for the first time, add pluggable database services in tnsname.ora file, connect sys as sysdba, alter session set container = pdborcl, startup open; alter user name_of_user identified by password account unlock;
Views: 8866 Data Science Center
how to open oracle sqlplus
 
04:53
how to open sqlplus in windows10
Views: 98 mahesh bouthu
Learn Oracle | How to Open SQL Plus for the First Time
 
02:31
Pebbles present, Learn Oracle 10g with Step By Step Video Tutorials. Learn Oracle 10g Tutorial series contains the following videos : Learn Oracle - History of Oracle Learn Oracle - What is Oracle - Why do we need Oracle Learn Oracle - What is a Database Learn Oracle - What is Grid Computing Learn Oracle - What is Normalization Learn Oracle - What is ORDBMS Learn Oracle - What is RDBMS Learn Oracle - Alias Names, Concatenation, Distinct Keyword Learn Oracle - Controlling and Managing User Access (Data Control Language) Learn Oracle - Introduction to SQL Learn Oracle - Oracle 10g New Data Types Learn Oracle - How to Alter a Table using SQL Learn Oracle - How to Create a Package in PL SQL Learn Oracle - How to Create a Report in SQL Plus Learn Oracle - How to Create a Table using SQL - Not Null, Unique Key, Primary Key Learn Oracle - How to Create a Table using SQL Learn Oracle - How to Create a Trigger in PL SQL Learn Oracle - How to Delete Data from a Table using SQL Learn Oracle - How to Drop and Truncate a Table using SQL Learn Oracle - How to Insert Data in a Table using SQL Learn Oracle - How to open ISQL Plus for the first time Learn Oracle - How to Open SQL Plus for the First Time Learn Oracle - How to Update a Table using SQL Learn Oracle - How to use Aggregate Functions in SQL Learn Oracle - How to use Functions in PL SQL Learn Oracle - How to use Group By, Having Clause in SQL Learn Oracle - How to Use Joins, Cross Join, Cartesian Product in SQL Learn Oracle - How to use Outer Joins (Left, Right, Full) in SQL Learn Oracle - How to use the Character Functions, Date Functions in SQL Learn Oracle - How to use the Merge Statement in SQL Learn Oracle - How to use the ORDER BY Clause with the Select Statement Learn Oracle - How to use the SELECT Statement Learn Oracle - How to use the Transactional Control Statements in SQL Learn Oracle - How to use PL SQL Learn Oracle - Data Types in PL SQL Learn Oracle - Exception Handling in PL SQL Learn Oracle - PL SQL Conditional Logics Learn Oracle - PL SQL Cursor Types - Explicit Cursor, Implicit Cursor Learn Oracle - PL SQL Loops Learn Oracle - Procedure Creation in PL SQL Learn Oracle - Select Statement with WHERE Cause Learn Oracle - SQL Operators and their Precedence Learn Oracle - Using Case Function, Decode Function in SQL Learn Oracle - Using Logical Operators in the WHERE Clause of the Select Statement Learn Oracle - Using Rollup Function, Cube Function Learn Oracle - Using Set Operators in SQL Learn Oracle - What are the Different SQL Data Types Learn Oracle - What are the different types of Databases Visit Pebbles Official Website - http://www.pebbles.in Subscribe to our Channel – https://www.youtube.com/channel/UCNNjWVsQqaMYccY044vtHJw?sub_confirmation=1 Engage with us on Facebook at https://www.facebook.com/PebblesChennai Please Like, Share, Comment & Subscribe
Views: 16399 Pebbles Tutorials
How To Run .sql Program File In Oracle Command Line | SQL Tutorial | PL/SQL | Oracle SQL 10g
 
03:48
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: 14530 Unpossible POG
How to Connect with SQLPLUS in Oracle 11g?
 
08:25
how to open and connect with SQLPLUS in Oracle 11g? Hi friends.. In last video..we have seen , How to install oracle 11g database in windows 7 system.. Now ,we are going to know how to open and connect sqlplus... Generally Sqlplus is coming with oracle database software so we no need to install seperately... actually sqlplus provides development environment of sql/plsql... now I show u and how open and connect with sqlplus with different users.. First of all ,to open sqlplus--go to start menu-All programs--oracle db home-application development-sqlplus. as shown in video... now I connected my sqlplus with system user... now i want to connect with scott user.. Eg:connect scott/tiger... so guys ...this is the way to open and connect the sqlplus with different users... thank u ...... please watch n subscribe and like my channel 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: 15777 pa online
How to download/install oracle database (software) 11g release 2 on Windows 10 Pro 64 bit
 
08:13
How to install oracle database 11g on Windows 10 Pro 64 bit, I'll explain the detail steps for downloading the oracle database 11g Release 2 then how to install it step by step. after that I will show you how to access oracle database(software) using SQL*Plus. thanks for watching. Subscribe for more: ---------------------------------- https://goo.gl/oL45FT SWE.Safaa Al-Hayali - saf3al2a TAGS: #How_to_install_oracle_database_11g_on_Windows_10_Pro_64_bit ----------------------------------------------------------------------------------------------------
Views: 216283 Safaa Al-Hayali
Oracle username and password and Account unlocking
 
08:37
all education purpose videos
Views: 297646 Chandra Shekhar Reddy
how to import oracle database or dmp file
 
05:50
This video will tell you how to import a user from oracle data to you oracle data base
Views: 94166 brijesh kumar
Oracle Data Export and Import using DataPump expdp and impdp
 
09:38
Oracle Data Export and Import using DataPump expdp and impdp
Views: 191910 Abbasi Asif
How does an Oracle database start? - Database Tutorial 38
 
12:39
Video 38 How does an Oracle database start? - Database Tutorial 38 How does an Oracle database start? - Database Tutorial 38 The startup of sequence of an Oracle Database. 1) Startup process looks for a parameter file in the default location. 2) If a parameter file is found, it then parses it and gets the information about the control files. 3) With that information, it reads the control files. 4) Upto this point, we can say that the Oracle Instance has been started in nomount mode. 5) The same can be achieved by issuing the following command in sqlplus. a) startup nomount; 6) Then, from the control files, the Instance gets to know about the details of the database and its related files. 7) It then 'mounts' the database. 8) At this point, the database has been started. But it can be only accessed by the DBAs. 9) This is called 'mount' mode. 10) The same can be achieved by issuing the following command in sqlplus. a) startup mount; 11) Then, once the database has mounted, it gets opened for other users. 12) This is called 'OPEN' mode. 13) This is the final mode of a startup process after which the database is available for use. 14) The same can be achieved by issuing the following command in sqlplus. a) startup 15) That concludes the startup.
Views: 13331 Sam Dhanasekaran
PL/SQL Hello World Program | how to run PL SQL program
 
02:02
for more video plz like and subscribe! this channel
Views: 10045 Ramji Tech
Oracle tutorial : SQLPLUS COPY Command In Oracle PL SQL
 
07:29
Oracle tutorial : SQLPLUS COPY Command In Oracle PL SQL For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond oracle sqlplus sql commands sql commands with examples sql prompt command
Views: 1631 Tech Query Pond
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: 195027 Manish Sharma
Oracle DB - Startup & Shutdown
 
11:55
Oracle DB - Startup & Shutdown Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
Oracle DBA Justin - How to set the Oracle environment on a Unix or Linux system
 
28:22
How to set the Oracle environment on a Unix or Linux system
Views: 51394 jbleistein11
How to start the oracle database,  ORA-01033: ORACLE initialization or shutdown in progress
 
04:40
ORA-01033: ORACLE initialization or shutdown in progress when oracle display error message ORA-01033, its mean that our database is not in working. For that it is very necessary to start the database. for that connect with the sys as sysdba user. and write the command startup open;
Views: 16529 Data Science Center
Oracle Database 12c Tutorial 3:Connect HR/SYS user with SQL Developer in Oracle12c Using TNS Service
 
05:24
Learn how to connect HR and Sys User of Oracle database 12c With SQL Developer using TNS service. Connect HR user which is in pluggable database to SQL Developer ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : 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: 59593 Manish Sharma
How to Export data from Oracle to Excel
 
05:48
This tutorial shows you how to export data from Oracle to excel sheet. sql developer is used in this tutorial to export the data with two methods. Please feel free to comment. Please subscribe for more
Oracle tutorial 03: Connecting to oracle database through command prompt.mp4
 
04:03
steps to connect to oracle database through command prompt.....!!!!
Views: 70246 navingupta52
SQL command line Tutorial 1 ( Connect to Oracle SQL and Unlock)
 
02:02
you can get all query in these link : https://scarletsoummo.wordpress.com/ have to download Oracle SQL command line link: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html Have to accept license and download it . After finishing installation go to command prompt and write down: c: cd.. cd.. sqlplus / as sysdba alter user hr identified by hr account unlock; Like command and subscribe :)
Views: 20361 Soummo Supriya
1.Introduction to basic SQL*Plus and SQL commands in oracle 9i
 
20:41
A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as invented by E. F. Codd, of IBM's San Jose Research Laboratory. Many popular databases currently in use are based on the relational database model.RDBMSs have become a predominant choice for the storage of information in new databases used for financial records, manufacturing and logistical information, personnel data, and much more since the 1980s. Relational databases have often replaced legacy hierarchical databases and network databases because they are easier to understand and use. However, relational databases have been challenged by object databases, which were introduced in an attempt to address the object-relational impedance mismatch in relational database, and XML databases. Object-relational database management system (ORDBMS) ============================================ An object-relational database can be said to provide a middle ground between relational databases and object-oriented databases (OODBMS). In object-relational databases, the approach is essentially that of relational databases: the data resides in the database and is manipulated collectively with queries in a query language; at the other extreme are OODBMSes in which the database is essentially a persistent object store for software written in an object-oriented programming language, with a programming API for storing and retrieving objects, and little or no specific support for querying. Object-relational database management systems grew out of research that occurred in the early 1990s. That research extended existing relational database concepts by adding object concepts. The researchers aimed to retain a declarative query-language based on predicate calculus as a central component of the architecture. Probably the most notable research project, Postgres (UC Berkeley), spawned two products tracing their lineage to that research: Illustra and PostgreSQL. Many of the ideas of early object-relational database efforts have largely become incorporated into SQL:1999 via structured types. In fact, any product that adheres to the object-oriented aspects of SQL:1999 could be described as an object-relational database management product. For example, IBM's DB2, Oracle database, and Microsoft SQL Server, make claims to support this technology and do so with varying degrees of success. SQL(Structures Query Language) ======================== SQL was initially developed at IBM by Donald D. Chamberlin and Raymond F. Boyce in the early 1970s. This version, initially called SEQUEL (Structured English Query Language), was designed to manipulate and retrieve data stored in IBM's original quasi-relational database management system, System R, which a group at IBM San Jose Research Laboratory had developed during the 1970s.The acronym SEQUEL was later changed to SQL because "SEQUEL" was a trademark of the UK-based Hawker Siddeley aircraft company. SQL*Plus ======= SQL*Plus is a command line SQL and PL/SQL language interface and reporting tool that ships with the Oracle Database Client and Server software. It can be used interactively or driven from scripts. SQL*Plus is frequently used by DBAs and Developers to interact with the Oracle database. If you are familiar with other databases, sqlplus is equivalent to: "sql" in Ingres, "isql" in Sybase and SQL Server, "sqlcmd" in Microsoft SQL Server, "db2" in IBM DB2, "psql" in PostgreSQL, and "mysql" in MySQL.
Views: 50414 DASARI TUTS
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 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: 393712 Manish Sharma
How to install sql developer on Windows 10 Pro 64 bit
 
07:47
How to install sql developer on Windows 10 Pro 64 bit, and also in this video I will show you how to access oracle database (software) 11g r2 using sql developer thanks for watching. Subscribe for more: ---------------------------------- https://goo.gl/oL45FT SWE.Safaa Al-Hayali - saf3al2a TAGS: #How_to_install_sql_developer_on_Windows_10_Pro_64_bit ----------------------------------------------------------------------------------------------------
Views: 140563 Safaa Al-Hayali
ORA-39002: invalid operation ORA-39070: Unable to open the log file
 
03:18
http://dbacatalog.blogspot.com
Views: 3391 dbacatalog
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: 390986 Chitu Okoli
How to reset or change password in sqlplus ,system, admin
 
03:03
Hy guess in this Video Tutorial We are going to show How to Reset Password of SQL Plus or Change user password in SQL Plus. If you face any confusion so comment below or send us email at [email protected] *** Subscribe our Channel for more upcoming Videos. *** Also Visit our website uogstack.wordpress.com
Views: 8168 UOG Stack
Connect to Oracle 12c DB in the same machine with Oracle express and E business suit
 
08:06
in this video you will see how to connect to Oracle 12c users like sys and hr ... in the same machine with oracle express (Oracle apex) and oracle e business suite (Oracle Apps) ... by sql plus , sql developer and toad ..... and you can use this way to add any other database you need and this is what I did in the video =================================== 1- The go to the file tnsnames in the path (D:\app\gaid2\product\12.1.0\dbhome_1\NETWORK\ADMIN) And this part (D:\app\gaid2) different from your one this is which you put you database in while installation 2- Open this file you will find this code ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) 3- Copy this and past it blew but make a little change like this PDBORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdborcl) ) ) 4- Then save and take this 2 blocks of code copy and go to this file tnsnames in the path in the partition where you installed your oracle express DB Which in my case (C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN) 5- Open this file and past the 2 blocks of code 6- Then save 7- Then Open sql plus from start menu 8- Write username : sys as sysdba 9- The write the password which you entered while installation of Oracle 12c DB 10- The write ALTER SESSION SET CONTAINER = PDBORCL; Then enter 11- Then write SHOW CON_NAME; Then enter You will find that the con_name became pdborcl 12- Then run this statement to see if the status of pdborcl open or not SELECT NAME , OPEN_MODE FROM V$PDBS; If it in MOUNTED status then we need to open it by this statement ALTER PLUGGABLE DATABASE OPEN 13- Then we need to unlock user hr by one of this statements ALTER USER HR INDENTIFIED BY HR ACCOUNT UNLOCK; ALTER USER HR ACCOUNT UNLOCK; 14- Then go to toad and sql developer to check like I do. Thanks Ahmed Gaid Please subscribe :)
Views: 41 Ahmed Gaid
pl sql developer - connect to oracle 12c database using pl sql developer with tnsnames.ora
 
06:22
pl sql developer - connect to oracle 12c database using pl sql developer with tnsnames.ora Connect to oracle database - how to connect to oracle database using sqlplus in windows: https://youtu.be/8GK4RQuCx_8 In this tutorial "pl sql developer - connect to oracle database using pl sql developer with tnsnames.ora" will show you how to configure tnsname.ora in pl sql developer for oracle database connection, create table in pl sql developer, insert data in pl sql developer, and select result in pl sql developer. You can find me: Facebook: https://www.facebook.com/HingTipi Instagram: https://www.instagram.com/pi_sapphire/?hl=en Linkedin: https://www.linkedin.com/in/tipi-hing-93080261/ Google plus: https://plus.google.com/u/0/115396916707479934437 Twitter: https://twitter.com/TiPiHing photo credit: CREDIT PHOTO https://www.flickr.com/photos/[email protected]/10614978976/in/photolist-hb1xqU-4A4jrh-fPduyd-rcmbAc-fPcRfU-r8Jbhv-5gAYFx-bqrToM-dRFrZg-fNVyov-62Yv2h-nQug-9h8PzA-5aZeqx-9h5FM4-7H6iUU-9h8PrQ-9h5FAc-b78rj-9h5Fv8-fJt9Ex-kqoVuF-jcK5w5-hEoyms-9h5FJ8-Ro3Xc9-9h5FGK-8b8puq-9h5FBR-dfUthv-agLG6c-9h5Fz8-pSbCPg-5A8zDb-jC4vYX-RT31DE-9h8Pqm-4VMqsw-SCqtuw-4VMpCo-bofeWo-fPrqnP-aznTRJ-8vh3ny-7heoWE-jC5rn8-bTzxkx-gYu6fR-9GywxF-fNUJjF Subscribe. Like. Share. Comment. Thanks, pl sql developer connect to oracle 12c database using pl sql developer
Views: 29878 Junior Geek
Formatting your Oracle Query Results Directly to CSV
 
03:02
How to get Oracle SQL Developer to automatically format your query results to CSV, HTML, JSON, Insert statements, and more.
Views: 52483 Jeff Smith
Setting the  default editor in SQLPlus to persist between sessions
 
05:53
This is a short tutorial on how to set up a default editor that persists between sessions in SQLPlus.
Views: 2067 C.S. Taylor, Jr.
ORACLE TUTORIAL - How to convert .dmp file into .sql file
 
07:18
in this tutorial i'm going to demonstrate you how to convert .DMP file into .SQL file using the sqlfile parameter steps by steps.
Views: 7501 OCP Technology
Oracle Database 18c Installation on Windows 10
 
32:47
In this video we are going to demonstrate how to install Oracle Database 18c in Windows 10 Operating System. Oracle Database 18c is RDBMS software from Oracle Corporation with tons of features including Cloud Support. Oracle Database 18c installation in Windows Platform is very easier. This video guides step by step installation of oracle 18c on windows also covers, oracle database installation, sql plus and sqldeveloper to run sql queries, oracle instance manager to start and stop the database and finally access oracle enterprise manager 18c in browser. Hardware Requirements : Enough Hard disk space, RAM. Installation Class : Desktop class is choosen, which is easy to configure for desktops and laptops. Installation method : Offline, Oracle 18c zip file for windows downloaded and installed.
Views: 20668 java frm
How to Install Oracle Database 12c on Windows 10
 
08:46
https://www.databasestar.com/oracle-hq/ - This video takes you through the exact steps required to install Oracle Database 12c on Windows 10. It uses 12c Release 2 Standard Edition, but the same steps can be followed for installing Oracle 12c Enterprise Edition. The steps involved are: 1. Visit www.oracle.com and go to Downloads - Database - Oracle Database 2. Log in with your Oracle account (or create one) and download the ZIP file 3. Extract the ZIP file 4. Run setup.exe as an administrator 5. Follow the steps in the installer 6. Log in to the database using SQL*Plus to check it has installed correctly For more information on Oracle SQL, visit my website at www.databasestar.com. There you'll find guides on various Oracle SQL topics and tips on improving your career. Finally, if you like the video, don't forget to subscribe to the channel! Thanks!
Views: 45849 Database Star