You're confusing a number with the string representation of a number. A number is just the digits that make up the number. There is no difference between 1234 and 1234.00 - they're both the same floating-point number. Databases shouldn't be...

Oracle

User convert a number to have 2 decimal places in oracle

12 Apr 2024 by sa ku

User Convert a number to have 2 decimal places in Oracle I have a number column whose values I will like to convert into a number with 2 decimal places. For example the number 1234 should become 1234.00 I tried the formula SELECT...

Oracle

Deploy Arm Instances on Oracle Cloud Infrastructure (OCI) using Terraform

11 Apr 2024 by Frédéric -lefred- Descamps

How to deploy Arm instances on Oracle Cloud Infrastructure (OCI) using Terraform

How to resolve the exception and the crash are originating from the runtime itself for RDLC report application

22 Jan 2024 by Dave Kreskowiak

First, that's not an error. That's Trend Micro's anti-virus software preventing your site from working because it's suspicious of something in your code. If Trend has been removed from the machine, or otherwise disabled, you have another...

How to resolve the exception and the crash are originating from the runtime itself for RDLC report application

21 Jan 2024 by SNI

We have report application (.rdlc) which was running fine but suddenly it is giving error for Trend Micro User-Mode Hook Event Module error and post check we have observed that w3wp.exe was not running. Post trying manually this exe is failed...

Stumped on trying to add 2 count subqueries to main query in oracle

17 Jan 2024 by theskiguy

I figured it out. It was a stupid typo. On the 4th line from the bottom I had "as TF", should have just been just "TF"

SQL

Oracle

Stumped on trying to add 2 count subqueries to main query in oracle

17 Jan 2024 by theskiguy

I am try to update an existing query to include 2 subqueries each computing a different count. The main query runs fine on its own and I have been able to get the 2 subqueries to run on their own, however, when I try to join them, I am getting a...

SQL

Oracle

ORA-21780: maximum number of object durations exceeded " error for nested table type

6 Nov 2023 by Maciej Los

This typically happens if there is infinite recursion in the PL/SQL function that is being executed. You should change the condition of recursion to avoid unlimited loop. In other hand, your issue might be related to memory limitations per...

SQL

Oracle

Connection string oracle schema table C#

6 Nov 2023 by Stylus STYLUS

Database name is TEST, user name test, pass test1234 I create a fake account, conection to db work. Data are located on next loaction: When conect to db OTHER USERS/MASTER/Table1 How to read that data to datagrid? I try this code and have error:...

Oracle

Connection string oracle schema table C#

24 Oct 2023 by OriginalGriff

I'm not an expert on Oracle connection strings (though this may help: Oracle connection strings - ConnectionStrings.com[^] ) but ... I can spot an unmatched bracket when I see one: String connectionString = "Data Source=(" ...

Oracle

Getting question marks instead of arabic contents in pdf format while generating crystal reports on oracle solaris

10 Oct 2023 by Richard MacCutchan

If you want to generate Arabic, or any other character set, then you need to ensure the PDF has the correct font installed.

Oracle

CrystalReports

Getting question marks instead of arabic contents in pdf format while generating crystal reports on oracle solaris

10 Oct 2023 by RahPune

Getting Question marks in pdf instead of arabic content on solaris system What I have tried: Excel get generated with correct content

Oracle

CrystalReports

Display the empno, ename and salary if salary is incremented by 10% of all employees

2 Oct 2023 by Harshita1803

