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

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

In this question, I was able to insert date in |----------|----------| | DT | FLAG | |---… Read more Oracle 10g: Inserting Missing Dates For Table With Others Values

I have two tables: CREATE TABLE PRODUCT ( PRODUCT_NAME VARCHAR(40) NOT NULL, SUPPLIER_NAME … Read more How To Create A Pl/sql Row Trigger That Validates A Column From Another Table

The Normal assignment operator is working fine but like operation is not working with below query i… Read more Dynamic Parameterized Query With Like

I this is my first attempt to create procedure and execute it. First I create simple table. DB sche… Read more Problem With Execute Procedure In Pl/sql Developer

I have Some static data for that i am creating select statement with the help of union all and i am… Read more Dynamic Delete In Oracle

I am a programmer, and I am writing some SQL code to pull data from a remote Oracle database and in… Read more How To Copy Only First 4000 Characters From Oracle Nclob To Nvarchar2(4000) Value?

I have a table like this in oracle: servername description … Read more String Splitting In Pl/sql

I've worked on this question and have it working properly for substitution variables declared, … Read more Pl/sql Bind Variables For Rectangular Prism Volume Calculation

is it possible to execute a dynamic piece of sql within plsql and return the results into a sys_ref… Read more Executing A Dynamic Sql Statement Into A Sys_refcursor

I have the below types CREATE OR REPLACE TYPE 'CLONE_PRODUCT_CHAR_RECORD' IS OBJECT ( Ch… Read more Search Inside Table Type Of Records

I am trying to create a trigger to calculate a derived attribute on each insert command. However I … Read more Sql Plus Trigger Compilation Errors

I am trying to print query result using solution in that page. The spool solution didn't work … Read more Invalid Create Command When It Is Used With Another Command

I have a table as follow: |----------|----------| | DT | FLAG | |----------|----------| |… Read more Sql: Inserting Row For Missing Month(s)

I need help with creating a view and then triggers for the following: update salesperson commission… Read more Sql Trigger For View

I am trying to learn to use PBKDF2 hash functions for storing passwords in the database. I have a r… Read more What Should Be The Data Type For The Hashed Value Of A Password Encrypted Using Pbkdf2?

I have a table which has several one to many relationships with other tables. Let's say the mai… Read more Sql Query To Count() Multiple Tables

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 have Write a pl/sql process to insert bulk record which is getting from select statement after f… Read more No Data Found Or Too Many Rows Exception Error Occured During Bulk Record Insertion