I need to know if it is possible to feed the PARTITION clause with the latest partition name of a table, instead of using his value. Normaly we have: SELECT *
I have a code as follows. My question is - why do we need IF statement for CURSOR%FOUND ? If no rows are found, that will trigger NO_DATA_FOUND condition and co
I tried fetching error message from the snp_session table in ODI 12C. I have explicitly inserted erroneous data in order to get an error. But that error is not
I want to show letters only in uppercase in input text field. <oj-input-text style="text-transform: uppercase;" id="text-input" placeholder="Select new Item
I’m having trouble on a query right now to retrieve only the last value saved for each group of results. I explain myself with a table. I have these value
I have problem with my function, I'm getting ORA-21700: object does not exist or is marked for delete error. It's caused by table type parameter in cursor, but
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