Recent questions tagged oracle

0 votes
1 answer

Compare each excel sheets with a table in oracle

Feb 5, 2023 in Others by Kithuzzz
 • 38,000 points • 815 views
0 votes
0 answers

how to connect ELK to Oracle DB using JDBC input plugin

Jan 3, 2023 in DevOps on Cloud by Damonlang
 • 1,230 points • 848 views
0 votes
0 answers

How to use "alter system.." sql statement in AWS RDS oracle?

Dec 14, 2022 in AWS by Roshan
 • 300 points • 1,089 views
0 votes
0 answers

How to use "alter system.." sql statement in AWS RDS oracle?

Dec 14, 2022 in AWS by Tejashwini
 • 5,380 points • 810 views
0 votes
0 answers

Convert oracle UDF function with to_number and value_error expection in it to AWS RDS maria db

Dec 14, 2022 in AWS by Tejashwini
 • 5,380 points • 767 views
0 votes
1 answer

How to download and setup sqlplus for running sql commands?

Nov 4, 2022 in Others by gaurav
 • 23,580 points • 2,388 views
0 votes
1 answer

When doing a MERGE in Oracle SQL, how can I update rows that aren't matched in the SOURCE?

Nov 4, 2022 in Others by gaurav
 • 23,580 points • 1,766 views
0 votes
1 answer

SQL Error: ORA-00933: SQL command not properly ended

Nov 4, 2022 in Others by gaurav
 • 23,580 points • 1,369 views
0 votes
1 answer

What does SELECT COUNT(1) from table_name on any database table mean

Sep 18, 2022 in Database by Kithuzzz
 • 38,000 points • 1,080 views
0 votes
1 answer

Is there a combination of "LIKE" and "IN" in SQL?

Sep 17, 2022 in Database by Kithuzzz
 • 38,000 points • 5,338 views
0 votes
1 answer

How to find top three highest salary in emp table in oracle?

Sep 17, 2022 in Database by Kithuzzz
 • 38,000 points • 10,886 views
0 votes
1 answer

Oracle PL/SQL - ORA-01403 "No data found" when using "SELECT INTO"

Sep 17, 2022 in Database by Kithuzzz
 • 38,000 points • 7,220 views
0 votes
1 answer

CASE .. WHEN expression in Oracle SQL

Sep 16, 2022 in Database by Kithuzzz
 • 38,000 points • 959 views
0 votes
1 answer

How do I limit the number of rows returned by an Oracle query after ordering?

Sep 13, 2022 in Database by Kithuzzz
 • 38,000 points • 2,696 views
0 votes
1 answer

SQL Error: ORA-00922: missing or invalid option

Sep 13, 2022 in Database by Kithuzzz
 • 38,000 points • 3,166 views
0 votes
1 answer

SQL Error: ORA-01861: literal does not match format string 01861

Sep 12, 2022 in Database by Kithuzzz
 • 38,000 points • 16,383 views
0 votes
1 answer

Oracle SQL Developer: Failure - Test failed: The Network Adapter could not establish the connection?

Sep 12, 2022 in Database by Kithuzzz
 • 38,000 points • 6,296 views
0 votes
1 answer

java.sql.SQLException: IO Exception : The Network adapter could not establish the connection?

Sep 12, 2022 in Database by Kithuzzz
 • 38,000 points • 6,701 views
0 votes
1 answer

How to display databases in Oracle 11g using SQL*Plus

Sep 11, 2022 in Database by Kithuzzz
 • 38,000 points • 4,017 views
0 votes
1 answer

How can I confirm a database is Oracle & what version it is using SQL?

Sep 11, 2022 in Database by Kithuzzz
 • 38,000 points • 1,200 views
0 votes
1 answer

java.sql.SQLException: - ORA-01000: maximum open cursors exceeded

Sep 10, 2022 in Database by Kithuzzz
 • 38,000 points • 4,294 views
0 votes
1 answer

How to solve : SQL Error: ORA-00604: error occurred at recursive SQL level 1

Sep 8, 2022 in Database by Kithuzzz
 • 38,000 points • 6,085 views
0 votes
0 answers

SQL Error: ORA-00913: too many values

Sep 5, 2022 in Database by Kithuzzz
 • 38,000 points • 2,580 views
0 votes
0 answers

What is the Oracle equivalent of SQL Server's IsNull() function?

