Oracle Tutorial for Beginners: 2017

Sunday, September 10, 2017

What is MySQL and Why It Is the World’s Most Popular Open Source Database

MySQL? What?

My is the daughter’s name of the MySQL’s co-founder, Monty Widenius.

The name of MySQL is the combination of My and SQL, MySQL.

The MySQL is a DBMS (database management system) that allows you to manage RDBMS (relational databases). MySQL is open source Database software backed by Oracle. It means you can use MySQL without paying a money. In addition, if you want, you can change its source code to fullfile your needs.

If you have need any support so you can buy a commercial license version software from Oracle to get a premium support services.

MySQL is very easy to master in comparison with other DB software like Oracle DB, or Microsoft SQL Server.

MySQL support to various platforms like Linux, UNIX, Windows, etc. You can install it in a server or even in a desktop. In addition, MySQL is reliable, scalable, and fast database software.

The legally way to pronounce MySQL is My Ess Que Ell, not My Sequel. However, you can pronounce it whatever you like, who care?

If you develop any type of websites or web applications, MySQL database is a good choice. MySQL is an important component of LAMP stack, which includes Apache, Linux, MySQL, and PHP.

Sunday, August 27, 2017

Using DG-Broker how to switchover Primary and standby roles step by step

How to switchover database role in DataGuard using DGMGRL ( DATA GUARD BROKER) STEP BY STEP.

Tuesday, August 22, 2017

How to configure Oracle 12c DataGuard Part-2 YouTube !

Tuesday, May 23, 2017

Oracle Tutorial - How to make a Login script for Oracle Database

Hello Friends in this video i'm going to demonstrate you how to make a auto login script for oracle database step by step.

For more detail please visit on following link.

www.ocptechnology.com

Thursday, April 27, 2017

How to import the dumpfile if the Database version are not same

Hello Friends in this video i'm going to show you how to import the dumpfile if the Database version are not same step by step.

oracle training for beginners

www.ocptechnology.com

Sunday, April 9, 2017

How to split the datapump dumpfiles || limit the file size of dumpfile i...

Hello Dosto,

In this video i'm going to demonstrate you how to export dumpfile in multiple files and how to export in multiple directories step by step,

For more detail you can visit on my official website www.ocptechnology.com

How to split the Data-Pump Dump-Files into multiple files and in multiple Directories ?

$expdp dumpfile=DATA_PUMP_DIR:OCP_1.dmp, OCPTECH:OCP_2.dmp logfile=OCPTECH:OCP.log

Use above command to export dumpfile into multiple directories.

Monday, March 27, 2017

How to make a password protected ZIP or RAR file || zip ya rar file par ...

How to make a password protected ZIP or RAR file || zip ya rar file par password Kaise Lagaye

Namaskar Dosto zip ya rar file par password Kaise Lagaye

Please subscribe for support.

Sunday, March 26, 2017

How to make a pdf password protected & how to convert a Document into pdf

Namaskar Dosto Is video main aap ko BataNe Ja Raha Hoon PDF file ko password Kaise Lagate Hain, or Document file ko PDF file me kaise convert Karte Hain and document file ko password protected kaise banaate hain?

Sunday, March 19, 2017

SQL TUTORIAL - CHARACTER FUNCATIONS

SINGLE ROW FUNCTIONS PART-2

www.ocptechnology.com

SQL Character Function

Character Function: Accept only Character type values and return in character and number both.

I. Concat: Joins two or more values together & using minimum two parameters with concat.

Ex. SELECT  CONCAT('OCP','TECHNOLOGY') FROM DUAL;

Above query will return OCPTECHNOLOGY as output.

II. Substr: Retrieve a string of specified length.

Ex. SELECT SUBSTR('OCPTECHNOLOGY',1,3) FROM DUAL;

Above query will return OCP as output.

III. Length: Calculate a lenth of a string as a numeric value.

Ex. SELECT LENGTH('OCPTECHNOLOGY') FROM DUAL;

Above query will return 13 as output.

IV. Instr: Shows the position of a named character in number.

Ex. SELECT INSTR('OCPTECHNOLOGY','T') FROM DUAL;

Above query will show you 3 as output.

V. Lpad: left pad shows the character value just right justified.

Ex. SELECT LPAD(SAL,10,'*') FROM EMP;

Suppose salary is 35000 rupees, show above query will return like *****35000 as output.

VI. Rpad: right pad shows the character value jus left justified.

Ex. SELECT RPAD(SAL,10,'*') FROM EMP;

Suppose salary is 35000 rupees, show above query will return like 35000***** as output.

VII. Replace: It’s just replace the value same like MS WORD.

Ex. SELECT REPLACE('BLACK AND BLUE','BL','J') FROM DUAL;

Above query will return JACK AND JUE as output.

VIII. Trim: It’s just trim a character or heading or both from a character string.

Ex. SELECT TRIM('O' FROM 'OCPTECHNOLOGY') FROM DUAL;

Above query will return CPTECHNOLOGY as output.

Saturday, March 18, 2017

PASS ANY INTERNATIONAL CERTIFICATIONS || ORACLE CERTIFICATIONS, REDHAT C...

Oracle certification preparations.

SQL CERTIFICATIONS.

SQL EXPERT CERTIFICATIONS.

ORACLE OCA CERTIFICATIONS,

ORACLE OCP CERTIFICATIONS,

ORACLE OCM CERTIFICATIONS,

PREPARE YOUR CERTIFICATION AND CLEAR YOUR EXAM

oracle 1z0-051, 1z0-052, 1z0-060, 1Z0-062,

Tuesday, March 7, 2017

How to get large YouTube video thubnail when shared on facebook

Hello Dosto eas video me hum apko btane ja rehe hai kese ap apni YouTube video k liye ek pyara sa thumnail bna shakte hai wo bhi free me.

Agar apko video pasand aye to please like ker dijiye or channel ko subscribe bhi ker lijiye.

Saturday, March 4, 2017

How to create a Website | Blog in 10 minuts | In Hindi

Subscribe for support

www.ocptechnology.com

YouTube Channel

https://www.youtube.com/channel/UCpQUgyIXnAf1YEeXkC8NkHg