Welcome To Ask or Share your Answers For Others

Recent questions tagged oracle11g

0 votes

746 views

1 answer

oracle11g - Calculate business days in Oracle SQL(no functions or procedure)

I am trying to calculate business days between two dates in Oracle select. I got to the point when my ... as BusinessDays FROM TABLE Thanks! See Question&Answers more detail:os...

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

0 votes

626 views

1 answer

oracle11g - Auto Increment for Oracle

I need to create a sequence and a trigger to auto-increment the primary key on a table but I have no idea on how to do it. See Question&Answers more detail:os...

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

0 votes

645 views

1 answer

oracle11g - How to handle Day Light Saving in Oracle database

In one of the Oracle database server it is showing "+01:00" when I fire the "Select dbtimezone from dual" ... after clock change ? How to fix this problem. Question&Answers:os...

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

0 votes

746 views

1 answer

oracle11g - How to uninstall / completely remove Oracle 11g (client)?

How to uninstall / completely remove Oracle 11g (client)? deinstall.bat doesn't work. Edit: Further ... -to-uninstalling-the-oracle-database-client-deleted Question&Answers:os...

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

0 votes

468 views

1 answer

oracle11g - Oracle DB: Leading zeros are disappeared for newly added attribute in type

I have added a attribute by altering the TYPE with char datatype for existing type in oracle DB as ALTER TYPE ... db-leading-zeros-are-disappeared-for-newly-added-attribute-in-type...

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

0 votes

542 views

1 answer

oracle11g - CREATE TABLE statement in Oracle with the existence check

This question is inspired by this. As stated, I don't want a solution from PL/SQL. I want a 1 ... com/questions/65876334/create-table-statement-in-oracle-with-the-existence-check...

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

0 votes

602 views

1 answer

oracle11g - Oracle SQL Developer plot scatter graph

I'm attempting to use the report function within Oracle SQL Developer to plot a scatter graph of my ... stackoverflow.com/questions/65876708/oracle-sql-developer-plot-scatter-graph...

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

0 votes

645 views

1 answer

oracle11g - Is there any way to find url in oracle database 11g?

Is there any way to find url in oracle database 11g ? Suppose I'm having four different schemas, in all schemas I ... /65878851/is-there-any-way-to-find-url-in-oracle-database-11g...

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

0 votes

616 views

1 answer

oracle11g - Can we do real time replication based on a condition on column in Oracle SQL?

Currently we are using Oracle SQL and replicating data. After doing some analysis we found out that we are not ... time-replication-based-on-a-condition-on-column-in-oracle-sql...

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

0 votes

608 views

1 answer

oracle11g - Is there a way to retrieve table identifier in Oracle

ALL, SELECT object_name, object_id FROM all_objects WHERE object_name = '<table_name>'; does not produce anything. SELECT ... is-there-a-way-to-retrieve-table-identifier-in-oracle...

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

0 votes

560 views

1 answer

oracle11g - Create index if not exist

ALL, SQL> SELECT 1 FROM all_indexes WHERE table_name = UPPER( 'abcatcol' ) AND index_name = UPPER( ' ... ://stackoverflow.com/questions/65934684/create-index-if-not-exist...

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

0 votes

692 views

1 answer

oracle11g - I need to convert oracle table data that I get 1 column value fixed as identifier and all other column name & values as a single row

I have a oracle table with multiple columns, I need to convert data in such a way that 1 column value is fixed ... -oracle-table-data-that-i-get-1-column-value-fixed-as-identifie...

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

0 votes

771 views

1 answer

oracle11g - 在Oracle中插入一百万行的最快方法(Fastest way to insert a million rows in Oracle)

How can I insert more than a million rows in Oracle in optimal way for the following procdeure? (如何针对以下过程以最佳方式 ... is '||l_end); End inst_prc1; ask by user1016594 translate from so...

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

0 votes

717 views

1 answer

oracle11g - 在Oracle中插入一百万行的最快方法(Fastest way to insert a million rows in Oracle)

How can I insert more than a million rows in Oracle in optimal way for the following procdeure? (如何针对以下过程以最佳方式 ... is '||l_end); End inst_prc1; ask by user1016594 translate from so...

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

0 votes

727 views

1 answer

oracle11g - 在Oracle中插入一百万行的最快方法(Fastest way to insert a million rows in Oracle)

How can I insert more than a million rows in Oracle in optimal way for the following procdeure? (如何针对以下过程以最佳方式 ... is '||l_end); End inst_prc1; ask by user1016594 translate from so...

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

0 votes

739 views

1 answer

oracle11g - 在Oracle中插入一百万行的最快方法(Fastest way to insert a million rows in Oracle)

How can I insert more than a million rows in Oracle in optimal way for the following procdeure? (如何针对以下过程以最佳方式 ... is '||l_end); End inst_prc1; ask by user1016594 translate from so...

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

0 votes

714 views

1 answer

oracle11g - 在Oracle中插入一百万行的最快方法(Fastest way to insert a million rows in Oracle)

How can I insert more than a million rows in Oracle in optimal way for the following procdeure? (如何针对以下过程以最佳方式 ... is '||l_end); End inst_prc1; ask by user1016594 translate from so...

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

0 votes

617 views

1 answer

oracle11g - How to merge a subquery result to the results of another subquery per row?

I'm struggling to find a way to get my desired output. It's the subquery that making it hard for me. Need ... So basically, what I'm struggling with is the TOTAL_SALES column....

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

0 votes

901 views

1 answer

oracle11g - Where is /etc/sysconfig/zabbix-server on ubuntu 18.04

so I was trying to make monitoring oracle database by ODBC using Zabbix, I follow some step from this Github my Zabbix ... server, is it the same from /etc/sysconfig/zabbix-server?...

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

0 votes

873 views

1 answer

oracle11g - Reverse of ascii function in Oracle

When I do following query select asciistr(first_name) from person where id = 1 the result contains '200D'. So what is ... , so I can find all names with that specific character....

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

To see more, click for the full list of questions or popular tags.

...