Home
Search results “Declare oracle varchar”
Every VARCHAR2(N) Declaration a Bug in PL/SQL!?
 
07:51
Every VARCHAR2(N) Declaration a Bug!? That's right. VARCHAR2 declarations mean that you have to provide an "N" or constraint on the size of the variable. If you have such declarations all over your code, that's a form of hard-coding and you are likely to get hammered by VALUE_ERROR exceptions. This video shows how to fix this problem. See the Practically Perfect PL/SQL YouTube channel for related videos. https://www.youtube.com/channel/UCpJpLMRm452kVcie3RpINPw ============================================ 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.
Oracle SQL Tutorial 32 - VARCHAR2 and NVARCHAR2
 
03:06
This video we are going to discuss the VARCHAR2 and the NVARCHAR2 data types. The previous videos are a good foundation to this video. I've actually discussed so much stuff in those videos that I don’t have a whole lot to say. Good for you, right? I discussed over the previous videos that you should prefer to use VARCHAR2 over CHAR. That's because there is not a difference in performance or storage for a VARCHAR2 column. The only difference is that an CHAR column forces each value to take up a certain length even if it's not. There is one difference between the variable length and fixed length data types here that you need to know about, and that is storage limits. CHAR has a limit of 2000 bytes, while VARCHAR2 has a limit of 4000 bytes. That means you can store twice as much junk in a VARCHAR2 column! Other than that, these data types work exactly the same. I recommend you always use the VARCHAR2 data types instead of the CHAR data types, and only use NVARCHAR2 if you have a non-Unicode database. This will allow you to store Unicode characters in a column. Now, the amount of storage you can put in a VARCHAR2 column is twice what you can put in a CHAR column, but 4000 characters is still not very many characters. This is where the LOB data types come in, which we will discuss in the next video! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 5095 Caleb Curry
9. What are the Difference Between VARCHAR and VARCHAR2 in Oracle Database
 
02:13
What are the Difference Between VARCHAR and VARCHAR2 in Oracle Database
MySQL 26 - VARCHAR Data Type
 
04:29
Varchar is very similar to CHAR in that it is used to store strings, but there are some pretty big differences. The first difference is that when you store data less than the max it does not pad it with spaces to make it fit. The benefit in this is that you will save storage. The downside to this is that now MySQL is going to have to keep track of how many characters you have. To do this, each value is going to have an additional byte or two that MySQL can use. The max length is 65535 bytes. That is per value in that column! But you have to keep in mind encodings. If your characters are encoded with something such as UTF-8, each character can take up multiple bytes. The max size for a character in this case is 3 bytes. That means that we really can't store that many characters. Additionally, MySQL has a row limit of 65535 bytes (potential bytes…meaning declared sizes). What does this mean? It means that if you make this too big, you are not going to be able to create other columns. Earlier I said that there will be an additional byte or two for each value you put into this column. The purpose of this is to keep track of how long the string is. Why one or two and not one? The reason being is because with one byte we can only count to 255. if we want to keep track of bytes after that we need two bytes. This means that we actually can't store quite 65535 bytes. Realistically, we can't store that much because we have to store the length of the string, and each character can take up to 3 bytes which can push us over the row limit. This means the real max is a little less than a third of that. Not every character is going to take up 3 bytes, but MySQL assumes it will as to not cut you short. This is slightly different than CHAR because char you can store up to 255 characters, not bytes. Even if you use an encoding where some characters take up multiple bytes, you can still store 255 of them. Remember that reason for this is that VARCHAR is subject to the row-limit. MySQL will not let you go past the max and will tell you the appropriate max, so don't worry about it too much. You should try not to push your limits. Plus, most of the time you will not come even close to the max for most columns. Should you use the max? Varchar will only store what is needed to store a value, but you should still try to have the max size no more than what is needed. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 6836 Caleb Curry
PL/SQL tutorial 6: Bind Variable in PL/SQL By Manish Sharma RebellionRider.com
 
07:56
Watch and learn what are bind variables in PL/SQL how to declare or create them using Variable command, Initialize them using Execute (exec)command and different ways of displaying current values of a bind variable for example using AutoPrint parameter. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/bind-variable Previous Tutorial ► Constants in PL/SQL https://youtu.be/r1ypg7WH4GY ►User Variables :https://youtu.be/2MNmodawvnE ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►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 ------------------------------------------------------------------------- ►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: 90020 Manish Sharma
ORACLE 12c: How to extend VARCHAR2 datatypes to 32k
 
02:17
New feature 12c: Extend to VARCHAR2() 32k, instead of 4000 bytes. Let take advanced of VARCHAR2 over CLOB !!
Views: 5354 Database Tutorials
Difference between char,nchar,varchar,nvarchar in SqlServer
 