I am not able to understand the below question: Display the empno, ename and salary if salary is incremented by 10% of all employees. What I have tried: select empno, ename, salary from emp _ wher salary = (select * from emp wher salary =...

SQL

Oracle

Display the empno, ename and salary if salary is incremented by 10% of all employees

26 Sep 2023 by OriginalGriff

We can't see the actual question your teacher has set you, and the version you show here is lacking in any significant detail, rendering it pretty much unanswerable. And as Richard has said, your SQL is never going to work. So start with the...

SQL

Oracle

To design from procedural language code to object oriented model web applcaition

28 Jul 2023 by Richard MacCutchan

Here are some shortcuts: - Laravel - The PHP Framework For Web Artisans[^] - Composer[^] - PHP: Classes and Objects - Manual[^]

Oracle

PHP

Laravel

To design from procedural language code to object oriented model web applcaition

28 Jul 2023 by Raavi Revanth

I have designed a web application using procedural language model using php javascript jquery bootstrap and oracle database(ie is my browser). Now, i would like to use the same database and design an inetractive web application in chrome or...

Oracle

PHP

Laravel

Extract a string between two strings

27 Jul 2023 by Maciej Los

Try this pattern: 245\-\d{2}\/\$\d{1}(.*?)\d{3}\-\d{2}\/\$\d{1} Example: regex101: build, test, and debug regex[^]

Oracle

regular-expression

Extract a string between two strings

27 Jul 2023 by Member 16059392

Sorry, I know this has likely been asked before but I just can't get it to work in my use case. Need: In the below I need to extract the information between 245 and 250-03 (in bold). Quote: 100-01/$1 郑择魁; 245-02/$1 《阿Q正传》的思想和艺术 / 郑择魁;...

Oracle

regular-expression

To design from procedural language code to object oriented model web applcaition

26 Jul 2023 by Dave Kreskowiak

The only code you get is the code YOU write. Asking people to just hand over code is an insult to everyone, including yourself. Besides, you cannot get code for functionality you never described. Can you succeed? The only person who can answer...

Oracle

PHP

Laravel

Oci8 error: call to undefined function oci_connect()

9 Jul 2023 by Member 14362033

Hello, In my php project, I am using oracle DB and Linux rhel 7.9 as a remote server. I installed oci8 package and enabled the oci8 extension in apache but still, I am getting an error Call to an undefined function. Installed packages...

Linux

Oracle

PHP

ORA-21780: maximum number of object durations exceeded " error for nested table type

19 Jun 2023 by Member 9629252

I have a function and its return type is a nested table type. I have created a nested table type local variable in the function and the variable gets data from cursor with the help of bulk collect .During the bulk collect operation maybe after...

SQL

Oracle

Fetch second activity in SQL

1 May 2023 by AsthanaP

I have below table TABLE=USER_ACTIVITY |USERNAME|ACTIVITY|STARTDATE |ENDDATE | |--------|--------|----------|----------| |Amy |Travel |2020-02-12|2020-02-20| |Amy |Dancing |2020-02-21|2020-02-23| |Amy |Karate ...

SQL

Oracle

Fetch second activity in SQL

1 May 2023 by CHill60

A slight correction to Solution 1 - this query will get the 2nd activity if there are 2 or more activities for a user, OR the only activity if there is only oneSELECT A.* from ( SELECT a.username,activity, ROW_NUMBER() over(partition by...

SQL

Oracle

Fetch second activity in SQL

1 May 2023 by Maciej Los

If you want to get second activity starting from the new one... SELECT A.* from ( SELECT username,activity, ROW_NUMBER() over(partion by username order by startdate desc) seq FROM employee_Activity ) AS A WHERE A.seq=2

SQL

Oracle

Sql QUERY find the customer name, loan number and loan amount of all customers having a loan at the perryridge branch.

9 Apr 2023 by Abed Al Rahman Hussien Balhawan

customer table (CUST_ID,CUST_NAME,CUST_ADDRESS,EMP_ID) take table (CUST_ID,LOAN_NUMBER) table loan (LOAN_NUMBER,AMOUNT,BRANCH_NAME) Find the customer name, loan number and loan amount of all customers having a loan at the Perryridge branch. ...

Oracle

database

Need help in date function of SQL

29 Mar 2023 by Member 14124697

Hi, For better enhancement and to avoid manual modification every month, i need to modify my current query such a way that every month when i run this query in the Oracle SQL, system will run the query for Last month end date of the based upon...

Oracle

Need help in date function of SQL

28 Mar 2023 by OriginalGriff

See here: SQL Server DATEADD() Function[^] - if you provide it with negative numbers, it goes backwards. So subtract today's day-of-month from the current date and you get the last day of last month ...

Oracle

How to compare two file word document by oracle forms

15 Mar 2023 by Sofian Awwad

D جربت ولكن لم استطع الحصول على جواب أو طريقة يوجد بلغات أخرى لكن عن طريق الاوركل لم استطيع اريد أن اعرف الفرق بين ملفين وورد باختلاف التنسيقات Translation: I tried but couldn't get an answer or a way It exists in other languages but...

Oracle

Unable to increase session timeout more than 20 minutes in ASP.NET core 6.0

9 Mar 2023 by Member 15947136

I am not able to increase the session timeout more than 20 minutes in ASP.NET Core 6.0. Session gets expired after every 20 minutes not in debug mode but in IIS (Hosted after publish),For load balancing the application is hosted on 2 server and...

Unable to increase session timeout more than 20 minutes in ASP.NET core 6.0

9 Mar 2023 by OriginalGriff

Check the hosting service: they can override session length requests, and set their own maximum value. Try reducing the session timeout and see if that is obeyed. If it is, it's probably host settings that you can't override. Some (mostly the...

Sql query find all customer id for customers who have an account but no loan

4 Mar 2023 by Abed Al Rahman Hussien Balhawan

customer table (CUST_ID,CUST_NAME,CUST_ADDRESS,EMP_ID) has table (CUST_ID,ACCOUNT_NUMBER) take table (CUST_ID,LOAN_NUMBER) table loan (LOAN_NUMBER,AMOUNT,BRANCH_NAME) table account(ACCOUNT_NUMBER,ACCOUNT_BALANCE) Q1 Find all customer...

SQL

Oracle

database

Settextcontents is not working for oracle EBS java applet form

13 Feb 2023 by Member 14874302

I am trying to automate Oracle form Java Applet using Java Access Bridge through c#. I am able to get value from text field, click on buttons but setTextContents is not working. This is always giving false response only for Oracle form Java...

Oracle

automation

Why Do I Have Questions to GO

9 Feb 2023 by Alexey Shtykov

Lot of fancy languages were born and have died since I started working in IT, but a few of them continue their pitiful existance.

Odata filter for child

21 Dec 2022 by Madhushanka Chithrananda

I have to read invoice line items. To Read all invoices • projection/v1/InvoiceHandling.svc This would list all the invoices in all company registered in cloud(Only Header Info) To Read exact invoice •...

Oracle

OData

Odata filter for child

21 Dec 2022 by OriginalGriff

While we are more than willing to help those that are stuck, that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for...

Oracle

OData

Specified cast is not valid.(for some users only)

1 Dec 2022 by Thăng Nguyễn Ngọc 2022

I'm using .net core 2.2 and some users having this problem: My API code is below: var dt = ktd.LIST_VC_TUITHU_NOUSE_BCS(data.loai_taikien, data.noi_den, data.ma_tuithu, user.ma_buucuc, user.userid); List lstBK = new...

.NET

Oracle

CentOS

Specified cast is not valid.(for some users only)

1 Dec 2022 by OriginalGriff

We don't know the datatypes for any of those variables, and we have no idea where in that code you are getting the error - so we can't directly help you. So the first thing to do is to add a try...catch block to your code, and log the exception...

.NET

Oracle

CentOS

Resolve the 100 people with gun puzzle using only SQL query

27 Nov 2022 by Bittu14

100 people standing in a circle in an order 1 to 100. No. 1 has a sword. He kills the next person (i.e. No. 2) and gives the sword to the next (i.e. No. 3). All people do the same until only 1 survives. Which number survives at the last? There...

SQL

Oracle

Resolve the 100 people with gun puzzle using only SQL query

27 Nov 2022 by Bittu14

First all the even number dies then left with the odd number only. Then the passing goes on within the odd number in sequence from smaller to larger until one people stands, that is number 73 is the winner. The solution requires getting the...

SQL

Oracle

Error while installing oracle jdeveloper 12c (12.2.1.4.0) studio edition

19 Sep 2022 by Mohammad Rahat Akand

I want to install Oracle JDeveloper 12c (12.2.1.4.0) Studio Edition. But I am facing some problem. I can't install the software. I have tried the Generic Version, windows 64bit as well as 32bit. But all the time same issue. But when I install...

Java

Oracle

Vb.net combine lines into one string

17 Sep 2022 by Member 14588284

hi everybody :) i take datatable from excel page then insert oracle database in visual studio when rows more then 5000 then then it gets very slowly i changed my insert command with "INSERT ALL "& INSERT_SATTMSIP &" Select * FROM dual but...

Oracle

Visual-Studio

Vb.net combine lines into one string

17 Sep 2022 by OriginalGriff

Don't build up a huge string, it gets very inefficient as you have to copy the string data to a new string many, many times. Start by using a StringBuilder instead, which reduces the number of copies considerably - particularly if you allocate a...

Oracle

Visual-Studio

Need help in oracle query

26 Aug 2022 by TCS54321

I am new in Oracle. I create a procedure in which i have one select query. SELECT product.digital_product_id , product.product_type , product.product_description , FROM my_product product ...

Oracle

Need help in oracle query

26 Aug 2022 by CHill60

Be consistent in the operators you are using either AND, OR or &&, || but don't mix and match Based on the example in your comment and the code you have posted I'm presuming that you have two parameters to this code :param_productid...

Oracle

Need help in oracle query

25 Aug 2022 by OriginalGriff

Replace 1 = 1 (which is completely unnecessary) with param_productid IS NULL and use OR instead of AND.

Oracle

Executing Raw SQL Queries using Entity Framework Core 6

9 Aug 2022 by DiponRoy

Run Raw SQL Query - Entity Framework Core 6

Oracle

entity-framework

SQL-Server

PLSQL: compressing dataset using partition

5 Aug 2022 by sulaif

I have an interesting problem that I am struggling with resolving Multi row dataset that needs to be combined to produce a start and end times. Below is sample data with expected results. Any help will be greatly appreciated Raw Data ...

SQL

Oracle

ORA-01008: not all variables bound\n

4 Aug 2022 by Member 13019862

My program tried to upload excel file and save into database but failed due to below below error : {"ORA-01008: not all variables bound\n"} {System.Data.OracleClient.OracleException} What I have tried: using ClosedXML.Excel; using System;...

XML

Oracle

web

ORA-01008: not all variables bound\n

4 Aug 2022 by Wendelius

It looks that your code never assigns any values to the variables DATECREATED, DEVICE, LOTID, ... If the content of a variable is null (because not assigning it or it's the actual value) you should use DBNull.Value[^] instead when assigning a...

XML

Oracle

web

Oracle.dataaccess.client.oracleexception: the provider is not compatible with the version of oracle client

21 Jul 2022 by Muthu vj

HI I am Using Visual Studio 2008 . now i am trying to Connect the Oracle Database and Execute my WCF service. i am facing this Error while Execute it can you Help me on this. What I have tried: Oracle.DataAccess.Client.OracleException: The...

Oracle.dataaccess.client.oracleexception: the provider is not compatible with the version of oracle client

21 Jul 2022 by Maciej Los

Please, install proper version of Oracle connector! See: Oracle Data Provider for .NET Versioning Scheme[^]

JDBC connection string for oracle not connecting

15 Jul 2022 by Amey D

Below are my connection settings for Oracle SQL Developer with tnsnames.ora Imgur: The magic of the Internet[^] The pattern of jdbc string required is as below : jdbc:oracle:thin@:1521: What I have tried: I have tried the...

SQL

Oracle

JDBC

Run Database and GUI Clients in Docker

6 Jul 2022 by DiponRoy

Quick start example to run DB and clients in docker

Auto Increment Column Options in Different Databases

4 Jul 2022 by DiponRoy

How to auto increment column options in databases

Merge Data in Database

28 Jun 2022 by DiponRoy

How to use MERGE statements in different databases

How can I use output from one query to take results from 2nd table

28 Jun 2022 by Member 10952123

Select name, Id from table1; select colum1,colum2 from table2 where name='' and id='' ----output from the first table need to take the output from the table2 from all the values from table1 What I have tried: need to join the fist query...

Oracle

How can I use output from one query to take results from 2nd table

28 Jun 2022 by CHill60

You can use the concept of Sub-Queries and join to your results - see Oracle Subquery Made Easy[^] If you are not familiar with joins you can also look at Oracle Joins: A Visual Explanation of Joins in Oracle[^]

Oracle

How to add one column data to another table column using inner joins?

27 Jun 2022 by Suraj Ingle

there are two tables one is COPYCLAIMPRGNOTE and another one is COPYCLAIMPRGNOTE1, COPYCLAIMPRGNOTE contain only 2 columns one is claim_id and another one is NOTE_MEMO_CARETECH. and other table have many columns but NOTE_MEMO_CARETECH column is...

Oracle

How to add one column data to another table column using inner joins?

27 Jun 2022 by Member 12006214

Hi, Insert will add new rows in your new table, it will not update the existing rows. For this you will have to use update query as below UPDATE T1 SET NOTE_MEMO_CARETECH=T2.NOTE_MEMO_CARETECH FROM COPYCLAIMPRGNOTE1 T1 INNER JOIN...

Oracle

How to copy data from one database to another database in oracle?

22 Jun 2022 by CHill60

Firstly, is it safe to assume that you have set up a database link between the two databases? If not then see CREATE DATABASE LINK[^] Your code snippet COPY FROM olddbusername/olddbpassword TO new/newpassword contradicts your statement...

Oracle

How to copy data from one database to another database in oracle?

22 Jun 2022 by Suraj Ingle

I have two databases schema, one is an old database and 2nd is a new database both have same values and tables but in the new database in one table particular one column getting missing so the same column is in the old database also so I want to...

Oracle

How to copy data from one database to another database in oracle?

22 Jun 2022 by rnbergren

more than likely the Contact_ID field has been created to be a uniqueidentifier. It is probably generated by the system. Disabling that and then trying your insert Also then reenable the auto increment for that ID or the generation. Google...

Oracle

How can I create automatically another row after a row in a form in a oracle apex?

9 Jun 2022 by Member 13992723

Hi, everyone. I am building an accounting program in oracle apex. I have the following row: quantity, price, sum. And I want when I input data in those field automatically a new row to be created below, again: quantity, price, sum with empty...

Oracle

From the database I am trying to display a single common name using label please guide me I am a beginner in C#

8 Jun 2022 by Member 15667119

I am trying to make a feedback form where I want to show name which is inserted for n number of times. My DataBase Have for example 9 time same names as feedback was inputted for that same person 9 times and I want to display it on result that...

Oracle

ASP.NET

From the database I am trying to display a single common name using label please guide me I am a beginner in C#

8 Jun 2022 by OriginalGriff

You haven't told us what the problem you are meeting is, but ... don't do it like that! Never concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire...

Oracle

ASP.NET

Having trouble excluding duplicates from SQL server query

7 Jun 2022 by Chris_List

I have two tables that must be joined. I am trying to return ONLY a list of invoice numbers since they will be used in an outside script. The trouble is duplicate records are being produced and I do not want errors in my accounting records that...

Having trouble excluding duplicates from SQL server query

7 Jun 2022 by OriginalGriff

The problem is that they are distinct entries - they all have different invoice numbers as you would expect. So SQL can't "tell" that you mean to exclude them - or what criteria you might want to use to exclude them. If you only one row, then...

System.BadImageFormatException...

17 May 2022 by Sara Noemi

I have developed a C# application which uses Oracle.DataAccess to connect to an Oracle database. I have built it in x86 configuration and install it on the server machine (32 bit) and the program runs correctly.When I try to run it from the client (64 bit) I obtain a...

Oracle

System.BadImageFormatException...

17 May 2022 by amirfg

please also note that the version of "WebView2Loader.dll" which is in use is very crucial. I had almost the same problem with "Microsoft.WebView2.FixedVersionRuntime.101.0.1210.39.x64" when I tried to use the WebView2 component in the MMC...

Oracle

How do I multiply two fields in a form in oracle APEX

17 May 2022 by Member 13992723

Hi, everyone. I am making accounting program in oracle APEX. I need to multiply two fields in a form and to save the result in a third field. Can you help me? What I have tried: I searched for that in youtube and in stackoverflow but did not...

Oracle

How do I multiply two fields in a form in oracle APEX

17 May 2022 by Richard MacCutchan

See Create App from a Spreadsheet | Developer[^]

Oracle

How to check if exists a row before insert - PL/SQL

4 May 2022 by Member 11131110

SQL best way I can think of is add it like this:IF NOT EXISTS ( select 1 FROM APP_PROJECT_GROUP WHERE GROUP_NAME = :v_group_name AND USER_ID = :v_user_id ) BEGIN INSERT INTO APP_PROJECT_GROUP (GROUP_ID, GROUP_NAME,...

SQL

dbase

Oracle

How to check if exists a row before insert - PL/SQL

4 May 2022 by Jose Ewerton Alves Bezerra

Im new with SQL, and I want to knw how can I add a SQL in this structure to check if the row already exists before insert, Im tried this way, but I think its not the best. DECLARE v_project_id NUMBER; v_group_name VARCHAR2(100); ...

SQL

dbase

Oracle

Want to join two pivot for two column

3 May 2022 by xoxo29401

Hello ALL, I want to join two pivot table but getting error on below query. Please, help me Thanks What I have tried: With a1 as (SELECT DISTINCT LEMNUM, STATUSID, CHANGEDATE FROM BI_HZ_ETL.LEM_CNRLEMSTATUS WHERE STATUS NOT...

Oracle

SQL-Server

Want to join two pivot for two column

3 May 2022 by xoxo29401

Thanks Wendelius. Its didn't work. But I solved other way this

Oracle

SQL-Server

What will be execution sequence of from, select, where and group by in SQL engine ?

3 May 2022 by ganeshkavhar8

Suppose we have a requirement to fetch a record on basis of a condition. select records from the table on the basis of where clause and sort them by group by clause. Normally we used to code it like select first_name,salary from table1 where...

What will be execution sequence of from, select, where and group by in SQL engine ?

3 May 2022 by OriginalGriff

Probably teh best thing to do is start here: Analyze an Actual Execution Plan - SQL Server | Microsoft Docs[^]

Want to join two pivot for two column

2 May 2022 by Wendelius

It looks like you're having mismatched parenthesis and a 'naming issue' in pivoting. To isolate the problem, try running each cte separately. Also you seem to have an extra alias in the end of each cte For example the first one could be...

Oracle

SQL-Server

How to insert specific columns without entering in all the values. PLSQL

30 Apr 2022 by Member 15619928

Trying to create a procedure that updates 2 columns (and no more), of a table with 11 columns. I get an error saying: PL/SQL: ORA-00947: not enough values So I'm guessing it wants me to add every column, but I only want to update 2. Is there a...

SQL

Oracle

How to insert specific columns without entering in all the values. PLSQL

30 Apr 2022 by Wendelius

In your question you talk about updating but based on the code I take it that you want to insert the record if it doesn't exist. If that is the case, when you insert a row and you don't provide all values, you need to specify the columns you're...

SQL

Oracle

ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PROC_HRMS_EMPLOYEE' ORA-06550: line 1, column 7: PL/SQL: statement ignored

20 Apr 2022 by Mousumi Sarkar

Thank you for the reply it's working fine now ... create or replace package body PMS_HRMS_LINK AS Procedure Proc_HRMS_Employee(P_EMP_ID in Varchar2, P_EMP_FNAME in Varchar2, ...

Oracle

ASP.NET

ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PROC_HRMS_EMPLOYEE' ORA-06550: line 1, column 7: PL/SQL: statement ignored

20 Apr 2022 by Mousumi Sarkar

What I Have written, create or replace package body PMS_HRMS_LINK AS Procedure Proc_HRMS_Employee(P_EMP_ID in Varchar2, P_EMP_FNAME in Varchar2, P_EMP_TYPE in...

Oracle

ASP.NET

ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PROC_HRMS_EMPLOYEE' ORA-06550: line 1, column 7: PL/SQL: statement ignored

19 Apr 2022 by Mousumi Sarkar

After removing that P_P_ID when I am trying to insert the data into the database table it's not working !!

Oracle

ASP.NET

ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PROC_HRMS_EMPLOYEE' ORA-06550: line 1, column 7: PL/SQL: statement ignored

18 Apr 2022 by OriginalGriff

You add a P_DML_Msg parameter twice when you call it, but don't add a "P_P_ID" parameter. And the second one is added after it's been executed!

Oracle

ASP.NET