I’m trying to run any command on an autonomous database from oracle cloud after establishing connection but they don’t seem to work. cursor.execute(“select * from admin.customers”) gives me the …
Tag: sql
Query to “PIVOT” the results of SalesAmount & CumulativeMonthly for specific YEARS
I have a database table that captures every Sales Transaction: Transactions ( ID INT, TransactionDate DATETIME, SalesAmount MONEY ) I need to run a T-SQL query to produce a Sales …
ORACLE CREATE TABLE with FOREIGN KEY error
I am a beginner to Oracle and have been having problems creating a table with a foreign key, I have created the parent table region as well and have been receiving the same error. I have researched on W3school and used the same syntax but still no help. Answer Leave “FOREIGN KEY” out, if you want …
T-SQL query to summarize sales for ALL YEARS: with total per month per year, and cumulative monthly amounts
I need to create a Sales Report that shows all years sales per month, and cumulative sales. The database table is simple: I want the results to look similar to ExcelSheet below (I am showing only 2017/2018 amounts, but actual query needs to return results for all available years according to TransactionDate) …
APEX get Multiple entries FK
,i dont know what so search for my problem. I think its very simple, but i dont know about that 🙂 I have a Table where i listed all my “Groups/Teams” And then i have a Users Table where i list all the People: I use APEX 18.1 and have a Form with a List of Values, there i can
Snowflake SQL, how to lookahead until a certain occurrence of a value
Below is a sample of the text that I am working with. — info1: * val: “A” — Type: * answers: * – ! * val: “B” * – ! * val: “C” — info2: * val: “D” — …
Sql reverse search for products and discounts
I have two table, one for products, and one for discounts. Discounts table look like: ID | Name | Percentage | Product Name Search Param ——————————————————-…
SQL transaction with JS Array of Objects?
Say i have an Array of Objects Now i create a comma seperated list To pass it to sql.transaction? is there any other way then to loop through the array and pass object each by one or can i pass bulk array? When i pass the comma_seperated_list_response it says Error object Object Answer If every object into yo…
PROCEDURE Return always 0 for string statement
I have a procedure that can be changed dynamically by user for multi column and I write it in SQL when I run it. Everything is OK in SQL and Server Explorer in Visual Studio but when I want use it in …
MYSQL : Group count specific column per user?
I want count column per specific user, using data from 3 tables. TABLE 1 (users) : SAMPLE : TABLE 2 (data) : SAMPLE : TABLE 3 (access): SAMPLE : What i tried so far : Result : I what to link it with user name alse, Desired Result : Answer Seems you need also a join for users and as