Home
Search results “Col size oracle”
Finding Database Columns By Name in Oracle SQL Developer
 
05:11
How to find all columns in your Oracle Database by searching on the name.
Views: 7339 Jeff Smith
SQL tutorial 23: Rename and Modify Column Using Alter Table By Manish Sharma (RebellionRider)
 
04:36
How to Rename a column of a table using alter table and How to modify a column of a table using alter table Modify means How to change datatype of a column and how to change size/width of a column Web Article link http://bit.ly/sql-tutorial23 Tutorial 21 How to rename a table : http://bit.ly/sql-tutorial-21 Tutorial 22 How to add/ delete column: http://bit.ly/sql-tutorial-22 YouTube Video on How to create database http://bit.ly/create-database-using-DBCA Tool used in this tutorial is SQL Developer. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 47372 Manish Sharma
SQLPLUS: LineSize & PageSize
 
03:49
In this tutorial, you'll learn how to set linesize and pagesize . PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 19996 radhikaravikumar
Oracle: How-to: Change the PAGESIZE and LINESIZE in SQL*Plus
 
02:09
The Best Site to Learn SQL Online
Views: 20259 TechnicalSkills
06 of  13 - Oracle APEX 5 - Define UI (user interface) defaults; modify a navigation menu item
 
12:04
A new series using APEX 18.1 is now available. https://youtu.be/9_2Hxi7rANw This is one in a series of videos about creating an application using Oracle APEX 5. In this video we look at the user interface (UI) defaults for columns in tables and how to change these. Changing UI defaults to user-friendly text will help make APEX-generated reports and forms easier to read and use. We also look at how to change a navigation menu item so that it opens a different report page. This edit is done in the Shared Components section of APEX. SQL scripts for this series are available to download at: http://db.kreie.net
Views: 45158 Jennifer Kreie
JTable - Calculate JTable Column Values in Java Swing/AWT/SWT
 
02:44
Get Source Code/Read : http://intactabode.com/ For Developing support email your Details at : [email protected] Install Free Trail GST Ready Accounting Package Send your Contact information Name, Email, Contact Number to watch demo in English : https://www.youtube.com/watch?v=a4sFNtZuYzs&ab_channel=IntactAbode watch demo in Hindi : https://www.youtube.com/watch?v=I3eCieDpG3o&ab_channel=IntactAbode For Source Code Visit : http://corneey.com/wJ6X2K Subscribe to YouTube channel http://corneey.com/wJ6VoC Like us on Facebook http://corneey.com/wJ6C2l Follow us on Twitter http://corneey.com/wJ6C7x Follow me on Google+ http://corneey.com/wJ6Vhc linkedin http://corneey.com/wJ6V5g Watch More Java Swing(Windows Builder) GUI Tips ans FAQS Here: https://www.youtube.com/playlist?list=PLErD1cRL87W-NzXGuV1tAGO8kf2zrqU0k So in this video i show how to calculate or sum the jtable column values and make total and display in your JLabel, __________________________________________________________________ Also Watch More Java Swing Tutorials How to Display Time and Date In java Swing https://youtu.be/i-M08_hATzM How to Set Password Limit Attempts in Java Swing https://youtu.be/6SxzUHHRnsA How to Print JTable Without any Jar in Java Swing https://youtu.be/0Z9IfjIAMo8 How to Increase Font Size in Eclipse IDE https://youtu.be/dcevO7XNjB8 How to Generate Random Numbers in Java Swng https://youtu.be/qvaXkqt9OSU How to Fetch Database Selected Row in JTextField Java Swing https://youtu.be/xm1ovgF9FNA How to Fetch Database Selected Row in JTextField Java Swing https://youtu.be/1QiWXpqT28s How to Fetch Database Column in JComboBox Java Swing https://youtu.be/V_KkRr0DJ4c Java swing close window on button Clicked https://youtu.be/mblB8eG2mjA How to Display Selected Database Columns in JTable in Java Swing https://youtu.be/oz4iD_lidHg How to Delete Row From JTable in Java Swing https://youtu.be/accjKR4fxUM How to Convert String to Integer and Vice Versa https://youtu.be/MsfpBRZbkxA How to Close Current Frame When Clicked on Exit Java Swing https://youtu.be/PLrnvBIO-lA How to Calculate JTable Column Values in Java Swing https://youtu.be/zu57Gdg5TDY How to Add JTextField Values in Jtable DefaultTableModel in Java Swing https://youtu.be/Wl5guY77TUc How to Add Image to JButton in Java Swing https://youtu.be/jGYqtIWn5OY How to Print Jtable Data in Java Swing https://youtu.be/zaMhFY1-0eI How to Add or Remove Values in Database in Java Swing https://youtu.be/ARQ0UHukZzI How to Generate Random Numbers in Java https://youtu.be/p0psde93IBg How to Show Selected Colomn in JLable From Database in Java https://youtu.be/ydjouDv8tzQ How to Display Message in JLable in Java Swing https://youtu.be/L8xs35wX1QY Validations for JTextField in Java Swing Application https://youtu.be/MxEvihnQOD0 How to Open Two JFrames on One Button Click in Java https://youtu.be/zW9jn8e2lnc
Views: 11462 Intact Abode
MySQL - Increase Column Size
 
