Top "Oracle" questions

Oracle Database is a Multi-Model Database Management System created by Oracle Corporation.

Oracle TNS names not showing when adding new connection to SQL Developer

I'm trying to connect to an oracle database with SQL Developer. I've installed the .Net oracle drivers and placed the …

database oracle oracle-sqldeveloper tnsnames tns
ORA-28000: the account is locked error getting frequently

I am getting the error : ORA-28000: the account is locked Is this a DB Issue? When I unlock user account …

oracle oracle11g oracle10g
Passing an array of data as an input parameter to an Oracle procedure

I'm trying to pass an array of (varchar) data into an Oracle procedure. The Oracle procedure would be either called …

oracle stored-procedures plsql
how to modify the size of a column

I created the table Test_Project2 in Oracle SQL Developer. After that I realized that the column proj_name is …

oracle oracle-sqldeveloper alter-table
Boolean Field in Oracle

Yesterday I wanted to add a boolean field to an Oracle table. However, there isn't actually a boolean data type …

oracle boolean sqldatatypes
How to use a calculated column to calculate another column in the same view

I am hoping you can help with this question. I am using Oracle SQL (SQL Developer for this view)... If …

sql oracle
What is the difference between precision and scale?

What is the difference between precision and scale in Oracle? In tutorials they usually leave scale empty and set precision …

oracle types
How to export data with Oracle SQL Developer?

How to export Oracle DB data using SQL Developer? I need all data, tables, constraints, structure and so on.

sql oracle oracle-sqldeveloper
How to extract week number in sql

I have a transdate column of varchar2 type which has the following entrees 01/02/2012 01/03/2012 etc. I converted it in to date …

sql oracle oracle-sqldeveloper
What is the max size of VARCHAR2 in PL/SQL and SQL?

I am on Oracle 10g. In a requirement I need to increase the size of a pl/sql VARCHAR2 variable. …

sql oracle plsql varchar2