Skip to Main Content

Breadcrumb

Archive Contents

SubjectLast Updated
rouning inconsistency in oracle db 8.5 years ago
Grant Compile Packaged to Other User 8.5 years ago
Privilege required to execute a stored procedure 8.5 years ago
Change all procedures in a schema 8.5 years ago
How do I use UTL_SMTP to automatically send an email when a database table column value change? 8.5 years ago
oracle data block corrupted(file # 4,block # 3676) 8.5 years ago
Find value if found return the same or else look some other value to return in Oracle SQL 8.5 years ago
Compound trigger unexpected behavior for MERGE and BULK operations 8.5 years ago
Locking issues on Table A with FKs on table X while a procedure inserts records in table B with FKs on table X too 8.5 years ago
ORA-04020 between 2 sessions dealing with 2 different schemes 8.5 years ago
Does Oracle have a host OS utility similar to Sybase or SQL Server bcp? 8.5 years ago
Run bash scripts from application server for DBA tasks on DB server 8.5 years ago
apex version usage 8.5 years ago
Parsing json file 8.5 years ago
Above quiz ask during interview.-Particular string converted into table of column 8.5 years ago
Refreshing nested materialized views 8.5 years ago
spool output columns in seperate csv column - call from SQL developer 8.5 years ago
Insert statements 8.5 years ago
Refreshing SQL Profiles 8.5 years ago
Rename index with DBMS_METADATA 8.5 years ago
Degree of Parallelism (DOP) of Index 8.5 years ago
Issue with OR expanding and subquery 8.5 years ago
Column data conversion 8.5 years ago
Primary key type and performance 8.5 years ago
Compound Principle Amount and Profit Calculation 8.5 years ago
Multiple Oracle Homes on Exadata 8.5 years ago
using dynamic port 8.5 years ago
Difference BW 11G & 12C 8.5 years ago
Is it possible to reuse the same Connection (established from an external JDBC client) within a java stored procedure? 8.5 years ago
Is there a way to create local hash partition index? 8.5 years ago
Fetch records in multiple variables 8.5 years ago
Is it known error with timestamp field update in a compound trigger internal procedure? 8.5 years ago
How to format long number result? 8.5 years ago
Parsing comments in SQL 8.5 years ago
How to call one database procedure another database don't pass as dblink 8.5 years ago
subtracting/adding day to dates but not counting sat and sun 8.5 years ago
Oracle 12C 8.5 years ago
Building a complex logic for grouping the day of the week and time 8.5 years ago
Non partition to composite partition. 8.5 years ago
can i cache a table on active physical standby dataguard database 8.5 years ago
Performance issue for global temp table 8.5 years ago
Sequence reset problem on RAC 8.5 years ago
GRANT CREATE FUNCTION TO edeploymentuser; : FAILS with an error 8.5 years ago
AWR 8.5 years ago
ORA-00904 INVALID IDENTIFIER IN MERGE THOUGH COLUMN IS ALIASED 8.5 years ago
Swap Join Inputs Optimization 8.5 years ago
listener issue 8.5 years ago
Pipelined Functions 8.5 years ago
How to place UNION queries in specific order 8.5 years ago
How can I implement a “natural sort” order-by in a SQL query using REGEXP_LIKE ? 8.5 years ago
Deny developers access to schema owner of tables 8.5 years ago
Extracting information from SQL*LOADER log 8.5 years ago
Extract data from a table to Hadoop File System, 8.5 years ago
oinstall group 8.5 years ago
Reorg and partition 8.5 years ago
Security 8.5 years ago
FAST_START_MTTR_TARGET parameter for OLTP 8.5 years ago
shared pool issue 8.5 years ago
Removing a datafile associated with a tablespace that is no more in the database 8.5 years ago
Is there any difference in the execution plan (for better or worse) the order of tables in the from clause? 8.5 years ago
How to alter system password in oracle 11g 8.5 years ago
bind variable does not exist 8.5 years ago
Binding variables change names each time. How to avoid hard parse? 8.5 years ago
Global Session Parameter must be true when bulk inserting over a database link using a local function 8.5 years ago
Oracle Analytics 8.5 years ago
Pl/SQL For loop 8.5 years ago
Calculate months with two date 8.5 years ago
Printing a name with out using dbms_output.put_line 8.5 years ago
Query used for fetching records from last executed query is taking much time 8.5 years ago
want to automate partition truncate 8.5 years ago
dbms_repair.rebuild_freelists v.s Move v.s Shrink 8.4 years ago
Fetch Ref cursor to another ref cursor 8.4 years ago
CTAS returns ORA-31011: XML parsing failed 8.4 years ago
the best way to count distinct tuples 8.4 years ago
Fast Refresh materialized view filter help 8.4 years ago
Query go down on knees when selecting a CLOB or a BLOB column data type 8.4 years ago
Oracle Text Contains search with Near is very slow 8.4 years ago
Edition based redefinition- Data handelling 8.4 years ago
Gather Index Stats ve Rebuild Index 6.7 years ago
When it's time to close cursors 6.3 years ago
SQL loader to load data from excel spreadsheet 5.7 years ago
Spool file hide SQL statement 5.2 years ago
Query on SCAN Listener 3.7 years ago
Unused indexes Identification 3.2 years ago
to_char manipulates DST times ? 3.1 years ago
ORA-01460: unimplemented or unreasonable conversion requested 2.8 years ago
Parsing of query 1.7 years ago
Security lockdown - revoke all privileges from PUBLIC 1.4 years ago
Getting ORA-31626: job does not exist and ORA-06512 from my export data pump job 1.1 years ago
Sending Mail Through Oracle Which Has HTML Table Content Or Sending mail Through Attachment Using Oracle 7 months ago

Clicking a subject will open in the thread in a new browser tab