01:13
Install Free Trail GST Ready Accounting Package Send your Contact information Name, Email, Contact Number to watch demo in English : https://www.youtube.com/watch?v=a4sFNtZuYzs&ab_channel=IntactAbode watch demo in Hindi : https://www.youtube.com/watch?v=I3eCieDpG3o&ab_channel=IntactAbode For Source Code Visit : http://corneey.com/wJ6X2K Subscribe to YouTube channel http://corneey.com/wJ6VoC Like us on Facebook http://corneey.com/wJ6C2l Follow us on Twitter http://corneey.com/wJ6C7x Follow me on Google+ http://corneey.com/wJ6Vhc linkedin http://corneey.com/wJ6V5g How to increase the size of the current column size in sql
Views: 686 Intact Abode
Primavera P6: Format Columns
 
08:52
Bill Pepoon, Managing Partner of Construction Science, demonstrates how to format columns in the Activity Table.
Views: 11679 Bill Pepoon
Oracle Sqlplus - Set Linesize
 
02:58
How to Set Linesize On Oracle Sqlplus
Views: 340 Rizki I
Tablespaces in oracle database
 
08:27
This video will give you basic idea about tablespace issue. Plese find the following important query . Query to check tablespace usage ============================================== select a.TABLESPACE_NAME, a.BYTES bytes_used, b.BYTES bytes_free, b.largest, round(((a.BYTES-b.BYTES)/a.BYTES)*100,2) percent_used from ( select TABLESPACE_NAME, sum(BYTES) BYTES from dba_data_files group by TABLESPACE_NAME ) a, ( select TABLESPACE_NAME, sum(BYTES) BYTES , max(BYTES) largest from dba_free_space group by TABLESPACE_NAME ) b where a.TABLESPACE_NAME=b.TABLESPACE_NAME order by ((a.BYTES-b.BYTES)/a.BYTES) desc; To check datafiles respective to tablespace_name. ======================================================== col tablespace_name format a30; col file_name format a40; SELECT TABLESPACE_NAME, FILE_NAME, BYTES/1024/1024 FROM DBA_DATA_FILES where TABLESPACE_NAME='&tablespace_name'; To check ASM disk group usage ======================================== select name, group_number, name, type, state, total_mb, free_mb from v$asm_diskgroup; Please comment , like, subscribe and reach me if you have any query. EmailId: [email protected] ================================================ Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected]
Views: 1046 ANKUSH THAVALI
Get Table Names with Column Names and Data Types in SQL Server - SQL Server Tutorial
 
05:47
In this video ,we will generate the script that will return us all the table names with column names and data type of those columns. We often need this information. Let's say we are going to prepare mapping document for load the data from Source Database to Destination database. We can get the list of all tables with column names and data types from Source Database and Destination Database and then paste in Excel and map the required input columns to output columns for ETL Process. Blog link with scripts used in video http://sqlage.blogspot.com/2015/02/get-all-tables-with-column-names-and.html
Views: 51617 TechBrothersIT
TABLESPACE MANAGEMENT DATAFILE SIZE ENABLE DISABLE AUTOEXTEND ON
 
02:50
HOW TO ENABLE/DISABLE AUTOEXTEND ON FOR A DATAFILE ================================================== alter database datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\GOODKING01.DBF' autoextend on; HOW TO FIND THE SIZE OF A DATAFILE ================================== SELECT SUBSTR (df.NAME, 1, 50) file_name, df.bytes / 1024 / 1024 allocated_mb, ((df.bytes / 1024 / 1024) - NVL (SUM (dfs.bytes) / 1024 / 1024, 0)) used_mb, NVL (SUM (dfs.bytes) / 1024 / 1024, 0) free_space_mb FROM v$datafile df, dba_free_space dfs WHERE df.file# = dfs.file_id(+) GROUP BY dfs.file_id, df.NAME, df.file#, df.bytes ORDER BY file_name; set lines 180 pages 200 col tablespace_name for a20 col file_name for a55 select tablespace_name,file_name,autoextensible from dba_data_files;
Views: 1326 Praveen Biyyapu
64. CHANGE COLUMN name and its Data Type with constraint in SQL (Hindi)
 
06:53
Please Subscribe Channel Like, Share and Comment Visit : www.geekyshows.com
Views: 9364 Geeky Shows
Formatting Columns Using Oracle BI EE
 
05:29
This video teaches you how to format columns in an analysis. You add color, add currency, override the data format, and add conditional formatting. To find out more about Oracle BI EE, see the documentation at https://docs.oracle.com/en/middleware Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Converting A Single Comma Separated Row Into Multiple Rows
 
07:30
Check out my Blog: http://exceltraining101.blogspot.com This video shows how to convert comma separated row records into multiple rows. There are two examples: (1) A simple solution using paste special transpose and (2) using Power Query to unpivot the comma separated values. The second example would be used in situations where the records could be in the thousands or even millions of records. P.S. Feel free to provide a comment or share it with a friend! #exceltips #exceltipsandtricks #exceltutorial #doughexcel --------------------- Excel Training: https://www.exceltraining101.com/p/training.html Excel Books: https://www.amazon.com/shop/dough
Views: 22526 Doug H
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: 49053 Jeff Smith
Assign custom width to Divi columns
 
00:49
This video explains how to assign custom width in various column strcutures of Divi theme
Views: 4609 Elegant Enthusiast
SQL tutorial 22: How to Add / Delete column from an existing table using alter table
 
