Home
Search results “Oracle size blob”
BLOB and CLOB in Oracle Database
 
03:13
BLOB and CLOB in Oracle Database
Views: 8585 Abe Samir's Academy
Working with Image in Oracle Apex 5.1 including Download option.
 
08:28
Simple but necessary demonstration how to include Images in Oracle Apex 5.1. Also show how to download the Image. Download Document Here : https://drive.google.com/file/d/1PJNmP0ovG_z1oJ5cwS-THfIZXrbw25-8/view?usp=sharing
Views: 5239 Oracle Testlab
PHP: Storing/Viewing Images Stored In A database (BLOB Data Type)
 
15:31
A video tutorial showing you how to store images inside a database using the BLOB data type. The showing you how to show that image on a page. http://www.abell12.com http://www.facebook.com/pages/Abell12/265102633605437
Views: 259168 abell12
Green Blob Outdoors tactical micro flip up front and rear Iron Sight Set
 
05:08
As an Amazon Associate I earn from qualifying purchases. Get it on Amazon here... http://geni.us/6f34qNa 6061 Aircraft Aluminum and T6 Heat treated Aluminum body Front Sight A2 post elevation adjustment Rear Sight Dual Aperture Windage Adjustment Front Sight: Weight: 1.5 oz Height: 1.7" Width: 1.5" Length: 1" , Rear Sight: Weight: 1.9 oz Height: 1.74" Width: 1.5" Length: 1"
Views: 17251 Peter von Panda
Displaying Image of Pdf Report in BI Publisher: Oracle -Apex 18.2
 
15:05
1. CREATE OR REPLACE FUNCTION pdf2img(p_blob IN BLOB) RETURN CLOB IS l_clob CLOB; l_step PLS_INTEGER := 12000; - make sure you set a multiple of 3 not higher than 24573 BEGIN FOR i IN 0 .. TRUNC((DBMS_LOB.getlength(p_blob) - 1 )/l_step) LOOP l_clob := l_clob || UTL_RAW.cast_to_varchar2(UTL_ENCODE.base64_encode (DBMS_LOB.substr(p_blob, l_step, i * l_step + 1))); END LOOP; RETURN l_clob; END; Mobile : 01554-767291
Oracle SQL Tutorial 33 - NUMBER Data Type
 
07:18
This video we are going to discuss the NUMBER data type. The Number data type is used to store integers, and real numbers. When you create a column as a NUMBER, you can store pretty huge or pretty small numbers in this column. Now there are two things you need to consider when working with numbers, and that is the precision as well as the how big the number is. For example, we can store the number 9.9. This has two significant digits. We could also store the number 9.9 X 10^4. In this situation, the number is much larger, but the number of significant digits is the same. 9.9 are the significant digits. When we expand this out we just have 99000, and the zeros are just used for size and are not considered "significant" in this situation. In fact, you get a max precision of 38, but a maximum value of 9.99 * 10^125. You can also use this data type to store very small numbers. Check the docs for the specifics on maximums and minimums. You can provide it with two pieces of information: Precision - The total number of digits. Scale - The number of digits to the right of the decimal. You do it in this format: NUMBER (precision, scale). The important thing to remember in this is that when you specify a precision, you will be limiting the max size of the numbers. The secret behind this data type is that it is actually stored in scientific notation. That is we store a number and then we can multiply it by 10 raised to some power. This allows us to store much larger numbers without taking up a ton of space. The oracle docs actually gives a formula that you can use to see how much storage is going to be required for a specific NUMBER data type. How much precision can be used? The acceptable range is 1-38. What about scale? The range is actually -84 to 127. I'll explain the scale in more detail in an upcoming video. That's because there is a lot of confusing things here…What does it mean for the scale to be negative? How can we have a scale that is bigger that the total number of digits available through the precision. That's a topic for another video. It's important to understand that when we increase our scale, we decrease the max size of the number. For example if we have a precision of 5 and a scale of 3, the highest number we can store is 99.999. This is in contrast to a precision of 5 and a scale of 2 which allows for up to 99.999. Either way you get 5 significant digits, but the numbers of digits to the left and right of the decimal change. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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: 8405 Caleb Curry
Jaspersoft Studio : Display Image (BLOB) in Report
 
02:50
Jaspersoft Studio : Display Image (BLOB) in Report More tutorials at www.thainetbeans.com/report
Views: 19097 Prakan Puvibunsuk
hibernate blob and clob
 
26:47
hibernate 3.x
Views: 128 Hiberante
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: 5726 Caleb Curry
SQL 048 Data Types, BLOB Compare Database Usage
 
02:22
Explains the data type BLOB or Binary Large Object. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 2401 cbtinc
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: 220 Prabhat Sahu
Oracle Database 18c Express Edition (XE)
 
02:45
Learn what's new in the latest release of Oracle Database 18c XE.
MySQL 27 - TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT
 
