sql
Question: I have a question to generate a report, I need it to take the data from an SQL table and instead of the table name I need its ID, below the data that the query generates COD_CLIENTE NOME ENDERECO CPF ———————————————————————– 2 Fulano Av. Rio Branco 2837462890 3 Ciclano …
Question: I need to create a schedule where I allocate a service provider to work for a client. For example: PrestadorDeServicos João will provide services to the customer condominium vale do sol on March 15, 2016 from 10:00 am to 12:00 pm . João cannot be registered on the same …
sql – How to check if there is a schedule in a time range? Read More »
Question: I'm not able to put the result of a select inside a variable. I want to add the turno column inside my WHERE . The problem is that I get the value of @turnos in the following 3 formats: 1 – 'A' 2 – 'A','B' 3 – 'A','B','C' Current …
Question: There is an ID field in some Tab table, some numbers are missing, for example: 1,2,4,5,6,8 How to choose numbers 3 and 7? I made such a request for a long time and now I can’t remember how)) I remember there was ID + 1 in the condition Answer: …
Question: There is a table like this: create table email_stats ( id bigserial primary key, mailing_list_id int not null, sended_date timestamp not null, emails_send bigint not null default 0, emails_clicks bigint not null default 0 ); Now we need to add a new field to it. So the task is …
How to add a field to a large PostgreSQL table without locking? Read More »
Question: I made a View to send to a client, but I can't pass the login and general access password to the same. In this way I created a user ( cliente_view ) and I would like it to view only the View created (View_consulta_vendas). How to do this process …
How to make a user in SQL Server 2008 see only one VIEW? Read More »
Question: It is necessary to insert values into the table from the collection declared in the package. I create the following: create table t_test (col01 number, col02 number); create or replace package pack is type numtab is table of number; function getnt (arg numtab) return numtab pipelined; end pack; / …
Using Collections of Packages Declared in the PL/SQL Specification in SQL Context Read More »
Question: Please tell me how to change the following code : with temp as ( select 108 Name, ‘test’ Project, ‘string-1 , string-2 ; string-3’ Error from dual union all select 109, ‘test2’, ‘single string’ from dual ) select distinct t.name, t.project, trim(regexp_substr(t.error, ‘[^,;]+’, 1, levels.column_value)) as error from temp …
Question: I have a ESTOQUE table containing a field called QTDE , this field has 3 decimal places. What would be the command to return directly from SQL formatted with 3 places? Because the integer values are returning without the places. I use: Firebird 2.0 / Field: Decimal(15,3) Answer: Try …
Format decimal places directly in SQL command in Firebird Read More »
Question: When I didn't know much about the issue of database structure and relationship between tables, I used to use JSON or comma-separated data in a certain field of any table in the database. I actually remember a specific case where I needed to relate multiple images to a particular …
