Skip to main content

Scalar function in SQL

Scalar function

Scalar function:  Scalar function takes one or more parameters and returns a single value

 These functions are based on user input, these too returns single value.
  •  UCASE()
  • LCASE()
  •  MID()
  •  LEN()
  •  ROUND()
  •  NOW()
  •  FORMAT()

Comments

Post a Comment

Popular posts from this blog

What is Cyber Ethics ?

What is Cyber Ethics ? Cyber ethics is the study of ethics related to computers, covering user's behavior and what computers are programmed to do, and how this affects individuals and society. With the increase of young children using the internet, it is now very essential than ever to tell children about how to properly operate the internet and its dangers. It is especially hard to talk to teens because they do not want to be lectured about what is right and wrong. They seem to think they have it all sorts out. That is why is it is important to instill appropriate cyber etiquette at an early age but if you haven’t there is still time to tell to your child. Issues in Cyber Ethics :- Copyrighting and downloading another's content:-  Downloading the copyright product from the internet is came into the cyber crime.We don't know that how much illegal is this product is that we only have to use it though it will present in any place . Hacking :- Stealin...
Post a Comment
Read more

what is symmetric and asymmetric key cryptography?

Symmetric  key cryptography ?  Symmetric key cryptography is oldest method of encrypting the message.It is a simplest method that involves only one secret key.This secret key is a simple text like number,string,letter,etc. A simple example of symmetric key encryption is that suppose I want to send " hello " to someone then to encrypt it I will replace every text of this message into third text like for 'h' I will replace it with 'k' and 'e' with 'h' . so.. our message is : ----   Hello Encrypted message is :---khoor so if the unauthorised person read the encrypted message the he is not able to understand it .So our message is always be secure from unauthorized acess. Example :-  RC4, FISH, Py, QUAD, SNOW etc . Asymmetric key cryptography? Asymmetric encryption is also called public key cryptography.This is new technique instead of symmetric key cryptography.Asymmetric key cryptography uses two keys to encrypt the message .one is p...
Post a Comment
Read more

what is a public key encryption??

what is a public key encryption?? In public key encryption we have two keys: - one is public and another is private.We use these keys for secure communicating with each outher.Public key is used by sender to encrypt his message and private key is used by receiver to decript this message. Example :- Suppose I want to get message from many resources so  I will distribute public key to all the user who want to send me message and I keep private key to decrypt the message which user send to me.
Post a Comment
Read more