03:42
The TEXT data types have not yet been discussed, but they are another string data type. They are similar to the VARCHAR data type with some minor differences that are important to know. The first thing to note is that there are four versions used to determine different sizes. From least to greatest size is TINYTEXT, TEXT, MEDIUMTEXT, LARGETEXT. These each have different maximum byte sizes: 255, 65535, 16 million something, and 4 billion something. You create a column as one of these data types just as you would with a varchar column. You work with them exactly the same, too. If that is the case, what are the primary differences between these and VARCHAR? The first difference is that VARCHAR is restricted by the row limit of a table. TEXT tables do not contribute nearly as much (max of 12 bytes) because the data is not stored inline in the table. This means that if you need to allow for extra space for other rows, you can use a TEXT column. And even though the table only contains a pointer to the data, it is all hidden to us and working with a TEXT column is the same as working with a VARCHAR column. The second primary difference is that TEXT data types do not allow for a default other than NULL. Thirdly, VARCHAR is limited to just under 64KB, whereas you can use MEDIUMTEXT or LARGETEXT to allow for more storage. So if what you are trying to store as an individual value is over 64KB, use a text column. Other than those three things, VARCHAR will usually work just fine for our text needs. Now, last thing is that these data types are often called CLOB data types. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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: 5725 Caleb Curry
Oracle SQL Tutorial 24 - Important Data Types
 
06:09
In the upcoming videos we are going to discuss data types in depth, but I don't want to drown you in all of the details. Because of that, I'm giving you this video which is going to introduce you to the most important data types. Then, in the upcoming videos, I'll describe them in more depth. One of the data types we've already discussed in this video is NUMBER. This data type is used to, obviously, store a number. It can be used to store integers (whole numbers), or numbers with decimals. There are two other numeric data types you should know of. BINARY_FLOAT and BINARY_DOUBLE are both numeric data types that are known as floating point numbers. A floating point number is often used for large numbers that have decimal places where it is acceptable to not be completely precise. What I mean by this is that these numbers can only store numbers correctly up to a certain decimal point. If you need perfect precision, you will want to use the NUMBER data type. Now storing numbers is good sometimes, but occasionally you will want to store string data. String data can be any sequence of characters, including numbers. By telling the database that a column is a string data type, the database knows how to treat that column. There are four important string data types that you need to know about. The first two are CHAR and NCHAR. These data types are used to store a fixed-length string. So for example, you can say you want to store 12 characters. This means that every value for this column will be exactly 12 characters. If you insert less than 12 characters, the data will be padded with spaces. This means you will want to use one of these data types when every value in the column is the same length. What is the difference between CHAR and NCHAR? CHAR uses what is known as ASCII while NCHAR uses Unicode. The difference is what characters are allowed and how much space each character takes. ASCII takes up less space but only supports English, numbers, and some symbols. UNICODE allows you to store characters from multiple languages but takes up more space. Those were both fixed-length string. What if you want to store data that changes in length? That is where VARCHAR2 and NVARCHAR2 come in. When it comes to storing dates, the data types that are most important are DATE and TIMESTAMP. Date can be used to store dates and time. Timestamp is a data type that can be used to store an exact moment in time. Lastly, there are interval types. These store a date range. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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: 6938 Caleb Curry
HOW TO IMAGE UPLOAD IN ORACLE FORMS & STORE IT INTO DATABASE BANGLA TUTORIAL
 
09:28
THIS CLIP HELPS YOU TO UPLOAD IMAGE IN ORACLE FORMS 10G. THE EASY WAY TO STORE IMAGE IN DATABASE & RETRIEVE FROM. .FMB FILE INCLUDED. LINK: OFF-COMMENT: [SORRY FOR THE NOISE ]
Views: 15312 iModhu
Java JDBC Tutorial – Part 10: BLOB - Reading and Writing BLOB with MySQL
 
