What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-11-03 06:16:10
SQL MM/dd/yyyy format
-- Oracle:TO_DATE(string, format) SELECT TO_DATE('2012-06-05', 'YYYY-MM-DD') FROM dual; SELECT TO_DATE('05/06/2012 13:25:12', 'DD/MM/YYYY HH24:MI:SS') FROM dual; -- SQL Server: CONVERT(data_type, string, style). Cf source link for style codes. SELECT CONV... Add solution -
SQL 2021-11-02 05:24:07
mysql xampp reset root password
/* Go to the phpMyAdmin panel and select the SQL tab. ** Then run this lines: */ UPDATE mysql.user SET Password=PASSWORD('new_password') WHERE User='root'; FLUSH PRIVILEGES; /* Open the file C:\xampp\phpMyAdmin\config.inc.php ** Search for this line and ... Add solution -
Other 2021-10-29 20:41:14
medium generate-tsql-stored-procedures
CREATE proc [dbo].[USP_QuerycreationSupport](@table_Name varchar(100))asbeginDECLARE @InserCols NVARCHAR(MAX)DECLARE @Inserparam NVARCHAR(MAX)DECLARE @Insertquery NVARCHAR(MAX)DECLARE @Selectquery NVARCHAR(MAX)DECLARE @Update NVARCHAR(MAX)DECLARE @DeleteQ... Add solution -
SQL 2021-10-27 07:15:10
oracle undo tablespace schema
SELECT S.SID, S.USERNAME, round(sum(SS.VALUE) / 1e6, 2) AS UNDO_SIZE_MB, SQL.ELAPSED_TIME, SQL.SQL_TEXT FROM V$SESSTAT SS JOIN V$SESSION S ON S.SID = SS.SID JOIN V$STATNAME STAT ON STAT.STATISTIC# = SS.STATISTIC# LEFT JOIN V$SQLAREA ... Add solution