03:56
How to add column to an existing table using Alter table How to delete a column from a table using alter table Links Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Blog Link: http://bit.ly/add-column SQL tutorial 21 rename table using alter table http://bit.ly/rename-table Tool used in this tutorial is SQL Developer. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 42458 Manish Sharma
33 - ( CSS3 Tutorial ) Multi-Columns : Column Span , Column Width
 
03:23
شرح الخصائص column-span column-width
Question (Sum of Amount in Interactive Grid in Oracle Apex)
 
01:03
I have calculate the sum of amount, however when I am going to edit this sum of amount it will blank the whole Interactive Grid.
Views: 159 Omar Baig
How to Display Selected Database Columns in JTable in Java Swing
 
03:27
Get Source Code/Read : http://intactabode.com/ For Developing support email your Details at : [email protected] Install Free Trail GST Ready Accounting Package Send your Contact information Name, Email, Contact Number to watch demo in English : https://www.youtube.com/watch?v=a4sFNtZuYzs&ab_channel=IntactAbode watch demo in Hindi : https://www.youtube.com/watch?v=I3eCieDpG3o&ab_channel=IntactAbode For Source Code Visit : http://corneey.com/wJ6X2K Subscribe to YouTube channel http://corneey.com/wJ6VoC Like us on Facebook http://corneey.com/wJ6C2l Follow us on Twitter http://corneey.com/wJ6C7x Follow me on Google+ http://corneey.com/wJ6Vhc linkedin http://corneey.com/wJ6V5g Watch More Java Swing(Windows Builder) GUI Tips ans FAQS Here: https://www.youtube.com/playlist?list=PLErD1cRL87W-NzXGuV1tAGO8kf2zrqU0k IN this video i shown How to Display Selected Column in JTable in Java Swing, How to fetch the data and add display them in your prefered jtable __________________________________________________________________ Also Watch More Java Swing Tutorials How to Display Time and Date In java Swing https://youtu.be/i-M08_hATzM How to Set Password Limit Attempts in Java Swing https://youtu.be/6SxzUHHRnsA How to Print JTable Without any Jar in Java Swing https://youtu.be/0Z9IfjIAMo8 How to Increase Font Size in Eclipse IDE https://youtu.be/dcevO7XNjB8 How to Generate Random Numbers in Java Swng https://youtu.be/qvaXkqt9OSU How to Fetch Database Selected Row in JTextField Java Swing https://youtu.be/xm1ovgF9FNA How to Fetch Database Selected Row in JTextField Java Swing https://youtu.be/1QiWXpqT28s How to Fetch Database Column in JComboBox Java Swing https://youtu.be/V_KkRr0DJ4c Java swing close window on button Clicked https://youtu.be/mblB8eG2mjA How to Display Selected Database Columns in JTable in Java Swing https://youtu.be/oz4iD_lidHg How to Delete Row From JTable in Java Swing https://youtu.be/accjKR4fxUM How to Convert String to Integer and Vice Versa https://youtu.be/MsfpBRZbkxA How to Close Current Frame When Clicked on Exit Java Swing https://youtu.be/PLrnvBIO-lA How to Calculate JTable Column Values in Java Swing https://youtu.be/zu57Gdg5TDY How to Add JTextField Values in Jtable DefaultTableModel in Java Swing https://youtu.be/Wl5guY77TUc How to Add Image to JButton in Java Swing https://youtu.be/jGYqtIWn5OY How to Print Jtable Data in Java Swing https://youtu.be/zaMhFY1-0eI How to Add or Remove Values in Database in Java Swing https://youtu.be/ARQ0UHukZzI How to Generate Random Numbers in Java https://youtu.be/p0psde93IBg How to Show Selected Colomn in JLable From Database in Java https://youtu.be/ydjouDv8tzQ How to Display Message in JLable in Java Swing https://youtu.be/L8xs35wX1QY Validations for JTextField in Java Swing Application https://youtu.be/MxEvihnQOD0 How to Open Two JFrames on One Button Click in Java https://youtu.be/zW9jn8e2lnc
Views: 16952 Intact Abode
Tom Clancy's Ghost Recon Breakpoint: World Premiere Livestream | Ubisoft [NA]
 
