I have a column with type varchar2 and i want to convert this column into number how can i achieve this in oracle database How to convert varchar2 to number in oracle?
Oraask Latest Questions
How to insert multiple rows in sql oracle?
I am new to sql and i have a table with name "ACTIONS". what is the command to delete this table from the database? i tried this: delete table ACTIONS but it does not work.
What is large pool? and it's optional or required memory area in oracle database ?
What is database normalization and its types? any help will be appreciated
Can someone explain what is top 5 wait events in oracle in an AWR report?
I have SQL_ID for particular sql query and i need to know how to purge this sql_id from shared pool? Thanks
i want to rename column in a table inside oracle database 10g without drop the table can someone help me in this?
In oracle How do I get a list of all tables in a database?
There are three status or stats i know generally (Free & Pinned & Dirty) but not in dept and what is the difference between them all. i will really appreciated if some one briefly clarify this to me. thanks in advance.