Oracle SQL Questions


How can i keep sys_guid() unique in multiple table insert
I want to use unique sys_guid() for insert multiple table but out put are difference sys_guid() drop table T1; drop table T2; drop table T3; create table T1 (ROW_ID varchar2(50)); create table T2 (ROW_ID varchar2(50)); create table T3 (ROW_ID varchar2(50)); insert all into T1 values (NEW_ROW_ID) into T2 values (NEW_ROW_ID) into T3 values (NEW_ROW_ID) select [...]

Answer Question   |  November 26, 2012  12:40 PM
Oracle 9, Oracle SQL
asked by:
15 pts.

Using select statement in an update query of Oracle SQL
how to update an entire column of an table by an subquery in an update statement.and that subquery is returning multiple rows

Answer Question   |  May 22, 2012  11:28 AM
Oracle Query, Oracle SQL
asked by:
5 pts.

Return only one word– SQL
Hello, I have a column called Profile in a table and I am searching for a specific word in that column. I use the keyword LIKE with the wildcard (%) and that is working fine, but how do I have the query only return that word and not all the text in the Profile column. [...]

Answer Question   |  March 31, 2012  7:12 PM
Oracle, Oracle SQL, SQL, SQL Server
asked by:
5 pts.

Create date as column name in Oracle SQL?
I WANT TO CREATE A TABLE WITH THE COLUMN NAME AS DATE BUT IT SHOWING THE ERROR.BUT I WANT TO DISPLAY COLUMN NAME AS DATE ONLY CAN ANY ONE HELP i try it SQL> create create table store_information(store_name varchar2(10),sales varchar2(10),date date); create create table store_information(store_name varchar2(10),sales varchar2(10),date date)        * ERROR at line 1: ORA-00901: [...]

Answer Question   |  June 13, 2011  12:39 PM
Oracle administration, Oracle SQL, Oracle SQL Developer
asked by:
25 pts.

SQL Oracle for rolling the period return
Hi ,  i had requirement such that .. if i enter a period , it should return 5 other periods based on that in oracle sql query .  return of period is done as below .. for Jan 2011 it should return march2010,june2010,sep2010,dec2010,jan2011 for feb it should return march2010,june2010,sep2010,dec2010,feb2011 for march it should return march2010,june2010,sep2010,dec2010,march2011 for April [...]

Answer Question   |  May 16, 2011  5:56 PM
Oracle SQL, Oracle SQL Developer, Oracle SQL Pagination, SQL Database
asked by:
15 pts.

Converting double byte characters to single byte characters in a single string
converting double byte characters to single byte characters in a single string

Answer Question   |  April 12, 2011  9:58 PM
Double-byte, Oracle SQL, Oracle SQL Developer, Single Byte
asked by:
25 pts.

un-format object viewer sql tab
Hi experts, Can someone tell me, how can I turn off automatic code formating on the Object viewer’s SQL tab (i.e. the sql code in the SQL tab of an opened view is automatically formated compared to the code I used to create it) Thnx in advance for yr answers

Answer Question   |  February 11, 2011  8:13 AM
Oracle SQL, Oracle SQL Developer, SQL, SQL Server
15 pts.

IN and Exists in SQL?
What is the difference between IN and EXISTS IN SQL? I googled but I dint get good information. PLease provide me the exact deifference between them.

Answer Question   |  November 26, 2010  7:18 AM
Oracle 10g Express, Oracle SQL, SQL, SQL commands, SQL Server
asked by:
220 pts.

Terminate SQL exception, if it is running more than a specified time.
Whether we can forcefully terminate an sql statement during its execution if it is running for a long time or running more than a specified time?

Answer Question   |  November 15, 2010  10:03 AM
Oracle 9i, Oracle performance, Oracle SQL, SQL Exception, SQL statement
asked by:
5 pts.

Database for OLTP
Which database is most suited for OLTP? Is it Oracle or Microsoft SQL?

Answer Question   |  April 22, 2010  11:26 AM
Microsoft SQL Server, OLTP, Oracle SQL
asked by:
150 pts.