01:18:32
Watch the World Premiere of Tom Clancy's Ghost Recon Breakpoint and learn what it takes to be an elite spec ops soldier. Pre-order Ghost Recon Breakpoint now for guaranteed access to the Beta! #GhostRecon #Breakpoint Please SUBSCRIBE: http://bit.ly/UbisoftYouTubeChannel Visit our official channels for exclusive intel on Ghost Recon Wildlands: http://www.ghostrecon.com http://www.facebook.com/ghostrecon.usa https://instagram.com/ghostrecon_us/ http://www.twitter.com/ghostrecon http://www.youtube.com/Ubisoftna Tom Clancy’s Ghost® Recon Breakpoint is a military shooter set in a diverse, hostile, and mysterious open world that you can play entirely solo or in four-player co-op. Injured, without support, and hunted down by ex-Ghosts, you must fight to survive while lost in Auroa. Choose the right alliances and decide how to take down your toughest enemy. KEY FEATURES DISCOVER A MYSTERIOUS AND DIVERSE ARCHIPELAGO Explore Auroa, home of the Silicon Valley giant Skell Technology, both on- and off-road, in the air, on land, and at sea. Immerse yourself in a mysterious place where the most architecturally advanced buildings meet the wildest and most untamed nature. From the highest fjords and snowy peaks to the deepest swamps, meet different factions – from Skellers to Homesteaders to Outcasts – that will impact your mission. What happened to Jace Skell? Who is pulling the strings? Find the truth and clear the plot! TAKE DOWN YOUR EX-BROTHER-IN-ARMS Face your toughest enemies, the Wolves, a lethal ex–US military unit gone rogue, ready to use the most effective killing machines to take you down. The Wolves used to be you. They have the same training and experience as you have. They have seized the archipelago of Auroa, taking control of the most important resources of the island: the drones. And they are led by your ex-brother-in-arms, Colonel Cole D. Walker, so you will have no choice but to confront your former teammate. LIVE THE LIFE OF A TRUE GHOST STRANDED BEHIND ENEMY LINES Test your survival skills and adapt to the varied terrains of Auroa. Steep slopes, accumulating injuries, and fatigue are the new challenges for you to tackle. Set up a camp with your teammates, manage your equipment, class, and weapons in your bivouac, and fine-tune your strategies. If you’re wounded in battle, you’ll have to crawl to the safety of cover to heal yourself, or if a teammate goes down, you’ll need to pick them up and carry them to a safe place before treating their injuries. Use new tools, like the mini drone, that will allow you to sync shot several targets, even in solo. CUSTOMIZE YOUR GHOST AND EXPERIENCE FULL FREEDOM OF APPROACH Create your character and choose among thousands of customization combinations to create your perfect Ghost. Loot materials from the world, craft and upgrade your weapons with multiple attachment possibilities, and customize your gear in order to adapt your Ghost to any situation and to fit your playstyle. Experiment with a brand new class system to give you more chances to defeat your enemies. Do you want to play assault? You can go berserk. Do you want to play sniper? You can get special ammunition that gives you more range and accuracy. You can also play stealthy with the Panther class, and use a smoke bomb to get away from your enemies. Tom Clancy's Ghost Recon Breakpoint is all about your choice, your way to have fun. ENJOY A TRUE SOCIAL EXPERIENCE WITH NEW SHARED PROGRESSION AND BEST-IN-CLASS ENDGAME CONTENT However you decide to play, in Tom Clancy’s Ghost Recon Breakpoint, you will always keep the same character: the same customization, the same skills, and the same weapons. You keep and improve your progression across both our PvE and PvP experiences. Tom Clancy’s Ghost Recon Breakpoint is also a truly social experience. Find your friends in the new Social HUB, play the campaign together, or enter a PvP arena to take on an intense 4v4 match. The adventure does not stop there! The game will be regularly updated and supported years after launch. New story arcs will keep expanding the story, new features will be continuously added, and new classes and gameplay possibilities will available to players, as well as events and a brand-new type of endgame content: Raids. Tom Clancy's Ghost Recon Breakpoint: World Premiere Livestream | Ubisoft [NA] https://www.YouTube.com/UbisoftNA
Views: 249042 Ubisoft North America
add new column in oracle forms 10g | Ten Minute Code
 
06:33
add new column in oracle forms builder 10g 1. Create table CREATE TABLE add_column (id NUMBER, Name VARCHAR2(20)); 2. Create forms 3. Add new column sql*plus ALTER TABLE add_column ADD gender VARCHAR2(10); 4. Go to form 5. Go to data block wizard table refreshapply 6. Frame select go to Layout wizard data blockapply
Views: 2266 abdulquium
Oracle to Excel - PL/SQL Excel xlsx export API - ORA_EXCEL
 
00:48
If you need to create Excel xlsx document from Oracle database using only PL/SQL http://www.oraexcel.com is solution for you. With ORA_EXCEL you will be able to: * to export SQL query to sheet * to add up to 1.048.576 rows per sheet * to save worksheet to XLSX file * to save worksheet to BLOB * to set font family, size and color * to make text, bold italic and underline * to set sheet paper size * to set left and right text indent * to add unlimited sheets per document * to apply horizontal and vertical text alignment * to set cell background color * to set column width * to set row height * to set custom format to cells * to set borders with colors and styles * to set sheet margins * to set sheet header and footer text * to set cell comment * to merge cells horizontally and vertically * to wrap text within cell * to appy cells filtering * to rotate text * to hide columns and rows * to set column formulas * to set sheet portrait or landscape * to set cell as hyperlink * to create styles with formatting For more details check on http://www.oraexcel.com
Views: 10375 Zoran Marincic
Iron Man 2 (2010) Deleted Scene - Extended New Element Scene
 
04:00
A deleted scene from Iron Man 2 (2010). Tony Stark (re)discovers a new element. Find out more at http://www.marvelfilmguide.com
Views: 5668193 Marvel FilmGuides
Visualforce Training for beginners:Visualforce Component: apex panelGrid column width
 
03:25
Visualforce Training for beginners:Visualforce Component: apex panelGrid column width Visualforce Complete Course: https://courses.mytutorialrack.com/p/visualforce-tutorial-for-beginners/ Checkout my website: http://mytutorialrack.com/ connect me on facebook: https://www.facebook.com/tutorialRack/ Follow me on twitter: https://twitter.com/mytutorialrack Visualforce is markup language that allows to define user interface components in Salesforce. This is very interesting tool which runs on force platform. By using page layouts, we can easily configure User interface. But by using visusalforce pages, you can develop your own customized user interface. What are we going to cover in this course? Visualforce Tags Standard Controllers Associating a Standard Controller with a Visualforce Page What are action methods? Action methods that are supported by all standard controllers Associating a Standard List Controller with a Visualforce Page Accessing Data with List Controllers Standard List Controller Actions Custom Controllers and Controller Extensions Building a Controller Extension Multiple controller extensions Building a Custom List Controller
Views: 1685 MyTutorialRack
how to create database ,table  with primary key and auto increment in phpmyadmin
 
