I need to decrease the character size from 17000 to 4000 with php, how to do this compression, and then be able to decode back to normal string length, I can not lose characters after decoding again.
I have the following query:
SELECT distinct CAPA.COD_HOLDING,
CAPA.COD_MATRIZ,
CAPA.COD_FILIAL,
CAPA.ID_NF_ENTRADA,
CAPA.NUM_NF,
CAPA.DT_ENTRADA,
CAPA.DT_EMISSAO,
CAPA.COD_CLIFOR,
CAPA.COD_UF,
CAPA.CGC_CPF,...
I'm doubtful in the date format that ODBC runs. I tried every way and nothing. This Query performs normal if I enter only the code, but when I want to insert dates it does not execute. I believe it's because of the format. Can someone help me?...
I use oracle 11g in the free version. According to database classes with oracle, the free version does not allow you to create a database. You can create user and create tables. Based on this, how do I back up these tables?
Example of the initia...
I'm trying to do this update, but I'm having trouble since I'm grateful for the help !!
UPDATE pctabpr set pctabpr.ptabela = (SELECT ptabela
FROM pcembalagem
WHERE p...
I need help. I have the USUARIO table, where I have the columns LOGIN , SENHA but I need to include the column called DATACRIACAO , but I would like to know how to insert this column DATACRIACAO after column L...
I have the PLSQL block below listed, the email is sent but the file that should be attached arrives empty in the destination email.
Send an existing file, right?
What am I doing wrong?
Thankful
declare
ds_email_origem_w varchar2(30)...
The table has composite primary key, and the fields are a date (ID_DEPURACAO) and a number (SEQ_DEPURACAO).
What I want to do is a sub-select that takes only data that is larger than a certain date and has sequences from a certain number....
Hello! I am trying to return people's names and the amount of cars each has according to the 2 tables below, but accuses the following error:
ORA-00979: not a GROUP BY expression
00979. 00000 - "not a GROUP BY expression"
Here ar...
How do I list all synonyms in my database? I need to know which ones are created to compare what exists between banks. I've tried the following code but it does not return synonyms:
select * from all_objects