sqloracleoracle-sqldeveloper-CodePudding

Tags > sqloracleoracle-sqldeveloper

11-10Software designUse "case when" in where clause of a query
01-29OSOracle SQL statement to update column value based on a matching condition
01-27databaseOracle SQL script parallel execution
01-18MobileORACLE SQL Total Cost of a Customer
01-16NetORACLE SQL number of customers who have ordered something on a date
01-16NetOracle Sql (Age In Years Of Youngest Employee)
01-07MobileUnable to create a global variable in package
01-06MobileGenerate JSON Structure looping over table in Oracle SQL
01-04databaseUnable to fix : ORA-00907: missing right parenthesis
01-03NetUntruncate HTML report dbms_sqltune.report_sql_detail
12-21front endhow can i correct line errors in views?
12-17NetHow to add an total line to a query
12-06front endDetect numeric values from VARCHAR2 oracle
11-30BlockchainHow to identify records where one ID column matches in both rows, and another column is populated in
11-27databaseSQL Developer - save result form many SELECT
11-23MobileHow to resolve subquery return more than one value in oracle
11-18Mobileadding a min and max date and getting error: literal does not match format string
11-15Software engineeringHow to update a specific value on the table using a temp table with subquery
11-09Back-endAgreggate rows from with same value caluculated in nested query | Oracle SQL
11-08otherOracle SQL - Change Data Default of a column to NULL - Is there any difference between NULL and (nul
11-06Software designCompounding Daily Returns SQL
10-31databaseCheck if records from one table have same column value in two different dates from another table
10-05Software designHow do I select unique values in a single column with multiple column selected?
10-05Software designSQL : instead of using a union want to use a where clause but one of the clauses is only true if ano
09-27Software designHow can I group into months a column count?
09-23BlockchainNeed to create a lot of views for reporting purposes how to best organise them into folders
09-20BlockchainCommon Table Expression to Replicate Dates
09-19Mobilehow to display the columns affected by the constraints (primary and foreign keys)
09-19Back-endAre recursive foreign keys also marked as primary keys? (In Oracle SQL Developer)
09-19EnterpriseMultiply columns and then sum rows: Oracle SQL
09-16MobileChoose a value by year and the max week
09-16MobileOracle SQL: Average amount for past few months