07:37
This video explain how to create database and table and primary and auto increment in phpmyadmin
Views: 62292 expert programming
Setting Properties for a Column Using Oracle BI EE
 
03:36
This video teaches you how to set the properties for columns by using options such as value suppression, currency formatting, and so on. To find out more about Oracle BI EE, see the documentation at https://docs.oracle.com/en/middleware Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
How to Detect Soft Corruption in Oracle 12c Database
 
18:19
Detection of Soft Corruption in 12c: To use the scripts below replace : , ",# and $ by proper bracket Lets Create a tablespace and small table. SQL: create tablespace DEMO1 datafile '/u02/tstdb1/TSTDB1/datafile/demo01.dbf' size 50M SQL: create table objects tablespace DEMO1 as select * from dba_objects; SQL: alter table objects add constraint pk_obj primary key #object_id$; SQL: create index idx_obj_name on objects#object_name$ tablespace demo1; Backup tablespace. RMAN: backup tablespace DEMO1; We need to put the DB in archivelog first Rebuild index with NOLOGGING option to simulate soft corruption later. RMAN: alter index idx_obj_name rebuild nologging; Confirm that we have datafiles that require backup because they have been affected with NOLOGGING operation. RMAN: report unrecoverable; Simulate corruption. RMAN: alter database datafile 5 offline; RMAN: restore datafile 5; RMAN: recover datafile 5; RMAN: alter database datafile 5 online; Query table with corrupted index and notice error. SQL: select count#*$ from objects where object_name like 'A%'; Let’s perform validation of datafile to check block corruption. RMAN: backup validate check logical datafile 5; Notice that we have 457 blocks marked corrupt but v$database_block_corruption view is empty. SQL: select count#*$ from v$database_block_corruption; Let’s query v$nonlogged_block view. set lines 200 set pages 999 select file#, block#, blocks,object#,reason from v$nonlogged_block; Will RMAN detect that we have corrupted blocks? RMAN: backup datafile 5; RMAN backup won’t fail due to NOLOGGING corrupt blocks and our backup will contain soft corrupted blocks. Let’s Identify corrupt segments using v$nonlogged_block view. set lines 2000 set pages 9999 col owner for a20 col partition_name for a10 col segment_name for a20 SELECT e.owner, e.segment_type, e.segment_name, e.partition_name, c.file# , greatest#e.block_id, c.block#$ corr_start_block# , least#e.block_id+e.blocks-1, c.block#+c.blocks-1$ corr_end_block# , least#e.block_id+e.blocks-1, c.block#+c.blocks-1$ - greatest#e.block_id, c.block#$ + 1 blocks_corrupted FROM dba_extents e, V$NONLOGGED_BLOCK c WHERE e.file_id = c.file# AND e.block_id "= c.block# + c.blocks - 1 AND e.block_id + e.blocks - 1 := c.block# UNION SELECT s.owner, s.segment_type, s.segment_name, s.partition_name, c.file# , header_block corr_start_block# , header_block corr_end_block# , 1 blocks_corrupted FROM dba_segments s, V$NONLOGGED_BLOCK c WHERE s.header_file = c.file# AND s.header_block between c.block# and c.block# + c.blocks - 1 UNION SELECT null owner, null segment_type, null segment_name, null partition_name, c.file# , greatest#f.block_id, c.block#$ corr_start_block# , least#f.block_id+f.blocks-1, c.block#+c.blocks-1$ corr_end_block# , least#f.block_id+f.blocks-1, c.block#+c.blocks-1$ - greatest#f.block_id, c.block#$ + 1 blocks_corrupted FROM dba_free_space f, V$NONLOGGED_BLOCK c WHERE f.file_id = c.file# AND f.block_id "= c.block# + c.blocks - 1 AND f.block_id + f.blocks - 1 := c.block# order by file#, corr_start_block# / This is the best outcome to get if you notice corruption errors. All errors are related to index corruption so we could fix this problem rebuilding index. alter index idx_obj_name rebuild; Simply issuing "alter index rebuild" command won't work. We should mark index unusable to drop segment before rebuilding it or just rebuild index with online option. It is better choice to mark index unusable because you don't need additional space then, but I will simply rebuild index with online option and see what will happen. SQL: alter index idx_obj_name rebuild online; Index altered. SQL: select count#*$ from objects where object_name like 'A%'; No errors... but, let's validate datafile for corruption. RMAN: backup validate check logical datafile 5; Notice "Marked Corrupt" column. Hm... 457 like before. Don't worry, this is not new corruption. These are FREE blocks which will be reused and Oracle will automatically re-format those blocks. Query the v$nonlogged_block view again as given above. We could force re-formatting creating dummy table and inserting data to dummy table. Check Doc ID 336133.1. create table s # n number, c varchar2#4000$ $ nologging tablespace DEMO1; SQL: BEGIN FOR i IN 1..1000000 LOOP INSERT /*+ APPEND */ INTO sys.s select i, lpad#'REFORMAT',3092, 'R'$ from dual; commit ; END LOOP; END; / SQL: drop table sys.s purge; Notice that we don't have corrupted blocks any more. RMAN: backup validate check logical datafile 5;
Views: 222 OracleDBA
SQL tutorial 44: How to import data from Microsoft Excel to Oracle Database using SQL Developer
 
