What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-11-14 15:09:10
sql show columns in table
-- MySQL SELECT * FROM INFORMATION_SCHEMA.COLUMNS; -- SQL Server (possible solution) SELECT * FROM SYS.COLUMNS; -- Oracle SELECT * FROM ALL_TAB_COLS; -- (If you only want user-defined columns) -- ALL_TAB_COLS : only user-defined columns -- ALL_TAB_CO... Add solution -
SQL 2021-11-10 16:11:18
how to send a query result as an email body sql server
CREATE TABLE #Temp ( [Rank] [int], [Player Name] [varchar](128), [Ranking Points] [int], [Country] [varchar](128) ) INSERT INTO #Temp SELECT 1,'Rafael Nadal',12390,'Spain' UNION ALL SELECT 2,'Roger Federer',7965,'Switzerland' UNION ALL SELEC... Add solution -
SQL 2021-11-09 16:45:12
query to check cpu utilization in oracle database
SELECT PARSING_SCHEMA_NAME, MODULE, SQL_ID, round(((CPU_TIME / 1e6) / 60), 2) AS CPU_TIME, EXECUTIONS, ROWS_PROCESSED, DISK_READS, FIRST_LOAD_TIME, LAST_LOAD_TIME, OPTIMIZER_COST, SQL_FULLTEXT FROM V$SQLAREA WHERE PARSING_SCHEMA_NAME IN... Add solution -
PHP 2021-11-09 06:55:08
number of rows in a mysql table pdo
//Instantiate the PDO object and connect to MySQL. $pdo = new PDO( 'mysql:host=127.0.0.1;dbname=my_database', 'username', 'password' ); //The COUNT SQL statement that we will u... Add solution -
SQL 2021-11-08 22:25:18
sql limit results
-- MySql SELECT * FROM emp ORDER BY sal DESC LIMIT 5; -- SQL Server SELECT TOP 5 * FROM emp ORDER BY sal DESC; -- Oracle < 11g SELECT * FROM ( SELECT * FROM emp ORDER BY sal DESC ) WHERE ROWNUM <= 5; -- Oracle 12c + SELECT * FROM emp ORDER BY sa... Add solution -
SQL 2021-11-08 21:15:23
sqlite3 get data from table c
#include <stdio.h> #include <string> using std::string; #include <sstream> using std::stringstream; #include "sqlite3.h" bool find_employee(int _id) { bool found = false; sqlite3* db; sqlite3_stmt* stmt; strin... Add solution -
Python 2021-11-07 18:09:20
how to save form data to database in flask\
# routes.py import sqlite3 as sql from my_app import app from flask import render_template, request # connect to qa_database.sq (database will be created, if not exist) con = sql.connect('qa_database.db') con.execute('CREATE TABLE IF NOT EXISTS tbl_QA ... Add solution -
SQL 2021-11-05 22:49:09
rebuild index oracle
-- Indexes: SELECT 'alter index ' || OWNER || '.' || INDEX_NAME || ' rebuild tablespace ' || TABLESPACE_NAME || ';' SQL_TO_REBUILD_INDEX FROM DBA_INDEXES WHERE STATUS = 'UNUSABLE'; -- For unusable indexes -- Indexes partitions: SELECT 'alter index ' ... Add solution -
SQL 2021-11-05 20:47:15
sql server to_date
-- 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