07:40
NEED TO LEARN JAVA? - 5 FREE JAVA VIDEO COURSES - CLICK HERE - https://goo.gl/7i95F8 --- View more videos on my "Java JDBC Tutorial" Playlist: http://goo.gl/crT4nS Download Java Source Code: http://www.luv2code.com/?p=1057 Follow Me on Twitter: https://twitter.com/luv2codetv Please SUBSCRIBE to this channel: https://www.youtube.com/user/luv2codetv?sub_confirmation=1 --- In this video tutorial we will learn how to use JDBC to read and write BLOB with MySQL. --- Transcript Time - 00:00 Hi, this is Chad (Shod) with luv2code.com. Welcome back to another tutorial on Java JDBC. In this video we're going to learn how to read and write BLOBs. For this tutorial we're going to use the employees table. I have a SQL script that will create the table and add sample data for you. You can download it from the link below. The file is sql/table-setup.sql. Time - 00:28 So what exactly is a BLOB? Well a BLOB is basically binary data that we store in the database. You normally use BLOBs to keep track of documents, images, audio, or any other binary object that you have. Note that not all databases have support for BLOBs. In this example we’re going to make use of MySQL and they have BLOB support. Time - 00:48 On this slide we will learn how to create a BLOB column. So when we create a table in MySQL we add a column with the BLOB data type. On this slide I want to learn how to write a BLOB to a database. For this example I'm going to add a resume for an employee. I'm going to read a local PDF file and I'll take that file and update the database with the binary data that's the actual content of PDF file. Let's walk through the code. Time - 01:17 At the beginning I’ll set up a SQL statement. I’ll say update employees set resume equals to question mark where the email address equals [email protected] We’re only going to make a change for this John Doe employee, set up a prepared statement, and then I go, we’re going to create a file that's an actual handle to the local file sample_resume.pdf. Then I’ll set, on my statement I’ll set the binary stream, that first parameter for the resume comma the input. That's the input stream I have for that file. Then I actually call my statement .executeUpdate. That will actually update the database with the binary data. Time - 01:54 All right so let's switch over to Eclipse and let’s look at a very simple demo. I have a program called WriteBlobDemo. In this program we're going to actually read a resume from a local file system and write it as a BLOB to the database. I’ll walk through the code here. The first thing we do is we get a connection to the database. We prepare a statement. We're going to update employees, set resume equals to question mark where email equals [email protected] So we’re going to update the resume for John Doe. Time - 02:22 Then I’ll move down, I’ll set up a file handle for this file sample_resume.pdf. I’ll set up an input stream on that file and then I’ll set that as the parameter for our binary stream for our prepared statement. Then I’ll move through and I’ll actually do an execute update. This will actually store this binary file from the file system into the actual database column. Time - 02:47 I just ran the application and here's the output of the program. So beginning it says that it’s reading the file and gives me the full path to the file just for sanity sake, I know which file is actually reading. Then it tells me that it's storing the resume in the database for our employee [email protected] and then it says that it completed successfully. Excellent. Time - 03:10 Now let's move over to MySQL tool and verify this. I'll take a look at the employees there in the database right now. l’ll run this query select * from employees and I'll get a list of the actual employees. Notice here for John Doe there’s an entry here for a resume, there's a BLOB entry. Note all the other entries are null. So we have a BLOB entry here. I can select this entry. I can right click. I can say, “Open Value in Editor” and it’s going to show me this BLOB. Again, it's a binary large object so we see all this binary data. Actually it should be displayed as hex. Time - 03:50 Instead of looking at it in this fashion there's a tab here called “Image.” I can select this tab and now it'll actually show me this image or the actual data as a PDF that I can view. This is the actual PDF document for this employee, John Doe. This looks really good. We know that we were successful in storing the BLOB in the actual database. Time - 04:18 Now that we know how to write BLOBs in the database let's learn how to read a BLOB from the database. In this example I'm going to read the employee’s resume from the database as a BLOB and then store it as a file on my local files system. Let's walk through the code. [snip] .... see the Transcripts tab for details.
Views: 58353 luv2code
TSQL: Get Table Size and Column Count
 
03:21
GitHub script: https://github.com/tmmtsmith/SQLServer/blob/master/Admin%20Tools/tspace.sql
Views: 918 SQLInSix Minutes
Oracle SQL Tutorial 23 - Intro to Data Types
 
05:03
Every column within a table has to be given what is known as a datatype. A data type is a fairly simple concept when you dissect the word. It is literally the type of data. Why do we use types, though? The biggest benefit is so that Oracle knows how to interpret and work with our data. It also makes the database better at rejecting incorrect data. If we had to concept of a data type, there would be a lot more work involved in forcing data to be of the right format. It would also be harder for us to get the database to treat the data in the correct way. In addition to this, a database can optimize storage and performance for a column if everything is of the same data type. Because of this, each column can only support one data type. There are numerous different data types in Oracle and it helps us if we categorize them. The first types of datatypes we should learn about are: String, Numeric, Temporal Now, there are few more categories we could make, but these are the main ones. We will worry about the other ones another day as I am only introducing the topic. A string data type is anything within quotes. Most databases use single quotes for string data. Inside of the quotes can be any number of characters. What is a character? Think of any letter, number, or symbol you can type. Some people call these letters, numbers, and symbols alphanumeric. Numeric data type includes only numbers. These data types are often used for data that you plan on using for mathematical calculations. Temporal data types are data types that are used for dates and times. Now, each data type is probably going to have some options you'll need to worry about, but one that comes up with every data type is storage. The reason we need to consider storage is because we may end up with millions of rows in a table and the difference between a few bytes for each row will make a huge difference when we look at the whole picture. When a data type gives you the option of size, you will want to a size that will be able to hold what you need, but nothing more. In the upcoming videos we are going to discuss the available data types in more detail. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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: 8307 Caleb Curry
How to display image on Report | Apex5
 
04:58
in this tutorial i'll show you how to display image in report of apex5. Code you needed: you get code on 1st comment.
Views: 4186 Raihan N Tarek
images (blob) in ApEx
 
05:15
how to add images in ApEx with help of "Form on a Table with Report"
Views: 18936 Петя Иванов
How to upload and retrieve image with database using servlet/jsp
 
12:47
For code comment your email address. How to upload and download file using Servlet/JSP with database link: https://www.youtube.com/watch?v=vfGWnZxhw9o How to upload and display blob image with database using servlet/jsp. link: https://www.youtube.com/watch?v=ROfQah8CV6k How to send email with attachment using servlet/jsp. link: https://www.youtube.com/watch?v=XDknUoNEVcs How to upload file in spring mvc framework. link: https://www.youtube.com/watch?v=le0nJWMGC3E How to upload and retrieve image with database using servlet/jsp https://www.youtube.com/watch?v=vfGWnZxhw9o
Views: 34696 Dharmesh Mourya
Oracle Database tutorial 67: How to create Tablespace using SQL Developer By RebellionRider
 