08:21
Step by Step Oracle Database/ SQL tutorial on How to import Data from Microsoft excel to the oracle database using SQL Developer. Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Website: www,Rebellionrider.com Create Table using ●SQL Developer & Command Prompt: http://youtu.be/UU0EEfpa-2c ●Enterprise Manager: http://youtu.be/I-LUXP9GmPU ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Connect with me on my LinkedIn and Endorse My Skills and Do you know that I share Tips and tricks On Google+ Account? 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: 65262 Manish Sharma
Oracle APEX -  Interactive Gird with Javascript
 
04:54
Interactive Grid Interface By default, all interactive grids have a search bar, Actions menu, and Reset button. All grids also have Column Heading Menus, which users access by clicking the name or heading of a column. With the Actions and Column Heading menus, users can hide, filter, freeze, highlight, sort, and create control breaks on individual columns. Advanced users can also define aggregations, which appear at the bottom of the column or column group. Users can directly customize the appearance of an interactive grid with the mouse. Users can resize or drag and drop columns into different places in the grid. The width and order of columns can also be configured in the Columns dialog. Users can quickly chart the data with the Chart function. This feature is useful for quick data visualization or even presentation, and responds immediately to changes in the data. Users can quickly revert their modifications with the Reset function, or perform an incremental revert with the Flashback function. In cases of a highly dynamic data set, users can use the Refresh function to pull in the latest version of the data on the database. Editable Interactive Grids Oracle Application Express also contains editable interactive grids, which provide a more robust tool set for directly editing data in the interactive grid.
Views: 1584 Oracle Apex
BI Publisher - How to Use Formula and Custom Column
 
02:43
This 2 minutes demo shows you how to use the formula functionality in the Layout Editor and create a custom column.
Views: 14260 bipublisher
When to Choose Row Vs Column Store in S/4HANA?
 
03:45
FREE!!! Complete End to End Video Courses .. FREE Check Here http://www.sapyard.com/courses/ Channel is extension to our SAP Technical site www.sapyard.com. If you are not sure, which store type to choose, as a thumb rule, go for Row as Row store is less restrictive. When SELECT * is needed, go for Row. If we do SELECT * in Col Store table, then traversing through all the column store individual tiny tables would be exponentially expensive.
Views: 3260 SAP Yard
Tom Clancy’s Ghost Recon Breakpoint: Global Threat Story Trailer | Ubisoft [NA]
 
02:58
As technology races forward and overtakes human capability, what happens when it’s used for the wrong intentions? Ghost Recon Breakpoint. Available October 4. #GhostRecon #Breakpoint Please SUBSCRIBE: http://bit.ly/UbisoftYouTubeChannel Visit our official channels for exclusive intel on Ghost Recon Wildlands: http://www.ghostrecon.com http://www.facebook.com/ghostrecon.usa https://instagram.com/ghostrecon_us/ http://www.twitter.com/ghostrecon http://www.youtube.com/Ubisoftna Tom Clancy’s Ghost® Recon Breakpoint is a military shooter set in a diverse, hostile, and mysterious open world that you can play entirely solo or in four-player co-op. Injured, without support, and hunted down by ex-Ghosts, you must fight to survive while lost in Auroa. Choose the right alliances and decide how to take down your toughest enemy. KEY FEATURES DISCOVER A MYSTERIOUS AND DIVERSE ARCHIPELAGO Explore Auroa, home of the Silicon Valley giant Skell Technology, both on- and off-road, in the air, on land, and at sea. Immerse yourself in a mysterious place where the most architecturally advanced buildings meet the wildest and most untamed nature. From the highest fjords and snowy peaks to the deepest swamps, meet different factions – from Skellers to Homesteaders to Outcasts – that will impact your mission. What happened to Jace Skell? Who is pulling the strings? Find the truth and clear the plot! TAKE DOWN YOUR EX-BROTHER-IN-ARMS Face your toughest enemies, the Wolves, a lethal ex–US military unit gone rogue, ready to use the most effective killing machines to take you down. The Wolves used to be you. They have the same training and experience as you have. They have seized the archipelago of Auroa, taking control of the most important resources of the island: the drones. And they are led by your ex-brother-in-arms, Colonel Cole D. Walker, so you will have no choice but to confront your former teammate. LIVE THE LIFE OF A TRUE GHOST STRANDED BEHIND ENEMY LINES Test your survival skills and adapt to the varied terrains of Auroa. Steep slopes, accumulating injuries, and fatigue are the new challenges for you to tackle. Set up a camp with your teammates, manage your equipment, class, and weapons in your bivouac, and fine-tune your strategies. If you’re wounded in battle, you’ll have to crawl to the safety of cover to heal yourself, or if a teammate goes down, you’ll need to pick them up and carry them to a safe place before treating their injuries. Use new tools, like the mini drone, that will allow you to sync shot several targets, even in solo. CUSTOMIZE YOUR GHOST AND EXPERIENCE FULL FREEDOM OF APPROACH Create your character and choose among thousands of customization combinations to create your perfect Ghost. Loot materials from the world, craft and upgrade your weapons with multiple attachment possibilities, and customize your gear in order to adapt your Ghost to any situation and to fit your playstyle. Experiment with a brand new class system to give you more chances to defeat your enemies. Do you want to play assault? You can go berserk. Do you want to play sniper? You can get special ammunition that gives you more range and accuracy. You can also play stealthy with the Panther class, and use a smoke bomb to get away from your enemies. Tom Clancy's Ghost Recon Breakpoint is all about your choice, your way to have fun. ENJOY A TRUE SOCIAL EXPERIENCE WITH NEW SHARED PROGRESSION AND BEST-IN-CLASS ENDGAME CONTENT However you decide to play, in Tom Clancy’s Ghost Recon Breakpoint, you will always keep the same character: the same customization, the same skills, and the same weapons. You keep and improve your progression across both our PvE and PvP experiences. Tom Clancy’s Ghost Recon Breakpoint is also a truly social experience. Find your friends in the new Social HUB, play the campaign together, or enter a PvP arena to take on an intense 4v4 match. The adventure does not stop there! The game will be regularly updated and supported years after launch. New story arcs will keep expanding the story, new features will be continuously added, and new classes and gameplay possibilities will available to players, as well as events and a brand-new type of endgame content: Raids. Tom Clancy’s Ghost Recon Breakpoint: Global Threat Story Trailer | Ubisoft [NA] https://www.YouTube.com/UbisoftNA
Views: 576264 Ubisoft North America
Create Common Routing - Oracle Bills Of Material
 
