All Questions
4,385
questions
0
votes
2
answers
62
views
Oracle SQL query is not using index
I'm running the below query in my Oracle DB. The index trunc(create_date) is created on the table ORDERS. But the below query is not using the index when I run it.
SELECT ITEM, MAX("Orders") ...
0
votes
0
answers
16
views
how to import views into oracle database [duplicate]
I have an Oracle dump, which includes tables and views. While importing into the database, it's accepting only tables, not views.
Imp system/system file=test.dmp full=y log=test.txt
am I missing any ...
0
votes
0
answers
11
views
Can lexical parameters be used in Oracle Discoverer?
I have a question for you. In a Oracle Discoverer report, we can add an additional WHERE clause conditionally, or we can directly obtain values using the get and set structure. However, the values we ...
0
votes
1
answer
44
views
How to find which User created a Database View in an Oracle Database?
I need to determine who created a view in an Oracle Database. I do not have access to the database myself, so I am looking for a query to provide. I believe the equivalent for a TSQL database is
...
0
votes
2
answers
70
views
Whatever the data available in previous record it should add to the new record
Thanks in advance for answer my question.
Assume I have a table like t1. There are 3 columns in the table.
t1.id t1.ins_dt base_id
10000 2024-03-27 00:00:00 1234/45678/000/00
...
0
votes
0
answers
168
views
Using FND_FUNCTION.EXECUTE
I use FND_FUNCTION.EXECUTE and the function I want to call comes without any problems and I can perform my operations there. But when I close the function I called, it does not run the codes below ...
0
votes
2
answers
63
views
ERROR at line 19: PLS-00103: Encountered the symbol "¿"
This procedure is getting following error.
create or replace procedure shedule(grad IN varchar2) as
cursor cur(grad varchar2) is
select s.departments dep, s.groups gr, dis.disc_name ...
1
vote
0
answers
51
views
how connecting to web by utl_http in oracle10gr2?
I am using Oracle 10g R2
and facing the problem connecting to web.
SQL> select UTL_HTTP.REQUEST('https://backend.jofotara.gov.jo/core/invoices/',null,'file:E:\ho','Mmarwan2000@') Output from dual;
...
0
votes
0
answers
45
views
creating DAT file in Oracle SQL
I tried to create dat file using Oracle SQL.Dat file is created but below query output is not writing in Data File.Dat file created with 0kb size.
set echo off
set feedback off
set linesize 100
set ...
0
votes
2
answers
74
views
Historical SQL queries
Is there an table on oracle database where historical SQL queries executed by users are stored?
Tried with v$sql, v$sqlstats, but couldn't find anything useful.
-1
votes
2
answers
46
views
how to return multiple values if a condition satisfy in oracle sql
how can we return multiple values if a condition is satisfy for ex
we can't create or edit the existing table
table= ITEMS
ITEM |. TYPE
------------------------------------------
apple, ...
-1
votes
2
answers
70
views
Table in Oracle which will store the Server count on monthly basis
I have to create a table in Oracle in similar that can be seen below. As you can see months and year is combined and then storing the monthly server count data based on the description type. To fetch ...
0
votes
1
answer
166
views
Oracle reports repeating frame
I am creating a report with Oracle reports 10g. I used frame and repeating frame in page layout. I have only one question. My client wants the data to be on the same page. Let's say a frame's data ...
-3
votes
1
answer
64
views
I need to convert below code from sql to oracle SQL
I need to convert below code from SQL Server to Oracle:
Update A
Set
A.ShiftName=@ShiftName,
A.ShiftStartTime=DATEADD(day,DATEDIFF(day,0,AttendanceDate),
CAST(S....
-1
votes
1
answer
45
views
How do I update particular record in below scenario?
I have a table data structure like below,
ID
NAME
START_DATE
END_DATE
CREATE_DATE
100
Apple
01-NOV-23
31-DEC-99
01-NOV-23
100
Anar
10-OCT-23
31-DEC-99
12-SEP-23
100
Anar
04-SEP-23
10-OCT-23
04-SEP-...