06:56
Learn (The easiest way)how to create tablespace in oracle database using Oracle SQL Developer GUI: SQL Developer trips and tricks tutorial ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/tablespace-using-sql-developer Previous Tutorial ► How to make SYS user Connection: http://bit.ly/how-to-create-new-connection-in-sql-developer ► Permanent tablespace https://youtu.be/vkwKZIssvfc ► Temporary Tablespace https://youtu.be/Hc_OXitKgWM ► Undo Tablespace https://youtu.be/HlSrHX7ffbI ------------------------------------------------------------------------- ►►►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 ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at 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: 32365 Manish Sharma
Lesson - 15 : JDBC -  How to insert and select image from Database
 
09:34
Inserting a picture is nothing but storing binary data(bytes) of the picture into a database table.In JDBC we need preparestatement interface for transferring binary data from java program to database.If we want to insert a picture into a table then that table column should be of blob(binary large object) type.The following are the steps required for inserting a picture 1. Creating a java.io.File object for the picture. 2. Create java.io.FileInputStream object for reading the binary data from the file. 3. Find size of the picture file. 4. Call setBinaryStream() for inserting binarydata of the picture into an SQL statement.
Views: 915 Sada Learning Hub
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: 10292 Zoran Marincic
Reclaiming free space from innodb tables
 
06:05
Reclaiming free space from innodb tables
Views: 167 Ask Guru
PLS-4: PL/SQL Variables
 
24:47
For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=5 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors ---------------------------------------------------------------------------------------- A variable is nothing but a name given to a storage area that our programs can manipulate. Each variable in PL/SQL has a specific data type, which determines the size and layout of the variable's memory; the range of values that can be stored within that memory and the set of operations that can be applied to the variable. The name of a PL/SQL variable consists of a letter optionally followed by more letters, numerals, dollar signs, underscores, and number signs and should not exceed 30 characters. By default, variable names are not case-sensitive. You cannot use a reserved PL/SQL keyword as a variable name. PL/SQL programming language allows to define various types of variables, which we will cover in subsequent chapters like date time data types, records, collections, etc. For this chapter, let us study only basic variable types. With PL/SQL you can declare variables and then use them in SQL and procedural statements anywhere that an expression can be used. Variables can be used for the following: • Temporary storage of data: Data can be temporarily stored in one or more variables for use when validating data input and for processing later in the data flow process. • Manipulation of stored values: Variables can be used for calculations and other data manipulations without accessing the database. • Reusability: After they are declared, variables can be used repeatedly in an application simply by referencing them in other statements, including other declarative statements. • Ease of maintenance: When using %TYPE and %ROWTYPE (more information on %ROWTYPE is covered in a subsequent lesson), you declare variables, basing the declarations on the definitions of database columns. If an underlying definition changes, the variable declaration changes accordingly at run time. This provides data independence, reduces maintenance costs, and allows programs to adapt as the database changes to meet new business needs. More information on %TYPE is covered later in this lesson. Types of Variables" All PL/SQL variables have a data type, which specifies a storage format, constraints, and valid range of values. PL/SQL supports four data type categories—scalar, composite, reference, and LOB (large object)—that you can use for declaring variables, constants, and pointers. • Scalar data types hold a single value. The main data types are those that correspond to column types in Oracle server tables; PL/SQL also supports Boolean variables. • Composite data types, such as records, allow groups of fields to be defined and manipulated in PL/SQL blocks. • Reference data types hold values, called pointers, that designate other program items. Reference data types are not covered in this course. • LOB data types hold values, called locators, that specify the location of large objects (such as graphic images) that are stored out of line. LOB data types are discussed in detail later in this course.
Views: 41878 Oresoft LWC
Oracle 12C New Feature Listagg function improvements
 
09:56
oracle 12c new features Queries used in the video are given in the blog link http://easy-learning-tech.blogspot.in/2018/04/oracle-12c-new-feature-listagg-function.html oracle 12c new features for developers
Views: 1040 Siva Academy
What Is The Use Of LOB In Oracle?
 