13:40
Compleate diffrence between char,nchar,varchar,nvarchar in SqlServer
Views: 14312 Tech mohan
What is Hard-Coding in PL/SQL?
 
08:14
Practically Perfect PL/SQL with Steven Feuerstein See the first in a multi-video series that describes the nuances of hard-coding in PL/SQL. See the Practically Perfect PL/SQL YouTube channel for related videos. https://www.youtube.com/channel/UCpJpLMRm452kVcie3RpINPw 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.
Oracle tutorial : sys_refcursor  in oracle pl sql (sys_refcursor)
 
09:53
Oracle tutorial : sys_refcursor in oracle pl sql oracle tutorial for beginners cursor in pl sql we can use sys_refcursor as OUT parameter. A cursor is a pointer to a result set for a query. By returning a sys_refcursor you allow the client to fetch many rows from the query as it requires. basically we use sys ref cursor to return set of rows to client. so client can use this result set. u can fetch multiple rows. lets see example.. CREATE OR REPLACE PROCEDURE get_my_list (list OUT SYS_REFCURSOR) AS BEGIN OPEN list FOR SELECT ALTID, FNAME, LNAME FROM EMPLOYEE; END get_my_list; / DECLARE l_cursor SYS_REFCURSOR; ID VARCHAR2(20); FNAME VARCHAR2(20); LNAME VARCHAR2(20); BEGIN get_my_list (list = l_cursor); LOOP FETCH l_cursor INTO ID, FNAME, LNAME; EXIT WHEN l_cursor%NOTFOUND; DBMS_OUTPUT.PUT_LINE(ID || ' | ' || FNAME || ' | ' || LNAME); END LOOP; CLOSE l_cursor; END; / Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://techquerypond.wordpress.com https://twitter.com/techquerypond database cursor example database cursor sql server cursor
Views: 1989 Tech Query Pond
Oracle SQL Tutorial 18 - How to Create Foreign Keys
 
07:09
In this video we are going to be creating foreign keys. I highly recommend watching the previous video before you watch this one. Essentially, we are creating a very simple database for a system where we can create projects and add people to those projects. We started with the users table: --Delete the table if needed: --DROP TABLE users; CREATE TABLE users( user_id NUMBER, username VARCHAR2(50 CHAR) UNIQUE, CONSTRAINT users_pk PRIMARY KEY (user_id) ); Now we are going to create a table for projects with a column that is a foreign key to the username. We're going to want to make this match data types: CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) ) Next, we need to add the column attributes we decided on last video: CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL ) NOT NULL because we want every project to have a creator, but we are not labeling UNIQUE because that means we could only have a specific username once in the table. We want to allow a user to create multiple projects. We also need to add a primary key: CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL, CONSTRAINT projects_pk PRIMARY KEY (username) ) Now, the question that remains is, how can I tell Oracle that I want the username to reference the username column of the other table? We have to make a foreign key constraint. As you've learned from the previous videos, there are about three ways to create constraints. You can do it inline at the column level, unnamed. You can do it at the column level, named, and you can do it at the Table level, named. Usually the table-level is preferred, but I will quickly remind you how to do all three again. CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL REFERENCES users (username), CONSTRAINT projects_pk PRIMARY KEY (project_id) ) This works, but if we want to name it, we should do this: CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL CONSTRAINT projects_users_fk REFERENCES users (username), CONSTRAINT projects_pk PRIMARY KEY (project_id) ) This works, but the preferred method is to do it at the table level: CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL, CONSTRAINT projects_pk PRIMARY KEY (project_id), CONSTRAINT projects_users_fk FOREIGN KEY (creator) REFERENCES users (username) ) Great! So you've learned how to create a foreign key, now we can see it inside of Oracle SQL Developer. One important thing when it comes to foreign keys is what happens when have data in your database and you try to delete the parent row that a row in the child table references? In the next video we are going to configure that using ON DELETE. See you all then and if you enjoy this series, please do me a huge favor by liking the video and subscribing to my YouTube channel. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 21291 Caleb Curry
Oracle PL/SQL Tutorials | Bind Variable in PL/SQLSQL Bind Variable | Mr.Vaman Deshmukh
 
09:26
** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 ► Visit Our Website for Classroom Training: https://nareshit.in ► For Online Training: https://nareshit.com/ #OraclePLSQLTutorials #BindVariableinPLSQL -------------------------- ► About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ► Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ► Follow us on Instagram: https://www.instagram.com/nareshitech/ -------------------------------------------------------------------------------------------------------- #oracletutorials #oracletraining #sqltrainingvideos #sqltutorials #oraclevideos
How to concatenate stored procedure varchar variables
 
