Home
Search results “Oracle execute immediate truncate”
Execute Immediate in PL/SQL Explained with example.
 
12:07
Execute Immediate is mainly used to run native dynamic sql, This video takes a lay men approach to easily but precisely explain the concept using real project examples.
Views: 1422 Tech Coach
PL/SQL Tutorial: EXECUTE IMMEDIATE   Native Dynamic SQL
 
03:51
PL/SQL Tutorial: EXECUTE IMMEDIATE Native Dynamic SQL SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 306 TechLake
SQL Tutorial : Difference Between Truncate and  Drop in SQL Oracle
 
05:40
SQL Tutorial : Difference Between Truncate and Drop in SQL Oracle SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 1094 TechLake
Truncating tables in SQL tutorial part-15
 
10:24
Truncate table empties a table completely. Logically, this is equivalent to a delete statement that deletes all rows, but there are practical differences under some circumstances.
Views: 198 SQL
PL/SQL tutorial 21: How To Create Startup Trigger In Oracle Database By Manish Sharma
 
03:08
Learn how to create a startup trigger with easy to understand example or startup auditing in oracle database by Manish Sharma RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/startup-shutdown-database-trigger Previous Tutorial ► PL/SQL tutorial 20: 'LogOff' Trigger https://youtu.be/l5lcE68xK-k ►PL/SQL tutorial 19: 'LogOn' Trigger https://youtu.be/dJSlgiwt7w0 ►SQL tutorial 46: System Privileges https://youtu.be/EQzdtKPiErU ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ 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: 24461 Manish Sharma
Use Cursor to Run Dynamic SqL How To
 
08:15
How to use cursor to run strings of sql. Adventure Works example. Dynamic System Table video: https://www.youtube.com/watch?v=Rq_TgTCpvzo
Views: 186 Blake B
Oracle Dynamic SQL Basic (Native Dynamic SQL for Creating Table)
 
07:06
Dynamic SQL merupakan fitur dari Oracle DBMS dimana tidak hanya nilai saja yang dapat berubah saat query dieksekusi, tapi nama atribut maupun nama tabel dapat di ubah saat query dieksekusi. Native dynamic SQL merupakan dynamic SQL yang menggunakan sintaks EXECUTE IMMEDIATE. Video ini memberikan contoh penggunaan native dynamic sql pada stored procedure dimana procedure tersebut dapat membuat tabel secara dinamis.
Views: 209 Boby Siswanto
DIFFERENCE BETWEEN PROCEDURE AND FUNCTION IN ORACLE PL/SQL WITH EXAMPLE
 
06:33
The audio and video now synced. This video is a free tutorial on the difference between procedure and a function. The tutorial demonstrates the difference between oracle PL/SQL stored procedure and a function, also it shows the different type of return statement in both of the database objects and various ways to execute a procedure and a function. By learning the difference the users can make an effective judgment on when to use procedure and when to use a function. If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below: union and union all: https://youtu.be/n9FqQOd8liY char and varchar2: https://youtu.be/039qzwjWf4k replace and translate: https://youtu.be/HKYF77BGzOE in and exists: https://youtu.be/REX4IjRYlFw rank and dense_rank: https://youtu.be/WGSX998hZ9M delete and truncate: https://youtu.be/u76wMm2byXo %type and %rowtype: https://youtu.be/MlLUFeZ_3eM
Views: 4718 Kishan Mashru
PL/SQL: Dynamic SQL part-2
 
05:14
In this tutorial, you'll learn what is dynamic SQL and how to implement it.. 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.
Views: 17484 radhikaravikumar
SQL tutorial 60: SQL View in Oracle Database By Manish Sharma RebellionRider
 
07:30
SQL View in Oracle Database. In this tutorial you will learn how to create a vie as well as how to replace a view along with the examples of all the DML e.g. DESCRIBE, SELECT, UPDATE, INSERT and Delete on view by Manish Sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-view-in-oracle-database Previous Tutorial ► Tut 5: SELECT statement http://youtu.be/f_mVBVgnqmM ------------------------------------------------------------------------- ►►►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: 43174 Manish Sharma
Oracle Database | Bangla Tutorials 31 :: Truncate Table |(Remove all Record a Table)
 