00:45
Introduction to lobs oracle help center. Use oracle lob's apache db project the software lobs and undo management not as simple i thought large objects (lobs). Using oracle lob data types with ojbbackgrounder large objects in databases. Htm url? Q webcache. Object datatypes and lobs oracle help center. Introduction to lobs oracle help center docs. Space usage of lobs, general behavior and in otm database lob space oracle dba scripts. Two type of lobs supported. This chapter contains these topics this describes the usage and semantics of lobs that you need to be familiar techniques use when accessing a cell in lob column differ table print_media oracle database sample schema pm, is used has introduced many new multi media datatypes, or datatypes if just as an indexing system file locations why not long raw difference between internal external. Those stored as operating system files, such bfiles large objects (lobs) are a set of datatypes that designed to hold amounts data. How to determine oracle lob storage footprint? Database and xmltype data types (oracle connector) ibm. Object data types and lobs oracle help centeroracle large object (lob) supportoracle lob working with blob clob devart. Oracle cd b10501_01 adl01int. Where is lob data stored? . [email protected] select count( ) from external tables containing lob data. Storing data in lobs enables you to access and manipulate the efficiently your application use lob (large object) columns store large amounts of (maximum existing long raw attributes is recommended by oracle this chapter introduces objects (lobs) discusses how types are used development. Lob types support both input and output streaming. A lob can hold up to a maximum size ranging from 8 terabytes 128 depending on how your database is configured. This articles shows how external tables are used to read clob and blob data, enabling parallel load operations of large 7 jan 2014 what is lob (large object) a group oracle database build in data types. Tanel poder's performance operations on tables and views that contain lob data in oracle finding table name for segment base external containing. The microsoft 12 apr 2012 so i have a lob segment taking up lots of space need to find out the corresposding table for. Using lob data types in oracle database allows user to store 14 sep 2011 how the dba can find size of a segment, space that is allocated and unused within if you've marked blob column as deduplicated then you run something like following get stats on actual bytes used connector supports reading writing bfile, blob, configure use inline form, set enable Introduction lobs help center. Your database the most 25 jan 2010 as soon old versions of lob data pages start to occupy more than pctversion amount used space, oracle tries further, oracle8 provides call interface (oci) and pl sql package internal s use copy semantics participate in transactional model 22 apr 2012 there was a question l about where is undo for rollback & consistency,
Oracle 12c new feature Identity column
 
09:48
Oracle 12c new feature Identity column oracle identity column identity columns in oracle 12c
Views: 223 Siva Academy
Oracle Forms tutorial in bangla How to Load image
 
14:10
Today we will learn how to load image in oracle forms Step 1: start your oc4j to run the forms builder and run your forms builder to load an image. Step 2: take a canvas to to load an image in your form module, step 3: create an image item in your canvas to load your images in a block. Step 4: set the properties palette of image style to adjust of the image item from toolbar to load images, step 5: rename your image item name as your sweet will. Step 6: create a Push Button to to load images. Step 7: take some photos from your hard drive and saves in a folder to get the images quickly. Step 8: now copy the path link and write your trigger in the Push button by using WHEN-BUTTON-PRESSED trigger to load images. Step 9: then compile your form to load images Step 10: Then run your form by clicking run, (before run you must log into your database). Step 11: After running your form just click the push button Step 12: Your image will view in your running browser. By this way you can load images in your form. Thanks for watching... Subscribe my Channel : Mahfujur Rahman Subscribe my channel : Mahfujur Rahman Thanks For Watching MdMahfujur Rahman Database Design and Development IDB-BISEW IT Scholarship Project. 01673472384
Views: 2982 Mahfujur Rahman
Image Slider | Oracle APEX 5.1
 
04:04
Slider with Images, Carousel on Oracle APEX 5.1 Oracle Application Express 5.1 is a great leap forward in end user productivity and introduces powerful new declarative features, enabling you to develop, design and deploy beautiful, responsive, database-driven desktop and mobile applications using only a browser.
Views: 644 abdul rafay
Basics of jdbc programming Tutorial-10(Storing a text file into oracle database)
 
10:36
this video deals with the overall idea of how the jdbc program is connected to the database in order to store a text file //storing of a text file to oracle database import java.sql.*; import java.io.*; class Jdbc { public static void main(String[] args) throws Exception { Connection con=null; PreparedStatement pst=null; try { Class.forName("oracle.jdbc.driver.OracleDriver"); con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "student","shubham123"); if(con!=null) { System.out.println("connection established"); pst=con.prepareStatement("update myfile set col1=? where col2=100"); } if(pst!=null) { System.out.println("preparedstatement object created"); File f=new File("f:\\hello.txt"); FileReader fr =new FileReader(f); pst.setCharacterStream(1,fr,(int)f.length()); System.out.println("file size="+f.length()); int i=pst.executeUpdate(); System.out.println(i+" records affected"); } } catch(SQLException e) { e.printStackTrace(); } catch(ClassNotFoundException e) { e.printStackTrace(); } catch(Exception e) { e.printStackTrace(); } finally { pst.close(); con.close(); } } }
Views: 129 Learn it by Fun
Install Oracle 11G R2 11.2.0.3 on Centos 7
 