03:19
concat strings in stored procedure
Views: 7 Adam Tech
PL/SQL tutorial 33: Table Based Record Datatype In Oracle Database by Manish Sharma
 
06:48
Learn how to create a table based record type variable in Oracle Database By Manish Sharma from RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/table-based-records Previous Tutorial ► Introduction To Records: https://youtu.be/1iHbZDuDbis ► SELECT-INTO Statement: https://youtu.be/Zt0vlmTqhP4 ------------------------------------------------------------------------- ►►►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: 30852 Manish Sharma
SQL ORACLE 07 variables de sustitucion y comando DEFINE
 
13:08
SQL Oracle 07 - Variables de sustitución y comando DEFINE -------------------------------------------------- Curso de Sql usando la base de datos Oracle 11g r2 -------------------------------------------------- En este tutorial veremos como crear scripts que nos permitan sustituir valores para las variables que definamos en nuestras sentencias select. Espero les guste
Views: 2733 Jesus Luque Medina
SQL Tutorial - 7: Data-Types in SQL (Part-2)
 
06:48
In this tutorial we';; check out the data type options we have available for use in SQL. We'll talk about Bigint, int, smallint, tinyint, decimal, number, float, char, varchar, blob, datetime, date, time and year.
Views: 98120 The Bad Tutorials
how to auto increment varchar in sql server
 
08:26
how to auto increment varchar in sql server
Views: 13780 Kannababu Banna
PL/SQL tutorial 85: Execute Immediate with Using Clause in Native Dynamic SQL by Manish Sharma
 
08:45
In this tutorial, we have Bind Variable, Using clause and Execute Immediate of Native Dynamic SQL. Go ahead and learn How to use bind variable by applying using clause of execute immediate of Dynamic SQL by Manish Sharma from RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/nds-6 Previous Tutorial ► Must Read Before Taking 1Z0-061 Oracle Database 12c SQL Fundamentals Exam. https://www.facebook.com/notes/manish-sharma/must-read-before-taking-1z0-061-oracle-database-12c-sql-fundamentals-exam/470058480064194/ ► Bind Variable https://youtu.be/TJtjo3FTBtE ► Create Table DDL with Dynamic SQL https://youtu.be/dl39itjrWYw ► Insert DML https://youtu.be/uQXgqFtxI_k ------------------------------------------------------------------------- ►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: 2658 Manish Sharma
Debugging Oracle PL/SQL code with ORACLE SQL DEVELOPER tool
 
15:04
Want to know how to debug procedures on Oracle sql developer 3.0? Well the you are at the correct place, we have worked out this simple tutorial to help you guys use this cool feature of debugging on Oracle sql developer tool. You can debug your procedures, functions, packages easly with the steps mentioned in the video.
Views: 5010 Kishan Mashru
PL/SQL tutorial 4: Anchored Datatype (%TYPE) in PL/SQL By Manish Sharma RebellionRider
 
06:10
Anchored datatype or %TYPE in PL/SQL are those data type which you assign to a variable based on a database object. Watch this PL/SQL Tutorial 4 and leanr about %TYPE with examples By Manish Sharma from wwww.RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/anchored-datatype Previous Tutorial ► SELECT...INTO statement in PL/SQL https://youtu.be/F5eMJhwmCQs ------------------------------------------------------------------------- ►►►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: 100850 Manish Sharma
PL/SQL tutorial 37: User Defined Record Datatype variable By Manish Sharma
 
05:39
Learn What are User Defined Record Datatype variable and How To Create User Defined Record Datatype variable in Oracle Database By Manish Sharma from RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/User-defined-record Previous Tutorial ►Anchored Datatype Variable: https://youtu.be/Zt0vlmTqhP4 ► ------------------------------------------------------------------------- ►►►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: 21272 Manish Sharma
PL/SQL tutorial 3: SELECT INTO statement in PL/SQL by Manish Sharma RebellionRider
 
05:22
How to initialize the variable by fetching values from the table of the database or by using SELECT INTO statement in PL/SQL by Manish Sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/select-into-statement-pl-sql Previous Tutorial ► Variables: https://youtu.be/2MNmodawvnE ------------------------------------------------------------------------- ►►►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: 119449 Manish Sharma
SQL Tutorial for beginners: Difference Between IN and EXISTS Operators in Oracle
 
06:58
Difference Between IN and EXISTS Operators 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: 573 TechLake
66. Input Variables in Oracle SQL Plus
 
06:52
In this video you will learn about Input Variables in Oracle SQL Plus. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 3357 ITORIAN
Oracle sql and pl/sql Interview question : Difference between %type and %rowtype in oracle pl/sql
 