Retrieve data from Oracle9i to SQL server
Currently my database client using SQL Server 2005 and there have another database whereby is using Oracle 9i, I wanted to retrieve the data from the oracle whereby query in SQL server 2005. 

Answer Question   |  January 20, 2010  10:42 AM
Oracle, Oracle 9i, Oracle SQL, SQL
asked by:
15 pts.

Function to find greatest numeric value across different fields
In a row of data with multiple numeric fields, how can I easily find the greatest value using simple function like GREATEST(Attribute1, Attribute2) as for Oracle SQL?

Answer Question   |  August 25, 2009  2:52 AM
Oracle SQL, WinSQL, WINSQL Numeric Function
asked by:
5 pts.

following error when logging into SQLPlus
When i try to log into Oracle SQL*Plus i get the following error ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist I’m using Oracle 9i Personal Edition

Answer Question   |  August 21, 2009  6:41 AM
ORA-01034, ORA-27101, Oracle SQL, SQL Plus
asked by:
5 pts.

SR in oracle(tickets)
Can u please give me a list pf SR’s u have solved ?

Answer Question   |  August 18, 2009  6:22 AM
Oracle Service Request, Oracle SQL, Oracle SR, PL/SQL
asked by:
5 pts.

Equivolent HLOOKUP using SQL
I am a beginner at SQL… I’ve come across a situation maybe someone can help me out. I have a table with the following structure: bkt_id am bkt_101 bkt_102 bkt_103 … bkt_228 bkt_101 $100 $100 $20 $0 bkt_102 $50 $100 $20 $0 … I want to compare am with the proper bkt_n value using the [...]

Answer Question   |  July 24, 2009  1:31 AM
Excel HLOOKUP function, Oracle, Oracle 10g, Oracle SQL, SQL
asked by:
5 pts.

Conecting Oracle through dynamic IP
I want to connect 2pcs’s having oracle 9i (sever version) installed in them ,through a broadband connection(ie. a dynamic IP). Can any one show me the way.

Answer Question   |  April 28, 2009  4:39 PM
Dynamic IP address, Oracle SQL
asked by:
5 pts.

How To execute procedure
I have procedure iven below Output of the procedure below is multiple rows but i am getting only 1st row how to use concept of SYS_REFCURSOR over here CREATE OR REPLACE procedure Vishal_PROC_sp1 (kpiid in number, val1 out varchar2, val2 OUT Number) as cursor c1 is select kpimainid,sysdate,selectstmt,clause,to_char(sysdate,’MON’) month,cautionmax,cautionmin from kpimain where kpimainid = kpiid; [...]

Answer Question   |  April 30, 2009  7:25 PM
Oracle SQL, Oracle stored procedures, SYS_REFCURSOR
asked by:
85 pts.

Oracle SQL question
I want to create a SQL script in Oracle that will run one of two possible SQL scripts based on what the user enters in the Parameter request. Since I’m unable to use IIF and If Then like I can in SQL Server, is there another way to do this? I have tried using case [...]

Answer Question   |  April 22, 2009  2:39 AM
CASE statement, IF THEN statement, IIF statement, Oracle developers, Oracle development, Oracle SQL, SQL
asked by:
5 pts.

HOW TO SAVE DATA FAST
I have a query that retrieves 7 lakh rows of data in say 3 minutes but when i go to save this data in comma sepatrated file using toad’s save as feature .it takes almost 3 hrs to save the data. This query looks like: SELECT circle_name,cluster_name,rsnnumber ,mdnnumber,hs_rsnnumber ,otafdate, (case when old_mdn is null then [...]

Answer Question   |  April 15, 2009  12:46 PM
Oracle Database, Oracle Output Via SQL, Oracle SQL
asked by:
10 pts.

What is the difference between software package in SQL and PL/SQL
why is the need of psql when the sql is already avaliable.

Answer Question   |  March 30, 2009  7:43 AM
Oracle SQL, PL/SQL, SQL, SQL development
asked by:
5 pts.