I’ve always been a silent reader here until now. Now I would like to ask for your expertise and post my ver first question here. I have to achieve the following task on a weekly basis in my MariaDB via Events: Every Week on Saturday night at midnight, i want to save the results of a certain view in an
Tag: variables
PLSQL – Use variable array on where clause IN
I am looking to use an array of values in the WHERE IN condition. After research, I saw that I had to make a “CREATE TYPE”, since a “TYPE” in local does not work. This solution does not suit me, I do not want to make a new TYPE in Oracle, since the database is used for an ERP/PGI I
SQL Oracle: Save variable from select with where statement
i’m using SQL Developer 19.1. I have a huge script with multiple subselect statements. It looks like this i want to get var1 and var2 with a another select statements. How do i do that? i tried but it seems like i cant use a where statement there. i also tried something with bind or @var1.. Do you guys …
Using Variables in a MSAccess Function with SQL
I’m struggling with entering a custom made ID number on all my tables to link all records together, trying out normalization. I have an EmployeeDetails table and a LoginDetails table. Its my understanding that I need a field called EmployeeID on both and I can use the SQL Select code I have to pull the …
Adding Variables to SQL queries
I have the following code which returns a table from my ms sql Database How would I add the one_yrs_ago variable to the SQL query in this situation , like so : Answer Not seeing the full context but this is how I would do it in SQL Server I would say parameterize what you pass in is important as
Set a local variable and use throughout the query batch?
Once I insert default values in the table I store the result of scope identity in a variable After this, I have to run some other pieces of code that change the value of scope identity and after running those pieces of code I have to use the value of @id again but it shows an error saying that I
How to access multiple variables outside foreach loop in php
I am not a php pro and have already explored different online search forums but could not find any suitable answer and that’s why posting my question here. Function One: Runs a query to database and define variables in foreach loop as follows: Function two: Now I want to get the values of those variable…
VBA 3131 error in SQL using variables in query
Can you please help me? I was trying to figure it out for about 2 hours but I still have some error in the syntax. I have the following code with String variables which I need to pass into the SQL …
Update row if exists or insert
I’m working on a web based PHP form that’s currently connect to an Oracle database. I’m trying to get the functionality working so that after a user submits the form it’ll check if a row exists based on the Job Number, if it does then update, otherwise insert the values. It’s bri…
Setting SQL variables for First day of month and 1 year before
Possibly a dumb question because I’m totally new to SQL (I mean never touched it before today ????) but I’m adjusting a report in a program we use, so it always gets values for the year ending last …