01:30
www.facebook.com/oracle.shohag Email : [email protected] Website : www.oraclebangla.com skype id : shoahgcid2013 Topics :Truncate Table
Views: 2884 Oracle Bangla
2. SQL SERVER - How To Use DDL Command in SQL Server
 
17:37
This is my 2nd video for sql server beginners. Here i shown you how to use DDL Command in very easy way. i will also improve my video quality. in my next video i will show you other sql things. if you like this video please like and share with your friends. E - mail - [email protected] Contact - +91-7386375063 http://casualient.com/qcy
Views: 120 Nikhil Tech
DDL statement processing in an Oracle Database - DBArch Video 9
 
02:10
In this video you learn about what happens when you run a DDL ( data definition language) command in the Oracle Database. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 15095 Ramkumar Swaminathan
SQL Tutorial : Difference Between PLSQL Procedures and  Functions
 
09:43
SQL Tutorial : Oracle PLSQL Difference Between Procedures and Functions in Oracle SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 1637 TechLake
PL/SQL tutorial 75: PL/SQL Bulk Collect with LIMIT clause in Oracle Database
 
07:37
RebellionRider.com presents the 4th tutorial in Bulk Collect series. Watch and learn how to use Bulk Collect with LIMIT clause to enhance the query performance in Oracle Database by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/bulk-collect-4 Previous Tutorial ► Bulk Collect with Explicit Cursor https://youtu.be/PSA8HigCcRs ------------------------------------------------------------------------- ►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: 8160 Manish Sharma
PL/SQL tutorial 80: Introduction to Native Dynamic SQL by Manish Sharma
 
04:31
RebellionRider.com presents an introduction to Native Dynamic SQL (NDS) in Oracle Database by Manish Sharma. In this tutorial, you will learn what is a Static SQL and a Dynamic SQL. Also different ways of using Dynamic SQL in Oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/NDS-1 "What Is A Database Management Systems (DBMS)?" http://bit.ly/the-DBMS Previous Tutorial ► Bind Variables: https://youtu.be/TJtjo3FTBtE ►Bulk Data Processing Playlist https://www.youtube.com/playlist?list=PLL_LQvNX4xKwLcCuxb7-e8BVFxXFHCUPo ------------------------------------------------------------------------- ►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: 7072 Manish Sharma
Oracle SQL Interview Questions : Delete duplicate records
 
04:48
This is the 1st video of the video series Oracle Interview questions. The video Demonstrates how to delete duplicate records in Oracle. I will cover all the major common questions asked in SQL and PL/SQL interviews as a part of this series. Please do contribute questions that you have come across in any of your interviews
Views: 3221 Tech Coach
PL/SQL tutorial 18: DDL Trigger with Schema Auditing Example
 
08:12
Learn how to create a DDL Trigger in Oracle Database with Schema Auditing Example where we will learn how to keep an any on which object is created, altered or drop and by who. Manish Sharma From RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/DDL-Trigger Previous Tutorial ►PL/SQL Tut 14 Triggers Introduction https://youtu.be/R3fvX_xf5P4 ► PL/SQL Tut 17 Table Backup Using DML Trigger https://youtu.be/jSv1LIlNKU0 ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 47247 Manish Sharma
PLSQL Tutorial : Introduction To PLSQL Triggers and Types of Triggers
 
05:28
Introduction To PLSQL Triggers and Types of Triggers SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 541 TechLake
PL/SQL tutorial 77: Forall statement with Lower & Upper bound in Oracle Database
 
07:17
Learn how to use PL/SQL FORALL statement Lower and Upper Bound Clause for bulk data processing in Oracle Database by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/forall-2 You can also read the latest blog in Database Concept series http://bit.ly/the-DBMS Previous Tutorial ►Intro to FORALL https://youtu.be/8HMd7fZQNHs ►Associative Array https://youtu.be/wGXeD_oWxUk ------------------------------------------------------------------------- ►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: 6185 Manish Sharma
DDL commands | SQL queries | Oracle database 11g version 2 |
 
