Recent questions tagged Oracle

0 votes

841 views

1 answer

oracle - Inner Join Two Table, aggregating varchar fields

Sorry I change my question a bit . I have two table and I want to merge them TERMS_TABLE ID | TERMS 309 | ... ,phone,mp3....,hardware,software' See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

oracle - Regular Expression (RegEx) for IPv6 Separate from IPv4

Please read before marking as duplicate I have not been able to create or find a RegEx that works for all IPv6 formats (my ... }))$','i') ) then See Question&Answers more detail:os...

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

0 votes

864 views

1 answer

oracle - How do you connect to an LDAP server using node-oracledb?

I have a database that I can connect to using jdbc using the string "jdbc:oracle:thin@ldap://SERVER_NAME:1234/ ... to connect to the database? See Question&Answers more detail:os...

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

0 votes

822 views

1 answer

oracle - Is there any other way to create constraints during SQL table creation?

Assume I have this following SQL statements, using Oracle: drop table department cascade constraints; drop table ... the alter table statement? See Question&Answers more detail:os...

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

0 votes

868 views

1 answer

oracle - Call pl/sql function in java?

So I've got a function that checks how many cancellations are in my booking table: CREATE OR REPLACE FUNCTION ... tried but with no luck. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - Declare bind variables in SQL*Plus

I am using SQL*Plus. When I am using the below query, it is giving error Error report: ORA-06550: line 4, ... where id = 'test123'; end; See Question&Answers more detail:os...

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

0 votes

932 views

1 answer

oracle - Why does SQL*Plus commit on exit?

Surely this should be the same as a termination of a session and cause a rollback? It seems to me to be the ... changed it to rollback on exit? See Question&Answers more detail:os...

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

0 votes

808 views

1 answer

oracle - SQL - Find missing int values in mostly ordered sequential series

I manage a message based system in which a sequence of unique integer ids will be entirely represented at the end ... NEXT_ID != NUMERIC_ID + 1 See Question&Answers more detail:os...

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

0 votes

880 views

1 answer

oracle - Grouping records hour by hour or day by day and filling gaps with zero or null

I have written a query that counts records hour by hour: select TO_CHAR(copied_timestamp, 'YYYY-MM-DD HH24') ... Any help is really appreciated. See Question&Answers more detail:os...

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

0 votes

803 views

1 answer

oracle - sysdate difference

There are such calls some_proc(sysdate, sysdate); select some_func(sysdate, sysdate) from dual I wonder if there ... due to speed of execution? See Question&Answers more detail:os...

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

0 votes

886 views

1 answer

oracle - Execution order of conditions in SQL 'where' clause

I have a set of conditions in my where clause like WHERE d.attribute3 = 'abcd*' AND x.STATUS != 'P' AND x ... db here, else I would have tried) See Question&Answers more detail:os...

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

0 votes

979 views

1 answer

oracle - Working with very large text data and CLOB column

According to documentation CLOB and NCLOB datatype columns, can store up to 8 terabytes of character data. I have ... am doing something wrong ? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - Currently Executing Procedure Name within the Package

Is there a way to get the currently executing procedure name within the package? create or replace package test_pkg ... end proc1; end test_pkg; See Question&Answers more detail:os...

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

0 votes

846 views

1 answer

oracle - java.security.AccessControlException: access denied ("java.security.SecurityPermission" "authProvider.SunMSCAPI")

Till morning everything working fine in my applet. I took Java update and everything stopped. I'm dealing ... if using code signing certificate See Question&Answers more detail:os...

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

0 votes

965 views

1 answer

oracle - Return value from sql script to shell script

I have shell script that calls the following sql script: INSERT INTO SEMANTIC.COUNT_STATISTICS (...); UPDATE SEMANTIC ... why is not working? See Question&Answers more detail:os...

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

0 votes

981 views

1 answer

oracle - What is the algorithm used by the ORA_HASH function?

I've come across some code in the application I'm working on that makes a database call merely to call ... hashing or partitioning in general. See Question&Answers more detail:os...

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

0 votes

900 views

1 answer

oracle - Full complete MySQL database replication? Ideas? What do people do?

Currently I have two Linux servers running MySQL, one sitting on a rack right next to me under a 10 Mbit/ ... just resolves to the other server. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - How to get the week day name from a date?

Given 03/09/1982 how can we say it is which week day. In this case it will be Tue. Is it possible to get in a single query? See Question&Answers more detail:os...

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

0 votes

909 views

1 answer

oracle - ORA-03113: end-of-file on communication channel after long inactivity in ASP.Net app

I've got a load-balanced (not using Session state) ASP.Net 2.0 app on IIS5 running back to a ... to kill connections between those servers. See Question&Answers more detail:os...

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

0 votes

979 views

1 answer

oracle blob text search

Is it possible to search through blob text using sql statement? I can do select * from $table where f1 like ' ... ? Any counter part for this? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

oracle - How to use a package constant in SQL SELECT statement?

How can I use a package variable in a simple SELECT query statement in Oracle? Something like SELECT * FROM ... use SELECT within BEGIN/END)? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - ORA-01830: date format picture ends before converting entire input string / Select sum where date query

I am trying to execute my query through Java like this: public ResultSet execSumStatment2() throws SQLException{ String ... ! Thanks in advance! See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

oracle - How to redirect the output of DBMS_OUTPUT.PUT_LINE to a file?

I need to debug in pl/sql to figure times of procedures, I want to use: SELECT systimestamp FROM dual INTO ... the data I want to collect? See Question&Answers more detail:os...

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

0 votes

841 views

1 answer

oracle - How many database indexes is too many?

I'm working on a project with a rather large Oracle database (although my question applies equally well to ... and ignore everything else? See Question&Answers more detail:os...

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

0 votes

910 views

1 answer

oracle - Time subtraction format result

I'm having trouble formatting the result of my time calculation as well as searching for a forum solution. I do ... Desired result: 07:30:17 See Question&Answers more detail:os...

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

0 votes

697 views

1 answer

oracle - convert many date formats to a single formatted date

I want to bring a string which contains a date to a single format date. EX: 13-06-2012 to 13-JUN-12 13/06 ... Q1.set_act_id_1 IS NOT NULL ) ); See Question&Answers more detail:os...

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

0 votes

849 views

1 answer

oracle - Perl DBI - run SQL Script with multiple statements

I have a sql file test.sql used to run some SQL (create object / update / delete / insert) that can look like ... without the ";" at the end. See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

oracle - Why cannot I create triggers on objects owned by SYS?

While trying to create a trigger named ghazal_current_bef_upd_row : create trigger ghazal_current_bef_upd_row before update on ... by SYS . See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags