A database has a lot of columns (more than 100). Some of these columns have null entries. How can I find out how many columns have null entries in开发者_JAVA百科 at least one row, without manually tes
I\'m inserting data in table through this statement: insert into CATEGORY_MASTER ( CAT_MAS_ID, DESCRIPTION, ORG_ID, STATUS, MODIFY_EMPID, LANGUAGE_ID, LG_IP_MAC)
For debugging purposes, I\'d like to be able to \"TO_CHAR\" an Oracle PL/SQL in-memory table. Here\'s a simplified example, of what I\'d like to do:
Is it possible to access (call) Java Cryptography Architecture (JCA) classes开发者_运维问答 from PL/SQL? For example, when stored procedure are running.
If I query: select max(date_created) date_created on a datefield in PL/SQL (Oracle 11g), and there are records that were created on the same date but at different times, Max() returns only the late
I am trying to move some data over a dblink and one of the columns is an XMLType column. The code looks like this:
How can I get the IP v4 Of the server by using PL/SQL ? UTL_INADDR.GET_HOST_ADDRES开发者_StackOverflow社区S gives me IPv6, while I need IPv4
Say I have a boolean variable foo. At the moment I use IF foo = FALSE THEN ... to compare it it, but it seems so cum开发者_StackOverflow社区bersome. There has to be a better way!
i wanna be able to execute my below proc like so: exec procname(\'29-JAN-2011\'); proc code is: PROCEDURE procname(pardate VARCHAR2) IS
I have two types CREATE OR REPLACE TYPE my_record_type IS OBJECT ( namevarchar2(30) ) ; CREATE OR REPLACE TYPE my_table_type AS TABLE OF my_record_type
加载中,请稍侯......