i need help for a problem. Before someone complain. I have post the same question in another forum but i didn't get any useful help there. https://community.ora
I need to create a table where we have one date column. I need to insert the date from yesterday to yesterday-30 days.Table output should look like this There
I’m trying to connect to an oracle database using Sequelieze ORM. I know that Sequelieze doesn't support Oracle but I'm asking if there is any way to do t
I have two data tables. They both have an employee id column and a sales quarter column, in addition to lots of other columns. The first, which ill call "Rost
I have a function in Oracle 21 version that return a CLOB variable, let's call it x (more than 4000 bytes) and I'm selecting this variable to display it in a cl
Can someone help me with the connection to the Oracle Cloud from Qt. I can't find any information on the Qt website, nor examples, but surely someone has wanted
[ { "name": "sometablename", "numofcolumns": 5, "numofrows": 5, "colheadings": [ { "colname": "customcol1", "coltype": "
I am trying to use the LISTAGG function in Oracle. I would like to get only the distinct values for that column. Is there a way in which I can get only the dist
I'm trying to figure out on how to create an Index for below query such that the SELECT statement only traverse the leaf level of the index horizontally and it
I am polling clob column using apache camel as below. <route> <from uri="timer://timer1?period=2m" /> <setBody>
I'm new to Oracle AWS RDS, we have a RDS deployed and an S3 bucket. The download from S3 works fine, however I wanted to write a script which checks if the file
When I install Oracle 19C on my vmware windows 10 it. Show like in photo. How to fix it. Thanks all of you for help. enter image description here
I have problem with login in enterprise manager. I have windows 10 Education.Database successfully installed but still unable to log into http. Po wydaniu polec
I want to dequeue message with message id from my queue table, but I get error that ORA-25263: no message in queue OPERATION_QUEUE with message ID DBF9DE01CB5C0
does any one have any material to recommend me on how to properly create a good CRUD code to handle python with oracle? I am doing some basic query/insert/updat
Goodday everyone. Faced strange OOM after switching from reading varchar field to clob from Oracle database in java application. (We are using oracle.jdbc.drive
I have a task to import some data from Postgres database to Oracle via dblink The connection between Postgres and Oracle works good, but unfortunately, when I t
Good day, everyone! I've got a bunch of sequences. For example: CREATE SEQUENCE seq_id INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 20000
I'm trying to select user role from Oracle database using id of user in spring boot framework but it not working? I'm trying to select user role from Oracle
I have a requirement to change the owner of an interactive report and also change the interactive report from public to private. I am aware of the APEX_IR.CHANG