11:37
This video tutorial explains the usage of %type variable declaration and %rowtype variable declaration. It also states the advantages of using %type and %rowtype variable declaration. At the end the viewes can easily identify the difference between %type and %rowtype variable declaration 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
Views: 539 Kishan Mashru
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: 4428 Kishan Mashru
SEARCH WITH ORACLE FORM
 
06:57
شرح كيفية عمل زر للبحث الكود DECLARE V_block_val VARCHAR2(100); BEGIN V_block_val := :BLOCK10.FILTER_; IF GET_ITEM_PROPERTY('PUSH_BUTTON14',PROMPT_TEXT)='SEARCH'THEN MESSAGE(GET_ITEM_PROPERTY('PUSH_BUTTON14',PROMPT_TEXT)); GO_BLOCK ('EMPLOYEES'); SET_BLOCK_PROPERTY('EMPLOYEES',DEFAULT_WHERE,'SALARY ='||TO_NUMBER(:BLOCK10.FILTER_)); SET_ITEM_PROPERTY('PUSH_BUTTON14',LABEL,'MAHMOUD'); EXECUTE_QUERY; ELSE SET_BLOCK_PROPERTY('EMPLOYEES',DEFAULT_WHERE,''); SET_ITEM_PROPERTY('PUSH_BUTTON14',LABEL,'SEARCH'); END IF; END;
Views: 8780 Mahmoud Alsaqqa
pl-sql tutorial in hindi lec 4 (%type and select data from sql table in hindi)
 
10:36
http://www.bitsinfotec.in/ plsql tutorial part 4 . what is % type in pl-sql , what is column type in pl-sql, why do we use %type in pl-sql in hindi, plsql tutorial by alok on javatreepoint , plsql in oracle in hindi. %TYPE attribute in hindi. Where to use pl-sql in hindi. what is the use of %TYPE attribute.
Views: 1277 JavaTreePoint
8. CREATE, INSERT and SELECT commands
 
15:42
In this video you will learn how to execute CREATE, INSERT and UPDATE commands. I will show you by executing these command and you will understand it easily. We will also cover its theory part before demo. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 127335 ITORIAN
Literals in Oracle
 
02:00
Views: 139 Geeky Abhijeet
Oracle tutorial : Global Temporary Table In Oracle PL SQL
 
08:49
Oracle tutorial : Global Temporary Table In Oracle PL SQL create temp table sql This video will explain to you how to create Temporary Tables in Oracle Oracle tutorial : Global Temporary Table In Oracle 1)The data in such a table is stored only as long as the session or transaction lasts and is private for each session. 2)The definition is visible to all sessions. 3)After commit or disconnection, the data is lost but the definition of the table remains. 4)Indexes created on a temporary. 5)Scope of TRUNCATE command is a single database session. There is no effect of TRUNCATE on other sessions. 6)Foreign key constraints are not applicable in case of Temporary tables 7)Temporary tables cannot contain column of persistent collection type Syntax : CREATE GLOBAL TEMPORARY TABLE table_name ( column_name column_data_type … … ) ON COMMIT DELETE ROWS; CREATE GLOBAL TEMPORARY TABLE Emp ( id number(5) NOT NULL, name varchar2(50) NOT NULL, city varchar2(50) NOT NULL ) ON COMMIT DELETE ROWS INSERT INTO Emp VALUES (1, ‘Test1’, ‘city1’); INSERT INTO Emp VALUES (2, ‘Test2’, ‘city2’); INSERT INTO Emp VALUES (3, ‘Test3’, ‘city3’); SELECT COUNT(*) FROM emp; Result = 3 rows COMMIT; SELECT COUNT(*) FROM emp; Result = 0 rows For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond oracle temporary table create temporary table sql temp table
Views: 3879 Tech Query Pond
bulk collect and record type in oracle example
 
03:00
DECLARE CURSOR c_cust_cur IS SELECT ENAME, EMPNO, SAL, DEPTNO FROM EMP; ---smple cursor TYPE v_cust_cur IS RECORD( ENAME VARCHAR2(60), EMPNO VARCHAR2(60), SAL VARCHAR2(60), DEPTNO VARCHAR2(60)); ---record type TYPE cust_cur_tbl IS TABLE OF v_cust_cur INDEX BY BINARY_INTEGER; v_cust_cur_tbl cust_cur_tbl; v_data_clob CLOB := EMPTY_CLOB(); v_from VARCHAR2(100); v_to VARCHAR2(32700); BEGIN OPEN c_cust_cur; FETCH c_cust_cur BULK COLLECT --Bulk collect INTO v_cust_cur_tbl; CLOSE c_cust_cur; BEGIN /* FOR i IN 1 .. v_cust_cur_tbl.COUNT LOOP or we ca write also output will be same */ FOR i IN v_cust_cur_tbl.first .. v_cust_cur_tbl.last LOOP v_data_clob := v_cust_cur_tbl(i).ENAME || '",' || '"' || v_cust_cur_tbl(i) .EMPNO || '",' || '"' || v_cust_cur_tbl(i).SAL || '",' || '"' || v_cust_cur_tbl(i) .DEPTNO; dbms_output.put_line(v_data_clob); END LOOP; END; END;
Views: 8 Young India
Oracle tutorial : Autonomous Transactions in Oracle 11g PL SQL-PRAGMA
 
