I have the following table as my input: Date | Agent Name | Agent Department | Call ID | Transfer? | TransferToAgent_Dept ————————————————————————…
Tag: database
How setting Auto Commit off, helps to start a transaction in JDBC?
Many articles and documents says that by setting Auto Commit off, You can start a transaction in JDBC. This Topic also ask same question but It doesn’t answer to the question and just said: …
CONNECT BY PRIOR and concatenation of parent – child hierarchy
I have this table: img Desired result: img What i’m trying: select SEG from my_table CONNECT BY PRIOR PARENT_SEG_ID = SEG_ID; So, in the column LEVEL_LOCATOR we can see f.e. that the LEVEL 5.9 has 6 childs, and 5.9.4 has 2 childs. And, f.e., the parent of the child 5.9.1 is Postpaid that has the SEG_ID = 361978 and it’s
Is there a way to split text from cell into multiple records in SQL using line break delimiter?
I have a system generated report that exports all expense reports for a given period. All employees attached to the report are exported in one field “Attendees”, separating multiple employees with line breaks. I would like to break the cell into multiple records, still including the expense report NO. on each record. Note, the names in the attendee field are
table in database rows
I have a table People, having people_id,people_name,people_lastname. I am facing difficulties creating a pl/sql function to display all the rows of that table. I have done this much so far Answer One option is to return refcursor:
Fetch rows for the last 6 hours in SQL Server
I run a Microsoft SQL Server SELECT query and have an issue trying to define a specific time range for that query every 6 hours (I am a newer user of SQL Server). I have an external script calling …
Why do I fail to save data in my application?
I am a student and started working on android studio recently. I don’t know about it much. I am working on an application where I save the item name and its amount in the database and display toast …
How to pass a Variable/Function into SQL Query?
I am attempting to Insert a Row on a Table, but I cannot seem to pass the TASK_ID as a value/variable/function into the SQL Statement. Throughout the application, to acquire TASK_ID, I use: Dim …
Custom SQL response (JOIN TABLE)
I have two tables, table1 and table2 I want to link the two tables with the id, by grouping the information in one and the same answer. table1: ╔════╦══════════════╦ ║ id ║ product_id ║ ╠════╬═══…
Getting unknown column in on clause when trying to get the latest record
I have two tables orders and order_items I am trying to get the last order_sum for each day using an inner join but I am running into an error in my second join. Unknown column ‘o.last_order_date’ …