Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 2 years ago. Improve this question I have 2 tables – sales and ratio. sales table has 2 columns – state, sales. Thi…
Tag: sql
Query to find the tables size occupied in GB in Oracle SQL for various SCHEMAS
I am trying to find the space occupied by list of tables in Oracle DB (for various SCHEMAS ) ,currently i am using this query QUERY 1 – DBA_SEGMENTS QUERY 2 – DBA_OBJECTS when i compare the LIST OF TABLES counts it’s not matching , what could be the reason ? can you please suggest is this co…
SQL Grammar Exception in Spring Boot H2
I’v got a problem in my Spring Boot with H2 project. I got a get method for listing elements from the SQL table and the SQL command working. In the H2 database I can execute and see the results but I …
Oracle : replace string of options based on data set – is this possible?
I have column in table looking like this: Every option has a number of value. There is a table – let’s call it option_set and records look like I want to replace option name to number in 1st table, if exists of course, if not exists then =0. I have done this in PLSQL (get the pattern, go through e…
sql distinct statement not working in powershel script
I am trying to run the following sql command on a powershell script: I set the following as a variable: after some other commands, i have the following: The above command works perfectly in SQL, but when I run on my powershell I get the error: Please can anyone advise? Thank you. Answer Thank you to Luuk and …
Create Children and Parent of a Person
I have the following Type Address and PhoneNumber: CREATE TYPE Adress AS Object (Street varchar2(50), PostalC number, Ville varchar2(50)); CREATE TYPE PhoneNumber AS Object (Ind varchar2(3), PhNumber …
No data is showing in object browser in Oracle Apex
I have a SQL table created in Oracle database with 5 records. However, the records are not reflecting in the Oracle Apex Object Browser (table). I tried refreshing the data but no luck. I was able to …
How can I pass multiple parameters to identify a page?
I currently have one question and that is if I can pass 2 parameters in my url to identify a page. Currently I have this code, which gets me through the parameter “url_slug” my post stored …
How exactly transactions work in Microsoft SQL Server
I’ve read that creating for insert trigger creates transaction implicitly. So I can rollback transaction from within trigger and “undo” the insert. Is that so? create trigger TRIGGER_NAME …
“Object not found” error when using multiple table expressions in WITH…AS inside of CREATE VIEW
I am trying to create a view based on complex query in HSQLDB (version 2.5.1). The query looks like this (simplified for clarity), also includes DDL for the tables: However, it fails with the following error: [42501][-5501] user lacks privilege or object not found: JOIN in statement [CREATE VIEW TEST_VIEW AS&…