What do you want to save?
Add Code snippet
New code examples
-
C# 2021-10-04 15:43:02
c# mysql query
MySqlConnection con = new MySqlConnection(connectionString); con.Open(); MySqlCommand cmd = new MySqlCommand("SELECT * FROM customers",con); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { //You can get values from c... Add solution -
SQL 2021-10-04 06:15:04
oracle add column comment
COMMENT ON COLUMN TABLE_NAME.MY_COLUMN IS 'A column comment'; SELECT * FROM ALL_COL_COMMENTS WHERE TABLE_NAME = 'TABLE_NAME'; -- All schema columns: SELECT t.OWNER, t.TABLE_NAME, c.COLUMN_NAME, com.COMMENTS FROM DBA_TABLES t LEFT JOIN DBA_TAB_COLUMNS c ... Add solution -
PHP 2021-10-03 23:08:02
pl sql php connect
<?php // Create connection to Oracle $conn = oci_connect("phphol", "welcome", "//localhost/orcl"); $query = 'select * from departments'; $stid = oci_parse($conn, $query); $r = oci_execute($stid); // Fetch the results in... Add solution -
SQL 2021-10-03 09:50:03
oracle datafile max size 32gb
SELECT * FROM DBA_DATA_FILES; ALTER TABLESPACE my_tbs ADD DATAFILE '/path/to/my_file.dbf' SIZE 100M AUTOEXTEND OFF; -- Autoextend with max size: ALTER TABLESPACE my_tbs ADD DATAFILE '/path/to/my_file.dbf' SIZE 10G AUTOEXTEND ON NEXT 1G MAXSIZE 32G; ... Add solution
Best helpers
Ranking is empty