10:40
Oracle tutorial : Autonomous Transactions in Oracle 11g PL SQL-PRAGMA What is pragma autonomous_transaction An autonomous transaction is an independent transaction to the main or parent transaction. If an Autonomous transaction is started by another transaction it is not nested, but independent of parent transaction. PRAGMA autonomous_transaction 1)In Oracle session, all of the changes made to data are part of a single transaction. 2)An autonomous transaction is an independent transaction started within another transaction (the main transaction). 3)Autonomous transactions allow you to temporarily suspend the main transaction, perform additional SQL operations, commit or rollback those operations separately, then resume the main transaction. 4)To define an autonomous transaction, we can use a PRAGMA statement PRAGMA AUTONOMOUS_TRANSACTION; CREATE TABLE log_data ( empno NUMBER(6), userid VARCHAR2(30), create_date DATE ); CREATE OR REPLACE TRIGGER add_log BEFORE INSERT OR UPDATE ON employee FOR EACH ROW DECLARE PRAGMA AUTONOMOUS_TRANSACTION; — This statement made this autonomous this trigger BEGIN INSERT INTO log_data VALUES (:new.id, USER, SYSDATE); COMMIT; END; / Insert into EMPLOYEE (ID, NAME, CITY, SALARY, DEPT_NO) Values (20, ‘MY Tech Query’, ‘Mumbai’, 20000, 1) ROLLBACK; SELECT * FROM EMPLOYEE SELECT * FROM LOG_DATA https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond oracle transaction pragma autonomous_transaction
Views: 2545 Tech Query Pond
Using Conversion Functions in Oracle Database
 
12:42
data type conversion in oracle convert date function in oracle oracle convert varchar implicit datatype conversion in oracle cast function in oracle oracle convert date
Views: 22 Adam Tech
Session6 Data type in Oracle
 
