I have a display only item in a static content which looks like this: I want to change the whole background colour of the button/item instead of the text’s colour. My PL/SQL code looks like this for example for the first item: Is it possible to change it with PL/SQL? All I could do is change the span ba…
Tag: sql
SQL timestamp filtering based only on time
I want to create a query in Oracle SQL that will grab records from a given time interval, during certain hours of the day, e.g. records between 10am to noon, in the past 10 days. I tried this, but it does not work: where timestamp is of type TIMESTAMP. I have also thought of using a join, but I am
How to add placeholder in python for creating table name in mysql database?
here i want to name the table name according to user desire but i can’t please help ** I HAVE INCLUDED THIS CODES FOR CONNECTING PYTHON TO DATABASE ** Answer The syntax for creating a table in mySql looks like this: This will create the table named “my_table_name” with one column named ̶…
basic sql employee
The employee table (EMP) specifies groups by department code, the sum of salaries by group, the average (constant treatment), and the number of people in each group’s salary, and is presented below, listed in department code order. I would like to modify the following SQL syntax to look up departments w…
SQL SERVER: OPTION(MAXRECURSION n) not working with dynamic variables
Techies, This more or less works when the date range is between 1/1/-1/3. I have 2 problems I need to solve. The first is that SQL Server will not let me do this: OPTION (MAXRECURSION @recdays). The next, I am pulling results for 1/4, when I only want results up to 1/3. Any advice for getting this to work? I
split data in a single row into multiple records
I need to split a comma separated field into multiple records based on ‘,’ Answer Youll want to use string_split like this:
SQL Compare rows of a table with multiple columns
I have a table T1 Id Col1 Col2 IsActive 1 T1 v1 1 2 T2 v2 0 Now received the following data and it need to be inserted into the above table. As this data contains some duplicated values, it need to be inserted based on IsActive Column value. For row with IsActive 1, need to insert with IsActive 2
Sql query to return information about customers which has spent the most amount
I have a database about the shop, and I need to return full information of the first 5 customers, which has spent the most amount, and in returned results also display that total amount. (counting all his/her payments together from the payments table). Order descending by the total amount. Can someone help wi…
How to add a link to edit and delete each row in a table formulated using php
I have written php code that outputs a php table and for each row, I want to be able to add an extra column to an edit and delete link (CRUD functionality). Currently I have been able to add the extra column but I am unsure on how to actually add the edit and update links in each row. My
Why nulls are appearing and proper reference of a combined variable
In the following code Combined table still pops up with Nulls. Questions: Why? Is it because of the WHERE statement? Is it only acceptable to use fully qualified names such as Things I’ve tried..different naming conventions and syntax, etc. The fully qualified names version works as expected, hence the …