Hi, there!
If I want to practice Oracle PL/SQL, what kind of tool shall I use? Are there some good tutorial website?
With best regards,
Juhani
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23104513.html
Zones:
PL / SQLDate Answered: 01/23/2008 Grade: A Views: 118
Are there tool (Oracle SQL developer or TOAD) with debug feature for PL/SQL?
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23105407.html
Zones:
PL / SQLDate Answered: 01/23/2008 Grade: A Views: 33
I trying to write an SQL script against a database that I have no ER, or datadictionary. In nearly every table within the DB is a column called "TIMESTAMP"; the data type for the column is nvarcha...
http://www.experts-exchange.com/Database/Oracle/Q_23208943.html
Does anyone know how to access call a method stored in an ASP page from a PL/SQL script? Is this possible at all?
I have attempted this using the utl_http utility but I get a response code 100 ...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23253262.html
I need to exectue a select statement in my return criteria to return a value from a lookup table based on the "hdr.fee_sched_head_id" that is being returned during the executing query. I wasn't abl...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23268148.html
I am working in this precedure it is living me the right results except that if the records is in the table like this one
SORTEST_PIDM SORTEST_TESC_CODE SORTEST_TEST_SCORE
223562 LR 560
22...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23271887.html
Zones:
PL / SQLDate Answered: 09/10/2008 Grade: A Views: 0
If I have a variable called myvariable = 'MY-LAST-HOME-WAS-HERE' how can I search for the first occurance of '-' and place all the characters before '-' in another variable called mynewvariable? T...
http://www.experts-exchange.com/Database/Oracle/Q_23299875.html
Hallo,
Anybody know what the difference is between a varchar2(32767) vs CLOB in PL/SQL?
Differences in perfomance?
In my scenario I'm passing the variable betweeen functions, not using the D...
http://www.experts-exchange.com/Database/Oracle/Q_23378713.html
Hello guys,
I am quite new to PL/SQL and I have a problem.
I have to port an old application, which uses Sybase, to Oracle.
I have a table like this:
sql> select col1, col2 from test
---...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23421761.html
Is the a more efficient way to do this query.
Tables:
All_Names > 15,000,000 records
Unique at the Customer_Id Store level
Multiple customer_ids
Credit_Account > 10,000,000 records
Unique...
http://www.experts-exchange.com/Database/Oracle/Q_23759584.html