15:11
how to write sql queries i.e DDL commands in oracle
Views: 435 Education 4u
Oracle Function NVL Function
 
12:32
Go to below link to get source code of video https://justinclick.blogspot.in/
Views: 1906 Just1click
Oracle - SQL - DDL Statements
 
04:20
Oracle - SQL - DDL Statements Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
What are types of View available in Oracle
 
05:10
What are the types of View available in Oracle? Watch More... What is Parameterized Cursor in Oracle https://www.youtube.com/watch?v=JMKwHlVi6-A What is autonomous transaction in Oracle. https://www.youtube.com/watch?v=gyvFajpfoWE What are Constraints available in Oracle. https://www.youtube.com/watch?v=WivhdLXQklQ What is Mutation Error and How to avoid mutation. https://www.youtube.com/watch?v=CbWNCyW18Bs 5 Effective way to delete Duplicate rows https://www.youtube.com/watch?v=1wtTtnc87Oc What is Difference between Delete and Truncate https://www.youtube.com/watch?v=7b6wQ3Qumgg
Views: 10076 Ram Gupta
Difference between Procedure and Function
 
06:33
This Video is out of audio and video sync, please find the updated video on https://www.youtube.com/watch?v=pofSn7lzqxA This video is a free tutorial on difference between procedure and a function. The tutorial demonstrates the difference between oracle pl/sql stored procedure and a function, also it shows the different type of return statement in both of the database objects, and various ways to execute a procedure and a function. By learning the difference the users can make an effective judgement on when to use procedure and when to use function. If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below : union and union all : https://youtu.be/n9FqQOd8liY char and varchar2 : https://youtu.be/039qzwjWf4k replace and translate : https://youtu.be/HKYF77BGzOE in and exists : https://youtu.be/REX4IjRYlFw rank and dense_rank : https://youtu.be/WGSX998hZ9M delete and truncate : https://youtu.be/u76wMm2byXo %type and %rowtype : https://youtu.be/MlLUFeZ_3eM
Views: 12782 Kishan Mashru
Oracle SQL DDL Commands
 
14:31
Oracle SQL: 1. CREATE TABLE 2. ALTER TABLE ( ADD COLUMN, DROP COLUMN ) 3. ALTER TABLE TO MODIFY DATATYPE 4. TRUNCATE TABLE 5. RENAME COLUMN 6. RENAME TABLE 7. DROP TABLE
Views: 68 Ujjal Das
Call Oracle Procedure in informatica
 
03:21
Execute Stored Procedure in Informatica Pre SQL/Post SQL When you may want to execute a stored procedure in pre sql of a session. For example: In my case, I wanted to truncate a table before loading data into it each time I run the workflow/mapping/session. I know you can truncate a table by selecting an option inside a session task(Target properties), but I was not able to do that because of limited privileges. The connection was not allowing me truncating a table. To resolve it, I got to call a stored procedure, which is written to truncate the related table. Now my job was to execute the stored procedure each time the session is run. Follow the steps given in video : https://youtu.be/Gnpt3-i_fJU to learn Execute Stored Procedure in Informatica Pre SQL
Views: 3830 InformaticaTutorial
PL/SQL Tutorial : Using RETURNING  INTO Clause  in FORALL
 
04:11
PL/SQL Tutorial : Using RETURNING INTO Clause in FORALL RETURNING INTO Clause with FORALL & BULK COLLECT SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 517 TechLake
What is a Partition in Oracle and Type of Partitions , Range Partition
 
10:52
What is Partition in Oracle and Type of Partitions Range Partition SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 2562 TechLake
PostgreSQL Hstore Basics
 
