oracle

oracle

📝How to find tables with foreign keys that reference a specific table

📝If the record exists in target but doesn't exist in source, i need to delete it

📝select distinct one column and pick just one occurence out of the second one

📝Oracle: convert varchar2 to the datetime format 'yyyy-mm-ddThh:mm:ssZ'

📝Extremely slow ResultSet next() performance

📝Want to make the output human readable

📝Issue while using between operator in oracle SQL

📝System.Runtime.InteropServices.COMException (0x80070008): Not enough storage is available to process this command

📝Simple SQL Query 1

📝PL/SQL Dynamic action [Set Value] not recognizing apex item value

📝How to insert data into a PL/SQL table type rather than PL/SQL table?

📝Triggers Oracle || Backup records to another table after insert

📝Query uses rank() needs optimization

📝How to drop overloaded functions in Oracle?

📝How do I extract consonants from a string field?

📝How to replicate schema with the same privileges of an existing account in oracle?

📝Can't Connect to SQL*Plus using SID

📝Oracle Minus - From a list of values, how do I count ONLY non reversed values

📝How does Oracle Insert Into work when order of values is not defined?

📝Visual Studios .NET 4 - adding Oracle Database as Data Source - Warnings about OracleDataAdatper deprecated

📝Not handle no_data_found

📝Limit ConnectionTimeout for Oracle Database

📝A required class was missing oracle/jdbc/OracleDriver when executing custom Maven Plugin

📝Run a select based on an if condition

📝sql to get intersection in a many to many relation

📝Oracle Multiple queries with locked row

📝sql for Oracle updation

📝Warning: oci_connect(): OCIEnvNlsCreate() failed

📝SQL - How to select a row having a column with max value in Oracle

📝Reading clob line by line with pl\sql

📝Defining tablespace for local index in Oracle

📝Need to incorporate Timezone Selection (UTC) within Web App

📝How to kill long running queries through Pro*C?

📝Select columns if row exists else default values in oracle

📝ORA-00979: not a GROUP BY expression in Oracle

📝Oracle Client and Oracle Server on different Operating systems

📝How to convert string to clob?

📝How to Escape dot(.) In a like expression in Oracle PL/SQL Statement

📝no matching unique or primary key for this column-list

📝oracle decode not working well with character

📝Convert a row to column depending on Conditon

📝Oracle update data by function regexp_*?

📝How to aggregrate without using `GROUP BY`?

📝sql missing or invalid option on create table statement

📝Oracle sql to count instances of different values in single column

📝Hi, I'm trying to create a list by getting values from the user, I have used pl SQL table of type object. but I'm getting errors while inserting

📝ORA-00904 invalid identifier on decode alias

📝SEVERE: Error while registering Oracle JDBC Diagnosability MBean

📝Oracle Database Error At Startup of Windows 10

📝How to pass a variable in oracle and return the date

📝Merge statement

📝Hibernate and Oracle overstate sequence incrementing

📝passing the desc command to oracle using openquery

📝INSERT SELECT with SELECT's column object

📝Reverse a comma separated column that stores hierarchy

📝How to implement a cross-database foreign key constraint?

📝Generate Logical model from oracle database

📝Get values between ranges

📝sqoop data from oracle to hive ERROR

📝Using the returned select rows while updating a table

📝Converting hexadecimal string in Oracle

📝How to partition a table copied from another schema?

📝split string into multiple rows with multiple columns

📝how to SELECT a column which has a space in between its name

📝How to make Oracle UCP always store several available connections

📝Can I create a brand new oracle db/schema with roundhouse?

📝Is oracle DB able to return timezone region rather than just the offset?

📝Count different enteries by year in SQL

📝PLS-00201: identifier 'CURSOR' must be declared

📝How to convert this Oracle stored procedure into a SQL Server stored procedure?

📝Toad SQL Query: Sorting by a column, then removing duplicates of that column based on the max of another column

📝Command to clear SQL PLUS prompt

📝Oracle Enterprise Manger Agent not working, making it not possible to configure EM DB console

