Recent questions tagged oracle11g

0 votes

592 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

490 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

460 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

631 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

506 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

448 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

534 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

529 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

493 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

561 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

466 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

421 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

482 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

444 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

568 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

630 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

737 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

503 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

657 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

489 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

402 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

651 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

484 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

541 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

452 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

363 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

601 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

481 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