01:01
With hstore you can add schema-less data to PostgreSQL. This allows you to store model attributes without creating separate database columns. We will see how to query an hstore column by using hstore operators and functions. In this episode, watch how to do this in Rails 5.1. For the entire video, check out: https://rubyplus.com/episodes/611-PostgreSQL-Hstore-Basics
Views: 81 Bala Paranj
Database Basic Delete Data in Table Using UserInterface and Code
 
02:13
This video I'll show you about how to delete data/records in a table using Interface and Code in MS SQL Server Management Studio. This is my first video. Sorry for some mistakes. If you like it. Please subscribe my channel. Thanks. :)
Views: 43 Kode 4Fun
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: 183090 Manish Sharma
Oracle SQL PLSQL 12C Tutorial 7   How to Insert Record or Data in Table
 
04:24
This Video Tutorial Will Describe how to insert values or data into the table in oracle 12C version. This command will also work on other versions of database like Oracle 11g Database, Oracle 10g Database, Oracle 9i Database, Oracle 8i Database, Oracle 8 Database and so on. Whenever you create a new table in oracle, you need to insert some data into that table otherwise that table is not usable. Example to select data, to update data and delete data, you first need to insert some data. Full Syntax will be given in this video tutorial about how to insert records in oracle database table. Along with the live example to insert records. All the keywords, format, mandatory clauses etc are described in this video. In this video, I use the INSERT command to add an entire record into a table. When using the command you must also use the keyword VALUES. If you want to enter a null value (one that has no value) for a field you can use the keyword NULL. Be sure to put single quotes around data types that are not numbers. Values need to be entered in the order the fields appear in the table.
Views: 83 game hounds
GLOBAL TEMPORARY TABLE (GTT) IN ORACLE SQL WITH EXAMPLES
 
13:33
This video demonstrates the usage and working of GTT in oracle SQL. The video shows how internally oracle works with GTT, and also explains the working of ON COMMIT DELETE ROWS and ON COMMIT PRESERVER ROWS in oracle with easy examples.
Views: 9776 Kishan Mashru
Oracle SQL Developer Tutorial For Beginners  86   To Quote or Not To Quote
 
02:30
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 591 Sam Dhanasekaran
SQL Tutorial : Differences between Where and Having clauses in oracle
 
05:32
SQL Tutorial : Differences between Where and Having clauses in oracle SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 1075 TechLake
oracle - create table from another tables
 
04:35
oracle - create table from another tables --script select id, first_name, last_name, address, email, phone, admission_date, login from student -- Now i want to make another tables with same column names as student tables create table student_2 as select * from student where 1 != 1 select id, first_name, last_name, address, email, phone, admission_date, login from student_2 -- now data -- Now create another table with data create table student_with_data as select * from student where 1=1 select * from student_with_data -- that simple
Views: 30 Mr Code
Oracle 11g Online Training: Free Demo on Oracle 11g Training - Oracle 11g Job Oriented Training
 
