Recent questions tagged Oracle

0 votes

921 views

1 answer

In my database at several places developers have used dynamic sql instead of static. And they are saying reason for ... delete from X; end; See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

oracle - Managing error handling while running sqlplus from shell scripts

#!/bin/sh echo "Please enter evaluate database username" read eval_user echo "Please enter evaluate database password" ... to be done here? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

oracle - How can you tell if a PL/SQL Package, Procedure, or Function is being used?

How can you tell if a PL/SQL Package, Procedure, or Function is being used? Is there an Oracle table ... Package, Procedure, or Function usage? See Question&Answers more detail:os...

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

0 votes

963 views

1 answer

oracle - ExecuteBatch method return array of value -2 in java

When I am executing executeBatch method in java, its returning an int array that's fine but the value is ... affected. Thank, Deepesh Uniyal 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 insert into a BLOB column from an insert statement in sqldeveloper?

Is it possible to insert into a BLOB column in oracle using sqldeveloper? i.e. something like: insert into mytable(id ... (1,'some magic here'); See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

oracle - ORA-01653: unable to extend table by in tablespace ORA-06512

I tried to generate some test data by running the following sql. BEGIN FOR i IN 1..8180 LOOP insert into ... need? What 128 stands for? See Question&Answers more detail:os...

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

0 votes

965 views

1 answer

oracle - SQL Query to Collapse Duplicate Values By Date Range

I have a table with the following structure: ID, Month, Year, Value with values for one entry per id per ... endMonth, value Database is Oracle See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - Run Stored Procedure in SQL Developer?

I am trying to run a stored procedure that has multiple in and out paramaters. The procedure can only be ... /SQL compilation error. *Action: See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

oracle - Find out free space on tablespace

Our application has failed a few times because an 'ORA-01536: space quota exceeded for tablespace', and ... return completely different results. 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 Query: Return Max value record of a Group

I have a sample table with similar structure & data as shown below: +------+---------+-------------+------------+ ... ------------+------------+ See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

oracle - How to read and extract zip entries from java.sql.Blob type zip file without having FileInputStream or filepath as a string java

public static void unzipFiles(java.sql.Blob zip) throws Exception{ String paths = ""; byte[] blobAsBytes = ... would be really appreciated. 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 Log Alter Column DDL Operations

I need to create a database trigger which will record each alter (Add Column,Modify Column,Drop Column) statements in a ... ,NULL,NULL,V); END; See Question&Answers more detail:os...

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

0 votes

1.2k 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 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

oracle - change the size of datatype in sql

I have created a table with column id as varchar2(20). Now I want to modify it and change size to 13 i.e ... `t have any data in my table. 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 pass values to IN operator dynamically?

I want to create a procedure which accepts an array list for IN operator. For eg: Create or Replace Procedure ... table1 where col1 IN (val1) See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - Top n percent top n%

I do have the following code. SQL> select * from student_gpa; SSN GPA --------------- ---------- ... return all rows that had gpa of 4.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 - When executing a script on SQLPlus, it prints a sequence of numbers instead of output

I'm trying to execute a script on SQL PLus, it's simple. SET serveroutput ON; DECLARE mode NUMBER(1) := ... indefinitely. What am I doing wrong? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

oracle - How to create a menu in SQLPlus or PL/SQL

I have several scripts that I would like to start from a menu presented to the SQLPlus user. Something like: ... direction, not a quick answer. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

oracle - How can you run the same query multiple times using loop in PL/SQL?

Using this code I'm not able to run an insert query multiple times; it asks for ID and name only one time ... code which will fix my problem. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - Getting an external table's location and file name?

I'm processing multiple files as part of an external table. Is there any way I can get the file name being ... is being processed at any time? See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

oracle - java.lang.UnsatisfiedLinkError: no ocijdbc11 in java. library.path

i am trying to make jdbc oci connection to oracle 11g that uses os authentication i made a sample console ... can i fix this exception. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

oracle - Calling a stored PROCEDURE in Toad

I have a defined a new stored procedure but get a error while calling it, CREATE OR REPLACE PROCEDURE SCOTT. ... OUT) --Invalid sql statement. 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 insufficient privileges within a query manually possible

I need to do this task , and update this table that has a lot of rows. This table has 2 columns : ... happening, can someone please 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 - Hierarchical SQL question

I have a basic tree structure of entities. The tree can be a maximum of 5 nodes deep, but may be N nodes ... am using Oracle SQL. Thanks, Jay See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

oracle - ORA-12505, TNS:listener does not currently know of SID given in connect descriptor. Eclipse and Fedora 20 via JDBC

I've installed Oracle 11g XE on a Fedora 20 Virtual Machine, configured it and set the enviroment variables ( ... in the solutions you suggest. See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

oracle - How to export the result into different tabs of Excel in Toad for Data Analyst?

Does anyone know how to export results from more than one query into different sheets of the same Excel workbook ... for data analyst? Thank you See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - Parallelizing calls in PL/SQL

I have a package with a proc that will execute a number of other procedures, like so: CREATE PACKAGE BODY pkg IS CREATE ... ; -- ... END; END; See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

oracle - Parsing pipe delimited string into columns?

I have a column with pipe separated values such as: '23|12.1| 450|30|9|78|82.5|92.1|120|185|52|11' ... one value at a time using substr? Thanks. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags