I have this query below where i want to check if a "CLOSE_TIME < OPEN_TIME"
The problem i have is that the close and open time are VARCHAR2(4 CHAR) data type.
ID = 12345
These are the raw data:
Current Title Start Date End Date Job
No 1/1/2000 12/1/2001 Intern
No 2/2/2002 7/1/2003 Cashier
No 9/2/2003 …
here is the script and output that I am trying to run
I have this setup with various sql statements on other unix systems and they run with no issues
runs from the command line with no issues
I have a table with a BLOB field type. This field has multiple lines, but I only one to retrieve the line with a specific keyword.
So my data can be like this:
I have a C#/asp.net web application which connects to Oracle. Based upon the connection string I need to find out the name of the Oracle database which is being accessed. The connection string works …
i have this error ORA-01843: not a valid month, this is the query
Hello experts i have an query, I want to track an employee login and logout information from a table .
suppose an employee did login/logout throughout a day and all info tracked into a table
What is partition purning .
How can we optimize partition table perfomance when performing DML operation .
What is mutateing error & when it occer. How to handel mutateing .
I have a web service called form an asp.net page. It originally inserted records into a SQL Server table, but that now needs to be Oracle. It works for SQL Server, but in trying to get it to work with…
How to add to the right side of table A , the colums and data of 2 other tables B and C .
table A: col1 (pk) , col2 -- 10 rows
table B: col3 (pk) , col4 -- 10 rows
table C: col5 (pk) ,…
I would like to find data from a table where created_DT is between the last day of the previous month and then 45 days prior to the last day of the previous month
How can I do this ?
My DATABASE got SHUTDOWN and then START automatically only the DATABASE not the server its self.
Can someone help me to identify what will be the reason DB SHUTDOWN AND START …
Please forgive if this has already been asked/answered. I've searched and searched and couldn't find anything...
I came across a column value in a table which isn't UTF-8. In Toad it comes across …
I have the below where clause in sql:
Please help me translate this to oracle
I have a table of individuals with the typical attributes (Individual ID (PK), name, address, city, state, zip)
These people can each belong to a number of groups. Each group having a number.
My procedure is passed a comma-separated list of IDs, for example 7369,7499,7839,7902. I tried to use it in my code like this:
p_empno_list constant varchar2(20) := …
Hi I have a table which returns data as per the following - eg
Select * from Mytable
Name ID Ref1 Ref2 Ref3
ABCD 1 10 12 14
I have two tables and want to pull records from table A when a matching row is not in table B
But i need to look at three fields - so OrderNumber, OrderDate, CustomerID would need to be in Table A …
I am having trouble scheduling a job to run on the 1st of every quarter even if 1st of the month is Saturday.
Here is what I am working with:
I start a query :
select DEPARTMENT ,
from group by DEPARTMENT
The result is a table like this :
I have the below query which pulls data from current date to 12 months back..
I want to change the above code date range to run from the last day of the previous month and back …
I'm using XMLSEQUENCE on a cursor to create xml parts. In general this works fine.
However for any column in the cursor having a null value, no xml tag is returned, while I need an empty tag to be …
I have this attached java program that basically reads data from an oracle table which has a CLOB column. In this case, it is "Document" column. What I need is to parse the CLOB into …
Our shop consists of an Oracle 12c RAC database configured with (3) nodes. Each (3) instances run on its own independent servers (separate box). We are currently running Oracle's OEM Performance …