26:14
Oracle 11g Online Training: Free Demo on Oracle 11g Training - Oracle 11g Job Oriented Training Subscribe to OPTGHAR Online IT Training and Placements at: https://www.youtube.com/channel/UCBGjmPr7EXF0GZmhw4isicA?sub_confirmation=1 Watch more demo videos at: https://www.youtube.com/channel/UCBGjmPr7EXF0GZmhw4isicA Apply for Oracle 11g DBA online training at: http://www.optghar.com/it-training-courses/oracle-11g-online-training-placement-opt-cpt-students/43/20 For more information contact OPTGHAR.com at: 844-678-4427 (844-OPTGHAR) | [email protected] | http://www.optghar.com Oracle 11g – SQL & PL/SQL The Oracle database environment 1.Reviewing basic architecture concepts 2.Oracle 10g Architecture 3.Main features of 9i and 10g Basic SQL*PLUS commands 1.Using script files, START, @, GET, SAVE, LIST, PROMPT, PAUSE, ACCEPT, DEFINE, SPOOL Basic SELECT Statement 1.Writing the statement in sql plus, Running the SELECT statement Ordering the output 1.Single Column, Descending order, multiple column sorts Conditional retrieval of data 1.Working with complex conditions, AND OR NOT LIKE BETWEEN Working with variables 1.Creating and using variables, Command substitution Pseudo columns and functions 1.Pseudo Columns, Row num, Sys date, User & UID, the Dual Table 2.Working with character functions 3.UPPER, LOWER, INITCAP, RPAD(), RTRIM(), SUBSTR(), INSTR(), 4.TRANSLATE(), REPLACE(), GREATEST(), LEAST(), DECODE 5.Working with date functions 6.TO_CHAR(), TO_DATE(), MONTHS_BETWEEN(), ADD_MONTHS(), LAST_DAY(), NEXT_DAY() Using non-character function 1.ROUND (), TRUNC (), SIGN (), Working with multiple tables, Different type of Joins, Writing Outer Joins Using the SET operators 1.Union, Intersect, minus Aggregating data using group functions 1.GROUP BY, HAVING Creating Sub queries 1.Single Row sub queries, Multiple row Sub queries Enhancing groups function 1.ROLLUP, CUBE Transaction Control Language 1.Rollback, Commit, save point Processing hierarchies 1.creating the Tree structure, LEVEL, CONNECT BY Data Manipulation Language 1.INSERT, UPDATE, DELETE Data Definition Language 1.CREATE, TRUNCATE, ALTER, DROP, RENAME, DESCRIBE Using Declarative Constraints 1.Views, Sequences, Synonyms, Indexes, USER_TABLES, USER_TAB_COLUMNS, USER_OBJECTS, USER_IND_COLUMNS, USER_UPDATEABLE_COLUMNS, Materialized Views, Other Data dictionary views Database Security 1.Object Privileges, Granting access to objects Improving query performance 1.Planning and managing the tuning process, Employing tuning tools, Running EXPLAIN PLAN and auto trace, SQL Trace and TKPROF output, Optimizer concepts, Fundamentals of access paths, Gathering object and system statistics with DBMS_STATS, Utilizing hints and optimizer mode, Specifying first-rows optimization, Determining the driving table Other Concepts 1.The Relational Database Model, The system Development Lifecycle, Overview of normalization PL/SQL Blocks 1.Structure, Writing Anonymous Blocks Variables 1.Oracle Data types, TYPE and ROWTYPE declarations, Value assignments Control structures 1.IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement, 2.LOOP END , LOOP statement, WHILE condition, FOR condition Cursors 1.Implicit and Explicit Cursors, Cursor Manipulation statements, 2.OPEN FETCH CLOSE EXIT WHEN Printing Values to Screen Procedures 1.Creating and Calling Procedures Functions 1.Creating and Calling Functions Packages 1.Package Header, Package Body Design Tips and Techniques 1.Format of standard packages in an application, Spec and Body, NOCOPY hint Triggers 1.Database triggers, calling procedures from triggers Dynamic SQL 1.EXECUTE IMMEDIATE, DBMS_SQL package Oracle Supplied packages 1.DBMS_OUTPUT, UTL_FILE Collection data types 1.Associative Arrays, Nested tables, VARRAYs Oracle 11g Online Training: Free Demo on Oracle 11g Training - Oracle 11g Job Oriented Training Subscribe to OPTGHAR Online IT Training and Placements at: https://www.youtube.com/channel/UCBGjmPr7EXF0GZmhw4isicA?sub_confirmation=1 Watch more demo videos at: https://www.youtube.com/channel/UCBGjmPr7EXF0GZmhw4isicA Apply for Oracle 11g DBA online training at: http://www.optghar.com/it-training-courses/oracle-11g-online-training-placement-opt-cpt-students/43/20 For more information contact OPTGHAR.com at: 844-678-4427 (844-OPTGHAR) | [email protected] | http://www.optghar.com
Learn Oracle | What is RDBMS
 
03:00
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: 398 Pebbles Tutorials
Introduction to SQL DDL Commands 2
 