55:11
Tutorial Install oracle 11G R2 11.2.0.3 Centos 7 Download Oracle 11g R2 11.2.0.3: cd /opt unzip p10404530_112030_Linux-x86-64_1of7.zip unzip p10404530_112030_Linux-x86-64_2of7.zip Prepare: -- Edit hosts file: Hosts File The "/etc/hosts" file must contain a fully qualified name for the server 127.0.0.1 localhost.localdomain localhost 10.84.70.152 stag-app01 Oracle Installation Prerequisites Automatic Setup -- install all the necessary prerequisites automatically then edit /etc/sysctl.conf và /etc/security/limit.conf yum install -y oracle-rdbms-server-11gR2-preinstall Manual Setup vi /etc/sysctl.conf add : fs.suid_dumpable = 1 fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 536870912 kernel.shmmni = 4096 # semaphores: semmsl, semmns, semopm, semmni kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default=262144 net.core.rmem_max=4194304 net.core.wmem_default=262144 net.core.wmem_max=1048586 Run : /sbin/sysctl -p Add line to file "/etc/security/limits.conf": oracle soft nproc 16384 oracle hard nproc 16384 oracle soft nofile 4096 oracle hard nofile 65536 oracle soft stack 10240 See more: https://github.com/phuongnguyenht/Oracle/blob/master/Install%20Oracle%20112030.md Fix Error: DB : pdksh-5.2.14 missing while installing 11g in RHEL-6.5 (64-bit) Change directory to /database/stage/cvu/cv/admin Backup cvu_config $ cp cvu_config backup_cvu_config Edit cvu_config and change the following line: from: CV_ASSUME_DISTID=OEL4 to: CV_ASSUME_DISTID=OEL6 Save the updated cvu_config file Install the 11.2.0.3 or 11.2.0.4 software using /database/runInstaller $ cd /database $ ./runInstaller “INS-35075: The specified SID is already in use” error in Oracle, how to fix it? Delete /etc/oratab How to increase swap size? Let's say you need another 500M: dd if=/dev/zero of=/tmp/swapfile bs=1M count=500 mkswap /tmp/swapfile swapon /tmp/swapfile After you're done installing, you can turn it off. swapoff /tmp/swapfile rm /tmp/swapfile From https://community.oracle.com/thread/2189824 *** Resolve Error in invoking target ‘agent_nmhs’ of makefile ins_emagent.mk*** vi /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk ... comment #$(MK_EMAGENT_NMECTL) to $(MK_EMAGENT_NMECTL) -lnnz11
Views: 239 Phuong Nguyen
HOW TO CREATE TABLE IN ORACLE
 
07:40
In this video we will see how to create table in oracle also PFB syntax and create table statement used in this video --CREATE TABLE SYNTAX CREATE TABLE TABLE_NAME ( COL1_NAME DATA_TYPE (LENGTH), COL2_NAME DATA_TYPE (LENGTH), COL3_NAME DATA_TYPE (LENGTH) ) ; CREATE TABLE STUDENT ( SNAME VARCHAR2(20), SROLLNO NUMBER(4,0), SCLASS VARCHAR2(20) );
Views: 67 DWBIADDA VIDEOS
Setting up data set to learn SQL in detail
 
09:30
As part of this video, we will see how to setup data set to learn sql in our workspace at apex.oracle.com github link: https://github.com/dgadiraju/code/blob/master/rdbms/oracle/load_schema.sql Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/itversityin https://twitter.com/itversity
Views: 588 itversity
Oracle APEX - File or Image Upload and View  APEX 18
 
05:32
When you upload image,its shows immediately Developer:Md.Abdullah Al Mamun (CSE)
Views: 3700 Oracle Apex
PL/PDF Oracle table rows and columns in PDF
 
05:05
How to implement the DOCX template for Oracle table printing in PDF. website: http://www.plpdf.com twitter: http://twitter.com/plpdf linkedin: https://www.linkedin.com/company/pl-pdf facebook: http://facebook.com/plpdf
Views: 904 PL/PDF
How to import or export binary data to or from your table? (Windows & Linux)
 
00:49
Navicat BLOB Viewer and Editor allow you to view, update, insert or delete BLOB data.
Views: 1752 Navicat Gui
Oracle Data Storage
 
09:58
CAPTIONS AVAILABLE - Full transcript (with some screenshots) available for a small fee at http://stores.lulu.com/konagora/. How Oracle stores your tables, how they grow, and how they can go bump.
Views: 8223 roughsealtd
ADF- Execute  Oracle PL-SQL in ADF Application- part2
 
21:30
----------------------------------------------------------------- Best regard Apps-Stuff Muhammad Yassein - Cairo - Egypt http://www.apps-stuff.com follow us on Facebook - Twitter with Appsstuff
Views: 4676 Appsstuff Middleware
Basics of jdbc programming Tutorial-11(Retrieving a text file from oracle database)
 
09:46
this video deals with the overall idea of how the jdbc program is connected to the database to retrieve a text file from the database. //Retrieving a text file from the oracle database import java.sql.*; import java.io.*; class Jdbc { public static void main(String[] args) throws Exception { Connection con=null; PreparedStatement pst=null; ResultSet rs=null; try { Class.forName("oracle.jdbc.driver.OracleDriver"); con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "student","shubham123"); if(con!=null) { System.out.println("connection established"); pst=con.prepareStatement("select * from myfile"); } if(pst!=null) { System.out.println("preparedstatement object created"); rs=pst.executeQuery(); rs.next(); Clob c=rs.getClob(1); System.out.println("File Size="+c.length()); Reader r=c.getCharacterStream(); int ch; FileWriter fw=new FileWriter("f://text.txt"); while((ch=r.read())!=-1) fw.write((char)ch); fw.close(); } } catch(SQLException e) { e.printStackTrace(); } catch(ClassNotFoundException e) { e.printStackTrace(); } catch(Exception e) { e.printStackTrace(); } finally { pst.close(); con.close(); } } }
Views: 66 Learn it by Fun
how to set digital clock or timer on oracle form
 