00:50
Routings can be maintained separately or commoned with some other item. In this tutorial you will learn how to commom routings with another item. For more details visit http://oracleappscommunity.com/oracle/blog/2354/create-common-routing/
Views: 1805 Oracleappscommunity
Adjust Column Width  in Excel | My Excel University Lesson 1:7
 
05:22
Learn how to adjust column width and row height in Excel to better fit your data. See more videos like this at myexceluniversity.com
Views: 50 Quinn Davis
Destiny 2: Forsaken - Cayde-6's pet chicken Colonel at the Tower
 
01:00
This video is a 4K UHD 2160p60 FPS stitched together from two 30-second clips that were captured on my Xbox One X. It shows the area in the Tower where Hunter Vanguard, Cayde-6 was located. Our friend Colonel needs a new home and it could be adopted by the Guardians. The original files were 223 MB at 12,302 kbps total bitrate, but HitFilm Express 4 needed them converted from MP4 to H.264 for editing it as one video. However, the software would not export this project and alternate settings had to be used, which resulted in a 22.5 GB file size with a total bitrate of 3,289,228 kbps when it was set for 60 Mbps and up to 90 Mbps in the settings; but as always, I wanted to thank you for your time.
Views: 1842 Tommy Anderson
BI Publisher Extensibility Training - How to Delete a Report Layout
 
01:19
This short tutorial details how to delete a report layout. Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Create a column and view selector in a Fusion OTBI report
 
03:37
This short video shows you how to add a column selector to view the same metric by different columns and a view selector so that you can switch between a tabular view and a graphical view. Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
How Can Excel Determine the Best Width of a Column? : Using Excel & Spreadsheets
 
00:57
Subscribe Now: http://www.youtube.com/subscription_center?add_user=ehowtech Watch More: http://www.youtube.com/ehowtech Excel determines the best width of a column by paying attention to how much text needs to be visible in that location. Find out how Excel can determine the best width of a column with help from a Microsoft certified applications specialist in this free video clip. Expert: Jesica Garrou Filmmaker: Patrick Russell Series Description: Microsoft Excel is still the most widely used spreadsheet creation tool in existence for both the PC and Mac platforms. Get tips on Microsoft Excel with help from a Microsoft certified applications specialist in this free video series.
Views: 86 eHowTech
TABLESPACE MANAGEMENT GRANT REVOKE QUOTAS ON TABLESPACE FOR USERS
 
06:20
How to grant/revoke quota for Users on Tablespace ================================================= create tablespace test datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\test.dbf' size 10m;---(tablespace created) create user naveen identified by naveen;(user created) alter user naveen quota 2m on test;(granted 2m on test tablespace) alter user naveen quota unlimited on test;(granted unlimited on test) How to revoke unlimited tablespace from user ============================================= revoke unlimited tablespace from &user; How to check the views on quotas ================================= select table_name from dict where table_name like '%QUOTA%'; Queries for tablespace quotas on all users ========================================== set lines 180 set pages 200 col tablespace_name for a30 col username for a20 select * from user_ts_quotas; set lines 180 set pages 200 col tablespace_name for a30 col username for a20 select * from dba_ts_quotas;
Views: 590 Praveen Biyyapu
Alter database table columns without dropping table   Part 67
 