11:41
This video will introduce you to DDL Command supported by Oracle with syntax and examples
Views: 282 Venkat C
UNION AND UNION ALL SET OPERATOR IN ORACLE SQL WITH EXAMPLE
 
03:50
This video is to understand the difference between union and union all set operations. Along with that we have also showed some simple solution to the 'ORA-01789: query block has incorrect number of result columns' error message. If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below : char and varchar2 : https://youtu.be/039qzwjWf4k replace and translate : https://youtu.be/HKYF77BGzOE procedure and function : https://youtu.be/q3LmOenL120 in and exists : https://youtu.be/REX4IjRYlFw rank and dense_rank : https://youtu.be/WGSX998hZ9M delete and truncate : https://youtu.be/u76wMm2byXo %type and %rowtype : https://youtu.be/MlLUFeZ_3eM
Views: 722 Kishan Mashru
SQL complex Query for Experienced and Fresher
 
29:05
Any query plz mail to : [email protected] Please read it and learn it below is sql interview question and answer for you. 1. What is SQL 2. what is DBMS 3.What is database 4.What is table 5.What is a join 6. Explain types of join 7.What is primary key 8.What is unique key 9.What is foreign key? 10.What is a view 11.What is Cursor 12. What is subquery in sql 13.Types of subquery 14.What is a constraint 15.What are types of constraint 16. If we create primary key, which index will be created? 17.What is Self-Join? 18.What is cross join? 19.What is an ALIAS command? 20.What is the difference between TRUNCATE and DROP statements? 21.What is the difference between TRUNCATE and delete statements? 22.Operator is used in query for pattern matching ? 23.How we can find EVEN NUMBER records from a table ? 24.How we can find ODD NUMBER records from a table ? 26.Select FIRST 20 records from a table. ? 27. Select LAST 20 records from a table. ? 25. How to get 6 Min salaries ? 26. How to get 6 Max salaries ? 27. Can you write return keyword in procedure? 31.Can you write function inside function? 32.What is types of partition? 32.where to use bitmap/B* tree index 33.What are the different type of indexes? 34.What are the difference type of parameters in a procedure? 35.What is RegExp_count? 35.What is Merge statement ? 36.Can we truncate GTT ? 37.What is trigger ? 38.Functions ? 39.What is Cursor ? 39.What is EXECUTE IMMEDIATE Statements ? 40.What is Cluster index ? 41.What is External table ? 42.What is Invisible index ? 43.What is NVL Function? 44.Type of locks? 45.What is use of trigger.? 46.Which two virtual Column available at the time of trigger execution.? 47.Differentiate between Syntax and runtime errors.? 48.How many triggers can be applied on one table.? 49.What is the importance of SQLCODE and SQLERRM? 50. Please try below qu
Views: 218 Benchpe Fun
Oracle DML Commands and DDL Commands 2
 
19:55
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS , ADF, INFORMATICA, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
All About Binds
 