15:25
Session 6: Datatypes In Oracle   ALPHABET           : A-Z , a-z NUMBER              : 0-9 (with precision and scale) DATE / Temporal  : any Date and time (Hours, Minutes, Seconds, Mili-seconds, Timestamp, Timezone etc)   Alphabet + Number = Alphanumeric Data                                     = String / CHARACTER Datatype Category Number                    =  Numeric Datatype Category Date                         = Date Datatype Category 1. CHARACTER Datatype: CHAR, VARCHAR, NCHAR: CHAR is fixed length datatype and VARCHAR is Variable length datatype to store character data. i.e. A-Z , a-z , 0-9 , all keyboard characters etc. The default size is 1 character and it can store maximum up to 2000 bytes. Example : EName, EmpID, PassportNo, SSN, etc. EName CHAR(10) := ‘TOM’; wastage of 7 space after the string EName VARCHAR(10) := ‘TOM’; Spaces can be Reuse which left after the string NCHAR additionally handles NLS(National Language Support). Oracle supports a reliable Unicode datatype through NCHAR , NVARCHAR2 , and NCLOB  VARCHAR2, NVARCHAR2: These are Variable length datatype. VARCHAR2 handles alphanumeric character string whereas NVARCHAR2 handles alphanumeric character string with NLS(National Language Support). The default size is 1 character and it can store maximum up to 4000 bytes.   LONG:  Variable length string.  (Maximum size: 2 GB - 1) Only one LONG column is allowed per table. RAW:    Variable length binary string (Maximum size 2000 bytes) LONG RAW: Variable length binary string (Maximum size 2GB) 2. NUMERIC Datatype: NUMBER: It stores Numeric values and performs numeric calculations. NUMBER,   NUMBER(n),   NUMBER(p,s) It stores Numbers up to 38 digits of precision. SeqNo NUMBER;                     1, 123, 12345678 EmpID NUMBER(4);                 1, 123, 1234 Sal NUMBER(7,2);                     23456.78 , 123.45 — correction in video: Sal NUMBER(a7,2); which is wrong please ignore. 1234567 can be a type of NUMBER, NUMBER(7), NUMBER(7,0) It can store both integer and floating point numbers NUMERIC(p,s) FLOAT:   Ex:  EmpSal FLOAT;    FLOAT(7)       Decimal Points allowed DEC(p,s), DECIMAL(p,s) , REAL, DOUBLE PRECISION INTEGER:   Ex:  SSN INTEGER;       Decimal Points are not allowed INT, SMALLINT 3. DATE Datatype: DATE: It stores DATE(Date, Month, Year) and Time(Hour, Minute, Second, AM/PM) and performs calculations with such data. Default DATE format in Oracle is “DD-MON-YY” Based on "Gregorian calendar" where the date ranges from “JAN 1 4712 BC” to “DEC 31 9999 AD” doj DATE;    “18-MAR-2010 12:30:00 PM” TIMESTAMP:    It can store all parameters as DATE datatype and additionally it can have “Fraction of seconds” and TIMESTAMP WITH TIMEZONE / TIMESTAMP WITHOUT TIMEZONE. Range from 0-9 digits, the default size is 6. 4. LOB Datatype: LOB: “Large Object” data. It can store pictures, motion pictures, Textfiles etc. CLOB: “Character Large Object” is used to store structured information like a text file with a specific file format. BLOB: “Binary Large Object” is used to store Un-structured information like Image, JPEG files, MPEG files etc. BFILE: “Binary File” is used to store the pointer to a specific file / Just store the location of a file. Maximum size: (4 GB - 1) * DB_BLOCK_SIZE initialization parameter (8 TB to 128 TB) Extra Information: NCLOB : It supports all the character set supported by CLOB and additionally it handles NLS(National Language Support ) Maximum size: (4 GB - 1) * DB_BLOCK_SIZE initialization parameter (8 TB to 128 TB) ROWID and UROWID(optional size) Datatype: contains fixed length Binary data. BBBBBBB.RRRR.FFFFF combination of BLOCK-ROW-DATABASE FILE Physical and Logical ROWID Upcoming Session: Session 7: Populating Data into Tables(INSERT Statement): Inserting data into all columns of a table Inserting data into Required columns of a table Inserting NULL value into a table Inserting Special Values(USER / SYSDATE) into a table Supplying data at runtime(using & and &&) THANK YOU :)
Views: 98 Prabhat Sahu
create report from package - pipeline pl/sql Oracle
 
02:15
12-march-2017 Oracle Apex create report from package - pipeline pl/sql steps 1. Create package on dept from HR 2. Package Specification create or replace PACKAGE r_deptinfo AS TYPE t_row IS RECORD ( DEPTNO NUMBER(2,0), DNAME varchar2(60), LOC varchar2(60) ); TYPE t_tab IS TABLE OF t_row; FUNCTION get_tab(p_DEPTNO number) RETURN t_tab PIPELINED; END; / 3. Package body create or replace PACKAGE BODY r_deptinfo AS FUNCTION get_tab(p_DEPTNO number) RETURN t_tab PIPELINED IS l_row t_row; cursor c1 is select DEPTNO, DNAME, LOC from dept where (DEPTNO = p_DEPTNO or 1=1); BEGIN FOR r1 IN c1 LOOP l_row.DEPTNO := r1.DEPTNO; l_row.DNAME := r1.DNAME; l_row.LOC := r1.LOC; PIPE ROW (l_row); END LOOP; RETURN; END; END; / 4. Call package select DEPTNO, DNAME, LOC from table(r_deptinfo.get_tab(10)); col DNAME for a30 col LOC for a30 drop package r_deptinfo / 5. now we can use it anywhere as a sql statement thats it Thanks . . .
Views: 636 Mostafiz Mitul
Learn Oracle | Data Types in PL SQL
 
13:14
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: 2340 Pebbles Tutorials
PL/SQL Tutorial 4- PL_SQL variable declare in Oracle Database By JavaInHand
 
08:52
variable declaration and initialization in pl/sql
Views: 683 JavaInHand
Why is varchar(max) getting truncated?
 
03:31
Have you ever tried to fit more than 8000 characters into a variable defined as varchar(max) (or nvarchar(max)) only to see your data get truncated? Today we explore why this happens and how to fix it, allowing you to create really long SQL strings. Related blog post with example code: https://bertwagner.com/2018/05/15/why-is-my-varcharmax-variable-getting-truncated/ Twitter: https://twitter.com/bertwagner Instagram: https://www.instagram.com/bertwagner/ https://www.instagram.com/sqlwithbert/ Facebook: https://www.facebook.com/SQLWithBert
Views: 365 Bert Wagner
SQL 033 Data Types, Character String Data, VARCHAR
 
