What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-03-11 15:25:02
prefix wikidata properties
PREFIX wd: <http://www.wikidata.org/entity/> PREFIX wds: <http://www.wikidata.org/entity/statement/> PREFIX wdv: <http://www.wikidata.org/value/> PREFIX wdt: <http://www.wikidata.org/prop/direct/> PREFIX wikibase: <http://wikiba... Add solution -
SQL 2022-01-22 18:46:11
oracle export view ddl
-- Views (use USER_VIEWS or DBA_VIEWS if needed): SELECT TEXT FROM ALL_VIEWS WHERE upper(VIEW_NAME) LIKE upper('%VIEW_NAME%'); -- Or: SELECT dbms_metadata.get_ddl('VIEW', 'VIEW_NAME', 'OWNER_NAME') FROM DUAL; -- Materialized views (use USER_VIEWS or DBA_... Add solution -
PHP 2021-11-13 23:59:11
drop down php form retrieve data from database
<!DOCTYPE html> <html> <head> <title>PHP Retrieve Data from MySQL using Drop Down Menu</title> </head> <body> <form> City: <select> <option disabled selected>-- Select City --</opti... Add solution -
Other 2021-11-05 20:06:13
Unique Field – Prevent Contact form 7 Duplicate Submissions
function is_already_submitted($formPostId, $fieldName, $fieldValue) { global $wpdb; /*We make a select in the table where the contacts are recorded, checking if the email informed already exists on today's date */ $entry = $wpdb->get_res... Add solution -
SQL 2021-11-05 17:03:16
how to get ddl for materialized view
-- Views (use USER_VIEWS or DBA_VIEWS if needed): SELECT TEXT FROM ALL_VIEWS WHERE upper(VIEW_NAME) LIKE upper('%VIEW_NAME%'); -- Or: SELECT dbms_metadata.get_ddl('VIEW', 'VIEW_NAME', 'OWNER_NAME') FROM DUAL; -- Materialized views (use USER_VIEWS or DBA_... Add solution -
SQL 2021-11-02 16:38:10
ddl materialized view
-- Views (use USER_VIEWS or DBA_VIEWS if needed): SELECT TEXT FROM ALL_VIEWS WHERE upper(VIEW_NAME) LIKE upper('%VIEW_NAME%'); -- Or: SELECT dbms_metadata.get_ddl('VIEW', 'VIEW_NAME', 'OWNER_NAME') FROM DUAL; -- Materialized views (use USER_VIEWS or DBA_... 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-06 22:54:03
sql numeric functions
ABS Returns the absolute value of the given number. ACOS Returns the arc cosine of the given number. ASIN Returns the arc sine of the given number. ATAN Returns the arc tangent of one or 2 given numbers. ATAN2 Return the arc tangent of 2 given numbers. AV... Add solution -
SQL 2021-09-07 03:57:02
how to get the query of a view in oracle
-- Views (use USER_VIEWS or DBA_VIEWS if needed): SELECT TEXT FROM ALL_VIEWS WHERE upper(VIEW_NAME) LIKE upper('%VIEW_NAME%'); -- Or: SELECT dbms_metadata.get_ddl('VIEW', 'FLEX_TRADE_AGREG', 'OWNER_NAME') FROM DUAL; -- Materialized views (use USER_VIEW... Add solution -
Javascript 2021-09-06 12:19:02
sequelize query result
sequelize.query("UPDATE users SET y = 42 WHERE x = 12").spread(function(results, metadata) { // Results will be an empty array and metadata will contain the number of // affected rows. }) /* In cases where you don't need to access the m... Add solution