06:16
TO USE OR PRINT this presentation click : http://videosliders.com/r/184 ============================================================== All About Binds Thomas Kyte ,It’s All About Binds ,Agenda Performance Is it just about sharing SQL (or is this really a parsing talk in disguise) Scalability Security Do I always want to bind? What is bind variable peeking? Is it good or evil in disguise or a bit of both? I’m binding, but it isn’t sharing – what’s up with that? So the developers don't bind is cursor_sharing = force/similar appropriate system wide? What is the real difference between cursor_sharing = force/similar and which should we use under what circumstances? ,Performance What is involved in all Parses The “conventional” parse - syntax Semantic check What about a hard parse Optimization (can you spell C.P.U…) Row Source Generation And then we can finally execute it Soft Parse is lighter weight But it is called a “shared” pool, not “your” pool Shared data structures have to be protected Optimization can be avoided Row Source Generation can be avoided Bind01.sql ,Performance Wonder if it might affect memory utilization? Strange that count(*) is so low for that first query isn’t it. Unfortunate that sum(sharable_mem) is so high (and remember, it really is 10 times that amount) Bind02.sql ,Scalability But it runs fast enough and I’ll buy more memory Does it really? Run bind03.sql [email protected]> select 11/10000 from dual; 11/10000 ---------- .0011 ,Latch Algorithm Loop for I in 1 .. 1 loop try to get latch if got latch, return if I = 1 then misses=misses+1 end loop INCREMENT WAIT COUNT sleep Add WAIT TIME End loop; ,More multi-user USERS NOBIND_CPU PARSE_MANY_CPU PARSE_ONCE_CPU ------- ---------- -------------- -------------- 1.00 .27 .07 .03 2.00 .72 .21 .09 3.00 1.46 .38 .13 4.00 2.59 .67 .27 5.00 3.20 .85 .34 6.00 4.20 1.01 .40 7.00 4.79 1.20 .51 8.00 5.74 1.44 .53 9.00 6.27 1.60 .64 10.00 7.16 1.76 .72 ,Security Google sql injection Funny thing happened during my last column create or replace procedure set_udump (p_udump in varchar2) as begin execute immediate 'alter system set user_dump_dest = '''||p_udump||''' scope=memory'; end; / ,Security Google sql injection Funny thing happened during my last column create or replace procedure set_udump (p_udump in varchar2) as begin execute immediate 'alter system set user_dump_dest = '''||p_udump||''' scope=memory'; end; / begin set_udump('C:\ORA4\admin\ora4\udump2'' scope=memory utl_file_dir=''*'' scope=spfile user_dump_dest=''C:\ORA4\admin\ora4\udump2'); end; ,Security Google sql injection Funny thing happened during my last column create or replace procedure set_udump (p_udump in varchar2) as begin if ( p_udump NOT LIKE '%=%' ) then execute immediate 'alter system set user_dump_dest = '''||p_udump||''' scope=memory'; else raise_application_error(-20000,'Sorry, but for safety reasons this procedure does not allow "=" in the parameter value'); end if; end; ,Do I always want to bind? Always say “Never say Never” Never say “Always” You do not want to Over Bind Always Bind Why…. ,Do I always want to bind? Over Binding Compulsive disorder to eradicate all literals in SQL Brought on by taking good advice to an illogical extreme Do we need to bind those? Might it be a bad thing to bind those? Begin for x in ( select object_name from user_objects where object_type in ( ‘TABLE’, ‘INDEX’ )) loop … ,Do I always want to bind? Always Binding Data warehouse – no way. When you run queries per second, yes. When you run queries that take seconds, maybe, maybe no. Conside
Views: 64 slide show me
SQL Tutorials 1 - Types of SQL Commands: DDL , DML
 