Sep 4, 2022 in Database by Kithuzzz
 • 38,000 points • 902 views
0 votes
0 answers

SQL Error: ORA-00942 table or view does not exist

Sep 4, 2022 in Database by Kithuzzz
 • 38,000 points • 1,306 views
0 votes
0 answers

Convert timestamp to date in Oracle SQL

Aug 29, 2022 in Database by Kithuzzz
 • 38,000 points • 1,301 views
0 votes
0 answers

SUBSTR and INSTR SQL Oracle

Aug 29, 2022 in Database by Kithuzzz
 • 38,000 points • 3,596 views
0 votes
0 answers

DECODE function in SQL server

Aug 27, 2022 in Database by Kithuzzz
 • 38,000 points • 679 views
0 votes
0 answers

How to Return Multiple Values from CASE clause in Where Condition

Aug 25, 2022 in Database by Kithuzzz
 • 38,000 points • 2,523 views
0 votes
0 answers

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Aug 22, 2022 in Database by Kithuzzz
 • 38,000 points • 7,764 views
0 votes
0 answers

What's the difference between RANK() and DENSE_RANK() functions in oracle?

Aug 22, 2022 in Database by Kithuzzz
 • 38,000 points • 701 views
0 votes
0 answers

How do I view the Explain Plan in Oracle Sql developer?

Aug 19, 2022 in Database by Kithuzzz
 • 38,000 points • 1,699 views
0 votes
0 answers

PL/SQL ORA-01422: exact fetch returns more than requested number of rows

Aug 19, 2022 in Database by Kithuzzz
 • 38,000 points • 1,620 views
0 votes
0 answers

How to Alter Constraint

Aug 15, 2022 in Database by Kithuzzz
 • 38,000 points • 981 views
0 votes
0 answers

Display names of all constraints for a table in Oracle SQL

Aug 15, 2022 in Database by Kithuzzz
 • 38,000 points • 1,086 views
0 votes
0 answers

CLEAR SCREEN - Oracle SQL Developer shortcut?

Aug 14, 2022 in Database by Kithuzzz
 • 38,000 points • 7,906 views
0 votes
0 answers

Oracle SQL: Update a table with data from another table

Aug 13, 2022 in Database by Kithuzzz
 • 38,000 points • 1,386 views
0 votes
0 answers

Creating a new database and new connection in Oracle SQL Developer

Aug 12, 2022 in Database by Kithuzzz
 • 38,000 points • 941 views
0 votes
0 answers

How can I set a custom date time format in Oracle SQL Developer?

Aug 12, 2022 in Database by Kithuzzz
 • 38,000 points • 1,079 views
0 votes
0 answers

Comparing Dates in Oracle SQL

Aug 9, 2022 in Database by Kithuzzz
 • 38,000 points • 2,710 views
0 votes
0 answers

How do I list all the columns in a table?

Aug 9, 2022 in Database by Kithuzzz
 • 38,000 points • 792 views
0 votes
0 answers

embedding image in html email

Aug 8, 2022 in HTML by Tejashwini
 • 780 points • 1,230 views
0 votes
0 answers

how to take user input in livesql.oracle.com in PLSQL

Jun 8, 2022 in Others by polo
 • 1,480 points • 1,210 views
0 votes
0 answers

ORA-00904: invalid identifier

May 20, 2022 in Database by Kichu
 • 19,040 points • 1,285 views
0 votes
1 answer

ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client

Feb 22, 2022 in Others by Rahul
 • 9,690 points • 1,969 views
0 votes
1 answer

How to insert date values into table?

Feb 18, 2022 in Database by Neha
 • 9,020 points • 4,092 views
0 votes
1 answer

How to import excel file in Oracle SQL live

Feb 18, 2022 in Others by Edureka
 • 13,690 points • 2,489 views
0 votes
1 answer

error: ORA-65096 - invalid common user or role name in oracle

Feb 16, 2022 in Others by Rahul
 • 9,690 points • 27,394 views
0 votes
1 answer

SQL error "ORA-01722: invalid number"

Feb 15, 2022 in Database by Vaani
 • 7,070 points • 3,634 views
0 votes
1 answer

Number of rows affected by an UPDATE in PL/SQL

Feb 14, 2022 in Database by Neha
 • 9,020 points • 1,714 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.