7 uniones SQL

 7 uniones SQL que debes conocer

1- Unión interna: recupera registros con valores coincidentes en ambas tablas.

2- Unión izquierda: recupera todos los registros de la tabla izquierda y los registros coincidentes de la tabla derecha.

3´- Combinación izquierda con comprobación nula: filtra solo los registros en los que no hay ninguna coincidencia en la tabla derecha (valores NULL).

Insertar símbolo de euro con Oracle SQL LOAD

I'm loading a csv file using sqlldr. the file contains the symbol "€" which is inserted into a VARCHAR2 column. After the load, the database displays '¿' instead of the euro symbol. I have specified the characterset in the control file during the load:

LOAD DATA 

CHARACTERSET WE8MSWIN1252

I'm runing all of this on a Solaris machine, which by the way can't display the '€' symbol, I gives me a '.' instead when I hit the key to get the €.

VIGILANCIA DIGITAL

 Vídeo que te cuentan: ¿CARTERA DIGITAL O VIGILANCIA DIGITAL? - Vlog de Marc Vidal

Vídeo: 

Título: "¿CARTERA DIGITAL O VIGILANCIA DIGITAL? - Vlog de Marc Vidal" 

Enlace: https://www.youtube.com/watch?v=_5Ga82dzLnA

List of Number Format Elements in Oracle

Below is a full list of the format elements that can be used to format numbers in Oracle Database.

Element Example Description

, 9,999 Returns a comma in the specified position. You can specify multiple commas. A number format model cannot begin with a comma. Also, a comma cannot appear to the right of a decimal character or period.

. 99.99 Returns a decimal point, which is a period (.) in the specified position. Only one period is allowed in a number format model.

$ $9999 Returns value with a leading dollar sign.

0 099990 Returns leading zeros and/or trailing zeros.

Formato de numeros con moneda en Oracle

 Oracle Database provides the TO_CHAR(number) function that enables you to format numbers based on a given format model. There are three format elements that you can use with the TO_CHAR() function in order to return a value as a currency.

The currency format elements are L, C, and U.

C Returns the ISO currency symbol (the current value of the NLS_ISO_CURRENCY parameter).

L Returns the local currency symbol (the current value of the NLS_CURRENCY parameter).

U Returns the Euro (or other) dual currency symbol, determined by the current value of the NLS_DUAL_CURRENCY parameter.

Funciones con cadenas de texto en Oracle

Oracle String Functions. 

Ver la web: 

https://www.oracletutorial.com/oracle-string-functions/

This tutorial provides you the most commonly used Oracle string functions that help you manipulate character strings more effectively.

Estan en la siguiente tabla: 

ASCIISTR() Function in Oracle

 In Oracle Database, the ASCIISTR() function returns an ASCII version of the given string in the database character set. 

Syntax

The syntax goes like this:

ASCIISTR(char)

Where char is a string or an expression that resolves to a string, in any character set.

Non-ASCII characters are converted to the form \xxxx, where xxxx represents a UTF-16 code unit.