Tag: oracle

974 Get list of all tables in Oracle? 2008-10-15T17:54:49.387

852 How do I limit the number of rows returned by an Oracle query after ordering? 2009-01-22T19:48:43.930

516 Fetch the row which has the Max value for a column 2008-09-23T14:34:13.877

326 How to select the nth row in a SQL database table? 2008-08-19T17:13:11.023

326 How to create id with AUTO_INCREMENT on Oracle? 2012-07-02T15:09:48.663

309 How to generate an entity-relationship (ER) diagram using Oracle SQL Developer 2011-07-05T09:30:51.243

293 What is the difference between Views and Materialized Views in Oracle? 2008-09-18T15:23:18.070

282 Oracle: If Table Exists 2009-11-25T18:46:10.640

281 Difference between a user and a schema in Oracle? 2009-05-18T23:11:55.147

271 Is there a combination of "LIKE" and "IN" in SQL? 2010-06-10T13:44:16.967

252 Oracle: how to UPSERT (update or insert into a table?) 2008-10-26T01:24:06.677

244 Update statement with inner join on Oracle 2010-03-15T11:40:21.430

239 How do I find duplicate values in a table in Oracle? 2008-09-12T15:10:27.277

238 How can I create a copy of an Oracle table without copying the data? 2008-10-24T14:53:17.023

232 Inner join vs Where 2008-09-23T15:13:28.040

215 SQL JOIN and different types of JOINs 2013-07-30T11:48:12.387

214 How to export query result to csv in Oracle SQL Developer? 2010-11-12T19:38:50.087

212 Can a foreign key be NULL and/or duplicate? 2011-09-27T17:57:45.437

211 Oracle "Partition By" Keyword 2009-02-18T16:31:10.017

210 What resources exist for Database performance-tuning? 2009-04-17T16:45:17.097

206 Best way to do multi-row insert in Oracle? 2008-09-02T13:56:19.413

206 Java JDBC - How to connect to Oracle using Service Name instead of SID 2011-01-28T19:05:24.357

204 What is the dual table in Oracle? 2008-09-16T15:43:19.863

200 Why does Oracle 9i treat an empty string as NULL? 2008-10-15T02:04:18.840

200 What is the difference between varchar and varchar2 in Oracle? 2009-07-23T11:40:25.993

199 How do I do top 1 in Oracle? 2010-08-10T17:10:08.067

194 Is there any boolean type in Oracle databases? 2010-09-16T12:43:08.500

191 Case insensitive searching in Oracle 2011-03-22T12:18:07.580

189 Oracle SQL: Update a table with data from another table 2011-08-11T18:05:54.983

187 Select count(*) from multiple tables 2009-03-03T12:37:06.900

176 How do I list all the columns in a table? 2009-10-16T21:10:05.297

171 Oracle Differences between NVL and Coalesce 2009-06-04T11:58:54.610

170 Liquibase lock - reasons? 2013-03-20T16:06:15.593

169 ORA-12514 TNS:listener does not currently know of service requested in connect descriptor 2012-05-28T15:07:05.377

167 How to implement one-to-one, one-to-many and many-to-many relationships while designing tables? 2011-09-04T01:17:36.723

164 What is the maximum length of a table name in Oracle? 2009-04-16T15:03:19.827

164 How can I find which tables reference a given table in Oracle SQL Developer? 2009-07-17T14:46:46.270

164 How can I set a custom date time format in Oracle SQL Developer? 2011-11-15T10:00:42.017

158 How can I get column names from a table in Oracle? 2009-01-16T23:53:00.937

152 When do I need to use a semicolon vs a slash in Oracle SQL? 2009-07-03T15:57:50.593

152 How do I turn off Oracle password expiration? 2009-07-08T02:32:05.280

151 How can I confirm a database is Oracle & what version it is using SQL? 2008-09-19T11:27:01.467

150 How SID is different from Service name in Oracle tnsnames.ora 2008-09-04T14:26:06.593

149 How do I reset a sequence in Oracle? 2008-09-09T09:36:39.320

147 Difference between BYTE and CHAR in column datatypes 2008-09-17T09:27:30.773

146 The provider is not compatible with the version of Oracle client 2009-03-18T17:34:20.203

143 What is the string concatenation operator in Oracle? 2008-11-10T15:42:01.070

142 Boolean Field in Oracle 2008-08-27T13:16:58.883

141 How to drop all user tables? 2009-11-06T20:59:18.770

