Answers for "select into sql"

sql select into

Select * into Backup_of_Student_info from student_info

sql select syntax

select [all/distinct] <COL1>, <COL2>, <COL3>
from <TABLE_NAME>
[join <JOIN_CONDITION>]
[where <CONDITION>]
[group by <COLUMN_NAME>]
[having <SEARCH_CONDITION>]
[order by <SORT_SPECIFICATION>]


/*
Specifically for SQL -> Oracle

LEGEND: 
[...]   :   optional entries
<...>   :   your specific entry
*/

SELECT INTO

SELECT * INTO nome_da_tabela_que_estao_a_mexer_BKP
	FROM nome_da_tabela_que_estao_a_mexer

select into

Wed, 17 Mar 2021 15:19:22 GMT

Failed to execute target procedure ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "CMFIN_09.CMA_FICHA_MANTER", line 790
ORA-06512: at line 33

  DAD name: cmfin_09
  PROCEDURE  : CMA_FICHA_MANTER.inserir_trata
  URL        : http://rai-dc-appdev.gov.cv:80/cmfin_09/CMA_FICHA_MANTER.inserir_trata
  PARAMETERS :
  ===========
  sessid:
   20081725210350882001
  p_id:
   67828
  qual_utente:
   0
  p_marca:
   VOLKSWAGEN
  p_especie:
   AUTOMÓVEL
  p_cilindrada:
   3500
  p_matricula:
   st-00-ZL
  p_dt_matricula:
   23-02-2021
  p_registo:
   232
  p_memo:
   
  p_activo:
   on
  P_ANO_ISENCAO_JUROS:
   NULL
  p_utente_id:
   97610
   
   
   
   
  p_utente:
   Aderito Filipe Pina Goncalves
   
   
   
   
  btnConfirmar:
   32
   12

  ENVIRONMENT:
  ============
    PLSQL_GATEWAY=WebDb
    GATEWAY_IVERSION=2
    SERVER_SOFTWARE=Oracle-HTTP-Server-11g
    GATEWAY_INTERFACE=CGI/1.1
    SERVER_PORT=80
    SERVER_NAME=rai-dc-appdev.gov.cv
    REQUEST_METHOD=POST
    QUERY_STRING=
    PATH_INFO=/CMA_FICHA_MANTER.inserir_trata
    SCRIPT_NAME=/cmfin_09
    REMOTE_HOST=
    REMOTE_ADDR=10.0.28.8
    SERVER_PROTOCOL=HTTP/1.1
    REQUEST_PROTOCOL=HTTP
    REMOTE_USER=cmfin_09
    ORACLE_SSO_USER=
    OSSO_IDLE_TIMEOUT_EXCEEDED=
    OSSO_USER_GUID=
    HTTP_CONTENT_LENGTH=402
    HTTP_CONTENT_TYPE=application/x-www-form-urlencoded
    HTTP_USER_AGENT=Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36
    HTTP_HOST=nosiappsdev.gov.cv
    HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9
    HTTP_ACCEPT_ENCODING=gzip, deflate, br
    HTTP_ACCEPT_LANGUAGE=pt-PT,pt;q=0.9,en-US;q=0.8,en;q=0.7
    HTTP_ACCEPT_CHARSET=
    HTTP_COOKIE=acgroupswithpersist=nada; nosimail=9FEEF8C6ECD9855F2C41AF7EF44E7F46E74C36F0; iNavigate_=1; iNavigate__35=0; acopendivids=Q4; nosiactiv=ADERITO.GONCALVES; iNavigate__11=0; iNavigate__16=0; iNavigate__57=0; iNavigate__18=0; iNavigate__58=0; iNavigate__34=0; iNavigate__12=0; iNavigate__62=0; iNavigate__39=0; iNavigate__50=0; iNavigate__36=0; iNavigate__40=0; iNavigate__31=0; iNavigate__17=0; iNavigate__48=0; iNavigate__9=0; iNavigate__10=0; iNavigate__21=0; iNavigate__13=0; iNavigate__15=0; iNavigate__6=0; iNavigate__8=0; iNavigate__5=0; iNavigate__1=0; iNavigate__2=0; iNavigate__4=0; iNavigate__51=0; iNavigate__7=0; iNavigate__59=1; iNavigate__3=1; nosisso=BDBD7948A39B8E33E0530100007FE03E
    HTTP_IF_MODIFIED_SINCE=
    HTTP_REFERER=https://nosiappsdev.gov.cv/cmfin_09/CMA_FICHA_MANTER.show?sessid=20081725210350882001
    HTTP_SOAPACTION=
    HTTP_ORACLE_ECID=
    HTTP_ORACLE_CACHE_VERSION=
    HTTP_AUTHORIZATION=
    WEB_AUTHENT_PREFIX=
    DAD_NAME=cmfin_09
    DOC_ACCESS_PATH=docs
    DOCUMENT_TABLE=rh_funcionarios_upload
    PATH_ALIAS=
    REQUEST_CHARSET=WE8MSWIN1252
    REQUEST_IANA_CHARSET=WINDOWS-1252
    SCRIPT_PREFIX=
    HTTP_IF_MATCH=
    HTTP_CACHE_CONTROL=
    SOAP_BODY=
    HTTP_X_ORACLE_DEVICE_CLASS=
    HTTP_X_ORACLE_DEVICE_ORIENTATION=
    HTTP_X_ORACLE_DEVICE_MAXDOCSIZE=
    HTTP_X_ORACLE_DEVICE=
    HTTP_X_ORACLE_ORIG_ACCEPT=
    HTTP_X_ORACLE_ORIG_USER_AGENT=
    HTTP_X_ORACLE_USER_LOCALE=
    HTTP_X_ORACLE_USER_NAME=
    HTTP_X_ORACLE_USER_DISPLAYNAME=
    HTTP_X_ORACLE_USER_USERKIND=
    HTTP_X_ORACLE_USER_AUTHKIND=
    HTTP_X_ORACLE_USER_DEVICEID=
    HTTP_X_ORACLE_USER_LOCATION_ADDRESSLINE1=
    HTTP_X_ORACLE_USER_LOCATION_ADDRESSLINE2=
    HTTP_X_ORACLE_USER_LOCATION_ADDRESSLASTLINE=
    HTTP_X_ORACLE_USER_LOCATION_BLOCK=
    HTTP_X_ORACLE_USER_LOCATION_CITY=
    HTTP_X_ORACLE_USER_LOCATION_COMPANYNAME=
    HTTP_X_ORACLE_USER_LOCATION_COUNTY=
    HTTP_X_ORACLE_USER_LOCATION_STATE=
    HTTP_X_ORACLE_USER_LOCATION_POSTALCODE=
    HTTP_X_ORACLE_USER_LOCATION_POSTALCODEEXT=
    HTTP_X_ORACLE_USER_LOCATION_COUNTRY=
    HTTP_X_ORACLE_USER_LOCATION_TYPE=
    HTTP_X_ORACLE_USER_LOCATION_X=
    HTTP_X_ORACLE_USER_LOCATION_Y=
    HTTP_X_ORACLE_SERVICE_HOME_URL=
    HTTP_X_ORACLE_SERVICE_PARENT_URL=
    HTTP_X_ORACLE_HOME_URL=
    HTTP_X_ORACLE_MODULE_CALLBACK_URL=
    HTTP_X_ORACLE_MODULE_CALLBACK_LABEL=
    HTTP_X_ORACLE_CACHE_USER=
    HTTP_X_ORACLE_CACHE_SUBID=
    HTTP_X_ORACLE_CACHE_AUTH=
    HTTP_X_ORACLE_CACHE_DEVICE=
    HTTP_X_ORACLE_CACHE_LANG=
    HTTP_X_ORACLE_CACHE_ENCRYPT=
    HTTP_X_ORACLE_ASSERT_USER=