📰 Dev.to · Query Filter

Articles from Dev.to · Query Filter · 47 articles · Updated every 3 hours · View all reads

All ⚡ AI Lessons (9351) ArXiv cs.AI Dev.to · FORUM WEB Forbes Innovation Dev.to AI OpenAI News Hugging Face Blog

catalog

Dev.to · Query Filter 4mo ago

SELECT o.name AS table_name FROM sysobjects o WHERE o.type = 'U' AND o.uid = USER_ID() AND...

dupl

Dev.to · Query Filter 4mo ago

WITH t AS ( SELECT t.table_name, LIST( 'SELECT ''' || t.table_name...

select2

Dev.to · Query Filter 4mo ago

SELECT RTRIM(XMLAGG(XMLELEMENT(E, chunk_content).EXTRACT('/text()') ORDER BY...

limit

Dev.to · Query Filter 4mo ago

Context,Limit Applied To,Value,Notes "SQL*Plus, JDBC, ODBC, .NET, etc.",One complete SQL or PL/SQL...

util

Dev.to · Query Filter 4mo ago

-- util.sql SET SERVEROUTPUT ON SET ECHO OFF SET FEEDBACK OFF WHENEVER SQLERROR EXIT SQL.SQLCODE --...

form8

Dev.to · Query Filter 4mo ago

<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> ...

perl2

Dev.to · Query Filter 5mo ago

!/usr/bin/perl use strict; use warnings; Read full SQL from stdin or file my...

perl

Dev.to · Query Filter 5mo ago

!/usr/bin/perl use strict; use warnings; Read full SQL from stdin or file my...

full text

Dev.to · Query Filter 5mo ago

CREATE OR REPLACE PROCEDURE get_blob_full_text( p_key1 IN VARCHAR2, p_key2 IN VARCHAR2...

loop

Dev.to · Query Filter 5mo ago

DECLARE l_chunk VARCHAR2(1000); l_start_byte NUMBER := 1; l_chunk_size NUMBER := 100; ...

blob16

Dev.to · Query Filter 5mo ago

CREATE OR REPLACE FUNCTION blob_to_text(p_blob BLOB) RETURN VARCHAR2 IS l_result VARCHAR2(32767) :=...

blob15

Dev.to · Query Filter 5mo ago

CREATE OR REPLACE FUNCTION blob_to_text(p_blob BLOB) RETURN VARCHAR2 IS l_result VARCHAR2(32767) :=...

blob10

Dev.to · Query Filter 5mo ago

CREATE OR REPLACE FUNCTION blob_to_text_large(p_blob BLOB) RETURN VARCHAR2 IS l_text...

blob6

Dev.to · Query Filter 5mo ago

CREATE OR REPLACE FUNCTION blob_to_text2(p_blob BLOB) RETURN VARCHAR2 IS l_raw RAW(32767); ...

rec

Dev.to · Query Filter 5mo ago

!/bin/bash Usage: ./verify_table_checksum.sh mytable.ctl Compares...

cursor

Dev.to · Query Filter 5mo ago

💡 Why it happens Oracle tracks every active cursor (open SQL or PL/SQL statement handle) per...

isql

Dev.to · Query Filter 5mo ago

!/bin/bash Purpose: Export Sybase ZMemo table with safe CLOB text column for...

py schema

Dev.to · Query Filter 6mo ago

!/usr/bin/env python schema_parser_batch.py - Python 2.7.5 compatible import...

tcount

Dev.to · Query Filter 6mo ago

SELECT t.owner || '.' || t.table_name AS full_table_name, XMLCAST( ...

tabel count

Dev.to · Query Filter 6mo ago

SELECT t.owner || '.' || t.table_name AS full_table_name, TO_NUMBER(EXTRACTVALUE(XMLTYPE( ...

db tables

Dev.to · Query Filter 6mo ago

SELECT table_name, MAX(CASE WHEN db = 'COMET_US_REF' THEN 'YES' ELSE 'NO' END) AS...

table select

Dev.to · Query Filter 6mo ago

SELECT table_name, COUNT(DISTINCT db) AS db_count, -- STRING_AGG(db, ', ') AS databases...

deply syb

Dev.to · Query Filter 6mo ago

!/bin/bash Define SYBASE environment variables export...