141 ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired 2011-01-30T11:59:43.563

140 Number of rows affected by an UPDATE in PL/SQL 2009-05-14T07:21:22.210

140 Why are Oracle table/column/index names limited to 30 characters? 2009-09-04T09:20:06.347

139 Oracle find a constraint 2010-01-19T17:17:30.083

137 How to list active / open connections in Oracle? 2009-06-25T10:19:21.840

131 How do I list all tables in a schema in Oracle SQL? 2010-02-11T19:58:04.590

130 Oracle "(+)" Operator 2010-10-26T04:51:14.067

128 How do I spool to a CSV formatted file using SQLPLUS? 2009-03-13T15:05:29.210

127 How to retrieve the current value of an oracle sequence without increment it? 2012-04-18T13:20:58.080

123 ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 2013-08-12T16:54:19.950

120 SQL Query to concatenate column values from multiple rows in Oracle 2011-01-13T23:34:34.283

119 How do I calculate tables size in Oracle 2008-11-05T11:47:31.153

119 Use tnsnames.ora in Oracle SQL Developer 2010-01-07T09:10:29.250

117 List of foreign keys and the tables they reference 2009-11-13T15:37:45.103

117 GROUP BY with MAX(DATE) 2010-08-16T07:30:56.470

115 Change Oracle port from port 8080 2008-09-27T03:19:03.003

115 Removing duplicate rows from table in Oracle 2009-02-09T17:34:43.987

113 ORA-00979 not a group by expression 2009-10-05T14:57:21.663

113 SELECT INTO using Oracle 2010-02-12T07:13:44.207

112 Changing password with Oracle SQL Developer 2010-06-21T16:10:26.843

111 How do I escape a reserved word in Oracle? 2009-07-22T00:01:33.713

110 Is there a version control system for database structure changes? 2008-08-02T01:52:54.653

109 How to execute an .SQL script file using c# 2009-03-16T11:58:13.077

106 Oracle PL/SQL - How to create a simple array variable? 2011-08-10T14:41:00.830

105 How many database indexes is too many? 2008-09-26T18:50:13.680

105 Comparing Dates in Oracle SQL 2012-04-16T16:50:51.720

104 ORA-30926: unable to get a stable set of rows in the source tables 2010-02-25T20:13:59.677

104 What's the difference between RANK() and DENSE_RANK() functions in oracle? 2012-06-25T04:35:25.957

103 What is the difference between precision and scale? 2011-04-16T20:24:53.733

101 Do I need to create indexes on foreign keys? 2010-11-08T19:22:06.080

100 What is the difference between Non-Repeatable Read and Phantom Read? 2012-06-15T01:54:03.760

100 Escaping ampersand character in SQL string 2012-10-18T18:23:10.313

98 Are foreign keys really necessary in a database design? 2008-08-20T20:18:08.757

97 Search All Fields In All Tables For A Specific Value (Oracle) 2008-10-16T13:14:26.350

97 How to avoid variable substitution in Oracle SQL Developer with 'trinidad & tobago' 2010-02-25T12:42:59.393

97 How to create a new database after initally installing oracle database 11g Express Edition? 2012-03-02T13:30:42.640

97 Is there any difference between "!=" and "<>" in Oracle Sql? 2012-05-18T10:22:56.437

95 How can I combine multiple rows into a comma-delimited list in Oracle? 2009-01-22T12:51:39.730

94 Can you use Microsoft Entity Framework with Oracle? 2008-09-17T12:36:35.250

94 Oracle SELECT TOP 10 records 2010-03-23T06:41:28.123

94 How to show all privileges from a user in oracle? 2012-03-21T19:39:23.817

93 Get table name by constraint name 2011-03-09T15:17:05.427

93 Oracle query to fetch column names 2012-01-05T07:47:34.433

92 How do I ignore ampersands in a SQL script running from SQL Plus? 2008-09-22T23:19:04.093

92 Why would you use Oracle database? 2009-02-11T13:25:38.680

92 How to add 'ON DELETE CASCADE' in ALTER TABLE statement 2009-10-15T10:44:59.010

92 Hibernate dialect for Oracle Database 11g? 2010-12-06T19:02:21.240

91 SQL selecting rows by most recent date 2008-10-09T21:05:02.280

91 How do I get textual contents from BLOB in Oracle SQL 2009-05-06T08:41:20.147

91 What is the Oracle equivalent of SQL Server's IsNull() function? 2010-08-19T14:55:49.423