Top "Oracle" questions

PLS-00103: Encountered the symbol "CREATE"

What is the problem with this package as it is giving an error? CREATE OR REPLACE PACKAGE PKG_SHOW_CUST_…

oracle pls-00103

Oracle: Import CSV file

I've been searching for a while now but can't seem to find answers so here goes... I've got a CSV …

oracle csv import sqlplus sql-loader

MySQL 'create schema' and 'create database' - Is there any difference

Taking a peak into the information_schema database and peaking at the metadata for one of my pet projects, I'm …

sql mysql oracle jdbc database

How to generate a GUID in Oracle?

Is it possible to auto-generate a GUID into an Insert statement? Also, what type of field should I use to …

oracle guid

How to run .sql file in Oracle SQL developer tool to import database?

I have exported database from Oracle SQL developer tool into .sql file. Now I want to run this file which …

sql oracle oracle-sqldeveloper

Oracle: is there a tool to trace queries, like Profiler for sql server?

i work with sql server, but i must migrate to an application with Oracle DB. for trace my application queries, …

sql-server oracle profiler

Connect to Oracle DB using sqlplus

I am using below command in Unix environment to connect to Oracle database: sqlplus test/test@'(DESCRIPTION=(ADDRESS_LIST=(…

oracle unix sqlplus

Different CURRENT_TIMESTAMP and SYSDATE in oracle

After executing this SQL in oracle 10g: SELECT SYSDATE, CURRENT_TIMESTAMP FROM DUAL I receive this strange output: What is …

oracle plsql oracle10g

SQLException: No suitable Driver Found for jdbc:oracle:thin:@//localhost:1521/orcl

I am trying to develop a Java EE application that connect to an Oracle database from eb service class but …

java oracle jdbc jboss ojdbc

SQL query for extracting year from a date

I am trying to create a query that gets only the year from selected dates. I.e. select ASOFDATE from …

sql oracle toad peoplesoft