Questions tagged as 'sql'

Tagged questions
1
answer

Delete in sql - Inner Join

How is the syntax of a query using Inner Join delete in sql, to compare two-table code and exclude to be equal? Sales item table. in the item sale table, a sale has been registered whose code is 4. To execute the reversal, if applicable, the...
asked by 27.05.2017 / 20:56
1
answer

Create transform view by deleting or transforming DATE into VARCHAR in ORACLE

I have a table with 58 different columns and would like to create a View that treats the DATE fields as VARCHAR , without my having which discriminate all columns in the View creation. CREATE VIEW VW_TESTE AS SELECT * FROM TABELA...
asked by 17.05.2017 / 19:06
0
answers

The "Bank" database is not accessible. (ObjectExplorer)

I created a new windows 10 local account. With this new account I can not access the database. Because the old Windows 10 account was in trouble. This is why I created a new local windows account. (New user) Former local windows account was "...
asked by 25.05.2017 / 20:35
1
answer

How to select records from a table in the uppercase in postgres?

I need to select all the records in a table where the letters of a particular column are in the uppercase (upper case). Is there a function that differentiates between uppercase and lowercase in POSTGRES ? Here is the image of my table:...
asked by 25.05.2017 / 21:13
0
answers

How to create a new database in ORACLE?

I installed the oracle database, oracle client, and sql developer on a windows 8.1 64 bit. With the installation of the oracle database a database was created in localhost: 1521 But now I would like to create a new database on this connect...
asked by 08.06.2017 / 17:23
0
answers

Help with combos boxes Database in php in two forms!

Is there any way to use two combo boxes to vary one of the other type in this example (Two combo boxes where one varies the other using 2 forms cant use ajax); Thisismydatabase(Mydatabase) <!DOCTYPEhtml>/*<html><head><title...
asked by 08.06.2017 / 16:40
1
answer

Find data between a period in a table with start date and end date fields

I have a problem fetching data in a table with start date and end date fields between a period (a -filter) The sample data is: ID - INICIO - FIM 1 - 01/01/2017 - 31/12/2017 2 - 10/01/2017 - 01/02/2017 3 - 01/05/2017 - 01/06/2017 4 -...
asked by 08.06.2017 / 17:42
1
answer

Problem with table wp_termmeta

The following error is occurring permanently, registered in my error_log: Error in WordPress Table database 'odiletan_bd.wpTP737termmeta' doesn't exist na query SELECT term_id, meta_key, meta_value FROM wpTP737termmeta WHERE term_id IN...
asked by 08.06.2017 / 14:51
1
answer

How to find the most updated tuple in postgres?

Friends. I'm having difficulty recovering the most current mileage of a vehicle when it arrives at the company. The identification of the tuple is by the date of arrival of the vehicle in the company. At the moment I have the following SQL...
asked by 16.05.2017 / 19:29
1
answer

Compare Date End of first record with Start Date of Second

Hello. I'm having trouble crafting a SELECT that checks if the End Date of the first record of the query is greater than the start date of the second. The database in question is for notes, and for some reason, some notes have a start da...
asked by 01.06.2017 / 22:35