10:45
Oracle Guru Must like share and subscribe. how to set digital clock or timer on oracle form
Views: 156 Oracle Guru
Uni Posca Mini Paintings | Keely Elle
 
11:10
These drawings are available for rehoming, and would love to be hung up on your wall! The link to my shop where you can purchase them is below! (also if you buy one from this YT video, add in a message on your order saying "I came from youtube!" and I'll include you some freebies ;)) Hey thanks for checking out my video! If you like speedpaints, there is a whole playlist on my YouTube channel! If you want to see more of my work, check out the links below: Instagram: https://www.instagram.com/keely.elle/ Twitter: https://twitter.com/Keely_elle Tumblr: http://keely-elle.tumblr.com/ YouTube: https://www.youtube.com/channel/UCDjT-02uzfmOQJJnB7362rw Etsy Shop: https://www.etsy.com/shop/keelyelleworks -I was so excited to see that Thematic had Qveen Herby music available bc no joke, I've been listening to her on repeat for weeks--she is perfect. If you don't like the music choices in this video, feel free to mute it and put your own music on in the background instead of being a boner dethroner in my comments section thank youuu- Music: Music by Qveen Herby - SADE IN THE 90s - https://thmatc.co/?l=C28D84CA Music by Qveen Herby - Wifey - https://thmatc.co/?l=7391B969 Music by Qveen Herby - BDE - https://thmatc.co/?l=788B7D48 Music by Qveen Herby - Gucci - https://thmatc.co/?l=ED90EE1B Materials Used: Uni Posca 12 Pack 0.7 size https://www.amazon.com/gp/product/B001VB4T86/ref=ppx_yo_dt_b_asin_title_o08__o00_s00?ie=UTF8&psc=1 Prismacolor Col-Erase Pencils https://www.amazon.com/Prismacolor-Col-Erase-Erasable-24-Count-20517/dp/B000089DCH/ref=sr_1_3?keywords=prismacolor+colerase&qid=1549855915&s=office-products&sr=1-3 Canson Watercolor Paper https://www.amazon.com/Canson-Watercolor-Textured-Charcoal-100510941/dp/B004M59O4C/ref=sr_1_3?crid=5QMAXBZZOZZQ&keywords=canson+watercolor+paper&qid=1549855857&s=office-products&sprefix=canson+watercol%2Coffice-products%2C390&sr=1-3 All of the materials used in this video were purchased by myself, and do not reflect any type of sponsorship or otherwise biased opinions.
Views: 6510 Keely Elle
Migrating to Azure: Moving from on-premises SQL Server and Oracle databases to Azure - BRK3164
 
01:14:46
Azure SQL Database and managed instances allow you build globally scalable applications with extremely low latency. Azure SQL Database is the best cloud database offering in market. In this session, we take a detailed look at the migration lifecycle and show you how we have made it easy to migrate SQL Server and Oracle instances to Microsoft Azure by using the Azure Database Migration Service and related tools. We also cover most commonly seen migration blocking scenarios and demonstrate how our service can unblock your migration to Azure SQL Databases. We also deep dive into how to perform scale migrations using our CLI components.
Views: 1000 Microsoft Ignite
MYSQL Databases and Connection Pooling
 
09:37
● Visit my website: http://www.CosmosMC.net ● Join my server: playmc.cc ● HikariCP: https://github.com/brettwooldridge/HikariCP ● Tutorial class: https://github.com/sgtcaze/Tutorial/blob/master/Resources/HikariExample.java Connect with my social media: ● Twitter: http://www.twitter.com/sgtcaze ● Facebook: http://www.facebook.com/sgtcaze ● BukkitDev: http://dev.bukkit.org/profiles/sgtcaze/ ● Spigot: http://www.spigotmc.org/members/sgtcaze.2397/ ● GitHub: http://www.github.com/sgtcaze Additional Links ● Audio file(s) provided by http://www.audiomicro.com Computer Specs: ● CPU: Intel(R) Core™ i7-3770 3.40 GHz 8MB Intel Smart Cache LGA1155 ● GPU: NVIDIA GeForce GTX 560 Ti 1GB 16X PCIe Video Card ● Motherboard: [CrossFireX] ASUS P8Z77-V LX Intel Z77 ● RAM: 16 GB (4GB x 4) Corsair XMS Heatspreader ● HDD: 1TB SATA-III 6.0Gb/s 32MB Cache 7200RPM HDD ● SSD: OCZ Vertex 4 128 GB SATA-III 6.0Gb/s running Trim [BOOT] ● Mouse: Razer DeathAdder ● Keyboard: Razer Blackwidow 2013 Elite Hardware: ● Asus 20" (x2) 120 hz monitors ● Blue Snowball microphone ● Turtle Beach P11 headset ● Verbatim 500GB external drive. ● Playstation 3 ● Hauppauge HDPVR ● Insignia HD Speakers ● Polaroid 15" TV FAQ: A full FAQ can be found on my website (above). Here's a short list: ● How many FPS do you get? Because frames differ because of entity count (tile and living), here are a few (smooth lighting on, render distance on far): Hypixel Lobby: 200 FPS WoodyCraft Lobby: 180 - 200 FPS ● What programs do you use? Total Media Extreme to record my HDPVR, OBS to record my PC, Sony Vegas to edit, Audacity to capture audio, and Call Graph to record skype. ● What livestream software do you use? OBS free-ware. ● Where did you get your computer from? From CyberPowerPC.com. I've had no problems with my pc. I recommended some friends there, and they had no problems. ● What content do you provide? Primarily showcases on minecraft mods and plugins as well as Bukkit development tutorials. ● What is your Minecraft Texture pack/ how is it HD? I usually use either Faithful 32x or Sphax 128x.
Views: 15993 SgtCaze
Встроенные строковые SQL функции в базах данных SQLite
 
20:27
Помощь проекту: WMR: R288272666982 WMZ: Z293550531456 Яндекс.Деньги: 410011531129223 Рубрика SQLite на сайте: http://zametkinapolyah.ru/zametki-o-mysql/sqlite/ Паблик блога в ВК: https://vk.com/zametkinapolyah Тематическая группа в ВК: https://vk.com/zametki_bd -- Конкатенация при помощи оператора || SELECT 'Привет,' || ' мир!'; SELECT 'Привет,' || ' ' || 'мир!'; -- Кавычки можно экранировать другими кавычками SELECT '''Привет,'''|| ' мир!'; -- Или использовать другой вид кавычек SELECT "'Привет, '" || '"мир!"'; -- Поиск вхождения подстроки в строку instr -- Функция работает начиная с SQLite 3.7.15 SELECT instr('Привет, миР!', 'П'); SELECT instr('Привет, миР!', 'Р'); SELECT instr('Привет, мир!', 'р'); SELECT instr('Привет, миР!', 'вет'); SELECT instr('Привет, миР!', 'г'); -- если строки с типом BLOB, то функция возвращает число байт до первого вхождения подстроки плюс один байт -- Как узнать длину строки length SELECT length(543); SELECT length('543'); SELECT length(9); SELECT length('string'); SELECT length(NULL); SELECT length(TRUE); SELECT length(''); SELECT length(' '); -- для BLOB строк возвращает не количество символов, а количество байт -- Перевод строки в нижний регистр lower -- Функция работает только для символов ASCII, для других того, чтобы обеспечить поддержку других символовов, -- воспользуйтесь расширением ICU. SELECT lower('Привет, миР!'); SELECT lower('ПРИВЕТ, МИР!!!'); SELECT lower('Hello'); SELECT lower('HELLO'); -- Отрезать символы слева ltrim SELECT ltrim(' Привет, мир!'); SELECT ltrim(' Привет, мир!'); SELECT ltrim(' Привет, мир! '); SELECT ltrim(' Привет, мир! Еще одна часть строки '); SELECT ltrim(' ааааббббвввв', 'а'); SELECT ltrim('абвабвпетя абв', 'абв'); SELECT ltrim('абвабввввввПетя абв', 'абв'); SELECT ltrim(' 3453462000абвабввввввПетя абв', '0123456789'); -- Замена подстроки в строке replace replace(строка, удаляемая подстрока, вставляемая подстрока ) SELECT replace('Привет, мир!', 'мир', 'Вася'); SELECT replace('Привет, Мир!', 'мир', 'Вася'); SELECT replace('Привет, Мир!', 'Мир', 'Вася'); SELECT replace('абв абв абв', 'а', 'К'); SELECT replace('абв абв абв', 'А', 'К'); SELECT replace('123 123 123', 2, 5); SELECT replace('123 123 123', '2', '5'); -- Отрезать символы справа rtrim SELECT rtrim('Привет, мир! '); SELECT rtrim(' Привет, мир! '); SELECT rtrim(' Привет, мир! еще немного текста '); SELECT rtrim('1230000', 0); SELECT rtrim('1230000', '0'); -- Получить подстроку substr substr(строка, стартовая позиция, [ длина подстроки ] ) SELECT substr('Привет, мир!', 1, 3); SELECT substr('Привет, мир!', 1); SELECT substr('Привет, мир!', 5); SELECT substr('Привет, мир!', -1, 3); SELECT substr('Привет, мир!', 4); SELECT substr('Привет, мир!', 4, 2); SELECT substr('Привет, мир!', -4, 2); SELECT substr('Привет, мир!', -1, 1); -- Обрезать символы trim SELECT trim(' Привет, мир!'); SELECT trim(' Привет, мир! '); SELECT trim(' Привет, мир! Еще одна часть строки '); SELECT trim('ааааббббвввв ааа', 'а'); SELECT trim(' ааааббббвввв ааа', 'а'); SELECT trim('абвабвпетя ттт абв', 'абв'); SELECT trim('абвабввввввПетя абв', 'абв'); SELECT trim('3453462000абвабввввввПетя абв', '0123456789'); -- Перевести строку в верхний регистр upper -- Функция работает только для символов ASCII, для других того, чтобы обеспечить поддержку других символовов, -- воспользуйтесь расширением ICU. SELECT upper('Привет, миР!'); SELECT upper('привет, мир!!!'); SELECT upper('hello');
ITV Oracle Animated Dog short advert 1990
 
00:11
A shortened version of the animated dog advert for ITV's Oracle service. From 1990. I also uploaded the full length version.
Views: 52 David315842