04:06
In this video, we will discuss, altering a database table column without having the need to drop the table. Let's understand this with an example. Text version of the video http://csharp-video-tutorials.blogspot.com/2013/08/part-67-alter-database-table-columns.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-67-alter-database-table-columns.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists We will be using table tblEmployee for this demo. Use the sql script below, to create and populate this table with some sample data. Create table tblEmployee ( ID int primary key identity, Name nvarchar(50), Gender nvarchar(50), Salary nvarchar(50) ) Insert into tblEmployee values('Sara Nani','Female','4500') Insert into tblEmployee values('James Histo','Male','5300') Insert into tblEmployee values('Mary Jane','Female','6200') Insert into tblEmployee values('Paul Sensit','Male','4200') Insert into tblEmployee values('Mike Jen','Male','5500') The requirement is to group the salaries by gender. To achieve this we would write a sql query using GROUP BY as shown below. Select Gender, Sum(Salary) as Total from tblEmployee Group by Gender When you execute this query, we will get an error - Operand data type nvarchar is invalid for sum operator. This is because, when we created tblEmployee table, the "Salary" column was created using nvarchar datatype. SQL server Sum() aggregate function can only be applied on numeric columns. So, let's try to modify "Salary" column to use int datatype. Let's do it using the designer. 1. Right click on "tblEmployee" table in "Object Explorer" window, and select "Design" 2. Change the datatype from nvarchar(50) to int 3. Save the table At this point, you will get an error message - Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created. So, the obvious next question is, how to alter the database table definition without the need to drop, re-create and again populate the table with data? There are 2 options Option 1: Use a sql query to alter the column as shown below. Alter table tblEmployee Alter column Salary int Option 2: Disable "Prevent saving changes that require table re-creation" option in sql server 2008 1. Open Microsoft SQL Server Management Studio 2008 2. Click Tools, select Options 3. Expand Designers, and select "Table and Database Designers" 4. On the right hand side window, uncheck, Prevent saving changes that require table re-creation 5. Click OK
Views: 95698 kudvenkat
USER MANAGEMENT CREATE USER DROP USER   CASCADE
 
07:46
USER MANAGEMENT HOW TO CREATE A USER ===================== create user naveen identified by naveen; create user pavan identified by pavan default tablespace king; HOW TO DROP USER ================= drop user naveen; (it will work if no objects) drop user pavan cascade; HOW TO GRANT ORACLE PREDEFINED ROLES TO USER ============================================ grant connect,resource to naveen; select * from session_privs; set lines 180 pages 200 col username for a30 select username,default_tablespace,temporary_tablespace from dba_users where username like '&user';
Views: 445 Praveen Biyyapu
Column count option create no change  by setting  new number
 
00:35
When clicking on column count and change the number and recheck the home screen it is similer before changing column count number and changing the number can't create any effect on app
Views: 4 Agun Chowdhury
Contact Form 7 Tutorial - Create a 2-Column Responsive Form With Contact Form 7 | CF7 Tuts Part 4
 
25:43
Contact Form 7 Tutorial - Create a 2-Column Responsive Form With Contact Form 7 Check out https://happyforms.me/ , it's a cool new form builder that you may like better than CF7 (and it's free!): HappyForms.me Exclusive for WPLearningLab viewers, up to 50% off hosting: https://wplearninglab.com/wordpress-hosting-offer/ Putting the contact form code into the YouTube description didn't make sense because YouTube doesn't allow pointy brackets, which there are a lot of in this code. So instead, you can find it here: https://wplearninglab.com/contact-form-7-2-column-responsive-form Below are the CSS styles I mention in the video: /*--- 2 Column Form Styles Start ---*/ #left { width: 47%; float: left; margin-right:6%; } #right { width: 47%; float: left; } .clearfix:after { content:"\0020"; display:block; height:0; clear:both; visibility:hidden; overflow:hidden; margin-bottom:10px; } .clearfix { display:block; } /*--- 2 Column Form Styles End ---*/ With over 1 million active downloads, the Contact Form 7 (https://wordpress.org/plugins/contact-form-7/) plugin by Takayuki Miyoshi is one of the most popular contact form plugins around. And for good reason. It makes contact forms a breeze. In this Contact Form 7 tutorial I'm going to show you how to create a 2-column Responsive form using Contact Form 7. They key to creating a contact form using Contact Form 7 with two columns is the use of HTML Div tags and CSS floats. A regular WordPress contact form is nice, but the two columns really adds a bit of polish. First things first, if you haven't installed Contact Form 7 yet, let's do that. To install this plugin please log into your WordPress dashboard, hover over Plugins and then click on Add New. On the next page type "Contact Form 7" into the search bar. The plugin we want should be the first one in the top left. Click on the Install Now button and then click Activate after it's installed. It will add a new menu item in the left hand admin menu called Contact Form. Hover over that click on Add New. You will taken to the new form creator. First enter a name for your contact form and then paste the HTML form code into the form editor. Next, click on the Mail tab to customize the email that is generated when the form is submitted. Make sure you add all of the available fields that are at the top of the Mail tab. Watch the video to see how to do this in detail. When you're done, click on Save Changes. Next, we need to add this form to a page. After saving a blue bar will appear at the top of the form editor. Inside that blue bar is the shortcode for your form. Copy that code. Now go to Pages, then Add New to create a new page OR find the page where your contact form needs to live. Inside the page editor paste the shortcode and click on Update to save the page. When you view the page, you will see a 1 column form. Now it's time to make it 2-column and responsive using CSS. Back inside the WordPress admin find a place where you can add custom CSS. Your theme may have a special spot in the Theme Options section or you may have a code insert plugin or you may have a plugin that allows you to add CSS directly to specific pages. However it is that you add CSS, do that. Just paste in the CSS and save. As long as you didn't change the HTML, your contact form 7 will now be 2 column responsive! And that's how easy it is to create a contact form WordPress. I hope this information helps you! If you have any questions leave a comment below or ping me @WPLearningLab on Twitter. -------------- If you want more excellent WordPress information check out our website where we post WordPress tutorials daily. https://wplearninglab.com/ Connect with us: WP Learning Lab Channel: http://www.youtube.com/subscription_center?add_user=wplearninglab Facebook: https://www.facebook.com/wplearninglab Twitter: https://twitter.com/WPLearningLab Google Plus: http://google.com/+Wplearninglab Pinterest: http://www.pinterest.com/wplearninglab/