I have some oracle calls that I am porting.开发者_如何学运维Today I came across this code which looks like \"procedural\" language, but is not declared in a function or anything... My question is:Can
I\'ve got a scenario where I want to switch on two different tables in an outer join. It goes something like this:-
I have two cursors in my procedure that only differ on the table name that they join to. The cursor that is used is determined by a parameter passed into the procedure
I am using Solaris.I have to log into sql plus and run some queries, which give a huge result set. I want to copy all that into a file.Is there any command for it in开发者_如何学C unix or sqlplus ?Us
I\'m currently trying to access Active Directory via the dbms_ldap API in Pl/Sql (Oracle). The trouble is that I\'m not able to connect with my own username and password or anynoymously.
When I try to create a unique index on a large table, I get a unique contraint error.The unique index in this case is a composite key of 4 columns.
Unfortunately most of my DB experience has been with MSSQL which tends to hold your hand a lot more than Oracle. What I\'m trying to do is fairly trivial in tSQL, however, pl/sql is giving me a headac
How would I store the result of a select statement so I can reuse the results with an in clause for other queries? Here\'s some pseudo code:
CREATE OR REPLACE PROCEDURE p_create_dynamic_table IS v_qry_str VARCHAR2 (100); v_data_type VARCHAR2 (30);
If I have a table like this: pkeyage ------- 18 25 312 412 522 I can \"group by\" to get a count of each age.
加载中,请稍侯......