Lab Sql

Here is what I have: 1) a simple sql file given to me that creates tables and fills them with data … Read more Creating A Simple User Interface To Access An Oracle Database

I have the following problem in my application which connects to an Oracle 10g database: When my cl… Read more Oracle: How To Detect Client Process Termination Like It Works For Sqlplus?

need to spool output into .csv file using loop, fyi...I have data in 4 diff partition. but no sure … Read more Spool To .csv File Using For Loop

I am setting a bind variable in a PL/SQL block, and I'm trying to use it in another query's… Read more Sqlplus - Using A Bind Variable In "in" Clause

Can anyone point me to the right syntax to use in order to create a table only if it does not curre… Read more Oracle Create Table If It Does Not Exist

I want to pass variables in sqlplus command in my bash script, answer might be given but doesn'… Read more Passing Variable User,pass,sid In Sqlplus Comman

I have a batch script that invokes PLSQL with connection details, which works fine but I still have… Read more Help With Sqlplus Please? How To Make Sqlplus Startup With Define `off` Initially?

I have replaced my original question with this final answer. With the help from Mr. MTO and Mr. Pon… Read more In Oracle 11g How Do You Time Weight Average Data Hourly Between Two Dates?

I have created a table with Blob datatype but I do not know how to insert values into the table or … Read more How To Insert Blob Datatype Values In Oracle 11g Database Through Sql*plus

Database is Oracle 10.2.0.1.0 - 64bit running on Red Hat Enterprise Linux ES release 4 (Nahant Upda… Read more Is This A Possible Oracle Bug Or Am I Missing Something?

I want to generate a whole lot of SQL*Plus scripts by querying the data dictionary, but I'm hit… Read more Generating Sql*plus Script Using Sql*plus

I have a few things of code I need help debugging but I feel that if I can get one of them running … Read more Pl Sql Trigger Using Raise_application_error Thows Error.

I am trying to export the result of my SQL query to a .csv file using column formatting as below. S… Read more Formatting Of Sql*plus To Csv Output Format Issues

I have created a database as part of university assignment and I have hit a snag with the question … Read more Create A Query To Select Two Columns; (company, No. Of Films) From The Database

I wish to use a sqlplus command with password hidden from view such that it doesn't show up on … Read more Hiding Plain Text Password With Sqlplus Command Line

Is there a way that you can have SERVEROUTPUT set to ON in sqlplus but somehow repress the message … Read more How Do I Suppress "pl/sql Procedure Successfully Completed" Message In Sqlplus?

SELECT dealing_record.* ,shares.* ,transaction_type.* FROM shares INNER JOIN… Read more Duplicate Columns With Inner Join

I am using Oracle Developer and Oracle 11g (Oracle Database 11g Enterprise Edition Release 11.2.0.3… Read more How Can I Get Time Zone Region From Sqlplus?

I am writing a script to be run in sqlplus 11. I have a user defined variable called compression. I… Read more Sqlplus Decode To Execute Scripts

I need to make some changes to an old Oracle stored procedure on an obsolete box that is being kept… Read more How Do I Open A Stored Procedure And Edit It In Sql*plus