Recent questions tagged Oracle

0 votes

1.1k views

1 answer

oracle - Difference between Table Function and Pipelined Function?

CREATE OR REPLACE TYPE ty_1 AS OBJECT ( fn VARCHAR2(100), sl NUMBER, hd DATE ); CREATE OR REPLACE TYPE ... how does the above code works? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

oracle - How to use ora_hash on a column of datatype xmltype

I would like to use ORA_HASH on xmltype datatype, and workarounds are straight forward solutions ? I am using ... store as binary xml; See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

945 views

1 answer

oracle - Direct-path inserts with reference partitioning?

How can I use direct-path inserts to quickly load data into a table with reference partitioning? Direct- ... for reference-partitioned tables See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

961 views

1 answer

oracle - How to get a list of months between 2 given dates using a query?

I have 2 dates, say 28-Mar-2011 and 29-Jun-2011. I need an sql query that will display the months between ... . June, May, April and March. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

980 views

1 answer

oracle - SQL*Plus does not execute SQL scripts that SQL Developer does

I am facing a very annoying problem. I have written (in Notepad++) some SQL scripts. Now when I try ... line before the concluding semicolon.) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

oracle - Is there any hash function in PL/SQL?

I'm looking for a Hash function in PL/SQL, to get the hash of a varchar. I found a package in Oracle ... SQL compilation error. *Action: Thanks! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

768 views

1 answer

oracle - How to change settings for SQL Developer to correctly recognize current version of SDK

I've installed Oracle 11g r2 to my machine and when I opened Oracle SQL Developer it says: java 1.6.0_02 is ... recognize 1.6.0_27 as my SDK? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

833 views

1 answer

oracle - How to access the structure and get the column list ,datatypes of refcursor?

I have a procedure which gets me the output with refcursor and data/structure in cursor will be dynami. Each time ... DATE|TS|VARCHAR2 END;** See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

oracle - Hibernate Timestamp with Timezone

I'm new to Hibernate and am working with an Oracle 10g database. We have columns in our tables that are of ... standard way to go about this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

888 views

1 answer

oracle - Can %NOTFOUND return null after a fetch?

This question raised a very interesting point; there seems to be a contradiction in the Oracle documentation on ... fetch has been executed? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.6k views

1 answer

oracle - ORA -12953: The request exceed the maximum allowed database size of 11GB

We have oracle express edition 11g i.e. ORACLE XE 64bit. There is 10GB available space in the database. But ... to add or resize the datafile? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

957 views

1 answer

oracle - syntax error when declaring variables in a pl/sql procedure

This is sending me a bit mad. I'm trying to add in a variable to a procedure, but it wasn't working - I just ... for select * from dual; end; / See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

985 views

1 answer

oracle sqldeveloper - Directly export a query to CSV using SQL Developer

Using SQL Developer to run queries works good, but I would save a lot of time if I instead of first ... them writing their results to disk. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

oracle - sqlplus remote connection giving ORA-21561

I have installed sqlplus based on instruction given here sqlplus 'username/password@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP ... already have value. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

817 views

1 answer

oracle - Delphi - prevent against SQL injection

I need to protect an application from SQL injection. Application is connecting to Oracle, using ADO, and search ... Delphi 7 standard and Jedi. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

803 views

1 answer

oracle - SQLDeveloper displays no tables under connections where it says tables

I am not sure why but I just installed SQLdeveloper 32 bit (3.0.0.4). When I click to expand the ... anytable and data shows. Any thoughts? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

732 views

1 answer

oracle - Script to find multi level dependencies of a package

I've a package which references many objects from the same schema and other schemas. I want to find all the ... build as we get in deptree) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

966 views

1 answer

oracle - INSERT trigger for inserting record in same table

I have a trigger that is fire on inserting a new record in table in that i want to insert new record in the ... :- I am using Oracle as database See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

875 views

1 answer

oracle - SQL to find duplicate entries (within a group)

SQL to find duplicate entries (within a group) I have a small problem and I'm not sure what would be the ... and check if it happens again. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.6k views

1 answer

oracle - How can I get the difference in hours between two dates?

I have to do a "select" that returns the difference between a field of type date from the database and the current ... ; But that did not work. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

oracle - XMLAGG with RTRIM issue

Currently I have the following query: SELECT CASE WHEN ('[Param.3]' = 'SELECTED') THEN (SELECT RTRIM(XMLELEMENT( ... to apply to make this work? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

850 views

1 answer

oracle - Is there a PL/SQL pragma similar to DETERMINISTIC, but for the scope of one single SQL SELECT?

In a SQL SELECT statement, I'd like to execute a function that is deterministic for the scope of that ... (without major performance impact)? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

oracle - Slow query execution in an empty table. (after deleting a large amount of inserts)

I have a table in an oracle database with 15 fields. This table had 3500000 inserts. I deleted them all. delete ... to an indexed field. Why? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

oracle - Why is the GETDATE() an invalid identifier

Why is the GETDATE() an invalid identifier says Oracle Sql Developer tool when I debug this code: CREATE OR REPLACE ... = :new.DET_ID; END; See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

878 views

1 answer

oracle - Create a Sequence with START WITH from Query

How can I create a Sequence where my START WITH value comes from a query? I'm trying this way: CREATE SEQUENCE " ... , I get the ORA-01722 error See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

797 views

1 answer

oracle - Setting a value for LIMIT while using bulk collect

I wanted to know if we have any technique by which we can calculate the value which needed to be set for a ... end loop; close c_emp; end; See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

895 views

1 answer

oracle - TNSPING OK but sqlplus gives ORA-12154?

I have Oracle 11 running on a Windows server and I'm logged onto the same server trying to use SQL ... .DIRECTORY_PATH= (TNSNAMES, EZCONNECT) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

783 views

1 answer

oracle - SQL to find upper case words from a column

I have a description column in my table and its values are: This is a EXAMPLE This is a TEST This is a VALUE ... column. How do I achieve this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags