Recent questions tagged ORACLE

0 votes

1.1k views

1 answer

oracle - Why EXECUTE IMMEDIATE is needed here?

I am a SQL Server user and I have a small project to do using Oracle, so I'm trying to understand ... need EXECUTE IMMEDIATE to run properly? See Question&Answers more detail:os...

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

0 votes

988 views

1 answer

oracle - SELECTing top N rows without ROWNUM?

I hope you can help me with my homework :) We need to build a query that outputs the top N best paid employees. ... s1.salary < s2.salary) <= 3 See Question&Answers more detail:os...

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

0 votes

976 views

1 answer

oracle - Two PLSQL statements with begin and end, run fine separately but not together?

Just wondering if anyone can help with this, I have two PLSQL statements for altering tables (adding extra fields) ... to make it work properly? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - Fetch pl/sql array return values in java

In Java how to get values from a pl/sql function which returns an array. if my pl/sql function ... param3); callablestatement.execute(); See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - How can we define output parameter size in stored procedure?

How can we define output parameter size in stored procedure? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - retrieve out parameter from stored procedure?

I have created one stored procedure in oracle: PROCEDURE string_opp(input_string IN varchar2,output_string OUT varchar2) ... someone help me? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - How can I pass a parameter to a t-sql script?

CREATE TABLE DMS_POP_WKLY_REFRESH_20100201 NOLOGGING PARALLEL AS SELECT wk.*,bbc.distance_km ,NVL(bbc.tactical_broadband_offer,0 ... every run. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - ORA-08177: can't serialize access for this transaction

I have a very simple code using ADO.NET which throws ORA-08177 exception. I am not sure what's wrong ... KB958690, KB958481, KB958483, KB943729) See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - How can we define output parameter size in stored procedure?

How can we define output parameter size in stored procedure? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - retrieve out parameter from stored procedure?

I have created one stored procedure in oracle: PROCEDURE string_opp(input_string IN varchar2,output_string OUT varchar2) ... someone help me? 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 can I pass a parameter to a t-sql script?

CREATE TABLE DMS_POP_WKLY_REFRESH_20100201 NOLOGGING PARALLEL AS SELECT wk.*,bbc.distance_km ,NVL(bbc.tactical_broadband_offer,0 ... every run. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - ORA-08177: can't serialize access for this transaction

I have a very simple code using ADO.NET which throws ORA-08177 exception. I am not sure what's wrong ... KB958690, KB958481, KB958483, KB943729) See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

oracle - Rounding to 2 decimal places in SQL

every time I want to round to 2 decimal places when it comes to zeros it doesnt want to round it... ... (TO_CHAR(COLUMN_NAME),2) thanks guys! See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

oracle - Dumping CLOB fields into files?

Say you have the table: Column_name | data_type Title | Varchar2 Text | CLOB with some rows: SomeUnkownMovie | A long ... not the one :( thanks! See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - Use of boolean in PL/SQL

I have a function in PL/SQL which checks if a particular emp_id exists or not which is: CREATE OR REPLACE ... more than requested number of rows See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

oracle - PL/SQL: Error "PLS-00306: wrong number or types of arguments in call to" triggered for table of numbers

I'm trying to call an API using the exact procedure signature, but somehow the table of numbers I don't ... 'GETSERVICE_API Any idea why? Thanks See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - Is it possible to use "return" in stored procedure?

CREATE PROCEDURE Pname(in_Tid IN VARCHAR2,in_IP IN VARCHAR2,outstaticip OUT VARCHAR2,outcount OUT NUMBER) AS BEGIN select ... ; end if; END; See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

oracle - SQL Query to Count() multiple tables

I have a table which has several one to many relationships with other tables. Let's say the main table is a person ... the best way to do this? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

oracle - Is ora_hash deterministic?

I am working with an Oracle database and I need to be able to partition the data in a table. I ... be deterministic. See the documentation. See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

oracle - EXTRACT() Hour in 24 Hour format

I have something like below- EXTRACT(HOUR from CAST(to_char(tran_datetime,'DD-MON-YYYY HH24:MI:SS') AS ... use EXTRACT() function specifically. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

oracle - Asking for opinions : One sequence for all tables

Here's another one I've been thinking about lately. We have concluded in earlier discussions : 'natural primary ... records in your database. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

oracle - SQL Inner join on select statements

I am trying to make an inner join on a select statement like this: select * from (select* from bars where ... would be appreciated, thank you! See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

oracle - java.sql.SQLException: ORA-03115: unsupported network datatype or representation

I'm Using Oracle 11g database. When i try to access data from db it was showing the error java.sql.SQLException: ... me to solve this problem.. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

oracle - Rank function in MySQL with Order By clause

How could this (Oracle) SQL: select a.*, rank() over (partition by a.field1 order by a.field2 desc) ... ordered by the fields of partition? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

oracle - Remove Column Header into the Output Text file

I want to create a flat file (text file) of my query from Oracle SQL Developer. I have successfully ... from terminal_table; spool off; See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

oracle - Reverse String Word by Word using SQL

I would need to reverse the word positions in a sentence or String. For example : "Hello World! I Love ... (Characters in reverse order) only See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - PL/SQL bulk collect into associative array with sparse key

I want to execute a SQL query inside PL/SQL and populate the results into an associative array, where one of the ... PL/SQL? If so, how? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - PL/SQL bulk collect into associative array with sparse key

I want to execute a SQL query inside PL/SQL and populate the results into an associative array, where one of the ... PL/SQL? If so, how? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags