Category "oracle-sqldeveloper"

SQL developer, retriev one of the values last or first doesn't matter

I have table called generalledger_mgmt that contains many columns. I wrote query to perform some operations and select some of them as below. My problem is some

Oracle SQL how to export null values

in relation with how to copy the records from output of oracle SQL developer to excel sheet I'm using Oracle SQL developer. I've some queries which get some nul

HOST command prefixes quotes with backslash

I have a SQL Plus script, with a code containing: host if not exist &&mksubdir (mkdir &&mksubdir) where &&mksubdir is a string in double

OTBI analytic to function value is not null in any one of the columns for a particular employee

My OTBI(Oracle Transactional Bi report) report have the following columns - Person number Date_to Person Name comp Specialization

How can I get a React application to send SQL queries to an Oracle database and retrieve results?

Background: I need to create a web application that connects to an Oracle database hosted by my university through a VPN. The app does not have to be hosted onl

How to get base table of a column in a view in oracle?

I have a view with some columns in it. How to check that those columns of the views is extracted from which base table? How to get base table of a column in a v

FRM-40501 unable to reserve record to update

I made a table called groups that has these columns client_id, course_name, group_number, day the primary key is (client_id, course_name) so each group num

SQL Developer - Add new connection is greyed out

suddenly, my SQL Developer turned off, i can't add any connection to connect to my work remote databases, i tried to factory reset the views, uninstalled and re

How to prevent Oracle SQL Developer from writing to AppData\Roaming?

Is there any way to prevent Oracle SQL Developer (ver 4.1.5.21) from writing into AppData\Roaming?

How to store password field in oracle 11g database in encrypted form?

I have a table in database with this structure: Username Password Age email Address Phone Number I want to store this table's data manually(not by an input

How to store password field in oracle 11g database in encrypted form?

I have a table in database with this structure: Username Password Age email Address Phone Number I want to store this table's data manually(not by an input

Import data from excel to oracle SQL

When I'm trying to import data from excel to Oracle SQL. I keep getting an error Data is not compatible with column definition or is not available for a not n

Laravel dosen't connect with Oracle

I'm using yajra/laravel-oci8 for Oracle connection with laravel. But I couldn't connected to Oracle, from my client PC to Server. showing this error: I'm u