Aqua Data Studio is a SQL client/IDE
Questions tagged [aqua-data-studio]
25 questions
0
votes
1 answer
Creating MySQL Stored Procedure
I am using Aqua Data Studio 20.6 to create a MySQL stored procedure. The following is my procedure, I have named it sp_GetObjIDByProType:
( IN prono char(15), IN imgtype char(8), OUT objid bigint )
BEGIN
SELECT ObjectID INTO objid FROM images…
MERNboy
- 125
- 14
0
votes
0 answers
SQL: Grouping Multiple Conditions
Is it possible to group multiple conditions to pull different data from different date ranges? I'd like to pull different marketing campaign performance data that were running at different times.
e.g. having two or more where clauses as in the…
Diana
- 1
- 1
0
votes
3 answers
How to declare and use a variable in Aqua Data Studio querying an Oracle server
In Microsoft SQL Server
DECLARE @var INT
SET @var = 1
SELECT @var
What would the equivalent statement be in Aqua Data Studio when querying an Oracle server?
I've tried different variations of this (with GO or ; as statement separators, nothing has…
Matthew Walk
- 1,014
- 2
- 16
- 36
0
votes
2 answers
Select records after specific date in SQL
I have a column in my database called "begin_date".
I am trying to select records where the begin_date are greater than a specific date. I put
select * from Table_Name
where begin_date >= '1/1/2014'
However, it returns error message "String to…
mumu.W
- 53
- 5
- 11
0
votes
1 answer
SQL How to read through a grouping of records and output a smaller table based on the values read?
I am trying to read through a group of students records (based on their stateID) and determine if they made the honor roll, or high honors. If they did not reach either, the entire records can be deleted for that grouping of stateID. This is what I…
Karen
- 157
- 2
- 12
0
votes
1 answer
Trivial PL/SQL block generating frustrating PLS-00103 error
I may be going a bit insane, but I keep getting a PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following... error. I have pared my program down to the following:
BEGIN
NULL;
END;
/
Which I am running within AquaData…
0xbe5077ed
- 4,565
- 6
- 35
- 77
-1
votes
1 answer
How to pivot in SQL for achieving multilevel headers
Pivot multilevel header without performing any aggregation
Unsure of how to really get this multilevel headings with no aggregation in the pivot, as you would notice the current and desired layout.
With pivot_data as
(
Select * from Table1
)
Select…
SaM
- 1
-1
votes
2 answers
add month to curent date in aqua data studio
I am trying to develop a report through aqua data studio by using SQL.I am trying to extract report of last month like counting the total number of new users in the last month. Date_Creation is the column when a user is registered in the system. I…
Adnan Haider
- 53
- 8
-1
votes
1 answer
Unable to establish the Cassandra - Generic JDBC connection in AQUA Data Studio
Your server is not listening or accepting connections on 127.0.0.1:9042. Verify host and port information is correct
VM: 127.0.0.1:9042
JDBC URL…
Ramesh Thangaraj
- 21
- 4
-1
votes
2 answers
Aqua Data Studio alternative
I am using Aqua Data Studio for my internship project. But the evaluation period has finished and now I cannot use it anymore. Please can you suggest me an IDE that is similar to Aqua Data Studio? Some software that is not commercial.
I would like…
Benz
- 289
- 4
- 15