What are the manipulation functions in SQL?

0 votes
Hi!!

Can someone list the various manipulative functions in SQL?
Oct 11, 2018 in Database by darklord
• 6,140 points
364 views

1 answer to this question.

0 votes

There are three case manipulation functions in SQL, namely:

  • LOWER: This function returns the string in lowercase. It takes a string as an argument and returns it by converting it into lower case. Syntax:
 LOWER(‘string’)
  • UPPER: This function returns the string in uppercase. It takes a string as an argument and returns it by converting it into uppercase. Syntax:
UPPER(‘string’)
  • INITCAP: This function returns the string with the first letter in uppercase and rest of the letters in lowercase. Syntax:
 INITCAP(‘string’)
answered Oct 11, 2018 by DataKing99
• 8,100 points

Related Questions In Database

0 votes
1 answer

What are the different authentication modes in SQL Server? How can it be changed?

Windows mode and Mixed Mode – SQL ...READ MORE

answered Oct 29, 2018 in Database by darklord
• 6,140 points
46 views
0 votes
1 answer

What are the different types of join in SQL?

Hi Suraj, You have a doubt regarding inner join ...READ MORE

answered May 28 in Database by Sampriti
• 860 points
44 views
0 votes
1 answer

What are the ways to get the count of records in a table

To count the number of records in ...READ MORE

answered Sep 26, 2018 in Database by darklord
• 6,140 points
48 views
0 votes
1 answer

What are the different types of keys used in the database?

There are mainly 5 types of Keys, ...READ MORE

answered Nov 19, 2018 in Database by darklord
• 6,140 points
50 views
0 votes
1 answer

Which query to use for better performance, join in SQL or using Dataset API?

DataFrames and SparkSQL performed almost about the ...READ MORE

answered Apr 19, 2018 in Apache Spark by kurt_cobain
• 9,240 points
80 views
0 votes
1 answer

How to connect Java program to the MySQL database?

You can connect your Java code with ...READ MORE

answered May 11, 2018 in Java by parth295
• 4,600 points
122 views
0 votes
1 answer
0 votes
1 answer

Automating Oracle script with nolio

Depending upon the details of your script ...READ MORE

answered Jul 17, 2018 in Other DevOps Questions by ajs3033
• 7,240 points
35 views
0 votes
1 answer

What are the advantages of SQL?

Simple SQL queries can be used to ...READ MORE

answered Nov 8, 2018 in Database by DataKing99
• 8,100 points
117 views
+1 vote
1 answer

What are the data types in MySQL?

The Data Types of MySQL are as ...READ MORE

answered Dec 12, 2018 in Database by DataKing99
• 8,100 points
41 views