Database

dbms_metadata.get_ddl(
object_type IN VARCHAR2,
name        IN VARCHAR2,
schema      IN VARCHAR2 DEFAULT NULL,
version     IN VARCHAR2 DEFAULT 'COMPATIBLE',
model       IN VARCHAR2 DEFAULT 'ORACLE',
transform   IN VARCHAR2 DEFAULT 'DDL')
RETURN CLOB;

SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name)
     FROM USER_TABLES u;

SELECT DBMS_METADATA.GET_DDL('INDEX',u.index_name)
     FROM USER_INDEXES u;

DECLARE @Input int
SET @Input = 30
SELECT TOP 1 Col1 FROM Table1
WHERE Col1 = (SELECT MIN(ABS(Col1-@Input))+@Input FROM Table1)
OR Col1 = (SELECT @Input-MIN(ABS(Col1-@Input)) FROM Table1)

SELECT * FROM news1 ORDER BY (news_id-10)*(news_id-10)

SELECT * FROM news1 ORDER BY ABS(news_id-10)

"... ORDERBY (var1-goal1)*(var1-goal1)+(var2-goal2)*(var2-goal2)...+(varN-goalN)*(varN-goalN)"

select num as [Closest Number] from(
select DENSE_RANK() over(order by abs(num - @inputNum)) [rank]		
		,num from @t
)X
where [rank] = 1

Closest Number
31

DECLARE @i int

SET @i = 30

SELECT TOP 1 Col1 FROM Table1 ORDER BY ABS(Col1-@i)

Shameel wrote:

TOP 1 Col1