Recent questions tagged oracle11g

0 votes

553 views

1 answer

I have searched Stackoverflow about pivot in Oracle 11g but could not find the syntax that works for my situation ... please educate me please? See Question&Answers more detail:os...

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

0 votes

465 views

1 answer

oracle11g - How to modify data type in Oracle with existing rows in table

How can I change DATA TYPE of a column from number to varchar2 without deleting the table data? See Question&Answers more detail:os...

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

0 votes

429 views

1 answer

oracle11g - Best way to run Oracle queries periodically

I need to know what the best practice is regarding running a query periodically on Oracle (I'm using 11g). In ... too. Many thanks in advance. See Question&Answers more detail:os...

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

0 votes

593 views

1 answer

oracle11g - How to transpose column into row in oracle sql 11G

I need to convert column into row for the below select column_name from all_tab_cols where table_name='TABLE_NAME' ... convert column into rows See Question&Answers more detail:os...

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

0 votes

476 views

1 answer

oracle11g - Oracle Instant Client for ARM based Debian device

As the title suggest Oracle doesn't provide a ARM based instant client. Which is necessary to communicate with the ... be some method now ? See Question&Answers more detail:os...

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

0 votes

432 views

1 answer

oracle11g - Sending a JMS Message from Oracle Database on DML Event

I'm trying to determine if it is possible to configure Oracle Database 11g to send a JMS message to a broker ( ... be grateful for that as well. See Question&Answers more detail:os...

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

0 votes

507 views

1 answer

oracle11g - Why oracle IN clause has limit of 1000 only for static data?

Oracle IN clause has limit of 1000 for static data,but it accepts unlimited data from sub queries. why? See Question&Answers more detail:os...

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

0 votes

502 views

1 answer

oracle11g - Creating a global trigger that listens to multiple tables

I want to create a global trigger in Oracle 11g. Which can be used for auditing of around 100 tables. Can ... then how can I achieve this? See Question&Answers more detail:os...

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

0 votes

430 views

1 answer

oracle11g - Alter table after keyword in Oracle

ALTER TABLE testTable ADD column1 NUMBER(1) DEFAULT 0 NOT NULL AFTER column2; Why can't I use mySql syntax ... Oracle command that I provided? See Question&Answers more detail:os...

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

0 votes

520 views

1 answer

oracle11g - Alter table after keyword in Oracle

ALTER TABLE testTable ADD column1 NUMBER(1) DEFAULT 0 NOT NULL AFTER column2; Why can't I use mySql syntax ... Oracle command that I provided? See Question&Answers more detail:os...

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

0 votes

420 views

1 answer

oracle11g - Understanding the ORA_ROWSCN behavior in Oracle

So this is essentially a follow-up question on Finding duplicate records. We perform data imports from text ... are actually inserted twice? See Question&Answers more detail:os...

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

0 votes

402 views

1 answer

oracle11g - Skipping data fields while loading delimited data using SQLLDR

Consider below scenario: Table T1 (f1, f2, f3); Data files: a|b|c|d w|x|y|z I want to load ... constructing the control file to achieve this. See Question&Answers more detail:os...

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

0 votes

461 views

1 answer

oracle11g - Mystery of rownum in oracle

I am struggling to fetch the data based on rownum. When I execute the below query to get the results based ... me out to create optimize query? See Question&Answers more detail:os...

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

0 votes

416 views

1 answer

oracle11g - How to pass date/timestamp as lowerBound/upperBound in spark-sql-2.4.1v with ojdbc14.jar?

I'm using spark-sql-2.4.1v and ojdbc6.jar to read data from oracle. Have oracle table ... .toInternalBoundValue(JDBCRelation.scala:178) See Question&Answers more detail:os...

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

0 votes

531 views

1 answer

oracle11g - In Oracle "AS" alias not working

Just want to know why Oracle not allowed "AS" alias in Query. In My project all queries which i returned have ... query using "AS"alias name. See Question&Answers more detail:os...

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

0 votes

592 views

1 answer

oracle11g - Raspberry pi No module named 'cx_Oracle'

I want to use the raspberry pi to send values to the Oracle11g database, but when I run import cx_Oracle syntax ... can I solve this problem? See Question&Answers more detail:os...

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

0 votes

718 views

1 answer

oracle11g - Getting ORA-22922 (nonexistent LOB value) or no result at all with wm_concat()

(Using Oracle 11.2) I have a rather complicated SQL with something like wm_concat( distinct abc ) that is ... exceed 1000 characters in length. See Question&Answers more detail:os...

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

0 votes

469 views

1 answer

oracle11g - Meaning of Oracle's dump(systimestamp) bytes

I'm trying to understand what the bytes from the timestamp set on my DB mean. How do they get computed to ... here. Any help is appreciated. See Question&Answers more detail:os...

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

0 votes

616 views

1 answer

oracle11g - ORA-28040: No matching authentication protocol : Oracle 12c Upgrade

We have migrated our Oracle database to 12c from 11g. We have a legacy application running in Java 1.5 and ... to get the application working. See Question&Answers more detail:os...

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

0 votes

454 views

1 answer

oracle11g - Grant SELECT on multiple tables oracle

I have 3 tables table1,table2,table3. I want to grant(select for example) these tables to a user, user1. I ... user1 using only 1 query? Thanks See Question&Answers more detail:os...

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

0 votes

382 views

1 answer

oracle11g - Underscore is not working in oracle like clause

When development, I used 'test_1%' to find 'test_123' in like. But in production environment its not working. Using ... use without escape '''. See Question&Answers more detail:os...

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

0 votes

609 views

1 answer

oracle11g - How to connect to Oracle 11g database remotely

I have Oracle 11g XE installed on computer A. I can connect through the sql command line using the command connect ... . How can I do that? See Question&Answers more detail:os...

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

0 votes

457 views

1 answer

oracle11g - Oracle SQL Developer: Failure - Test failed: The Network Adapter could not establish the connection?

Problem Please note that I changed details for security purposes. However, the problem remains intact. I installed ... . Thanks Regards, Geeky See Question&Answers more detail:os...

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

0 votes

522 views

1 answer

oracle11g - Difference between number and integer datatype in oracle dictionary views

I used oracle dictionary views to find out column differences if any between two schema's. While syncing data type ... if data type is integer. See Question&Answers more detail:os...

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

0 votes

431 views

1 answer

oracle11g - Order of execution of trigger and statements in Oracle stored procedure

Below are my table structures : Table -Customer CustomerID Blacklisted Customer Name 101 Y ABC 102 Y DEF Table ... ) statement. Please suggest. See Question&Answers more detail:os...

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

0 votes

335 views

1 answer

oracle11g - How to find out when a particular table was created in Oracle?

In Oracle, is there a way to find out when a particular table was created? Similarly, is there a way ... row was inserted/last updated? See Question&Answers more detail:os...

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

0 votes

556 views

1 answer

oracle11g - ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

I am getting the above error when trying to connect to a server database from a client using service name orcl. ... Please tell me what to do? See Question&Answers more detail:os...

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

0 votes

446 views

1 answer

oracle11g - Oracle Pivot - converting values into columns

I have table in Oracle 11g with 3 fields: STUDYID | STUDY_PARAMETER | STUDY_VALUE 5268 | Age Group | ADULT (18-65 ... see what I am doing wrong? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags