StackOverflow Questions for Tag: dynamic-sql

sodaCodes
sodaCodes

Reputation: 5

How to return columns from dynamic SQL in Python console

Score: 0

Views: 43

Answers: 2

Read More
StevenU
StevenU

Reputation: 39

Dynamic Oracle Query, without dynamic

Score: 0

Views: 55

Answers: 1

Read More
arthur
arthur

Reputation: 1064

Update record of a cursor where the table name is a parameter

Score: 8

Views: 19777

Answers: 1

Read More
Delta Soares
Delta Soares

Reputation: 1

Execute dynamic inserts in a procedure

Score: 0

Views: 110

Answers: 2

Read More
douglas_forsell
douglas_forsell

Reputation: 131

How to declare variables and use them to UPDATE each row based on the preceding row(s)

Score: 1

Views: 90

Answers: 1

Read More
Rancha124
Rancha124

Reputation: 43

How to query a dynamic list of strings using SQL?

Score: 0

Views: 77

Answers: 1

Read More
MRodriguez
MRodriguez

Reputation: 419

PostgreSQL Dynamic Query Execution with Table-Valued Variables

Score: 1

Views: 59

Answers: 1

Read More
GammaGames
GammaGames

Reputation: 1820

Cast value to type (TEXT) using string representation of type ("TEXT")

Score: 1

Views: 2179

Answers: 1

Read More
slevin
slevin

Reputation: 3878

concatenate additional text to string variable in pl/pgsql

Score: 4

Views: 7033

Answers: 1

Read More
TemNyilv
TemNyilv

Reputation: 1

Group_Concat() when is null, I get error 1064

Score: 0

Views: 66

Answers: 0

Read More
Allard
Allard

Reputation: 11

Oracle PL/SQL: generic and uniform journalling trigger without hardcoding columns in the trigger

Score: 1

Views: 68

Answers: 1

Read More
saif barakat
saif barakat

Reputation: 1

I am trying to use dynamic SQL query to generate dynamic columns but I received an error in MySQL

Score: 0

Views: 90

Answers: 0

Read More
James De Souza
James De Souza

Reputation: 668

Function to return dynamic set of columns for given table

Score: 5

Views: 11927

Answers: 2

Read More
user3673794
user3673794

Reputation: 11

Filter column names from existing table for SQL DDL statement

Score: 1

Views: 422

Answers: 1

Read More
Stephen
Stephen

Reputation: 1

How to assign a column to a variable in Dynamic SQL

Score: 0

Views: 77

Answers: 1

Read More
bzm3r
bzm3r

Reputation: 4596

DuckDB: how do I create a table containing a column with a specific name from a `CREATE MACRO ... AS TABLE ...`?

Score: 2

Views: 217

Answers: 2

Read More
Michael M
Michael M

Reputation: 8723

Change schema of multiple PostgreSQL functions in one operation?

Score: 2

Views: 2714

Answers: 2

Read More
Awaish Kumar
Awaish Kumar

Reputation: 557

Function returning a table for given table and column names

Score: 1

Views: 1404

Answers: 2

Read More
Biljana M.
Biljana M.

Reputation: 367

Dynamic SQL created with array of values

Score: 1

Views: 90

Answers: 1

Read More

How to run the prepared statement with arguments dynamically in a function?

Score: 2

Views: 156

Answers: 1

Read More
PreviousPage 2Next