Top "Oracle" questions

How can I select records ONLY from yesterday?

I've spent hours searching the web for an answer to this question... Here's what I currently have: select * from order_…

sql database oracle plsql

Trim Whitespaces (New Line and Tab space) in a String in Oracle

I need to trim New Line (Chr(13) and Chr(10) and Tab space from the beginning and end of a String) …

sql oracle trim

How to determine tables size in Oracle

I use Oracle 11 and want to find out the size of my tables (like in megabytes). What should I do? …

oracle oracle11g

How to rename a table column in Oracle 10g

I would like to know: How to rename a table column in Oracle 10g?

oracle oracle10g

Split function in oracle to comma separated values with automatic sequence

Need Split function which will take two parameters, string to split and delimiter to split the string and return a …

oracle function plsql split delimiter

Rename Oracle Table or View

What is the syntax to rename a table or view in Oracle?

oracle table-rename

Is it possible to output a SELECT statement from a PL/SQL block?

How can I get a PL/SQL block to output the results of a SELECT statement the same way as …

sql oracle plsql oracle10g oracle-apex

How to get row number from selected rows in Oracle

I am selecting few rows from database e.g.: select * from student where name is like %ram% Result: ID Name …

sql oracle rownum

how to convert a string date to date format in oracle10g

My date value is stored as varchar2 and the value is 15/August/2009,4:30 PM, how to convert this to a proper …

oracle oracle10g plsqldeveloper

Sleep function in ORACLE

I need execute an SQL query in ORACLE it takes a certain amount of time. So I wrote this function: …

sql oracle plsql oracle11g