02:10
Explains the SQL VARCHAR or variable length character data type. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 2170 cbtinc
PL-SQL tutorial 20 - How to use Multiple global variable in plsql program
 
07:06
Hi guys this videos very helpful for everyone i am going to explain How to use Multiple global variable in plsql program. Oracle database Unbeatable,Unbreakable Platform..
Views: 210 Oracle World
PL/SQL Tutorial 6- PL_SQL Data Types in Oracle Database By JavaInHand (in Hindi)
 
08:52
in this video describe what is data type and types of data types in pl/sql
Views: 598 JavaInHand
PL/SQL tutorial 86: Multiple Bind Variable with Execute Immediate of Dynamic SQL By Manish Sharma
 
12:29
Manish Sharma from RebellionRider.com presents how to use multiple bind variables by applying using clause of execute immediate statement in native dynamic SQL. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/nds-7 Previous Tutorial ► PL/SQL tutorial 45 https://youtu.be/byGweJ3tBLo ------------------------------------------------------------------------- ►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: 2736 Manish Sharma
collection methods in pl sql
 
05:32
DECLARE CURSOR c_cust_cur IS SELECT ENAME, EMPNO, SAL, DEPTNO FROM EMP; ---smple cursor TYPE v_cust_cur IS RECORD( ENAME VARCHAR2(60), EMPNO VARCHAR2(60), SAL VARCHAR2(60), DEPTNO VARCHAR2(60)); ---record type TYPE cust_cur_tbl IS TABLE OF v_cust_cur INDEX BY BINARY_INTEGER; --PL/SQL - Collections Associative array (or index-by table) -- or index by binary_integer|pls_integer|VARCHAR2(size); ---declaration of variable v_cust_cur_tbl cust_cur_tbl; v_data_clob CLOB := EMPTY_CLOB(); v_from VARCHAR2(100); v_to VARCHAR2(32700); BEGIN OPEN c_cust_cur; FETCH c_cust_cur BULK COLLECT --Bulk collect INTO v_cust_cur_tbl; CLOSE c_cust_cur; BEGIN v_cust_cur_tbl.delete(1); --Pl SQl Methods /* FOR i IN 1 .. v_cust_cur_tbl.COUNT LOOP or we ca write also output will be same */ FOR i IN v_cust_cur_tbl.first .. v_cust_cur_tbl.last LOOP /* Retrive data from record */ v_data_clob := v_cust_cur_tbl(i).ENAME || '",' || '"' || v_cust_cur_tbl(i) .EMPNO || '",' || '"' || v_cust_cur_tbl(i).SAL || '",' || '"' || v_cust_cur_tbl(i) .DEPTNO; dbms_output.put_line(v_data_clob); dbms_output.put_line(v_cust_cur_tbl.first); --Pl SQl Methods dbms_output.put_line(v_cust_cur_tbl.last);-- Pl SQl Methods dbms_output.put_line(v_cust_cur_tbl.count);-- Pl SQl Methods END LOOP; END; END; --Thanks friend we will give code in description box copy and execute .... enjoy ... try to do execute some methods yourself
Views: 16 Young India
1-.Programacion PL/SQL Orientada a Objetos - Arrays
 
10:35
create or replace type ListaTipoArray as array(5) of varchar2(100); / create or replace type ListaNumTipoArray as array(5) of number(1); / declare --datos nombre1 varchar2(10):= 'Mario'; apellido1 varchar2(10):= 'ruiz'; apellido2 varchar2(10):= 'gonzalez'; pais varchar2(10):= 'Mexico'; Ciudad varchar2(10):= 'CDMX'; --declarar variable tipo array DatosPersonales ListaTipoArray; --declarar variable tipo array NumeroDato ListaNumTipoArray; begin --se abren instancias DatosPersonales:= ListaTipoArray(nombre1, apellido1, apellido2, pais, Ciudad); NumeroDato:= ListaNumTipoArray(1, 2, 3, 4, 5); for i in 1 .. 5 loop dbms_output.put_line(NumeroDato(i)||'.'|| DatosPersonales(i)||chr(13)); end loop; exception when others then dbms_output.put_line(sqlerrm); end; POO Programacion PL/SQL Orientada a Objetos oracle oracle sql oracle pl sql oracle sqlplus curso curso de oracle curso de sql curso de pl sql curso de sqlplus sql developer toad pl / sql developer desarrollo de aplicaciones programador desarrollador como ser programador como ser desarrollador certificacion certificacion oracle certificaciones 1z0-061 1z0-062 dba dba oracle administrador de base de datos administrador de base de datos oracle database oracle preparar certificacion oracle oracle expert oracle experto oramex el mundo de oracle mario ruiz mario ruiz marioruizcommx buenas practicas como usar pl sql como usar oracle como usar toad como usar sqlplus preguntas de la certificacion braindumps oracle linux linux batch awk perl shell scripting shell
Views: 680 Mario Ruiz
Create EXCEL/PDF/html/etc Report from Oracle | Ten Minute Code
 