02:06
sql ddl sql ddl commands sql ddl dml sql ddl statements sql ddl vs dml sql ddladmin sql ddl example sql ddl trigger sql ddl create table sql ddl script sql ddl file sql ddl dml dcl sql ddl and dml sql ddl admin sql ddl and dml commands with examples sql ddl and dml w3schools sql ddl and dml statements sql ddl access sql ddl and dml queries pdf sql ddl and dml commands syntax sql ddl add column sql ddl and dcl sql and ddl sql and ddl commands what is a sql ddl script sql ddl boolean sql ddl befehle sql basics ddl dml sql basics ddl sql server ddl backup sql difference between ddl and dml sql server backup ddl only sql server bcp ddl basic sql ddl commands sql server difference between ddl and dml sql ddl changes sql ddl commands syntax sql ddl code sql ddl commands pdf sql ddl constraints sql ddl check sql ddl create view sql ddl commands tutorial sql ddl date sql ddl dml dcl tcl commands with examples sql ddl default value sql ddl definition sql ddl data types sql ddl dml dql sql ddl dml dql dcl sql ddl dml and dcl commands t sql ddl t sql ddl vs dml t-sql ddl trigger t-sql ddl statements t-sql ddl commands t-sql ddl transaction t sql ddl dml t-sql ddl primary key t sql ddl add column t-sql ddl in stored procedure sql ddl exercises sql ddl events ddl enable.sql sql ddl editor ddl sql execution error sql export ddl ddl sql execution error moodle sql extract ddl sql explain ddl dml e ddl sql comandos dml e ddl sql sql ddl foreign key example sql ddl format sql ddl foreign key sql ddl functions sql ddl formatter sql ddl file example sql ddl float ddl sql full form select ddl from oracle sql ddl generator sql ddl grant sql get ddl sql get ddl table sql developer ddl generation sql server ddl generator java sql ddl generator sql developer ddl grants select get ddl sql developer generate ddl for schema sql server ddl history hive sql ddl sql server ddl change history h2 sql ddl ddl sql view sap hana ms sql cdc.ddl_history sql ddl index sql ddl interview questions sql ddl insert sql ddl in transaction sql ddl in dbms sql is ddl or dml sql in ddl sql injection ddl sql server ddl in transaction pl sql ddl in procedure jquery ddl selected sql ddl parser java sql ddl to json java sql ddl java sql ddl statement java sql ddl 実行 sql ddl keywords sql ddl komutları kill bill ddl.sql sql ddl primary key sql ddl composite primary key sql server foreign key ddl sql ddl create table foreign key sql ddl language sql ddl log sql ddl list sql last ddl time sql language ddl dml dcl sql language ddl dml select ddl_lock_timeout sql server ddl log mysql ddl log sql ddl_database_level_events pl sql ddl pl sql ddl dml pl sql ddl commands pl/sql ddl trigger oracle pl/sql ddl execute immediate oracle pl sql ddl statements oracle 11g pl/sql ddl oracle pl sql ddl triggers ddl commands in pl sql block pl sql developer generate ddl sql ddl mysql sql dml ddl sql ddl means sql ddl modify sql ddl many to many teradata sql ddl manual ddl sql server management studio sql server mirroring ddl mysql ddl ms sql ddl commands mysql ddl and dml mysql ddl syntax ddl commands in mysql mysql table ddl ddl mysql workbench sql ddl not null sql ddl number sql ddl numeric sql ddl nedir sql ddl naredbe sql server ddl not null sql-ddl-sync npm extract ddl sql navigator sql ddl statement is not allowed sql server ddl trigger not firing sql ddl operation sql ddl oracle sql ddl online sql ddl on delete cascade select ddl or dml select ddl oracle jquery ddl selected option select ddl of table sql truncate ddl or dml sql server ddl operations types of sql ddl dml dcl elements of sql ddl dml example of sql ddl o que é ddl sql sql ddl permissions sql ddl ppt sql ddl pdf sql ddl parser sql ddl purge sql ddl practice ddl for sql profile sql server ddl permissions pl sql export ddl pl sql last_ddl_time pl/sql generate ddl pl sql developer ddl sql ddl query sql ddl queries examples sql ddl quiz sql ddl questions sql queries ddl commands sql server ddl query what is ddl dml and dql in sql select query ddl select query ddl or dml sql ddl rollback sql ddl rename column sql ddl rights sql ddl reference sql ddl relationship sql ddl rename sql replication ddl sql replication ddl changes role ddl.sql sql server ddl rollback sql ddl statements w3schools sql ddl syntax sql ddl statements examples sql ddl script example sql ddl stands for sql ddl standard sql ddl statements tutorial sql ddl sample sql ddl statements example sql ddl transaction sql ddl tutorial sql ddl trigger example sql ddl table sql ddl tutorial pdf sql ddl truncate sql ddl types sql ddl trigger events t-sql ddladmin sql ddl unique sql ddl update sql ddl update script sql ddl utasítások sql ddl to uml sql developer user ddl sql commands under ddl sql statement using ddl sql developer extract user ddl sql developer create user ddl sql ddl view sql ddl varchar select ddl value jquery select ddl value in c# oracle sql ddl vs dml sql server ddl view ddl vs sql v generate schema ddl.sql
Views: 1916 T3SO Tutorials