Top new questions this week:
|
|
Most all answers and examples of SQL injection are showing some form of dynamic SQL or interpreting parameters as SQL. I haven’t been able to find an example of the “correct” way. Microsoft …
|
|
Is it possible to adapt this into update query which has to seek a free sequence of 3 bytes or (0x000000) and replace it with a new sequence if the data is split like this every 3 bytes? The issue is …
|
|
I have this simple table schema: SQL Fiddle PostgreSQL 9.6 Schema Setup: CREATE TABLE IF NOT EXISTS users( id INT NOT NULL PRIMARY KEY, email TEXT NOT NULL UNIQUE, password TEXT NOT NULL, …
|
|
I have this SQLite script: CREATE TRIGGER ACCOUNT_UPDATE_DELETE_SESSION_ID_NULL AFTER UPDATE OF DELETE_SESSION_ID ON ACCOUNT FOR EACH ROW WHEN OLD.DELETE_SESSION_ID IS NOT NULL AND NEW….
|
|
We have a normalized database of survey respondents and answers, but, for a variety of reasons, we want to provide denormalized views for our surveys. It is annoying, however, when doing DB schema …
|
|
I have a table, where one column contains a substring of an url. It’s always the leftmost part of the url without scheme. id domain column1 column2 1 example.com value1 value2 2 example.org value3 …
|
|
Our DBAs have changed the ‘Cost Threshold for Parallelism’. Is there an audit that will give me a timestamp of this change, so I can correlate it with our APM (Application Performance Monitoring)?
|
Greatest hits from previous weeks:
|
|
I want to connect to an oracle database located on another host using sqlplus. This page suggested adding an item on my tnsnames to conenct to that database local_SID = (DESCRIPTION = (ADDRESS =…
|
|
I am running Ubuntu 16. I have installed Postgresql. Postgresql used to work, but then I rebooted. nmap commands show port 5432 is open. Postgres seems to be working correctly: service …
|
|
The title says it all, is there a way to quickly list all the current database links in oracle? Something along the same lines as this, which lists the current user’s tables: select * from …
|
|
I have a table items (item_id serial, name varchar(10), item_group int) and a table items_ver (id serial, item_id int, name varchar(10), item_group int). Now I want to insert a row into items_ver …
|
|
I’m having trouble finding answers with various Internet and Google searches for MySQL Workbench issue I’m experiencing. I have not found any answers on how to make this work again. Here’s the MySQL …
|
|
Is there a best practice between using a LEFT JOIN or a NOT EXISTS format? What is benefit to using one over the other? If none, which should be preferred? SELECT * FROM tableA A LEFT JOIN tableB B …
|
|
How can I move MySQL tables from one physical server to another? Such as this exact scenario: I have a MySQL server that uses innodb table and is about 20GB size. I want to move it to a new server, …
|
Can you answer these questions?
|
|
I’ve created a new table called device, in a schema called 51025. I’m now trying to add the following constraint on the table. ALTER TABLE “51025”.device ADD CONSTRAINT device_solution_fk …
|
|
Is there a proper snapshot function or anything analogue to it on Oracle Database (19c, 21c) on a schema or PDB level? For example, I wanted to run some tests that will alter tables, procedures and …
|
|
In order to reduce friction between frontend/backend/database in regards of dates, I’ve decided to use a subset of RFC3339 which is also compatible with ISO 8601 and HTML. As per this graph that means …
|