10:54
BELOW CODE cerate report server below commands windows key+R run paste -- rwserver server=showjobs status=on Declare repid REPORT_OBJECT; v_rep VARCHAR2(1000); rep_status VARCHAR2(20); PL_ID PARAMLIST; pr_nm varchar2(20):='PNM'; --rwserver server=SHOWJOBS EXCECUTE IT ON RUN v_rptserver varchar2(10):='SHOWJOBS'; ---- Change 1 v_host varchar2(20):='localhost'; ---- Change 2 -- v_rptserver varchar2(10):=:global.RWS1; -- v_host varchar2(20):=:global.IP1; BEGIN PL_ID := GET_PARAMETER_LIST(pr_nm); IF ID_NULL(PL_ID) = FALSE THEN DESTROY_PARAMETER_LIST(PL_ID); PL_ID := CREATE_PARAMETER_LIST(pr_nm); IF ID_NULL(PL_ID) THEN MESSAGE('ERROR CREATING PARAMETER LIST '||pr_nm); RAISE FORM_TRIGGER_FAILURE; END IF; ELSE PL_ID := CREATE_PARAMETER_LIST(pr_nm); END IF; --add parameter with separate statement for each parameter Add_Parameter(pl_id,'P_ECode',TEXT_PARAMETER,:P_ECode); ---change 3 your report have parameters Add_Parameter(pl_id,'P_ECode',TEXT_PARAMETER,:P_ECode); repid := find_report_object('DESG'); --- change 4 report name SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH); SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS); SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE); SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF'); -- change 5 pdf/html -- SET_report_object_property(repid,REPORT_DESFORMAT,:BLOCK3.REP_FORMAT); ------ need all format SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,v_rptserver); v_rep := RUN_REPORT_OBJECT(repid,PL_ID); rep_status := REPORT_OBJECT_STATUS(v_rep); IF rep_status = 'FINISHED' THEN WEB.SHOW_DOCUMENT('http://'||v_host||':8889/reports/rwservlet/getjobid' ||substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server='||v_rptserver,'_blank'); ELSE message('Error when running report'); END IF; END;
Views: 5551 Together Oracle
Oracle DBA  How to create sql stored procedure Using Sqlplus
 
03:09
Oracle DBA How to create sql stored procedure Using Sqlplus sql create stored procedure sql stored procedure TO Connect Database 1) Open command Prompt. 2) SET ORACLE_SID=DATABASE NAME 3) SQLPLUS USERNAME/[email protected] CREATE OR REPLACE PROCEDURE INSERT_DATA IS SQLSTRING VARCHAR2(1000); BEGIN SQLSTRING:=’INSERT INTO EMPLOYEE_BKP(ID,NAME,CITY,SALARY,DEPT_NO) ‘; SQLSTRING:=SQLSTRING||’ SELECT ID,NAME,CITY,SALARY,DEPT_NO FROM EMPLOYEE’; EXECUTE IMMEDIATE SQLSTRING; EXCEPTION WHEN OTHERS THEN RAISE_APPLICATION_ERROR(-20001,’An error was encountered – ‘||SQLCODE||’ -ERROR- ‘||SQLERRM); END;
Views: 1073 Tech Query Pond
Oracle ||  PLSQL  Data Types by Siva
 
05:45
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS , ADF, INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, 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............
#2. Oracle PL/SQL for Beginners - Block Structure (Hindi)
 
09:33
In this video, you'll learn about PL/SQL block structure. It is main structure of PL/SQL programming. Enjoy the video and keep commenting. JavaScript Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2tLfvp7bCL3c-psMH9Czs6 SQL Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2q8cobbotVbn36XOskQR2F HTML5 Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2_-PqGSrVTgBpVshxpqQlw Mobile Responsive Form using HTML5 & CSS: https://youtu.be/SECTfL3R0B0 MS SQL Server Installation: https://youtu.be/rZRA692RmuU Clock Animation in PowerPoint : https://youtu.be/LM5iwzNqQQo Envelope Animation in PowerPoint : https://youtu.be/HWlqGGleQqs FACEBOOK PAGE https://www.facebook.com/ishwaracademy/
Views: 508 Ishwar Academy

Nifuratelis 200mg viagra
Nexium 20 mg vademecum
Thuoc citopam 20mg citalopram
Singulair 5mg chewable ingredients
Medicamento unisedil 5mg cialis