Databases
StackOverflow2013
Postsdbo
POIs it possible to get the maximum possible length of a variable
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIs it possible to get the maximum possible length of a variable
    primarykey
    data
    text
    <p>I was wondering if a function giving the maximum length of a variable exists in plsql.</p> <p>For example, if I declare</p> <pre><code>DECLARE varia VARCHAR2(7) BEGIN call of a function that would return 7 END </code></pre> <p>even though varia is null, I could get the length 7 of the varchar.</p> <p>--- exemple</p> <pre><code>create or replace TYPE ENREG_320_03 UNDER ENREG_320_BASE( date_creation VARCHAR2(8), raison_sociale_emetteur VARCHAR2(35), adresse_emetteur_1 VARCHAR2(35), adresse_emetteur_2 VARCHAR2(35), adresse_emetteur_3 VARCHAR2(35), num_siret VARCHAR2(14), ref_remise VARCHAR2(16), code_bic_emetteur VARCHAR2(11), type_ident_compte_debit VARCHAR2(1), ident_compte_debit VARCHAR2(34), code_devise_compte_debit VARCHAR2(3), ident_client VARCHAR2(16), type_ident_compte_frais VARCHAR2(1), ident_compte_frais VARCHAR2(34), code_devise_compte_frais VARCHAR2(3), zone_reserve VARCHAR2(16), indice_type_debit_remise VARCHAR2(1), indice_type_remise VARCHAR2(1), date_execution_souhait VARCHAR2(8), devise_transfert VARCHAR2(3), MEMBER FUNCTION get_date_creation RETURN VARCHAR2 AS BEGIN RETURN CASE WHEN SELF.date_creation IS NULL THEN lpad(' ', 8, ' ') ELSE rpad(SELF.date_creation, 8, ' ') END; END get_date_creation; MEMBER FUNCTION get_raison_sociale_emetteur RETURN VARCHAR2 AS BEGIN RETURN CASE WHEN SELF.raison_sociale_emetteur IS NULL THEN lpad(' ', 35, ' ') ELSE rpad(SELF.raison_sociale_emetteur, 35, ' ') END; END get_raison_sociale_emetteur; MEMBER FUNCTION get_adresse_emetteur_1 RETURN VARCHAR2 AS BEGIN RETURN CASE WHEN SELF.adresse_emetteur_1 IS NULL THEN lpad(' ', 35, ' ') ELSE rpad(SELF.adresse_emetteur_1, 35, ' ') END; END get_adresse_emetteur_1; MEMBER FUNCTION get_adresse_emetteur_2 RETURN VARCHAR2 AS BEGIN RETURN CASE WHEN SELF.adresse_emetteur_2 IS NULL THEN lpad(' ', 35, ' ') ELSE rpad(SELF.adresse_emetteur_2, 35, ' ') END; END get_adresse_emetteur_2; MEMBER FUNCTION get_adresse_emetteur_3 RETURN VARCHAR2 AS BEGIN RETURN CASE WHEN SELF.adresse_emetteur_3 IS NULL THEN lpad(' ', 35, ' ') ELSE rpad(SELF.adresse_emetteur_3, 35, ' ') END; END get_adresse_emetteur_3; MEMBER FUNCTION get_num_siret RETURN VARCHAR2 AS BEGIN RETURN CASE WHEN SELF.num_siret IS NULL THEN lpad(' ', 14, ' ') ELSE rpad(SELF.num_siret, 14, ' ') END; END get_num_siret; MEMBER FUNCTION get_ref_remise RETURN VARCHAR2 AS BEGIN RETURN CASE WHEN SELF.ref_remise IS NULL THEN lpad(' ', 16, ' ') ELSE rpad(SELF.ref_remise, 16, ' ') END; END get_ref_remise; MEMBER FUNCTION get_code_bic_emetteur RETURN VARCHAR2 AS BEGIN RETURN CASE WHEN SELF.code_bic_emetteur IS NULL THEN lpad(' ', 11, ' ') ELSE rpad(SELF.code_bic_emetteur, 11, ' ') END; END get_code_bic_emetteur; MEMBER FUNCTION get_type_ident_compte_debit RETURN VARCHAR2 AS BEGIN RETURN CASE WHEN SELF.type_ident_compte_debit IS NULL THEN lpad(' ', 1, ' ') ELSE rpad(SELF.type_ident_compte_debit, 1, ' ') END; END get_type_ident_compte_debit; MEMBER FUNCTION get_ident_compte_debit RETURN VARCHAR2 AS BEGIN RETURN CASE WHEN SELF.ident_compte_debit IS NULL THEN lpad(' ', 34, ' ') ELSE rpad(SELF.ident_compte_debit, 34, ' ') END; END get_ident_compte_debit; MEMBER FUNCTION get_code_devise_compte_debit RETURN VARCHAR2 AS BEGIN RETURN CASE WHEN SELF.code_devise_compte_debit IS NULL THEN lpad(' ', 3, ' ') ELSE rpad(SELF.code_devise_compte_debit, 3, ' ') END; END get_code_devise_compte_debit; MEMBER FUNCTION get_ident_client RETURN VARCHAR2 AS BEGIN RETURN CASE WHEN SELF.ident_client IS NULL THEN lpad(' ', 16, ' ') ELSE rpad(SELF.ident_client, 16, ' ') END; END get_ident_client; MEMBER FUNCTION get_type_ident_compte_frais RETURN VARCHAR2 AS BEGIN RETURN CASE WHEN SELF.type_ident_compte_frais IS NULL THEN lpad(' ', 1, ' ') ELSE rpad(SELF.type_ident_compte_frais, 1, ' ') END; END get_type_ident_compte_frais; MEMBER FUNCTION get_ident_compte_frais RETURN VARCHAR2 AS BEGIN RETURN CASE WHEN SELF.ident_compte_frais IS NULL THEN lpad(' ', 34, ' ') ELSE rpad(SELF.ident_compte_frais, 34, ' ') END; END get_ident_compte_frais; MEMBER FUNCTION get_code_devise_compte_frais RETURN VARCHAR2 AS BEGIN RETURN CASE WHEN SELF.code_devise_compte_frais IS NULL THEN lpad(' ', 3, ' ') ELSE rpad(SELF.code_devise_compte_frais, 3, ' ') END; END get_code_devise_compte_frais; MEMBER FUNCTION get_zone_reserve RETURN VARCHAR2 AS BEGIN RETURN CASE WHEN SELF.zone_reserve IS NULL THEN lpad(' ', 16, ' ') ELSE rpad(SELF.zone_reserve, 16, ' ') END; END get_zone_reserve; MEMBER FUNCTION get_indice_type_debit_remise RETURN VARCHAR2 AS BEGIN RETURN CASE WHEN SELF.indice_type_debit_remise IS NULL THEN lpad(' ', 1, ' ') ELSE rpad(SELF.indice_type_debit_remise, 1, ' ') END; END get_indice_type_debit_remise; MEMBER FUNCTION get_indice_type_remise RETURN VARCHAR2 AS BEGIN RETURN CASE WHEN SELF.indice_type_remise IS NULL THEN lpad(' ', 1, ' ') ELSE rpad(SELF.indice_type_remise, 1, ' ') END; END get_indice_type_remise; MEMBER FUNCTION get_date_execution_souhait RETURN VARCHAR2 AS BEGIN RETURN CASE WHEN SELF.date_execution_souhait IS NULL THEN lpad(' ', 8, ' ') ELSE rpad(SELF.date_execution_souhait, 8, ' ') END; END get_date_execution_souhait; MEMBER FUNCTION get_devise_transfert RETURN VARCHAR2 AS BEGIN RETURN CASE WHEN SELF.devise_transfert IS NULL THEN lpad(' ', 3, ' ') ELSE rpad(SELF.devise_transfert, 3, ' ') END; END get_devise_transfert; </code></pre> <p>So I was wondering if a simple function existed to get the size of the field so I dont have to use numbers in the getters : if the size of the fields is changed, there would be no need to change the getters, it would work out whatever the size of the varchar</p> <p>But I understand it is not possible</p> <p>Thank you to everyone</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmlwacosmos
    1. USmlwacosmos
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POIs it possible to get the maximum possible length of a variable
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POIs it possible to get the maximum possible length of a variable
      1. USkpater87
      1. VTFavorite
    3. VO
      singulars
      1. POIs it possible to get the maximum possible length of a variable
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThat's sort of an odd requirement. The size is right there, why do you need a function call for it?
      singulars
      1. POIs it possible to get the maximum possible length of a variable
      1. USMat
    2. CObecause, if someday the size changes, there is another part of the code that does not need to be changed
      singulars
      1. POIs it possible to get the maximum possible length of a variable
      1. USmlwacosmos
    3. COCan you declare the variable (and the other part of the code, which I assume is another variable too) based on a column in a table; e.g. `declare varia tab.col%TYPE`? Then all references would be altered if the table definition changed. Depends how you're using it of course - if you need a maximum value for a substr when populating, for example, then you'd be a bit stuck.
      singulars
      1. POIs it possible to get the maximum possible length of a variable
      1. USAlex Poole
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload