Oracle Questions

As far as i know, foreign keys (fk) are used to aid the programmer to manipulate data in the correct way. suppose a programmer is actually doing

I have an java desktop application which connects directly with the db (an oracle). the application has multiple user accounts. what is the

I'm looking for a simple, sample snippet of c# code to monitor an oracle database and basically check for its last update. it could be either

When trying to enter a sql query with parameters using the oracle ole db provider i get the following error: parameters

How do i deploy an adf business component to the middle tier and call it using

Basically, i'm trying to selectively copy a table from one database to another. i have two different [oracle] databases (e.g., running on

Yesterday i wanted to add a boolean field to an oracle table. however, there isn't actually a boolean data type in oracle. does anyone here know

I am trying to make a procedure that would insert a row into a table in oracle sql. however, i can't figure out a solid reason on why this issue

i have an oracle database backup file (.dmp) that was created with expdp. the .dmp file was an export of an entire

I want to select the contact info (email and phonenumber) of all employees working between 2 time ranges in shops of type market and have

I need to write a "reverse" like condition with jpa predicate over oracle dbms. the example query i need to build is:

I have this request in oracle that is used by a php file $pub_request = oci_parse($conn, " select * from tp2_publicite p,

{ "description": "test", "id": "1", "name": "test", "prod": [ {

For college i'm doing a thesis on performance in different dbms. i have set of tables with same set of data in 5 different dbms (mysql, mariadb,

I am looking for a way to find all previous versions of the dbms (oracle is used). my point is to return versions of the dbms that ever existed on

I have this following code which prints the department number and department name from dept table whose department number is less than 40.

What i have is this: vi_id dp_date employee_id qty prate 1/1/2020 10000001 33 1/2/2020 10000001

I'm using oracle 18c express edition and trying to connect to the same using the below code.

Select case to_char(last_day(sysdate),'day') when '1' then last_day(sysdate) - 1

I used to write pl/sql procedures in oracle dbms. few times i would end up in situations like infinite loop and the query continuously running i

I have created an oracle job using dbms scheduler.but the status gets failed in the execution. it gives the following error. 'ora-27367:

I'm using oracle sql developer making pl/sql code. my code is to print the data by using a mathematical formula in dbms_output. however, codes

I am trying to write a block of sql code that compares two dates from two tables. one table shows when an item was acquired (ci_acquired_date).

For this assignment i have to return the names of the columns in all tables from a specific user where the column name has at least 2 vowels and

I've got the following query select 1, 2 from dual and i'd like something like select

I am trying to build a dependency graph of tables based on the foreign keys between them. this graph needs to start with an arbitrary table name

I am making a post call from ajax to node server. server makes the call and gives the response. but also below error displays in the cmd

In my tests i need to test what happens when an oracleexception is thrown (due to a stored procedure failure). i am trying to setup rhino mocks

I have an application deployed into multiple zones and there are some issues with opening larger documents (20-50mb) across the wan.

I have a webpp which works fine when under a light load. however, when we run a lot of threads each with their own database connection, then we

I have loaded image into a new, initialized oracle ordimage object and am processing it by pl/sql. i can read its properties, but cannot process

A sample perl script that connects to an oracle database, does a simple select query, and spits the results to stdout in csv format would be

Implementing: an employee email address should use the company domain. that is, the email address should end with 'abcco.com'.

Please help to modify the below code. i want to join these two select queries such that i can get a single output with records from two diff

In raport i create, i take data and separate hour in varchar. i must concat that and change type to timestamp date from user '20220323' in

I have a table with a date column (dd/mm/yyyy hh:mm:ss) as follows: 02/09/2021 09:50:37 03/09/2021 09:20:27 02/09/2021 14:05:25

For example, i have a table named xyz and it has a column country, how can i take out results in the following format using group by function,

I am interested in what methods of logging is frequent in an oracle database. our method is the following: we create a log table for the

I was asked to write a simple procedure, that inserts a new row into a table under certaing condition. the database: table users - user_id ....

I have external table created as below. create table external_table ( "col1" date ,

I have the following entities class productunitofmessure @manytoone @joincolumn(name="product_id") private product

I have three tables and would like to answer the following question in sql: "who has only certifications that do not have

I am making a query to a table, where i am interested in bringing the contract numbers that are being repeated, and for this i use partition by,

I am trying to split a string "hhhwwwhhhhwwwwwhhwwwwwhhwwwwwhh" is there any possibility to make like : h h h w w w

I have a column entitled "grade" and defined as varchar2(3); however when i have a grade value of '100' the system under oracle sql

I am trying to case a column that has a date format of dd-mmm-yyyy. basically, i am trying to convert the dates into a fiscal year column

What is the difference between views and materialized views in oracle?

In a node.js project i'm using oracle-orm-zn for the

I'm trying to complete an exercise for an assignment for my database programming class using oracle livesql. i defined the column that appears in

I am trying to connect to oracle database using cx_oracle in python. i am able to connect to the database and pull the data. now i am

I have two tables, one table has from_serial, to_serial and transaction_date. and another table has serial_no and activation_date. i want to merge

I got a sample data as below in this cte_orders. each row is a order and contains the user_id, zone_code and zone_name. i need to rank the

I am trying to display a record rowtype in oracle, i am getting sql error [900] [42000]: ora-00900: invalid sql statement at line 7

I have the code below for our erp system with ifs. the code calls a stored procedure after setting all the parameters. p3 is an inout parameter

I would like to manually authenticate the users in my company. the issue is that, i have 2 tables, called student and staff in the oracle

I need to print pdf documents to my network printer from my android studio application. i want to print the pdf as is with all images and

I want the following query to be executed but i get an error: insert into personal_info (case_type) values ('unknown') where

I would like to insert data into an oracle database table by using insertintotable which is referenced in the code below; the

I am creating an oracle-jet application, in which i have a requirement to use ojet-lists. i call the data dynamically from a rest api. here's the

How can i return a file from a blob column using nodejs? i'm using the oracledb library to handle the database operations and

Enter image description here so i have the following table and

I am creating an oracle database with a table called roles. i want the permission_level row to store values 1,2,3,4, or 5. how to i limit

I have been learning sql,and i was trying to learn about the case on oracle livesql: this is the query i am trying to use:

I need to return some oracle images that are recorded in lob field to send them to firebase storage. i am using oracledb with typescript

Ok so i'm writing a trigger in sql and what needs to happen is that if t is deleted and f.actdepartdatetime is not null then the table is backed

I am inserting new users into users table in oracle db but encountering this error, oracle: error: njs-012:

There was a similar question

I'm trying to figure out a way to return results by using the group by function. is it possible to have a group by ignoring the null field.

I have two unrelated oracle 11g database instances. i need to select a value of type clob from the one database and insert it to the other with

I have a column in my table for an id that is normally populated with .nextval. the .nextval works perfectly as a normal sql statement such as

I am using graphql in node js for my oracle database wherein i connect to the remote database and fetch some details. i am fairly new to these

I'm trying to change the sortest_tesc_code of any tuple whose sortest_test_date is greater than 5 years to zzz select sortest_pidm,

We have a batch job that needs to update millions of rows (not all rows) of a table with a particular value. we have the following

I have lately started learning sql,and as a part of my assignment,i was trying to solve this question:

I have a requirement in oracle to replace the special characters at first and last position of the column data.

I have following stored procedure inside the package: create or replace procedure

Response.setcontenttype("application/json"); response.setcharacterencoding("utf-8"); printwriter out = response.getwriter(); string

I try to make oracle request in python from raspberry pi. the problem is: "oracle does not support the arm cpu architecture which the

I have following code but it just doesn't seem to work. i don't understand what's wrong. await connection.execute( `update

I am trying to use the npm oracle library and update some tables with blob values created from files on my computer. oracle documentation says to

I want to find the columns in all the tables that could have the specific data or value in oracle. example:[email protected] how can i

I'm trying to create a procedure in an oracle database that will update the pmbpcsb with an 'x' if any of the other columns have a value present.

I try to make a sum in this formula but i have one issue, not group by expression ? who is the problem ? select round( sum(

I have a case statement (mycol is a number): select case when mycol < 0 then 0 else round(power(10,avg(log(10,mycol))),2) end

I have a table of distances from headquarters in 2 dp. i am trying to find the percentage of customers within 2 and 5 miles. select

I try to make login with flutter, nodejs(express), and oracle the backend is working when i test it with postman i can get the token here postman

Here is my code in laravel with oci8. i get this result oci8 statement resource @364 . does anyone

My organisation does not allow me to use pip to install python libraries, hence i downloaded the zip for cx_oracle (python-cx_oracle-master.zip)

I don't understand behaviour of my code. why when i have select min(i.column_name) into value_min from employees; in my code (see

I have the need to show on my .net core program an oracle view that in the database has some columns filtered by ... where

So i have a table employees as shown below id | name | department ---|------|----------- 1 | john | home 2 | alex | home 3 |

I'm new to this, i have some project that i must use a procedure in my oracle to run on laravel model/controller, but first in the model i already

I'm using oracle database version 12.1.0.2.0. i'm running a query that returns two columns, "permit #" and "date issued."

So i have two tables with information below one which is a holiday table which marks the location to and from and etc. and another table that has

I am using the oracledb cen node.js module and when making a database connection to make a select, it returns the data but this error also

I know you can remove html tags with a command such as this: regexp_replace(overview, '<.+?>') but, some of

I want to append dataframe (pandas) to my table in oracle. but this code deletes all rows in table:( my dataframe and my result become

I'm building a python file with docker. in this python file, i import cx_oracle to do something with oracle. i can run the python

I am using react js for frontend and node js for backend along with oracledb. i need to make the login page using the above technologies with