📝Create view in ORACLE

📝Is there a way to group values getting only the ones that verifies certain condition?

📝How to find connection string in Visual Studio Code

📝return data as cursor from function in pl/sql wiithout create type oracle 11g

📝Are data files required when creating tablespaces in Oracle?

📝range between interval that does not include the first row

📝VBA - Query with multiple AND statement not working

📝How to copy a JOB, PROGRAM, SCHEDULE definition to run it in another Oracle 11g DB?

📝What Is The Correct Way To Comment in SQL?

📝How to Oracle SQL return where values when now records found.?

📝Oracle - Count distinct values of a column

📝Oracle SQL - Query 2 tables based on their foreign keys

📝How to note down the multiple null columns from the multiple table with a single query, procedure

📝NOT IN or NOT EXISTS which is faster in Oracle10g?

📝how to fetch email address from oracle database

📝Variable that stores date with minutes and seconds

📝SQL Oracle to select a column that displays the highest value in a result set

📝Procedure to download file from a given url in Oracle 11g and save it into the blob type column

📝How to get names of Objects inside Custom Oracle Types in JDBC

📝How could I define a trigger which fires only when a particular column is updated to a certain value?

📝Best way to keep track of when a table was last updated?

📝Can't Connect PHP - Oracle 11g

📝What happen when we drop table & package in oracle?

📝ORA-02303: cannot drop or replace a type with type or table dependents

📝Sql plus doesn't show English

📝Why does converting date to_char() throw ORA-01830 error when placed in a case-then?

📝Compare values for audit trail

📝How can I load data from java into oracle DB

📝Refresh index stats in another schema

📝Upgrade to Oracle 11g to 19c

📝What are different types of locks in oracle

📝How to List Specification Data

📝Join to an oracle table valued function

📝PL/SQL: numeric or value errors

📝Loop through all rows and concat unique values in SQL table

📝Why SQL statement is taking so long to execute PL/SQL when using variables?

📝SQL query to get sum of headcount according to column grouping

📝sql loader requires dat file to load the data

📝Create a view/temporary table from a column with CSV

📝Trigger Oracle - Cant capture the userinformation who change the table

📝Extract xml data using oracle query

📝PLS-00103: Encountered Symbol DECLARE/EOF when trying to increment values with a sequence

📝ExecuteReader return null value for one of the column but data exist in the database

📝while creating a audit trigger throwing warning as Compilation error

📝How can you create a single-value sequence?

📝Creating a CLOB object from custom class object

📝return 0 in select count when no record found

📝date check to avoid exception in sql

📝Query must begin with SELECT or WITH error?

📝OracleResultSetMetaData throwing NullPointerException in its <init> method

📝Getting Mapped column names in knowledge module

📝Issue with Oracle SQL where statement

📝SQL query for statistic info

📝How to determine if an employee is a manager?

📝Which limitiations exist in using ORACLE CUSTOM DATA TYPES as parameter in PL/SQL Stored Procedures?

📝Get column names from procedure result

📝How to convert a varchar to a table name?

📝Oracle PL/SQL package/procedure for processing CSV from CLOB

📝Concurrent database creation

📝Oralce Query to pick the right record

📝How Split Json with oracle 19

📝User is not permitted to create v$ or x$ in one of my oracle database

📝Extract warehouse mappings as creation script

📝QlikView Data Load from Oracle Script

📝How to update one table column with its own value plus a variable from other table?

📝use select case result in other select

📝Hiding/Locking tables in oracle

📝not able to do a UNION in Oracle SQL

📝SQL invalid identifier and ambiguousy defined alias

📝subtract dates in workflow table with type and datestamps

📝ORA-01830 when converting number to words

📝Oracle Column Based on Another Column

📝SQL SELECT How to find a substring number in between two columns?

📝How to increment a string having number fields in oracle?

📝I'm getting an error on Oracle Apex ORA-00907: missing right parenthesis

📝SQL Self-Join Query

📝Oracle: How to DEREF a VARRAY of REFs and NESTED TABLE of REFs?